ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
2
*EDIT BLUE TEXT ONLY*02nd Home
3
AQUISITION COSTSPROPERTY VARIABLESINCOME SCENARIO 1PROFIT & LOSS PROJECTIONSANNUALIZED RETURN PROJECTIONS0.05Jumbo
4
Purchase Price Per Unit$700,000.00# of Turns5ADR$500.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
5
Closing Cost Percentage2.00%# of Units1Cleaning Fee$300MONTHLYANNUALMONTHLYANNUALMONTHLYANNUALDown Payment$70,000$70,000$70,0000.15DSCR
6
Closing Cost $14,000.00 Yearly Maintenance %3%Nights Booked17Gross Rent Income$8,783$105,400$10,463$125,550$11,703$140,430Closing Cost$14,000$14,000$14,0000.2
7
Reno & Furnishings$68,000 Occupancy Rate56.67%Cleaning Income$1,500$18,000$1,500$18,000$1,500$18,000Reno & Furnishings$68,000$68,000$68,0000.25
8
Set Up Costs (Design & Amenities)$0%%%Set Up Costs (Design & Amenities)$0$0$00.3
9
Seller Credits$0INCOME SCENARIO 2TOTAL INCOME$10,283$123,400100%$11,963$143,550100%$13,203$158,430100%Seller Credits$0$0$00.35
10
Loan Option2ADR$675.00Maintenance Repair$264$3,162$314$3,767$351$4,213TOTAL CASH Needed$152,000$152,000$152,0000.4
11
MORTGAGE CALCULATIONSLoan Option 1Loan Option 2HELOC PaymentCleaning Fee$300Association Fee$84$1,008$84$1,008$84$1,008CASH FLOW$15,428$33,409$47,3960.5
12
Loan TypeDSCR2nd HomeNights Booked15Property Management$0$0$0$0$0$0CASH ON CASH %10%22%31%
13
Purchase Price$700,000$700,000Occupancy Rate50.00%Tech Fee$125$1,500$125$1,500$125$1,500
14
Down Payment Option20%10%Pest Control$75$900$75$900$75$900Break Even Years1053
15
Down Payment$140,000$70,000INCOME SCNEARIO 3Utilities$800$9,600$800$9,600$800$9,600DSCR1.301.651.92
16
Loan Amount$560,000$630,000ADR$755.00Internet/Cable$125$1,500$125$1,500$125$1,500CAP RATE10%12%14%
17
PMI Percentage0.00%0%Cleaning Fee$300Insurance(Click for Quote)$220$2,640$300$3,600$300$3,600
18
PMI Payment$0$233Nights Booked15Cleaning Fee$1,500$18,000$1,500$18,000$1,500$18,000POTENTIAL COST SEGREGATION BENEFIT
19
Occupancy Rate50.00%Household Supplies$150$1,800$150$1,800$150$1,800Potential Tax Savings Year 1 $ 12,288.00 $ 12,288.00 $ 12,288.00
20
Interest Rate7%6.75%8.50%
Hot Tub/Landscaping/Snow Removal
$450$5,400$450$5,400$450$5,400After Tax Savings CoC Return*18%30%39%
21
Amortization303030MONTHLY EXPENSESProperty Taxes$600$7,200$600$7,200$600$7,200
22
Monthly Payment$3,648.62 $4,063.31 $0.00 Association Fee$84.00Marketing(Click)$0$0$0$0$0$0
23
Annual Payment$43,783.49$48,759.74$0.00Property ManagementOTA(Airbnb) Fee$309$3,702$359$4,307$396$4,753
24
Tech Fee$125Click HERE to learn how to qualify for STR Tax Benefits
25
TAX ASSUMPTIONSPest Control$75.00TOTAL EXPENSE$4,701$56,41246%$4,882$58,58141%$4,956$59,47438%
26
Filing Status:MFJUtilities$800.00NOI$5,582$66,98854%$7,081$84,96959%$8,246$98,95662%Click HERE to learn how to find profitable STR properties
27
W2/Business Income: $ - Internet/Cable$125.00HELOC Payment$0$0$0$0$0$0
28
Total Rental Income (All Properties) $ - Insurance(Click for Quote)$300.00PMI Payment$233$2,800$233$2,800$233$2,800
29
Type of Market Mountain (Not Smokies)Cleaning Fee$300.00Debt Service$4,297$51,56042%$4,297$51,56036%$4,297$51,56033%
30
Building Value (Can Override)80%Household Supplies$150.00NET CASH FLOW$1,286$15,42813%$2,784.10$33,40923%$3,950$47,39630%
31
Bonus Depreciation %20%
Hot Tub/Landscaping/Snow Removal
$450.00
32
Property Taxes$600.00
33
Income to Offset:$0 Marketing(Click)$0
34
Purchase Price Needed:$0OTA(Airbnb) Fee3%
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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