ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
v
2
AIRBNB Data Tool https://data.rabbu.com/
3
Pro Forma Vacation Rental Return Analysis
4
5
Instructions and Comments
6
Input Fields
7
Computed Fields1993 s kihei rd apt 600 kihei ha
8
Historical Data FieldsPro Forma20222023
9
Investment
10
Enter the sales prices of the unitAcquisition Cost $ 925,000.00 $ 925,000.00 $ 30,000,000.00
11
If mortgaged, enter percent of sales price to be mortgaged
Mortgage Percent3070%
12
Mortgage277,500.00 $ 647,500.00
13
Net Investment $ 647,500.00 $ 277,500.00 $ 30,000,000.00
14
15
Ownership Expenses
16
Enter the mortgage interest rate% Mortgage Annual Interest7.8757.88%0%
17
Mortgage Interest $ 2,185,312.50 $ - $ -
18
Annual property tax - add the two semi-annual payments of record
Property Tax $ 12,000.00 $ 5,000.00
19
Estimate or enter quoted annual insurance premiumInsurance $ 1,500.00 $ 400.00
20
HOA/AOAO Fees $ 800.00 $ 995.00 l
21
Capital Improvement $ - $ 2,000.00
22
Maintenance $ - $ 569.09 $ 569.00
23
Enter Yes if a leasehold property, No for fee simpleLeasehold Property? No no no
24
If leasehold, enter the historical or estimated monthly leasehold fee
Monthly Leasehold Fee $ - $ -
25
Total Monthly HOA/AOAO $ 492.00 $ 1,700.00 $ 995.00
26
Total Annual HOA/AOAO $ 5,904.00 $ 20,400.00 $ 12,000.00
27
Total Annual Ownership Expense $ 2,191,216.50 $ 33,900.00 $ 17,400.00
28
Per Month $ 182,601.38 $ 2,825.00 $ 1,450.00
29
30
Vacation Rental
31
Income
32
Rental Income
33
Enter the number of nights reserved for owner or guests per year
Owner Blocked Nights 15 60 15
34
Available Rental Nights 350 305 350
35
Estimate an occupancy rate that allows for rental gaps between reservations
Occupancy Rate850.50.5
36
Nights Rented Projection 298 153 175
37
Enter the total amount per night guests will be chargedAverage Rental Rate $ 230.00 $ 200.00 $ 650.00
38
Estimated Annual Rent $ 68,540.00 $ 30,500.00 $ 113,750.00
39
Enter Yes if the nightly room rate includes cleaningCleaning Fee Income included in Rent?yesnoNo
40
Enter the average number of nights per reservationAverage Number of Nights 7 10 5
41
Approximate number of reservations per yearEstimated Nr of Reservations 43 15 35
42
Enter the cleaning fee to be charged the guest (not amount actually paid cleaners)
Cleaning Fees per Rental $ - $ 211.00
43
Total Annual Cleaning Fees $ - $ 3,217.75
44
Total Annual Rental Income $ 68,540.00 $ 33,717.75 $ 113,750.00
45
Total Monthly Rental Income $ 5,711.67 $ 2,809.81 $ 9,479.17
46
47
Rental Expenses
48
Enter Yes if the nightly room rate includes taxesHawaii Taxes Included in Rent?noNoyes
49
Note if not included, must be collected from guestsGeneral Excise Tax (GET)
50
GET Tax Rate4.15%4.15%4.15%
51
GET Tax Due $ 2,844.41 $ 1,399.29 $ 4,720.63
52
Transient Accommodation Tax (TAT)
53
Transient Accommodation Tax13.25%13.25%13.25%
54
TAT Tax Due $ 9,081.55 $ 4,467.60 $ 15,071.88
55
Must have a GET/TAT tax licenses and file usually monthly
Total GET TAT Taxes Expense Annual $ - $ - $ 19,792.50
56
Must be paid whether taken as an expense or collected from guests
GET TAT Expense Per Month $ - $ - $ 1,649.38
57
58
Cleaning Expense
59
Enter average amount paid to cleaners each reservation
Per Reservation Cleaning Expense $ 175.00 $ 211.00 $ 200.00
60
Total Reservation Cleaning Expense $ 7,450.00 $ 3,217.75 $ 7,000.00
61
Enter estimate of periodic cleanings (carpets, windows, etc)
Periodic Cleanings Expense Annual $ 560.00 $ 500.00 $ 560.00
62
Total Cleaning Expense $ 8,010.00 $ 3,717.75 $ 7,560.00
63
Monthly Cleaning Expense $ 667.50 $ 309.81 $ 630.00
64
65
If billed separate from HOA/AOAO fee enter average estimated utility amounts
Utilities
66
Electric $ 238.00 $ 500.00 $ 500.00
67
Cable/Internet $ 112.29 $ - $ 150.00
68
Water $ - $ - $ -
69
Total Utlities per Month $ 350.29 $ 500.00 $ 650.00
70
Total Annual Utilities $ 4,203.48 $ 6,000.00 $ 7,800.00
71
72
Supplies Annual Budget
73
Enter estimates for these expensesTowels $ 250.00 $ - $ 2,250.00
74
Sheets $ 360.00 $ -
75
Cleaning Supplies $ 400.00 $ -
76
Paper Products $ 240.00 $ -
77
Miscellaneous $ 1,000.00 $ 3,000.00
78
Total Supplies Annual $ 2,250.00 $ 3,000.00 $ 1,400.00
79
Total Supplies per Month $ 187.50 $ 250.00 $ 2,250.00
80
81
Property Management
82
Enter Yes if utilizing a full time property manager, No if not
Utilize a Full Time Property Management Firm?
yesyesyes
83
Enter % Rental Retained by Property ManagerPercent of Rental Income Charge25%25%25%
84
Annual Property Management Expense $ 17,135.00 $ 8,429.44 $ 28,437.50
85
Monthly Property Management Expense $ 1,427.92 $ 702.45 $ 2,369.79
86
87
The following expenses will apply only if there is no Property Manager
Advertising
88
These are service fees charged for Airbnb, Homeaway, etc.
Average % charged for reservation fees3%
89
Reservation System Service Fees $ - $ - $ 3,412.50
90
Enter any other estimated advertising, website annual expense
Other Advertising Budget $ 500.00
91
Total Annual Advertising $ - $ - $ 3,912.50
92
Total Monthly Advertising $ - $ - $ 326.04
93
94
Required if not using a Property Management firm and owner not on island
On Island Representative
95
Enter total months owner not on island or 12 if annual contract
Months Required 0 11
96
Per month fee
97
Annual On Island Rep Expense $ - $ - $ -
98
99
Total Monthly Rental Expenses $ 8,322.00 $ 8,322.00 $ 8,322.00
100
Total Annual Rental Expenses $ 99,864.00 $ 99,864.00 $ 99,864.00