Summary

In this chapter, we have seen the importance of fixed asset and debt schedules. We have illustrated how they affect balance sheets, profit and loss accounts, and cash flow statements. We have learned about the base and corkscrew methods, as well as complex and simple approaches to preparing fixed assets, depreciation, and debt schedules.

It is important to note also that even outside of modeling, it is good practice for asset and debt schedules to be maintained by all companies as part of their accounting procedures. This helps to keep track of non-current assets and liabilities.

We have learned how to prepare a simple loan amortization table and also introduced one of the new functions of Excel 365, the SEQUENCE function, and we have seen how we can combine this with our amortization table to produce a dynamic numbered list of the number of repayment periods.

In the next chapter, we will perform our final calculations and prepare the cash flows in order to arrive...