O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required