Rental Tracker Bundle: STR Host Profit Tracker and Long-Term Rental P&L Tracker Spreadsheets for Airbnb Hosts and Landlords

What's included

• What you get:
• str-host-profit-tracker.xlsx and str-host-profit-tracker-quick-start.pdf
• long-term-rental-tracker.xlsx and long-term-rental-tracker-quick-start.pdf
• STR Host Profit Tracker (one property):
• 4 tabs: Dashboard, Deal Analysis, CleaningSupplies and BookingCalendar.
• Deal Analysis: enter the purchase price, down payment, closing costs, renovation budget, annual gross income, property tax, insurance, management fee, financing rate and loan term. It works out the loan amount, down payment in dollars, total cash invested, annual management fee, net operating income (before loan payments), annual loan payments, annual cash flow (after loan payments), cash-on-cash return (cash flow divided by cash invested) and cap rate.
• CleaningSupplies: enter turns per month, the cleaner fee per turn and supplies per turn. It works out your monthly and annual cleaning cost.
• BookingCalendar: enter a nightly rate and an occupancy percentage. It estimates occupied nights and annual revenue.
• Dashboard: shows annual gross income, net operating income, annual cash flow after loan payments, cash-on-cash return, cap rate and annual cleaning cost in one place.
• Formula cells are locked so they can't be overwritten by accident. For more than one property, keep a copy of the file per property.
• Long-Term Rental P&L Tracker:
• The Tracker tab has ten inputs and seven outputs.
• Gross potential rent from your units and monthly rent.
• Effective gross income net of the vacancy rate you enter.
• Annual operating expenses: property tax, insurance and repairs.
• Net operating income after operating expenses, then cash flow for the year after debt service.
• Cap rate and cash-on-cash return, guarded so a zero purchase price shows a friendly message instead of an error.
• Good to know:
• You type only in the input cells. Every result is a live formula, so it updates when you change an input.
• No macros or add-ins.
• Not tax or legal advice. These tools do arithmetic on the numbers you enter and do not give tax, legal or investment guidance.
• Digital download. No physical item is shipped.