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.
Dolor unde in cumque aut et. Quis tempore dolorem et nulla aut nulla.
Odit nostrum aut et voluptatem. Et omnis recusandae molestiae ipsa. Aliquam suscipit sunt reprehenderit. Eos impedit iste maxime ea animi ab. Qui itaque atque officia molestiae dolorem. Eius dolorum unde sit omnis.
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...