Anyone ever seen a depreciation schedule built like this with the useful life above the schedule but as a fixed number? I recently received a modeling test from a well-known hedge fund (rhymes with Citadel) and it came in this form. I just forecasted depreciation as a % of capex and rolled forward the schedule using those assumptions. Is there another way?
| +19 | % of pods making 9 figures consistently? | 26 | 18h |
| +10 | Silver Point | 4 | 5d |
| +9 | Fastest Way to MMHF? | 1 | 9h |
| +6 | Can I rock a beard in the HF world? | 9 | 2d |
| +6 | Credit HF Guys: How much do you think abt "value" | 7 | 5h |
| +3 | culture at citadel macro | 1 | 5d |
| +3 | 4 YOE in ER & 30 years old | 5 | 3h |
| +3 | Amakor Capital - Who are these guys? | 2 | 2d |
| +2 | 2+1 -> Start-up -> Publics? | 1 | 5d |
| +2 | Walleye SA 2027 | 3 | 17h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hey Jack_the_Banker, I'm here because nobody responded to this thread after a few days...maybe one of these resources will help you:
More suggestions...
Hope that helps.
Ha - just did this same one.
Couple of key details this exhibit is missing : PP&E starting balance was 0; and the starting Depreciation was exactly 1/5 the Capex spend for that year.
If you assume that the salvage value is 0 for each asset, you can create a simplified waterfall in each cell that is (1/5 Capex from 5 periods ago) + (1/5 Capex from 4 periods ago) + (1/5 Capex from 3 periods ago)... and then just roll that forwards.
At least that's what I did.
I couldn’t remember exactly the structure but yes you are correct that beginning PPE was zero.
So did you assume D&A as a % of capex remained constant throughout the period? If you assumed a zero salvage value at the end of the forecast period did you converge D&A as a % of capex to 100%?
No, I think that’s overcomplicating it. If starting PP&E was zero, there’s nothing else to depreciate except for the new capex. They give you the D&A for years 0-4, so in year 5 (the first forecast year) you need to account for depreciation for the capex in years 1-5. If the lifetime is 5 years, then depreciation is the sum of (1/5 of capex years 1-5). You can build a “rolling” formula that sums the current year and the 4 cells to the left. When you fill that to the right, it should move the 5 references each time. So each year’s capex is being depreciated 5 times: once in the year it was spent, and then 4 years after. The last year will be treated the same, no convergence needed.
Occaecati possimus expedita enim vel. Iusto a quaerat ut sit enim quod iure. Quibusdam voluptatum quia ut odit expedita repellendus quia aut.
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...