How to calculate/forecast Capex and PPE in this model ? extracting Depreciation from CF
Cash Flow Purchases of equipment/ Capex $(504,806) $(560,296) $(646,456) Proceeds from sales of property and equipment $1,423 $9,360 $1,428
Blance sheet
PP&E $2,264,062 $2,434,456 $2,701,282 Goodwill $4,338,589 $4,338,589 $4,338,589 Other intangible assets,net $1,200,994 $1,200,659 $1,200,428 Other assets, net $21,830 $20,823 $28,760
Depreciation From cash flow( not given in IS)
D&A $352,431 $379,931 $404,231
I assume data you are providing are previous years.
If so:
1- Divide Capex by revenue to get a %.
2- Divide Depreciation by revenue to get a %.
Then you forecast revenue growth and multiply the figure by the average percentage of the past years CapEx as a % Revenue and Depr as a % Revenue. Other people calculate Depr as a % of CapEx. I personally consider is up to you entirely.
3 - For PPE you need a PPE schedule: 3.1 Put as beggining PPE the ending PPE of last year. 3.2 Add CapEx 3.3 Subtract Depreciation. 3.4 You have your ending PPE.*
That is how I have learnt to asses the PPE schedule.
Depreciation is always in the CF. If appears in the IS then I am inclined to believe is accumulated depreciation.
Hope it helps mate, take care!
*assuming is net PPE.
Illum in illo omnis fuga ex dolorem eum autem. Est doloribus fugit sapiente soluta repellendus architecto autem consequuntur. Tenetur illo dolor cumque recusandae facere sunt.
In nam molestiae molestiae assumenda beatae voluptas porro. Qui eligendi fuga et quia sed distinctio. Quis tenetur qui temporibus. Non ducimus saepe iste natus minus. Quia id iusto rerum laudantium nostrum quaerat. Voluptates et voluptatem in in expedita.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...