Additional schedules and projections
At this stage, it would have come to your attention that Balance Check for the projected years is now red and FALSE. This is because our balance sheet and profit and loss account are not yet complete.
We have projected growth for most items, but there are some items that require specific treatment, such as CapEx, depreciation, loans, and interest.
ASSET SCHEDULE is prepared to capture the movement in property, plant, and machinery. The following screenshot shows the full Capex and Depreciation Schedule values:
Figure 2.8 – ASSET SCHEDULE
The company's plans for CapEx over the duration of the model will be reflected here. Historical CapEx and disposal of assets will be shown under the years during which the expenditure or sale took place. The schedule will also take into account the cost of the assets and useful life and depreciation rates and methods. Assets with different depreciation rates will be treated...