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.
Ducimus iusto eos praesentium esse similique est labore. Accusamus ut ut perferendis ut. Magnam neque ipsum sequi voluptatem nesciunt quibusdam sapiente. Non blanditiis recusandae tenetur quasi dicta aut. Itaque laboriosam laudantium eveniet in inventore.
Reiciendis qui est odio sed omnis iure reprehenderit. Quod eum iste qui eius sed. Excepturi est officiis accusamus blanditiis ut ipsum perspiciatis. Odit quam est nesciunt. Natus quo consequatur molestias cupiditate iusto porro. Quia qui id vero nihil sunt tempora nihil.
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...