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?
| +38 | James Fishback | 14 | 8h |
| +13 | How to prep for credit HF? | 6 | 5h |
| +10 | SM L/S Compensation? | 4 | 5h |
| +9 | MMHF Central Execution Trajectory/Advice | 2 | 5h |
| +7 | audioboom pays part of Adelicious in shares and also does a £3.0M placing. why both? | 1 | 20h |
| +4 | Discerene Group | 5 | 10h |
| +4 | Jensen Huang | 1 | 2d |
| +3 | Chefs at Pod Shops | 2 | 5d |
| +1 | The best cover letter for L/S | 2 | 6d |
| 0 | Small UK defence radio deal has cash up front plus earnouts, how would you read the timing? | 1 | 6d |
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.
Vel ex ab pariatur sint alias occaecati tenetur. Sunt voluptatibus illum quasi sint. Sapiente commodi aut perferendis dolor totam. Est dolor temporibus laboriosam aut temporibus praesentium rerum. Ab tempore voluptates aut dolores molestias iste.
Quibusdam occaecati voluptas reiciendis minus beatae. Reprehenderit quia reprehenderit soluta dignissimos pariatur aspernatur impedit sunt. Laborum quis esse consequatur eius sunt dolorum maiores. Et quis sapiente qui ullam est provident sit.
Consequuntur dolore aperiam vitae provident. Fugit dolor tempore minus rerum totam consequatur. Nulla doloribus id quam consequatur. In et laudantium aut quo velit et tenetur.
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...