ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
*EDIT BLUE TEXT ONLY*02nd Home
2
AQUISITION COSTSPROPERTY VARIABLESINCOME SCENARIO 1PROFIT & LOSS PROJECTIONSANNUALIZED RETURN PROJECTIONS0.05Jumbo
3
Purchase Price Per Unit
$710,000.00# of Turns5ADR$865.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
4
Closing Cost Percentage
2%# of Units1Cleaning Fee$300MONTHLYANNUALMONTHLYANNUALMONTHLYANNUALDown Payment$170,400$170,400$170,4000.15DSCR
5
Closing Cost $14,200.00 Yearly Maintenance %3%Nights Booked15
Gross Rent Income
$13,408$160,890$15,035$180,420$16,740$200,880Closing Cost$14,200$14,200$14,2000.2
6
Reno & Furnishings$275,000 Occupancy Rate50.00%Cleaning Income$1,500$18,000$1,500$18,000$1,500$18,000Reno & Furnishings$275,000$275,000$275,0000.25
7
Set Up Costs (Design & Amenities)
$81,000%%%
Set Up Costs (Design & Amenities)
$81,000$81,000$81,0000.3
8
Legal Costs$0INCOME SCENARIO 2
TOTAL INCOME
$14,908$178,890100%$16,535$198,420100%$18,240$218,880100%Legal Costs$0$0$00.35
9
Loan Option1ADR$970.00
Maintenance Repair
$402$4,827$451$5,413$502$6,026TOTAL CASH Needed$540,600$540,600$540,6000.4
10
MORTGAGE CALCULATIONS
Loan Option 1Loan Option 2HELOC PaymentCleaning Fee$300Association Fee$0$0$0$0$0$0CASH FLOW$71,145$89,503$108,7350.5
11
Loan TypeCommercial2nd HomeNights Booked15
Property Management
$0$0$0$0$0$0CASH ON CASH %13%17%20%
12
Purchase Price$710,000$710,000Occupancy Rate50.00%Tech Fee$120$1,440$120$1,440$120$1,440
13
Down Payment Option
24%15%Pest Control$75$900$75$900$75$900Break Even Years865
14
Down Payment$170,400$106,500INCOME SCNEARIO 3Utilities$700$8,400$700$8,400$700$8,400DSCR2.542.933.35
15
Loan Amount$539,600$603,500$0ADR$1,080.00Internet/Cable$100$1,200$100$1,200$100$1,200CAP RATE17%19%22%
16
PMI Percentage0.0%0%Cleaning Fee$300
Insurance(Click for Quote)
$550$6,600$550$6,600$550$6,600
17
PMI Payment$0$0Nights Booked15Cleaning Fee$1,500$18,000$1,500$18,000$1,500$18,000POTENTIAL COST SEGREGATION BENEFIT
18
Occupancy Rate50.00%
Household Supplies
$125$1,500$125$1,500$125$1,500
Potential Tax Savings Year 1
 $ 56,222.00 $ 56,222.00 $ 56,222.00
19
Interest Rate7.80%6.35%8.50%
Pool or other fees
$500$6,000$500$6,000$500$6,000
After Tax Savings CoC Return*
24%27%31%
20
Amortization302510MONTHLY EXPENSESProperty Taxes$400$4,800$400$4,800$400$4,800
21
Monthly Payment$3,859.34 $3,997.34 $0.00 Association Fee$0.00Marketing(Click)$200$2,400$200$2,400$200$2,400
22
Annual Payment$46,312.03$47,968.06$0.00Property Management0%OTA(Airbnb) Fee$447$5,367$496$5,953$547$6,566
23
Tech Fee$120
24
TAX ASSUMPTIONSPest Control$75.00
TOTAL EXPENSE
$5,119$61,43334%$5,217$62,60532%$5,319$63,83329%
25
Filing Status:MFJUtilities$700.00NOI$9,788$117,45766%$11,318$135,81568%$12,921$155,04771%
26
W2/Business Income: $ 500,000.00 Internet/Cable$100.00HELOC Payment$0$0$0$0$0$0
27
Total Rental Income (All Properties)
 $ 100,000.00 Insurance(Click for Quote)$550.00PMI Payment$0$0$0$0$0$0
28
Type of Market LakeCleaning Fee$300.00Debt Service$3,859$46,31226%$3,859$46,31223%$3,859$46,31221%
29
Building Value (Can Override)
80%Household Supplies$125.00
NET CASH FLOW
$5,929$71,14540%$7,458.56$89,50345%$9,061$108,73550%
30
Bonus Depreciation %25%Pool or other fees$500.00
31
Property Taxes$400.00
32
Income to Offset:$600,000 Marketing(Click)$200
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