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$480,000.00# of Turns5ADR$480.00Scenario 1Scenario 2Scenario 3Scenario 1Scenario 2Scenario 30.1Commercial
5
Closing Cost Percentage3%# of Units1Cleaning Fee$200MONTHLYANNUALMONTHLYANNUALMONTHLYANNUAL
Down Payment
$72,000$72,000$72,0000.15DSCR
6
Closing Cost $14,400.00
Yearly Maintenance %
3%Nights Booked15Gross Rent Income$7,440$89,280$8,370$100,440$9,145$109,740Closing Cost$14,400$14,400$14,4000.2
7
Reno & Furnishings$80,000
Occupancy Rate
50.00%Cleaning Income$1,000$12,000$1,000$12,000$1,000$12,000
Reno & Furnishings
$80,000$80,000$80,0000.25
8
Set Up Costs (Design & Amenities)
$0%%%
Set Up Costs (Design & Amenities)
$0$0$00.3
9
Legal Costs$0INCOME SCENARIO 2TOTAL INCOME$8,440$101,280100%$9,370$112,440100%$10,145$121,740100%Legal Costs$0$0$00.35
10
Loan Option1ADR$540.00Maintenance Repair$223$2,678$251$3,013$274$3,292
TOTAL CASH Needed
$166,400$166,400$166,4000.4
11
MORTGAGE CALCULATIONS
Loan Option 1Loan Option 2HELOC PaymentCleaning Fee$200Association Fee$0$0$0$0$0$0CASH FLOW$20,244$30,734$39,4760.5
12
Loan Type2nd HomeDSCRNights Booked15Property Management$0$0$0$0$0$0
CASH ON CASH %
12%18%24%
13
Purchase Price$480,000$480,000
Occupancy Rate
50.00%Tech Fee$60$720$60$720$60$720
14
Down Payment Option15%20%Pest Control$75$900$75$900$75$900
Break Even Years
854
15
Down Payment$72,000$96,000INCOME SCNEARIO 3Utilities$600$7,200$600$7,200$600$7,200DSCR1.561.852.09
16
Loan Amount$408,000$384,000ADR$590.00Internet/Cable$100$1,200$100$1,200$100$1,200CAP RATE12%14%16%
17
PMI Percentage0.40%0%Cleaning Fee$200Insurance(Click for Quote)$250$3,000$250$3,000$250$3,000
18
PMI Payment$160$0Nights Booked15Cleaning Fee$1,000$12,000$1,000$12,000$1,000$12,000POTENTIAL COST SEGREGATION BENEFIT
19
Occupancy Rate
50.00%Household Supplies$150$1,800$150$1,800$150$1,800
Potential Tax Savings Year 1
#N/A#N/A#N/A
20
Interest Rate7.56%7.56%8.50%Pool, landscaping, snow removal$540$6,480$540$6,480$540$6,480
After Tax Savings CoC Return*
#N/A#N/A#N/A
21
Amortization303030MONTHLY EXPENSESProperty Taxes$440$5,280$440$5,280$440$5,280
22
Monthly Payment$2,851.61 $2,683.87 $0.00
Association Fee
$0.00Marketing(Click)$50$600$50$600$50$600
23
Annual Payment$34,219.34$32,206.44$0.00
Property Management
0%OTA(Airbnb) Fee$253$3,038$281$3,373$304$3,652
24
Tech Fee$60Click HERE to learn how to qualify for STR Tax Benefits
25
TAX ASSUMPTIONSPest Control$75.00TOTAL EXPENSE$3,741$44,89744%$3,797$45,56641%$3,844$46,12438%
26
Filing Status:MFJUtilities$600.00NOI$4,699$56,38356%$5,573$66,87459%$6,301$75,61662%Click HERE to learn how to find profitable STR properties
27
W2/Business Income: $ - Internet/Cable$100.00HELOC Payment$0$0$0$0$0$0
28
Total Rental Income (All Properties)
 $ -
Insurance(Click for Quote)
$250.00PMI Payment$160$1,920$160$1,920$160$1,920
29
Type of Market Mountain (Not Smokies)Cleaning Fee$200.00Debt Service$3,012$36,13936%$3,012$36,13932%$3,012$36,13930%
30
Building Value (Can Override)#N/A
Household Supplies
$150.00NET CASH FLOW$1,687$20,24420%$2,561.19$30,73427%$3,290$39,47632%
31
Bonus Depreciation %25%
Pool, landscaping, snow removal
$540.00
32
Property Taxes
$440.00
33
Income to Offset:$0
Marketing(Click)
$50
34
Purchase Price Needed:$0
OTA(Airbnb) Fee
3%
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