Use Forecast to schedule income and costs across your development appraisal. The timeline brings together the amounts entered elsewhere in your appraisal and the periods in which they occur.
Set up the timeline
- Open your appraisal and select Forecast.
- Set the start and end periods for each stage. Expand the stage to check individual lines.
- Use a line’s period range where its timing differs from the stage. A line using the stage default follows the stage’s timing.
- Choose the distribution method for scheduled amounts. Linear spreads an amount evenly; S-curve changes the spread through the period range. Check the resulting amounts against your programme.
- Review the row total against its underlying amount and check the overall cash position.
Monthly and annual forecasts
Switch Use annual forecast on for annual periods or off for monthly periods. Review the period headings and timing assumptions after switching so the forecast matches the programme you intend to model.
Adjust an individual period
For a distributed line, select a period cell, enter an amount or percentage, and select Save. Manual overrides can affect the remaining distribution. See how to adjust forecast cells and clear overrides.
Operated assets
Operating income and operating costs are recurring lines. Their timing follows the operating start and holding assumptions, rather than a one-off distribution of the sale value. Review the operating receipts, operating costs and sale proceeds separately.
Review and export
Use Detailed mode to change the timeline presentation. Select Export to download the forecast as an Excel workbook. Check timing, manual overrides and totals before sharing the export.