Valuation of an Income Generating Property - Excel Model
Originally published: 12/07/2016 10:54
Last version published: 02/02/2018 14:50
Publication number: ELQ-58617-3
View all versions & Certificate

Valuation of an Income Generating Property - Excel Model

This Excel Valuation Model can be used to value property generating income.

The user must define the following inputs:
- Building Space
- Occupancy
- Rental Income
- Operating expenses
- Operating income before depreciation

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Outputs key metrics for valuing property and investment


keyboard_arrow_downShow all

People using this Best Practice also downloaded


More Best Practices from Prof. Aswath Damodaran

See all

Discussion feed for Valuation Of An Income Generating Property - Excel Model

The user community and author are here to help. Go ahead!

  • Faiz Abhuani
    Oh and what are "beggining" and "terminal years"?
    1arrow_drop_uparrow_drop_downReply reply
    • Faiz Abhuani
      Hi there! Thanks so much for this great model. I am trying my hand at developing a financial projection for a community housing project in Montreal. My objective is to know what my cashflow will be every year for the next 30 years. You can learn more about it here: - In any case, quick question: by "vacancy rate" you mean "occupancy rate", right? Thanks!
      1arrow_drop_uparrow_drop_downReply reply
      • Prof. Aswath Damodaran
        The vacancy rate is the occupancy rate (I screwed up there because it is usually 1- occupancy rate). The beginning year is the base year (usually most recent year) and the terminal year is year 6.
        3arrow_drop_uparrow_drop_downReply reply

        4.6 / 5 (28 votes)

        please wait...