ABCDEFG
1
PROPERTY / DEAL DETAILS:
2
>>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST)
3
Property Address2104 Valley Creek Way, Sevierville, TN 37862Bedroom Count:4
4
Purchase Price$975,000Bathroom Count:6
5
Listing URLLink to PhotosSquare Footage:2,586
6
7
CASHFLOW, TAX SAVINGS AND RETURNS:NOTES:
8
Cash on Cash Return (CoC):15.71%
9
Annual Cash-Flow:$28,047.67
10
Estimated Bonus Depreciation:$273,000.00
11
Estimated Additional Offset:$130,938.46
12
Total Year 1 Offset:$403,938.46
13
Year 1 Estimated Net Effective Tax Savings:$149,457.23
14
Year 1 Estimated Tax Savings And Cash-Flow:$177,504.90
15
Year 1 ROI:99.44%
16
17
DEAL SNAPSHOT:NOTES:
18
CASH NEEDED:CASHFLOW, TAX SAVINGS AND RETURNS:
19
Purchase Price:$975,000.00
20
Down Payment:$97,500.00
21
Mortgage Amount:$877,500.00
22
Closing Costs:$15,342.53
23
Seller Credit:$0.00
24
Inspection Seller Credit:$35,000.00
25
Adjusted Closing Costs:-$19,657.47
26
Total Cash To Close:$77,842.53
27
Post-Close Enhancements Budget:$100,667.20
28
Total Cash Needed:$178,509.73
29
30
MONTHLY INCOME PROJECTIONS:NOTES:
31
Average Nightly Rate (ADR):$650Comp 1 = $194k
32
Average Occupancy (OCC):74%Comp 2 = $200k
33
Gross Booking Revenue:$14,630Comp 3 = $210k
34
Cleaning Revenue:$1,500Comp 4 = $234k
35
Gross Monthly Income:$16,130Comp 5 = $228k
36
Gross Annual Revenue (Before ALL Expenses)$193,565Comp 6 = $176k
37
Net Annual Cashflow (After ALL Expenses)$28,048NK NOTES: We need to commit to a theme similar to the nubmer one performing spot, and know that it will be around $60k-$80k all-in paying the designer plus furniture/wall decor/paint budget.
38
Net Monthly Cashflow (After ALL Expenses)$2,337MAIN COMP: Airbnb Listing URL | Airdna Listing URL
39
40
RECURRING MONTHLY EXPENSES BREAKDOWN:NOTES:
41
RECURRING PAYMENTS:UTILITIES:
42
Principal + Interest Payments:$5,460.12Water/Sewer:$161
43
Property Taxes:$266.67Gas And Electricity:$431
44
STR Insurance Policy:$497.99Internet:$96
45
Flood Insurance:$0.00Cleaning:$1,500
46
Private Mortgage Insurance (PMI):$338.81HOA Dues:$183
47
TOTAL Monthly Mortgage Payment (PITI):$6,563.59Pest Control:$20
48
Repairs And Capex:$250Lawn Care:$0
49
Co-Hosting Fee:$2,633Snow Removal:$0
50
Average Platform Fee:$1,756Pool/Hot Tub Maintenance:$200
51
Net Annual Expenses:$165,517.33
52
Net Monthly Expenses:$13,793.11
53
54
ONE-TIME DESIGN AND ENHANCEMENTS BUDGET:NOTES:
55
INTERIOR:EXTERIOR:
56
Handyman/General Contractor "Wear And Tear" Enhancements:$1,500Handyman/General Contractor "Wear And Tear" Enhancements:$5,000This home has a typical good looking cabin. Nice baths, has an unfinished indoor pool, decks, countertops and a fireplace. Has a killer mountain view.
57
One-Time Supplies Stocking:$1,417Games:$0Improvements on the furnitures like bed frames, couches, bunk beds. Design enhancements and probably repainting of walls or painting wall murals/accent walls.
58
Bedrooms:$26,000Firepit:$1,500<<<increased budget for bedrooms to match qualify of bunkbeds and some small custom furniture (safari theme from comp - we'll try and model with a different them but out-perform)
59
Living Room:$5,000Hot Tub:$9,500potentilally budget higher for hot tub install since they need to lift/crane this thing up to the balcony
60
Dining Room:$5,000Sauna:$0
61
Basement:$0Artificial Turf Putting Green:$0
62
Loft Living Area:$0Patio Furniture:$3,750exterior balconies: balcony 1 - similar patio table w/ chairs as main comp | balcony 2 - narrow gas fireplace with small sofa sectional L/U shaped around

add in hot tub in whichever balcony makes sense - model this setup
63
Game Room:$7,500Pickleball Court:$0
64
Garage:$0Pool:$0
65
Design improvements budget:$5,000Misc Amenity 1:$0
66
Misc Improvement 2:$0Misc Amenity 2:$0
67
Paint/Mural:$4,500Misc Amenity 3:$0
68
Designer:$25,000Misc Amenity 4:$0
69
Total:$80,917Total:$19,750
70
NET DESIGN AND ENHANCEMENTS BUDGET TOTAL:$100,667