ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
*EDIT BLUE TEXT ONLY*65372980602nd Home
2
AQUISITION COSTSPROPERTY VARIABLESINCOME SCENARIO 1PROFIT & LOSS PROJECTIONSANNUALIZED RETURN PROJECTIONS0.05Jumbo
3
Purchase Price Per Unit$719,000.00# of Turns6.25ADR$550.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
4
Closing Cost Percentage3.5%# of Units1Cleaning Fee$300MONTHLYANNUALMONTHLYANNUALMONTHLYANNUALDown Payment$71,900$71,900$71,9000.15DSCR
5
Closing Cost $25,165.00 Yearly Maintenance %2%Nights Booked20Gross Rent Income$11,367$136,400$12,917$155,000$14,467$173,600Closing Cost$25,165$25,165$25,1650.2
6
Reno & Furnishings$76,500 Occupancy Rate66.67%Cleaning Income$1,875$22,500$1,875$22,500$1,875$22,500Reno & Furnishings$76,500$76,500$76,5000.25
7
Set Up Costs (Design & Amenities)$25,000%%%Set Up Costs (Design & Amenities)$25,000$25,000$25,0000.3
8
Legal Costs$0INCOME SCENARIO 2TOTAL INCOME$13,242$158,900100%$14,792$177,500100%$16,342$196,100100%Legal Costs$0$0$00.35
9
Loan Option2ADR$625.00Maintenance Repair$227$2,728$258$3,100$289$3,472TOTAL CASH Needed$198,565$198,565$198,5650.4
10
MORTGAGE CALCULATIONSLoan Option 1Loan Option 2HELOC PaymentCleaning Fee$300Association Fee$535$6,425$535$6,425$535$6,425CASH FLOW$47,105$64,775$82,4450.5
11
Loan TypeDSCR2nd HomeNights Booked20Property Management$0$0$0$0$0$0CASH ON CASH %24%33%42%
12
Purchase Price$719,000$719,000Occupancy Rate66.67%Tech Fee$150$1,800$150$1,800$150$1,800
13
Down Payment Option20%10%Pest Control$45$540$45$540$45$540Break Even Years432
14
Down Payment$143,800$71,900INCOME SCNEARIO 3Utilities + Trash + Gas$800$9,600$800$9,600$800$9,600DSCR2.022.402.78
15
Loan Amount$575,200$647,100ADR$700.00Internet/Cable$125$1,500$125$1,500$125$1,500CAP RATE13%15%18%
16
PMI Percentage0.0%0%Cleaning Fee$300Insurance(Click for Quote)$208$2,500$208$2,500$208$2,5000.08493650909
17
PMI Payment$0$0Nights Booked20Cleaning Fee$1,875$22,500$1,875$22,500$1,875$22,500POTENTIAL COST SEGREGATION BENEFIT
18
Occupancy Rate66.67%Household Supplies$200$2,400$200$2,400$200$2,400Potential Tax Savings Year 1 $ 40,570.50 $ 40,570.50 $ 40,570.50
19
Interest Rate7.25%6.00%9.00%
Pool/Lawn Care/Snow Removal
$350$4,200$350$4,200$350$4,200After Tax Savings CoC Return*44%53%62%
20
Amortization303010MONTHLY EXPENSESProperty Taxes$542$6,510$542$6,510$542$6,510
21
Monthly Payment$3,900.31 $3,860.39 $0.00 Association Fee$535.42Marketing(Click)$0$0$0$0$0$0
22
Annual Payment$46,803.76$46,324.67$0.00Property Management0%OTA(Airbnb) Fee$397$4,767$444$5,325$490$5,883
23
Tech Fee$150Click HERE to learn how to qualify for STR Tax Benefits
24
TAX ASSUMPTIONSPest Control$45.00TOTAL EXPENSE$5,456$65,47041%$5,533$66,40037%$5,611$67,33034%
25
Filing Status:MFJUtilities + Trash + Gas$800.00NOI$7,786$93,43059%$9,258$111,10063%$10,731$128,77066%Click HERE to learn how to find profitable STR properties
26
W2/Business Income:Internet/Cable$125.00HELOC Payment$0$0$0$0$0$0
27
Total Rental Income (All Properties)Insurance(Click for Quote)$208.33PMI Payment$0$0$0$0$0$0
28
Type of Market Mountain (Not Smokies)Cleaning Fee$300Debt Service$3,860$46,32529%$3,860$46,32526%$3,860$46,32524%
29
Building Value (Can Override)85%Household Supplies$200.00NET CASH FLOW$3,925$47,10530%$5,397.96$64,77536%$6,870$82,44542%
30
Bonus Depreciation %60%
Pool/Lawn Care/Snow Removal
$350.00
31
Property Taxes$542.49
32
Income to Offset:$1,000,000 Marketing(Click)$0
33
Purchase Price Needed:$2,083,333OTA(Airbnb) Fee3%
34
35
36
37
38
39
40
41
42
43
44
45
Lake85%
46
Beach (Not Condo/Townhome)70%
47
Beach (Condo/Townhome)95%
48
City Market80%
49
Mountain (Not Smokies)85%
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101