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

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

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