Rent Roll

This rent roll dashboard in Excel was built for a client who owns commercial property. The property owner sublets to multiple tenants who pay weekly rent. This rent roll is used as a simple dashboard to manage the business with the on-site property manager.

What Is A Rent Roll?
A rent roll (definition) is a document to manage leased property. It shows a list of units, the tenants, the rent charged for each unit, and lease expiration date. A rent roll can be used for residential or commercial properties. Uses for residential rent rolls could include duplexes, fourplexes, or apartment complexes. Commercial rent roll uses could include retail subletting, storage facilities, or office space rentals.

How The Rent Roll Excel Model Is Used To Manage Client’s Business

  • Property manager tracks rent paid each week
  • Tenants receive printed receipts with history of rent payments
  • Property manager monitors expiring leases and professional licenses
  • Owner compares rent paid by week to bank deposits
  • Owner monitors occupancy levels for any risk*

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

*Bonus Tip: The owner found staggering leases reduced risk substantially. He found the easiest way to stagger leases is to offer a renewal discount on the tenant’s birthday.

Selling House vs Renting

Should You Sell or Rent Your House?

This model considers three scenarios: selling your house now, renting your house, and waiting for a better offer.

How Do You Decide Rent vs Sell?

There are many factors to consider. What would be your estimated net proceeds at closing, with closing costs and commissions included? If you rented your house, what would be the monthly maintenance? What vacancy do you anticipate?

Also consider your expectations about the housing market. How much would your house rent for today, and how much might it sell for a year from now? If you aren’t earning enough rental income to offset your expenses you have negative cashflow. Would any negative cashflow be offset by a higher future sales price?

We also include a table on time versus price changes. Both the length of time that passes and the amount the offer changes will help you determine if you should take a lower offer for your home today. You can calculate how much better a future offer needs to be to justify waiting 1 month, or even a full year.

Start Your Analysis Today
Download our Excel model today to help determine if you should sell your house today, rent it out, or wait for a better offer.

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Duplex Investment Model

Buying a Duplex?

Considering a duplex as an investment property? Calculate and analyze the key ratios, metrics, and financial returns for successful property investment.

Included Features

  • Compare metrics: cash-on-cash returns, cap rates, GRM and more
  • View investment detail by month
  • Model estimated costs: insurance, maintenance, vacancies
  • Test how rent growth and rising property values impact your investment

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Requirements: Microsoft Excel 2007 and above

P.S. Want to read how the model helped when I bought my first rental property? I posted those details here. Includes my actual rental property purchase price, initial and current rents, financial returns, and more.