ABSTRACT
This chapter looks at some further examples of the way in which Excel can be set up to do valuations. Users recommended to set these out on their own computer for practice, and because a library of standard valuations can be very useful. The term Residual Valuation is usually applied to problems involving development, but in its broadest sense relates to any valuation which consists of an estimate of the value of a property after allowing for various items of expenditure. Setting up a residual valuation in Excel will follow the same general layout as a conventional calculation set out on paper. However the many format options allow for it to be tailored to the particular valuation under consideration. Excel is perfect for mimicking the S-curve pattern that is typical of construction expenditure during a development. Construction costs throughout the development period are rarely uniform as they may be depicted in some cash flows.
