Skip to main content

Deal Sheet

Deal Sheet

Deal Sheet

Deal Sheet

Deal Sheet

216 S Undermountain Rd

216 S Undermountain Rd

216 S Undermountain Rd

216 S Undermountain Rd

216 S Undermountain Rd

Deal Sheet: 216 S Undermountain Rd, Sheffield, MA 01257

Property Overview:

  • Type: Single Family Home
  • Size: 1,506 Sqft
  • Lot Size: 1.29 acres
  • Bedrooms: 3
  • Bathrooms: 2
  • Features: Fireplace, Waterfront, Panoramic Views, Fishing Spot

Purchase & Financing:

  • Asking Price: $549,000
  • Offer Amount: $525,000
  • Setup Cost: $70,000 (for renovations, furnishings, etc.)
  • Down Payment: 40% of offer price
  • Mortgage Interest Rate: 7.9%
  • Closing Costs: $5,000

Investment Structure:

  • Minimum Investment Amount: $500
  • Equity Share: Pro rata based on investment amount
  • Projected ROI: 11.97% IRR per year or 7% cash on cash
  • Holding Period: 10 years

Projected Income & Expenses:

  • Estimated Annual Rental Income: $70,000 (based on 55% occupancy)
  • Annual Fixed Costs: $16,000
  • Annual Mortgage Payments: $28,700 (until refinancing)

Strategy & Operations:

  • Exit Strategy: Sale after 10 years
  • Listing Platforms: Airbnb, VRBO

Investor Updates:

  • Communication Platforms: Short Stays platform, Slack, Email
  • Frequency: Monthly updates

For the 10 Years Invested

Return (IRR): 11.97% per year
Total Profit when Sold: $446,889.98
Cash on Cash Return: 148.96%
Purchase Capitalization Rate: 8.97%
Total Rental Income: $749,049.87
Total Mortgage Payments: $287,814.94
Total Expenses: $183,422.07
Total Net Operating Income: $565,627.81

First Year Income and Expenses

Monthly Annual
Income: $11,000.00 $132,000.00
Mortgage Pay: $2,398.46 $28,781.49
Vacancy (45%): $4,950.00 $59,400.00
Management Fee (10%): $605.00 $7,260.00
Property Tax: $583.33 $7,000.00
Total Insurance: $83.33 $1,000.00
Maintenance Cost: $416.67 $5,000.00
Other Cost: $250.00 $3,000.00
Cash Flow: $1,713.21 $20,558.51
Net Operating Income (NOI): $4,111.67 $49,340.00

Breakdown Over Time

Year Annual Income Mortgage Expenses Cash Flow Cash on Cash Return Equity Accumulated If Sold at Year End
Cash to Receive Return (IRR)
Begin -$300,000
1. $65,340 $28,781 $16,000 $20,559 6.85% $290,812 $253,732 -8.57%
2. $67,300 $28,781 $16,480 $22,039 7.35% $312,394 $274,202 2.86%
3. $69,319 $28,781 $16,974 $23,563 7.85% $334,782 $295,444 6.86%
4. $71,399 $28,781 $17,484 $25,134 8.38% $358,012 $317,494 8.83%
5. $73,541 $28,781 $18,008 $26,751 8.92% $382,124 $340,390 9.98%
6. $75,747 $28,781 $18,548 $28,417 9.47% $407,159 $364,173 10.71%
7. $78,019 $28,781 $19,105 $30,133 10.04% $433,162 $388,887 11.20%
8. $80,360 $28,781 $19,678 $31,900 10.63% $460,179 $414,576 11.54%
9. $82,771 $28,781 $20,268 $33,721 11.24% $488,260 $441,289 11.79%
10. $85,254 $28,781 $20,876 $504,673 11.87% $517,458 $469,077 11.97%
Total $749,050 $287,815 $183,422 $446,890 148.96%