Rental property exterior highlighting investment analysis and financial modeling importance.

Financial Model, Investment, Real Estate

Excel, Financial Projections, Free Financial Model Templates, Gross Yield, IRR (Internal Rate of Return), Net Yield

The rental property financial model calculates the homeowner’s IRR and long it takes to repay a mortgage when the property is rented.

The financial model contains:

Rental income and expenses
Gross yield and net yield
50 year forecast
Development of property value and equity value
Debt amortization calculation
Internal rate of return to homeowner dependent on holding period

This financial model is made for owners of residential real estate such as apartment to to find out if the purchase price is attractive when compared to the achievable rental income. One can simulate the repayment of mortgage and calculate the return the homeowner can get when holding on to the property. Simply finetune the assumptions and see how the financial model reacts.

Reviews

Excellent Model

By John Meyers on December 16, 2024 at 16:50 (Verified Purchase)

I am still playing and learning it but highly suggest that you consider downloading it.

315 of 723 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

Rental property financial model

By Jemitias Makombe on January 20, 2024 at 17:15

Simple model that gave me all I needed to make decisions

Thank you for your feedback.

375 of 671 people found this review helpful.

Errors

By Rick Li on July 30, 2020 at 03:57 (Verified Purchase)

Static cells throughout the file that is not linked to the summary of inputs. Formulas are incorrect (i.e., cost factor for the 1st year). Require further improvements by the author.

566 of 1075 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

Great Model. Thanks

By Michael on November 29, 2019 at 06:37

The model is simple and quite efficient

560 of 1125 people found this review helpful.

Help other customers find the most helpful reviews

Did you find this review helpful? Yes No

You must log in to submit a review.