| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | PROPERTY / DEAL DETAILS: | ||||||
2 | >>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST) | ||||||
3 | Property Address | 49 Forest Dr, Jim Thorpe, PA 18624 | Bedroom Count: | 6 | |||
4 | Purchase Price | $705,000 | Bathroom Count: | 3 | |||
5 | Listing URL | Link to Photos | Square Footage: | 3,000 | |||
6 | |||||||
7 | CASHFLOW, TAX SAVINGS AND RETURNS: | NOTES: | |||||
8 | Cash on Cash Return (CoC): | 11.06% | |||||
9 | Annual Cash-Flow: | $25,747.54 | |||||
10 | Estimated Bonus Depreciation: | $225,600.00 | |||||
11 | Estimated Additional Offset: | $165,752.42 | |||||
12 | Total Year 1 Offset: | $391,352.42 | |||||
13 | Year 1 Estimated Net Effective Tax Savings: | $144,800.39 | |||||
14 | Year 1 Estimated Tax Savings And Cash-Flow: | $170,547.93 | |||||
15 | Year 1 ROI: | 73.24% | |||||
16 | |||||||
17 | DEAL SNAPSHOT: | NOTES: | |||||
18 | CASH NEEDED: | CASHFLOW, TAX SAVINGS AND RETURNS: | |||||
19 | Purchase Price: | $705,000.00 | |||||
20 | Down Payment: | $70,500.00 | |||||
21 | Mortgage Amount: | $634,500.00 | |||||
22 | Closing Costs: | $16,864.83 | |||||
23 | Seller Credit: | $10,000.00 | |||||
24 | Inspection Seller Credit: | $15,000.00 | |||||
25 | Adjusted Closing Costs: | -$8,135.17 | |||||
26 | Total Cash To Close: | $62,364.83 | |||||
27 | Post-Close Enhancements Budget: | $170,500.00 | |||||
28 | Total Cash Needed: | $232,864.83 | |||||
29 | |||||||
30 | MONTHLY INCOME PROJECTIONS: | NOTES: | |||||
31 | Average Nightly Rate (ADR): | $725 | |||||
32 | Average Occupancy (OCC): | 60% | Comp 1 = $209k | ||||
33 | Gross Booking Revenue: | $13,231 | Comp 2 = $171k | ||||
34 | Cleaning Revenue: | $1,500 | Comp 3 = $158k | ||||
35 | Gross Monthly Income: | $14,731 | Comp 1 ~$168k-$178k/year Airbnb super weak interior/exterior design; competitive advantage with A frame and nicer kitchen; obviously cannot replicate the a frame - should try and beef up kitchen | ||||
36 | Gross Annual Revenue (Before ALL Expenses) | $176,775 | Comp 2 ~$175k/year this year (based on outperforming last year July) Airbnb match/exceed dining room table (MINIMUM 10 guests for total seating) | ||||
37 | Net Annual Cashflow (After ALL Expenses) | $25,748 | |||||
38 | Net Monthly Cashflow (After ALL Expenses) | $2,146 | |||||
39 | |||||||
40 | RECURRING MONTHLY EXPENSES BREAKDOWN: | NOTES: | |||||
41 | RECURRING PAYMENTS: | UTILITIES: | |||||
42 | Principal + Interest Payments: | $3,763.45 | Water/Sewer: | $179 | |||
43 | Property Taxes: | $707.83 | Gas And Electricity: | $650 | |||
44 | STR Insurance Policy: | $367.50 | Internet: | $110 | |||
45 | Flood Insurance: | $0.00 | Cleaning: | $1,500 | |||
46 | Private Mortgage Insurance (PMI): | $244.99 | HOA Dues: | $0 | |||
47 | TOTAL Monthly Mortgage Payment (PITI): | $5,083.77 | Pest Control: | $20 | |||
48 | Repairs And Capex: | $794 | Lawn Care: | $140 | |||
49 | Co-Hosting Fee: | $2,382 | Snow Removal: | $40 | |||
50 | Average Platform Fee: | $1,588 | Pool/Hot Tub Maintenance: | $100 | |||
51 | Net Annual Expenses: | $151,027.46 | |||||
52 | Net Monthly Expenses: | $12,585.62 | |||||
53 | |||||||
54 | ONE-TIME DESIGN AND ENHANCEMENTS BUDGET: | NOTES: | |||||
55 | INTERIOR: | EXTERIOR: | |||||
56 | Handyman/General Contractor "Wear And Tear" Enhancements: | $7,500 | Handyman/General Contractor "Wear And Tear" Enhancements: | $4,000 | This home's interior is nice, may need to change a furniture or fixture here and there but overall is quite good compared to its comps. Comps doesn't have much amenities. | ||
57 | One-Time Supplies Stocking: | $1,700 | Games: | $0 | Firepit improvement, patio furnitures, designing and furnitures. | ||
58 | Bedrooms: | $30,000 | Firepit Improvements: | $3,500 | |||
59 | Living Room: | $5,000 | Hot Tub: | $0 | |||
60 | Dining Room: | $6,500 | Sauna: | $8,000 | |||
61 | Basement: | $5,500 | Artificial Turf Putting Green: | $8,500 | PRIORITY SPEND (for the purpose of "differentiation") | ||
62 | Loft Living Area: | $0 | Patio Furniture: | $2,500 | |||
63 | Game Room: | $0 | Pickleball Court: | $35,000 | |||
64 | Garage: | $7,500 | Pool: | $0 | |||
65 | Kitchen Upgrades (Countertops, Cabinet (Vinyl Wraps, Appliance Upgrades) | $7,500 | Stone Patio Walkway | $4,000 | |||
66 | Misc Improvement 2: | $0 | Fridge Upgrade | $1,800 | |||
67 | Paint/Mural: | $4,500 | Hot Tub Fence | $1,500 | |||
68 | Designer: | $17,500 | Emory 9 Foot Kitchen Setup | $8,500 | |||
69 | Total: | $93,200 | Total: | $77,300 | |||
70 | NET DESIGN AND ENHANCEMENTS BUDGET TOTAL: | $170,500 | |||||