Free Investor Tool
Short-Term Rental Cash Flow Worksheet
Run the numbers before you write the offer.
Important — This is not a mortgage application
This is an investment-analysis worksheet, not a mortgage application. Use the worksheet to estimate income, expenses, cash flow, and potential returns. Completing this form will not begin a pre-approval or mortgage loan application.
Need Help With Financing?
Three Ways Lisa Can Help
Want to Discuss Financing?
Talk with Lisa about your goals, the property, down payment, loan options and next steps.
Book a Strategy CallReady to Make an Offer?
Send Lisa the listing and proposed offer details so she can review the financing before you submit the offer.
A pre-approval letter requires a completed mortgage application and review of credit, income, assets and required documentation.
Send Lisa the Property DetailsReady to Apply for Financing?
Complete Lisa's secure mortgage application to begin the official pre-approval or loan process.
Start Mortgage ApplicationThe calculators, worksheets, checklists, and guides on this site are educational tools and do not begin a mortgage application, strategy call, or property review.
A short-term rental can produce impressive gross revenue and still struggle after management, utilities, insurance, maintenance, reserves and financing are included. This free worksheet helps you evaluate the complete deal, not only the projected nightly income.
What the worksheet calculates
- Estimated loan amount and monthly payment
- PITIA and HOA expenses
- Annual operating expenses
- Net operating income
- Capitalization rate
- Annual cash flow
- Cash-on-cash return
- Estimated debt coverage
- Break-even occupancy
- Twelve-month seasonal cash flow
Educational note
This worksheet is designed for preliminary investment analysis. Revenue, expenses, eligible rental income and lender calculations vary by property, market and loan program. Verify all figures before making an investment decision.
Instant download
Get the free worksheet
Tell us where to send it. No spam, unsubscribe anytime.
This website provides general information about consumer and business-purpose mortgage financing. Some programs may be available only for investment or non-owner-occupied properties, while others may have personal occupancy requirements. Program availability, licensing, terms, documentation, and eligibility vary by lender, borrower, property type, occupancy, and state.
All mortgage financing is subject to credit review, income or asset verification when required, appraisal, title, insurance, lender guidelines, and final approval.
Lisa Stepp-Seritt, NMLS #680403
Mpire Financial, NMLS #2108504
Equal Housing Opportunity