📊 Get Airbnb Revenue Estimation
Start Here
1. To edit this Sheet, you need to make a copy. This protects your privacy and data, too. Click File, then Make a copy.
This will copy the Sheet into your Google account so you can edit it freely and securely. Do this NOW then continue reading
2. Once you have made a copy of this document, you will click the Dashboard tab at the bottom of this page. This will take you to the
Airbnb Investment Calculator
3. You will only want to edit numbers and text that are labeled blue like this, everything else will populate after you edit only the blue
4. You will start in the "Property Information" section and add your property address, year, square footage, subdivsion, and any notes on the property.
5. Next you will move to the "Purchase" section to input the information for the purchase of the home: asking price, down payment percentage,
closing cost, renovation cost, etc
6. Next move over to the "Expenses" section to input your expenses assosicated with the property
7. Next you will move over to "Income" section and input your average nightly rate, average occupancy rate, and cleaning fee; the rest
of the info will populate
8. After you input and edit all the numbers that are labeled blue, the calculator will calculate your expenses and cash flow for this propety
9. Next click the 5 Year Projected tab and the calculator will show you your projected 5 year return on the property, whether that's just cash flow
or whether you decide to sell the property.
10 View Images below for a visual explaination of Steps 1-8
Visual Examplanation:
1. - 2.
3. - 4.
5.
6.
7. - 8.
9.
Use Airbnb Calculator to get the occupancy rate and daily rate data
Property Information Purchase Expenses
Address: Sandhill Road Mortgage Amount: $600,000
City: Menlo Park Offer Price: $750,000 Term: (Years) 30
State: CA Down Payment (%): 20% # of Payments: 360
Zip Code: 94025 Down Payment ($): $150,000 Interest Rate (%): 5.50%
Bedroom: 2 Estimated Closing Cost (%): 2% Monthly Principle/Interest: $3,406.73
Bath: 2 Estimated Closing Cost ($): $15,000 Estimated Property Tax (Yr): $5,796
Square Feet: 1500 Renovation Cost: $20,000 Estimated Property Tax (Mo): $483
Subdivision: Winter Garden Setup Cost: $10,000 Estimated Insurance: (Yr) $1,500
Year Built: 2014 Total Investment: $195,000 Estimated Insurance: (Mo) $125
Other Info: Pool Private Mortgage Insurance (Yr): $1,152
Private Mortgage Insurance (Mo): $96
Income Monthly HOA: $100
Notes: Gross Income (Yr): $88,336 Estimated Monthly Utilites: (Water/Elec/Gas) $400
Gross Income (Mo): $7,361 AirBNB Fee (Yr): 3% $2,650
Average Nightly Rate: $286 AirBNB Fee (Mo): 3% $221
Average Occupancy: 76% Cleaning Fee (Mo): $750
Cleaning Fee (Mo): $750 Cable/Internet (Mo): $65
Net Operating Income: $88,336 Repairs/Maintenance (Mo) (%) 4.00%
Cap Rate: 11.78% Repairs/Maintenance (Mo) ($) $264
Cash on Cash Return: 7.70% Management Fee (Mo) (%) 3%
Management Fee (Mo) ($) $198
$15,024 $1,252
Cash Flow (Annual): Cash Flow (Monthly): $32,432
Operating Expenses: (Annual)
$2,703
Operating Expenses: (Monthly)
$73,312
Total Expenses: (Annual)
$6,109
Total Expenses: (Monthly)
Projected Year 1: Projected Year 2: Projected Year 3: Projected Year 4: Projected Year 5:
Annual Increase in Gross Income: (%) 2.00% 2.00% 2.00% 2.00%
Annual Increase in Operating Expenses: (%) 3.00% 3.00% 3.00% 3.00%
Annual Appreciation: (%) 3.00% 3.00% 3.00% 3.00%
5 Year Totals
Annual Gross Rental Income: $88,336 $90,103 $91,905 $93,743 $95,618
Total Annual Gross Income: $459,706
Annual Operating Expenses: $32,432 $33,405 $34,407 $35,439 $36,502 Total Operating Expenses: $172,184
Mortage Debt: $40,881 $40,881 $40,881 $40,881 $40,881 Total Mortgage Payments: $204,404
Cash Flow: $15,024 $15,818 $16,618 $17,424 $18,235 Total Cash Flow: $83,118
Monthly Cash Flow: $1,252 $1,318 $1,385 $1,452 $1,520 Average Monthly Cash Flow: $1,385
Cash on Cash Return from Initial Investment: 7.7% 8.1% 8.5% 8.9% 9.4%
Property Value: $750,000 $772,500 $795,675 $819,545 $844,132 Increase in Value $94,132
Amount Owed: $592,119 $583,805 $575,033 $565,779 $556,016 Mortgage Paydown -$36,103
Equity: $157,881 $188,695 $220,642 $253,766 $288,115 Appreciation + Cash flow: $177,250
Return on Initial Investment: 91%
Net Proceeds after Sale: (3% Agent
Commision) $262,791
Mortgage Breakdown:
Mortgage Amount: $600,000 $592,119 $583,805 $575,033 $565,779
Interest (Monthly) 0.46% 0.46% 0.46% 0.46% 0.46%
Monthly Payment: $40,880.81 $40,880.81 $40,880.81 $40,880.81 $40,880.81
Interest: $33,000 $32,567 $32,109 $31,627 $31,118
Principal Paydown: $592,119 $583,805 $575,033 $565,779 $556,016