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% | |||