All Forum Posts by: John C.
John C. has started 1 posts and replied 3 times.
Post: Short Term Rental Pro Forma Spreadsheet

- Posts 3
- Votes 0
Quote from @Jason Kudo:
Quote from @John C.:
Quote from @Jason Kudo:
Quote from @John C.:
I am an aspiring Short Term Rental investor looking to get feedback on a pro forma spreadsheet. I am looking at properties around the Joshua Tree, CA area. Please see spreadsheet link below and feel free to use it as a template.
Formula for Estimated Additional fees is --> (Total Nights Book / 2 Night Average Stay) * $120 --> $120 is total of $60 Cleaning Fee and $60 Service Fee.
The $60 service fee, is that referring to the 3% host fee that goes to Airbnb? What is the additional cleaning expense of $200 for?
Hey Jason,
The $60 service is what I would additionally charge each guest in addition to the nightly rate.
I am factoring additional cleaning and services fees to my income. Then deducting the expense (what I would actually pay for the cleaning) after collecting the fees as income from the guests.
Ok, I understand the cleaning fee side of this. We charge our guests a $175 cleaning fee per booking and $150 goes immediately to our cleaner per turnover and we save the $25 per turnover to go towards a deep clean bi-monthly so the cleaner eventually gets all of the $175 cleaning fee.
I don't understand why you would charge an additional $60 per guest in addition to the nightly rate and cleaning fee. Please advise?
I mistyped, its not $60 for each guest its $60 for each "guest stay". So an additional $120 each time a guest books a stay.
Post: Short Term Rental Pro Forma Spreadsheet

- Posts 3
- Votes 0
Quote from @Jason Kudo:
Quote from @John C.:
I am an aspiring Short Term Rental investor looking to get feedback on a pro forma spreadsheet. I am looking at properties around the Joshua Tree, CA area. Please see spreadsheet link below and feel free to use it as a template.
Formula for Estimated Additional fees is --> (Total Nights Book / 2 Night Average Stay) * $120 --> $120 is total of $60 Cleaning Fee and $60 Service Fee.
The $60 service fee, is that referring to the 3% host fee that goes to Airbnb? What is the additional cleaning expense of $200 for?
Hey Jason,
The $60 service is what I would additionally charge each guest in addition to the nightly rate.
I am factoring additional cleaning and services fees to my income. Then deducting the expense (what I would actually pay for the cleaning) after collecting the fees as income from the guests.
Post: Short Term Rental Pro Forma Spreadsheet

- Posts 3
- Votes 0
I am an aspiring Short Term Rental investor looking to get feedback on a pro forma spreadsheet. I am looking at properties around the Joshua Tree, CA area. Please see spreadsheet link below and feel free to use it as a template.
Formula for Estimated Additional fees is --> (Total Nights Book / 2 Night Average Stay) * $120 --> $120 is total of $60 Cleaning Fee and $60 Service Fee.