ABSTRACT
The first valuation tables were constructed using paper and pencil, with a lot of hand-written calculations. Excel can produce a page of tables in less than a second, but the setup needs some thought in order to be efficient. One very useful feature of Excel is the ability to name cells or groups of cells. One should remember that each cell has its own reference. Names are particularly useful in compiling a table of valuation factors. Using a new workbook, the users can assign the name interest to the top row where the rates of interest will be entered, and the name years to the left-hand column where the years will be inserted. The chapter demonstrates the construction of simple tables of the all-risks yield and implied growth. In recent years the concepts of the capitalisation rate or all-risks yield, and the equated yield or target rate, and the relation between these and anticipated future growth have received much attention.
