Skip to content
The title slide and first slides of the Rent Affordability Calculator template

Rent Affordability Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Apartment hunting makes every listing look reasonable until the numbers sit side by side. This calculator starts with your income. On the Income tab you enter yearly pay, other monthly income, debts and the share of income you are willing to spend on rent. The Rent tab lists each place with its rent, utilities, insurance and parking, then divides rent by income and marks the place Fits or Over.

The Result tab turns the share into a rent amount and repeats it for six shares from 25 to 40 percent, with the money left after rent and the yearly total beside each one. A second chart compares the full monthly cost of every place you listed. Sample data uses six invented listings; replace them with real ones and the marks update at once.

Useful for

  • Screening listings against a monthly budget
  • Seeing how much a ten percent difference in share changes rent
  • Comparing a solo place with a shared apartment

What's included

  • 4 tabs: Income, Rent, Result, How to use
  • Income: a table
  • Rent: a table
  • Result: a dashboard with 4 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Income tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What percent of income should go to rent?

Many guides suggest about 30 percent, but the right share depends on debts, location and other goals. The sheet lets you type any share and see the rent range for it.

Should I use gross or net income?

The sample uses gross pay before tax, which is how many landlords screen applicants. If you prefer to plan from take-home pay, enter that instead and use a higher share.

Do utilities count toward the rent share?

The share column uses rent alone, as landlords do. The total column adds utilities, insurance and fees to reveal the true monthly cost of each place.

  • #financial-calculator
  • #rent-affordability-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…