| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | PROPERTY / DEAL DETAILS: | ||||||||
2 | >>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST) | INTERNAL USE ONLY KEY | |||||||
3 | Property Address | 7430 Ventnor Dr, Tobyhanna, PA 18466 | Bedroom Count: | 4 | Yield | 21 | |||
4 | Purchase Price | $275,000 | Bathroom Count: | 2 | State | PA | |||
5 | Listing URL | Link to Photos | Square Footage: | 1,215 | Months left in the year | 7 | |||
6 | Is the home furnished (Y/N) | Y | |||||||
7 | CASHFLOW, TAX SAVINGS AND RETURNS: | NOTES: | |||||||
8 | Cash on Cash Return (CoC): | 17.41% | |||||||
9 | Annual Cash-Flow: | $33,191.12 | Client Credit Score | 780 | |||||
10 | Estimated Bonus Depreciation: | $88,000.00 | |||||||
11 | Estimated Additional Offset: | $143,502.24 | |||||||
12 | Total Year 1 Offset: | $231,502.24 | |||||||
13 | Year 1 Estimated Net Effective Tax Savings: | $85,655.83 | |||||||
14 | Year 1 Estimated Tax Savings And Cash-Flow: | $118,846.95 | |||||||
15 | Year 1 ROI: | 62.34% | |||||||
16 | Case-Shiller annual appreciation assumption | 4.00% | |||||||
17 | DEAL SNAPSHOT: | NOTES: | Interest Rate | 6.50% | |||||
18 | CASH NEEDED: | CASHFLOW, TAX SAVINGS AND RETURNS: | Term: (Years) | 30 | |||||
19 | Purchase Price: | $275,000.00 | # of Payments | 360 | |||||
20 | Down Payment: | $27,500.00 | Hot tub (Y/N) | Yes | |||||
21 | Mortgage Amount: | $247,500.00 | Pool (Y/N) | No | |||||
22 | Closing Costs: | $12,673.48 | HOA Fees (Month) | $0.00 | |||||
23 | Seller Credit: | $7,500.00 | |||||||
24 | Inspection Seller Credit: | $2,500.00 | |||||||
25 | Adjusted Closing Costs: | $2,673.48 | |||||||
26 | Total Cash To Close: | $30,173.48 | CLOSING KEY: | ||||||
27 | Post-Close Enhancements Budget: | $160,465.50 | Down Payment % | 10.00% | |||||
28 | Total Cash Needed: | $190,638.98 | Closing Cost % | 4.61% | |||||
29 | Home Depreciation % | 32.00% | |||||||
30 | MONTHLY INCOME PROJECTIONS: | NOTES: | Tax Bracket: | 37.00% | |||||
31 | Average Nightly Rate (ADR): | $455 | Revenue potential | INCOME KEY: | |||||
32 | Average Occupancy (OCC): | 63% | 119k comp | Average Number Of Reservations Per Month: | 6 | ||||
33 | Gross Booking Revenue: | $8,719 | 118k comp | Average Number Of Cleans Per Month: | 6 | ||||
34 | Cleaning Revenue: | $1,500 | 98k comp | Average Cleaning Revenue: | $250 | ||||
35 | Gross Monthly Income: | $10,219 | Average Cleaning Expense: | $250 | |||||
36 | Gross Annual Revenue (Before ALL Expenses) | $122,627 | |||||||
37 | Net Annual Cashflow (After ALL Expenses) | $33,191 | |||||||
38 | Net Monthly Cashflow (After ALL Expenses) | $2,766 | Gross Booking Revenue: | $104,627 | |||||
39 | Gross Yearly Revenue: | $122,627 | |||||||
40 | RECURRING MONTHLY EXPENSES BREAKDOWN: | NOTES: | |||||||
41 | RECURRING PAYMENTS: | UTILITIES: | EXPENSE KEY: | ||||||
42 | Principal + Interest Payments: | $1,564.37 | Water/Sewer: | $101 | Property Tax (Year) | $2,248.00 | |||
43 | Property Taxes: | $187.33 | Gas And Electricity: | $280 | Property Tax (Month) | $187.33 | |||
44 | STR Insurance Policy: | $155.18 | Internet: | $82 | Insurance (Year) | $1,862.15 | |||
45 | Flood Insurance: | $0.00 | Cleaning: | $1,500 | Insurance (Month) | $155.18 | |||
46 | Private Mortgage Insurance (PMI): | $95.56 | HOA Dues: | $149 | Flood Insurance (Y/N) | No | |||
47 | TOTAL Monthly Mortgage Payment (PITI): | $2,002.44 | Pest Control: | $20 | Flood Insurance ($) | $0 | |||
48 | Repairs And Capex: | $523 | Lawn Care: | $0 | Flood Insurance (Monthly) | $0 | |||
49 | Co-Hosting Fee: | $1,569 | Snow Removal: | $30 | |||||
50 | Average Platform Fee: | $1,046 | Pool/Hot Tub Maintenance: | $150 | |||||
51 | Net Annual Expenses: | $89,436.13 | |||||||
52 | Net Monthly Expenses: | $7,453.01 | |||||||
53 | |||||||||
54 | ONE-TIME DESIGN AND ENHANCEMENTS BUDGET: | NOTES: | DESIGN KEY (INTERNAL USE ONLY) | ||||||
55 | INTERIOR: | EXTERIOR: | Cost Per Square Foot: | ||||||
56 | Handyman/General Contractor "Wear And Tear" Enhancements: | $5,500 | Handyman/General Contractor "Wear And Tear" Enhancements: | $3,500 | Average Cost Per Bedroom: | ||||
57 | One-Time Supplies Stocking: | $1,143 | Games: | $1,500 | |||||
58 | Bedrooms: | $16,000 | Firepit: | $3,500 | |||||
59 | Living Room: | $4,000 | Hot Tub: | $12,000 | |||||
60 | Dining Room: | $4,000 | Sauna: | $12,000 | |||||
61 | Basement: | $0 | Artificial Turf Putting Green: | $7,000 | |||||
62 | Loft Living Area: | $0 | Patio Furniture: | $1,000 | |||||
63 | Game Room: | $3,500 | Pickleball Court: | $0 | |||||
64 | Garage: | $0 | Pool: | $70,000 | |||||
65 | Misc Improvement 1: | $0 | Misc Amenity 1: | $0 | |||||
66 | Misc Improvement 2: | $0 | Misc Amenity 2: | $0 | |||||
67 | Paint/Mural: | $1,823 | Misc Amenity 3: | $0 | |||||
68 | Designer: | $14,000 | Misc Amenity 4: | $0 | |||||
69 | Total: | $49,966 | Total: | $110,500 | |||||
70 | NET DESIGN AND ENHANCEMENTS BUDGET TOTAL: | $160,466 | |||||||