| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | PROPERTY / DEAL DETAILS: | ||||||
2 | >>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST) | ||||||
3 | Property Address | 700 Woodland Bluff Trl, Broken Bow, OK 74728 | Bedroom Count: | 4 | |||
4 | Purchase Price | $825,000 | Bathroom Count: | 5 | |||
5 | Listing URL | Link to Photos | Square Footage: | 2,281 | |||
6 | |||||||
7 | CASHFLOW, TAX SAVINGS AND RETURNS: | NOTES: | |||||
8 | Cash on Cash Return (CoC): | 17.33% | |||||
9 | Annual Cash-Flow: | $46,714.76 | |||||
10 | Estimated Bonus Depreciation: | $264,000.00 | |||||
11 | Estimated Additional Offset: | $166,729.12 | |||||
12 | Total Year 1 Offset: | $430,729.12 | |||||
13 | Year 1 Estimated Net Effective Tax Savings: | $159,369.77 | |||||
14 | Year 1 Estimated Tax Savings And Cash-Flow: | $206,084.53 | |||||
15 | Year 1 ROI: | 76.47% | |||||
16 | Total 5-Year Internal Rate Of Return: | 43.16% | |||||
17 | |||||||
18 | DEAL SNAPSHOT: | NOTES: | |||||
19 | CASH NEEDED: | CASHFLOW, TAX SAVINGS AND RETURNS: | |||||
20 | Purchase Price: | $825,000.00 | |||||
21 | Down Payment: | $82,500.00 | |||||
22 | Mortgage Amount: | $742,500.00 | |||||
23 | Closing Costs: | $42,145.83 | |||||
24 | Seller Credit: | $10,000.00 | |||||
25 | Inspection Seller Credit: | $40,000.00 | <<<seller offering $40,000 pool credit | ||||
26 | Adjusted Closing Costs: | -$7,854.17 | |||||
27 | Total Cash To Close: | $74,645.83 | |||||
28 | Post-Close Enhancements Budget: | $194,856.20 | |||||
29 | Total Cash Needed: | $269,502.03 | |||||
30 | |||||||
31 | MONTHLY INCOME PROJECTIONS: | NOTES: | |||||
32 | Average Nightly Rate (ADR): | $850 | |||||
33 | Average Occupancy (OCC): | 60% | |||||
34 | Gross Booking Revenue: | $15,513 | |||||
35 | Cleaning Revenue: | $1,656 | |||||
36 | Gross Monthly Income: | $17,169 | |||||
37 | Gross Annual Revenue (Before ALL Expenses) | $206,026 | |||||
38 | Net Annual Cashflow (After ALL Expenses) | $46,715 | |||||
39 | Net Monthly Cashflow (After ALL Expenses) | $3,893 | |||||
40 | |||||||
41 | RECURRING MONTHLY EXPENSES BREAKDOWN: | NOTES: | |||||
42 | RECURRING PAYMENTS: | UTILITIES: | |||||
43 | Principal + Interest Payments: | $4,451.66 | Water/Sewer: | $147 | |||
44 | Property Taxes: | $395.83 | Gas And Electricity: | $483 | |||
45 | STR Insurance Policy: | $400.00 | Internet: | $93 | |||
46 | Flood Insurance: | $0.00 | Cleaning: | $1,656 | |||
47 | Private Mortgage Insurance (PMI): | $286.69 | HOA Dues: | $63 | |||
48 | TOTAL Monthly Mortgage Payment (PITI): | $5,534.18 | Pest Control: | $20 | |||
49 | Repairs And Capex: | $200 | Lawn Care: | $126 | |||
50 | Co-Hosting Fee: | $2,792 | Snow Removal: | $0 | |||
51 | Average Platform Fee: | $1,862 | Pool/Hot Tub Maintenance: | $300 | |||
52 | Net Annual Expenses: | $159,310.84 | |||||
53 | Net Monthly Expenses: | $13,275.90 | |||||
54 | |||||||
55 | ONE-TIME DESIGN AND ENHANCEMENTS BUDGET: | NOTES: | |||||
56 | INTERIOR: | EXTERIOR: | |||||
57 | Handyman/General Contractor "Wear And Tear" Enhancements: | $2,500 | Handyman/General Contractor "Wear And Tear" Enhancements: | $0 | |||
58 | One-Time Supplies Stocking: | $1,356 | Games: | $0 | |||
59 | Bedrooms: | $15,000 | Firepit: | $3,500 | More bedroom/has bunk beds | ||
60 | Living Room: | $3,500 | Hot Tub: | $0 | Has a pingpong game table/billard/indoor games or activities | ||
61 | Dining Room: | $3,500 | Sauna: | $15,000 | Has some commercial-Grade Arcade Machines | ||
62 | Basement: | $0 | Artificial Turf Putting Green: | $10,000 | Has an outdoor Swing & slide | ||
63 | Loft Living Area: | $0 | Patio Furniture: | $3,500 | |||
64 | Game Room: | $0 | Pickleball Court: | $35,000 | |||
65 | Garage: | $0 | Pool: | $75,000 | |||
66 | Multi-Game Tables | $3,000 | Outdoor swing & slide | $1,500 | |||
67 | Commercial-Grade Arcade Machines | $3,000 | Kids' Jungle Gym Play Area | $4,500 | B67 arcade setups in that orphan space behind living/dining room area is probably all you can fit in | ||
68 | Paint/Mural: | $0 | Misc Amenity 3: | $0 | |||
69 | Designer: | $15,000 | Misc Amenity 4: | $0 | |||
70 | Total: | $46,856 | Total: | $148,000 | |||
71 | NET DESIGN AND ENHANCEMENTS BUDGET TOTAL: | $194,856 | |||||