ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
*EDIT BLUE TEXT ONLY*02nd Home
2
AQUISITION COSTSPROPERTY VARIABLESINCOME SCENARIO 1PROFIT & LOSS PROJECTIONSANNUALIZED RETURN PROJECTIONS0.05Jumbo
3
Purchase Price Per Unit
$615,000.00# of Turns10ADR$710.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
4
Closing Cost Percentage
2%# of Units1Cleaning Fee$375MONTHLYANNUALMONTHLYANNUALMONTHLYANNUALDown Payment$140,000$140,000$140,0000.15DSCR
5
Closing Cost $14,000.00 Yearly Maintenance %2%Nights Booked17Gross Rent Income$12,461$149,526$14,040$168,480$17,164$205,967Closing Cost$14,000$14,000$14,0000.2
6
Reno & Furnishings$250,000 Occupancy Rate55.00%Cleaning Income$3,750$45,000$3,750$45,000$3,750$45,000Reno & Furnishings$250,000$250,000$250,0000.25
7
Set Up Costs (Design & Amenities)
$35,000%%%
Set Up Costs (Design & Amenities)
$35,000$35,000$35,0000.3
8
Legal Costs$0INCOME SCENARIO 2TOTAL INCOME$16,211$194,526100%$17,790$213,480100%$20,914$250,967100%Legal Costs$0$0$00.35
9
Loan Option1ADR$800.00Maintenance Repair$249$2,991$281$3,370$343$4,119TOTAL CASH Needed$439,000$439,000$439,0000.4
10
MORTGAGE CALCULATIONS
Loan Option 1Loan Option 2HELOC PaymentCleaning Fee$375Association Fee$0$0$0$0$0$0CASH FLOW$46,712$62,823$94,6860.5
11
Loan TypeCommercial2nd HomeNights Booked17Property Management$1,621$19,453$1,779$21,348$2,091$25,097CASH ON CASH %11%14%22%
12
Purchase Price$700,000$900,000Occupancy Rate55.00%Tech Fee$100$1,200$100$1,200$100$1,200
13
Down Payment Option
20%0%Pest Control$75$900$75$900$75$900Break Even Years975
14
Down Payment$140,000$0INCOME SCNEARIO 3Utilities$600$7,200$600$7,200$600$7,200DSCR2.002.353.03
15
Loan Amount$560,000$900,000$0ADR$978.00Internet/Cable$120$1,440$120$1,440$120$1,440CAP RATE15%18%23%
16
PMI Percentage0.0%0%Cleaning Fee$375Insurance(Click for Quote)$500$6,000$500$6,000$500$6,000
17
PMI Payment$0$0Nights Booked17Cleaning Fee$4,000$48,000$4,000$48,000$4,000$48,000POTENTIAL COST SEGREGATION BENEFIT
18
Occupancy Rate55.00%Household Supplies$200$2,400$200$2,400$200$2,400
Potential Tax Savings Year 1
 $ 65,905.38 $ 65,905.38 $ 65,905.38
19
Interest Rate7.50%7.25%8.50%Snow Plowing$75$900$75$900$75$900
After Tax Savings CoC Return*
26%29%37%
20
Amortization302510MONTHLY EXPENSESProperty Taxes$400$4,800$400$4,800$400$4,800
21
Monthly Payment$3,891.28 $6,466.20 $0.00 Association Fee$0.00Marketing(Click)$0$0$0$0$0$0
22
Annual Payment$46,695.37$77,594.34$0.00Property Management10%OTA(Airbnb) Fee$486$5,836$534$6,404$627$7,529
23
Tech Fee$100
24
TAX ASSUMPTIONSPest Control$75.00TOTAL EXPENSE$8,427$101,11952%$8,664$103,96249%$9,132$109,58544%
25
Filing Status:MFJUtilities$600.00NOI$7,784$93,40748%$9,127$109,51851%$11,782$141,38256%
26
W2/Business Income: $ 800,000.00 Internet/Cable$120.00HELOC Payment$0$0$0$0$0$0
27
Total Rental Income (All Properties)
Insurance(Click for Quote)$500.00PMI Payment$0$0$0$0$0$0
28
Type of Market Mountain (Not Smokies)Cleaning Fee$400.00Debt Service$3,891$46,69524%$3,891$46,69522%$3,891$46,69519%
29
Building Value (Can Override)
85%Household Supplies$200.00NET CASH FLOW$3,893$46,71224%$5,235.22$62,82329%$7,891$94,68638%
30
Bonus Depreciation %25%Snow Plowing$75.00
31
Property Taxes$400.00
32
Income to Offset:$200,000 Marketing(Click)$0
33
Purchase Price Needed:
$1,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