7
Debt
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 ...
Get Mastering Cash Flow and Valuation Modelling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
