Chapter 6

Charting: While numbers in a spreadsheet are required, the interpretation can be difficult. These slides provide a brief overview of how to visually display, through graphics, quantitative data visually.

Custom Functions: P(Gain) was first introduced in the first edition of Foundations of Real Estate Financial Modelling. However, it is not a standard function in MS Excel. These slides demonstrate how to build P(Gain), and other custom functions, into the base of MS Excel.

MS Excel: A text on Real Estate Financial Modelling using MS Excel as the backbone would not be complete without lecture notes on MS Excel. The basics of MS Excel are introduced.