O'Reilly logo

Mastering Cash Flow and Valuation Modelling by Alastair Day

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

7

Debt

Debt schedule

Required entries

Interest rates

Forecast income statement

Forecast balance sheet

Summary

DEBT SCHEDULE

The Asset schedule generates key numbers, such as depreciation and fixed assets, ready for feeding into the forecast balance sheet. The design method ensures that there are blocks of auditable code on separate sheets and workings are separated on to individual schedules. It is better to set out a progression of workings rather than attempt to achieve the same answers with complex code. The next stage is to calculate the entries for the new debt entered on the Control and Forecast sheets. Figures 7.1 and 7.2 are extracts from the two input sheets where you need to know the split of debt, the term, interest rates and the ...

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