The complex approach

If your model requires a high level of precision, you will start by getting as much information as possible from published historical accounts and management discussions. You would look out for plans to obtain additional finance and liquidate existing loans, and additions to fixed assets that will require finance.

In addition, companies often publish information about maturing loans. You would use this to project annual repayments and ensure that these repayments are stopped once the respective loan has been paid off. The following screenshot presents a debt schedule:

We prepare a debt schedule using the base and corkscrew ...

Get Hands-On Financial Modeling with Microsoft Excel 2019 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.