ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
*EDIT BLUE TEXT ONLY*02nd Home
2
AQUISITION COSTSPROPERTY VARIABLESINCOME SCENARIO 1PROFIT & LOSS PROJECTIONSANNUALIZED RETURN PROJECTIONS0.05Jumbo
3
Purchase Price Per Unit
$1,000,000.00# of Turns5ADR$800.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
4
Closing Cost Percentage
4%# of Units1Cleaning Fee$700MONTHLYANNUALMONTHLYANNUALMONTHLYANNUALDown Payment$150,000$150,000$150,0000.15DSCR
5
Closing Cost $40,000.00
Yearly Maintenance %
4%Nights Booked14
Gross Rent Income
$11,573$138,880$20,904$250,852$36,167$434,000Closing Cost$0$0$00.2
6
Reno & Furnishings$400,000 Occupancy Rate46.67%
Cleaning Income
$3,500$42,000$3,500$42,000$3,500$42,000Reno & Furnishings$400,000$400,000$400,0000.25
7
Set Up Costs (Design & Amenities)
$42,000%%%
Set Up Costs (Design & Amenities)
$42,000$42,000$42,0000.3
8
Legal Costs$0INCOME SCENARIO 2
TOTAL INCOME
$15,073$180,880100%$24,404$292,852100%$39,667$476,000100%Legal Costs$0$0$00.35
9
Loan Option1ADR$1,445.00
Maintenance Repair
$463$5,555$836$10,034$1,447$17,360TOTAL CASH Needed$592,000$592,000$592,0000.4
10
MORTGAGE CALCULATIONS
Loan Option 1Loan Option 2
HELOC Payment
Cleaning Fee$700
Association Fee
$0$0$0$0$0$0CASH FLOW$808$104,942$275,2700.5
11
Loan TypeCommercial2nd HomeNights Booked14
Property Management
$0$0$0$0$0$0CASH ON CASH %0%18%46%
12
Purchase Price$1,000,000$1,000,000Occupancy Rate46.67%Tech Fee$120$1,440$120$1,440$120$1,440Gross Revenue$138,880$250,852$434,000
13
Down Payment Option
15%15%Pest Control$75$900$75$900$75$900Break Even Years73262
14
Down Payment$150,000$150,000INCOME SCNEARIO 3Utilities$1,100$13,200$1,100$13,200$1,100$13,200DSCR1.012.725.52
15
Loan Amount$850,000$850,000$0ADR$2,500.00
Internet/Cable
$125$1,500$125$1,500$125$1,500CAP RATE6%17%34%
16
PMI Percentage0.0%0%Cleaning Fee$700
Insurance(Click for Quote)
$900$10,800$900$10,800$900$10,800
17
PMI Payment$0$0Nights Booked14Cleaning Fee$3,500$42,000$3,500$42,000$3,500$42,000POTENTIAL COST SEGREGATION BENEFIT
18
Occupancy Rate46.67%
Household Supplies
$400$4,800$400$4,800$400$4,800
Potential Tax Savings Year 1
 $ 76,142.00 $ 76,142.00 $ 76,142.00
19
Interest Rate6.00%6.35%8.50%
Pool or other fees
$1,300$15,600$1,300$15,600$1,300$15,600
After Tax Savings CoC Return*
13%31%59%
20
Amortization302510MONTHLY EXPENSES
Property Taxes
$1,500$18,000$1,500$18,000$1,500$18,000
21
Monthly Payment$5,070.83 $5,630.05 $0.00 Association Fee$0.00
Marketing(Click)
$0$0$0$0$0$0
22
Annual Payment$60,849.90$67,560.65$0.00Property Management0%
OTA(Airbnb) Fee
$452$5,426$732$8,786$1,190$14,280
23
Tech Fee$120
24
TAX ASSUMPTIONSPest Control$75.00
TOTAL EXPENSE
$9,935$119,22266%$10,588$127,06043%$11,657$139,88029%
25
Filing Status:MFJUtilities$1,100.00NOI$5,138$61,65834%$13,816$165,79257%$28,010$336,12071%
26
W2/Business Income: $ 500,000.00 Internet/Cable$125.00
HELOC Payment
$0$0$0$0$0$0
27
Total Rental Income (All Properties)
 $ 100,000.00
Insurance(Click for Quote)
$1,000.00PMI Payment$0$0$0$0$0$0
28
Type of Market LakeCleaning Fee$700.00
Debt Service
$5,071$60,85034%$5,071$60,85021%$5,071$60,85013%
29
Building Value (Can Override)
80%Household Supplies$400.00
NET CASH FLOW
$67$8080%$8,745.20$104,94236%$22,939$275,27058%
30
Bonus Depreciation %25%Pool or other fees$1,300.00
31
Property Taxes$1,200.00
32
Income to Offset:$600,000 Marketing(Click)$0
33
Purchase Price Needed:
$3,000,000OTA(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%
50
Smokies92%
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