Money Toolkit · Excel and Google Sheets

Rental Property Analysis Spreadsheet

Run the numbers on a rental before you make an offer: cash flow, cap rate and cash-on-cash return, with a 10-year view.

Instant download · Excel and Google Sheets · 14-day refund · Free updates

The Rental Property Analyzer cover

What's inside

  • Purchase, loan and closing costs
  • Monthly cash flow after every expense
  • Cap rate, cash-on-cash return and DSCR
  • Compare up to three properties

The tabs

  1. Analyzer
  2. 10-year view
  3. Compare

How you use it

  1. Analyzer: enter the price, loan, rent and expenses from the listing, your lender and local rents. Everything else is calculated.
  2. Read the verdict panel: monthly cash flow, cap rate, cash-on-cash return and DSCR.
  3. 10-year view: set rent growth, expense growth and appreciation to see cash flow, equity and your annual return if you sell in year 10.
  4. Compare: shortlist up to three properties with their headline numbers side by side.

Try the free calculators first

The sheet does the same math as these calculators, every month, with your own numbers.

Questions

What do I get?

An email with your download straight after checkout: the Excel file and a one-page quick-start guide that shows how to open it in Excel or Google Sheets. The printable binder is a PDF in Letter and A4 sizes.

Excel or Google Sheets?

Both. Open the .xlsx in Excel, or import it into Google Sheets in three clicks (File, Import, Upload). Everything works in either, with no add-ons, macros or scripts.

Can I get a refund?

Yes. If a sheet isn't right for you, email hello@dollarsworld.com within 14 days of buying and we'll refund you in full.

Do I get updates?

Yes, free. The freelancer sheet is updated for each new tax year, and the Complete Toolkit includes every new tool we add.

Who handles payment and sales tax?

Our payment partner acts as the merchant of record: it takes the payment, charges the right sales tax or VAT for where you live, and emails your receipt. We never see your card details.

Is this financial advice?

No. The sheets are planning tools that show estimates from the numbers you enter. For decisions about your own situation, talk to a qualified professional.

Can I share it?

Each purchase is for personal use in your own household. For a business, team or classroom license, email us.