Title

A Pedagogical Tool To Assist In Teaching Real Estate Investment Risk Analysis

Abstract

This paper presents a simple Excel model that provides measures of the standard deviation of forecasted internal rate of return (IRR) given traditional data inputs such as annual cash flows, terminal values and equity. The model first calculates IRR using traditional discounted cash flow methods and then provides heuristic estimates of variability measured in terms of "high," "low" and "most likely" values. It also provides an actual measurement of risk in terms of mean and standard deviation and upper and lower quartiles, along with a graphical presentation of various risk parameters. The only additional analysis required is an estimation of the variability of periodic cash flows and the terminal value of the investment.

Publication Date

1-1-2004

Publication Title

Journal of Real Estate Practice and Education

Volume

7

Issue

1

Number of Pages

43-52

Document Type

Article

Personal Identifier

scopus

Socpus ID

6444237985 (Scopus)

Source API URL

https://api.elsevier.com/content/abstract/scopus_id/6444237985

This document is currently not available here.

Share

COinS