8

Balance sheet

Current assets

Non-current assets

Current liabilities

Long-term liabilities and shareholders’ funds

Tax

Balancing item

Summary

This chapter brings together information from the Forecast sheet together with the workings on the Assets and Debt sheets to complete the accounting statements. The information should flow logically through the model and where possible all information should be sourced from a sheet to the left of the current sheet. The intention is to avoid long formulas and show the mapping of the information onto the forecast sheets. Information can then ‘cascade’ or flow through the model.

The previous sheets together with the forecast percentages will derive the accounting entries except for cash. Cash and marketable ...

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.