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

6

Assets

Fixed assets

Excel functions

Existing assets

New asset depreciation

Written down value

Asset summary

Tax depreciation

Summary

FIXED ASSETS

This chapter shows how to build asset tables as defined working areas to provide the inputs to income statements and balance sheets. The fixed assets bear a relationship to sales since on-going investment is essential to produce future profits and cash flows. This is not necessarily a linear relationship, but it may be stable if the pattern of sales and costs do not change markedly over time. In a simple model, fixed assets could be related in a fixed assets turnover ratio derived from sales/fixed assets. The control sheet contains a schedule of asset purchases and this schedule seeks to derive ...

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