ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
3
4
5
Stabilized Year 1 - Short Term Vacation Rental CashflowInstructions: Only cells in light green require inputs. All other cells autocalculate.
6
Assumptions1Total Purchase Price: Enter total purchase price (including closing costs) in C7.
7
 Total Purchase Price$750,000 100% ADR$525 2Loan Amount: If you will be borrowing against the property, enter the loan percentage in D8. If you are not borrowing, select 0.00. Loan amount will autocalculate in C8.
8
 Loan Amount$525,000 70.00%Days Available3653Cash Amount: Both C7 and D9 will autocalculate based on your C9 input.
9
 Cash Amount$225,000 30% Occupancy Rate65.00%4Interest Rate: Select the interest rate for your loan in C10.
10
 Interest Rate6.50%5Average Daily Rate (ADR): This is the projected average daily rate for the 365 day period that you expect to be leasing your property. Insert this ADR projection in F7.
11
Effective Gross Rental Income$124,556 16.61%% of Purchase Price5Days Available: This is the projected number of days that you expect to be leasing your property. Insert this projection in F8.
12
Property Expenses6Occupancy Rate: This is the projected % of time that you expect your property to be leased over the 365 day period. Insert this Occupancy projection in F9.
13
Fixed Expenses7Effective Gross Rental Income: The EGRI is based on the (ADR (F7) x Days Available (F8)) x Occupancy Rate (F9). This cell autocalculates in C11.
14
 Taxes$4,000 3.21%HistoricalAnnually8Taxes: Enter the total projected property tax expenses for the property in C14. Then select if this was based on historical or market data in E14.
15
 Insurance$2,000 1.61%MarketAnnually9Insurance: Enter the total projected insurance expenses for the property in C15. Then select if this was based on historical or market data in E15.
16
Variable Expenses
17
 HOA$3,000 2.41%HistoricalAnnually10HOA: Enter the total projected HOA Dues (if applicable) for the property in C17. If none, enter "0". Then select if this was based on historical or market data in E17.
18
 Gas/Electric$3,500 2.81%HistoricalAnnually11Gas/Electric: Enter the total projected gas and electric expenses for the property in C18. Then select if this was based on historical or market data in E18.
19
 Water Sewer$1,200 0.96%HistoricalAnnually12Water/Sewer: Enter the total projected water and sewer expenses for the property in C19. Then select if this was based on historical or market data in E19.
20
 Trash$0 0.00%HistoricalAnnually13Trash: Enter the total projected trash expenses for the property in C20. Then select if this was based on historical or market data in E20.
21
 Internet/TV$0 0.00%HistoricalAnnually14Internet/TV: Enter the total projected internet and tv expenses for the property in C21. Then select if this was based on historical or market data in E21.
22
 Repairs and Maintenance$3,000 2.41%HistoricalAnnually15Repairs and Maintenance: Enter total project repairs and maintenance expenses for the property in C22. Then select if this was based on historical or market data in E22.
23
 Miscellaneous$0 0.00%HistoricalAnnually16Miscellaneous: Enter any miscellaneous expenses for the property in C23. Then select if this was based on historical or market data in E23.
24
 Miscellaneous$0 0.00%HistoricalAnnually17Miscellaneous: Enter any miscellaneous expenses for the property in C24. Then select if this was based on historical or market data in E24.
25
 Administration$1,868 1.50%MarketAnnually18Administration: Enter the projected administrative expenses for the property as a % of EGRI in D25. Then select if this was based on historical or market data in E25.
26
 Property Listing Services$3,737 3.00%MarketAnnually19Property Listing Services: Enter the projected property listing expenses for the property as a % of EGRI in D26. Then select if this was based on historical or market data in E26.
27
 Management Fee$18,683 15.00%MarketAnnually20Management Fee: Enter the projected management fee expense for the property as a % of EGRI in D27. Then select if this was based on historical or market data in E27.
28
Total Property Expenses$40,988 32.91%21Total Property Expenses: Autocalculated in C28 based on the expense inputs (C14:C27).
29
Total Pre-Debt Net Operating Income$83,568 67.09%22Total Pre-Debt Net Operating Income: Autocalculated in C29 based on the income calculations (C11) less (-) total property expenses (C28).
30
31
Year 1: Stabilized Capitalization Rate11.14%23Year 1 - Stabilized Capitalization Rate: Autocalculated in C31 based on total pre-debt Net Operating Income (C29) divided by the total purchase price (C7).
32
 Less: Interest Only Loan Expenses$34,12524Interest Rate: Autocalculated in C32 based on an interest only loan with the projected loan amount (C8) x the projected interest rate (C10).
33
 Total After Debt Service NOI$49,443 25After Debt NOI: Autocaluculated in C33 based on pre-debt operating income (C29) less (-) the interest expense (C32).
34
*Year 1: Stabilized IRR6.59%26Year 1 - Stabilized IRR: Autocalculated in C34 based on total after debt net operating income (C33) divided by the total purchase price (C7).
35
36
*Does not include appreciation or inflation over the holding period
37
This spreadsheet is a tool intended to provide general guidance and is not intended to give any accounting, legal or valuation advice.
38
Copyrights Blue Fusion Capital
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