Write it in this column as the equivalent of £1 after growth.
YP @ X%
% = cost of capital or target rate of return
PV @ X%
% also = cost of capital or target rate of return
Final column should be NPV.
Other things to remember:
To get an exit value multiply:
rental value of the final time
period x yp in perpetuity,
then PV £1 that for however
many years have passed.
When 'PVing' do it to the year before the start
of this time period/the year when the last rent
review took place.. Aka if the time period is
11-15 years then PV for 10 years.
When 'YPing' if the time period is the
same, e.g. they are all five years
difference then you can use the same
figure for each row.