I am trying to calculate the capital expenditure. Beginning PPE as of September 30, 2018 is $1,557,260. Ending PPE as of July 31, 2019 is 1,571,951. Depreciation from September 30, 2018 to July 31, 2019 (10 months) is 104,270. How do I calculate the CapEx? How do I adjust the partial period? Thanks so much.
| +148 | ONLY THESE BANKS OR YOU STRUCK OUT | 38 | 13h |
| +111 | IB Energy Drink Tier List / Ranking | 73 | 1d |
| +61 | Firm Thinks I'm Lying About Offer | 19 | 16h |
| +53 | Indiana University Fraternity Pipelines | 32 | 13h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 2d |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 21h |
| +36 | Rogo AI | 14 | 11h |
| +34 | Elite Boutique interview questions | 8 | 1d |
| +30 | Suspended for a Year | 11 | 14h |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 14 | 1d |
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.
Why do you need to adjust for a partial period at all? The question itself does not address it beyond the fact the period is, indeed, less than one year. As far as CapEx goes (assuming we're talking about PPE, net), CapEx = PPE Ending - PPE Beginning + Depreciation
This would be my answer as well, unless I am missing something. The balance sheet is just a point-in-time snapshot - you never need to adjust anything for stub periods.
What the excel shows is: Beginning Date: 2018-09-30. End date: 2019-07-31 Days in between= 0.83 [(end-beginning)/365] Partial period adjustment = 1-0.83=0.17
depreciation adjustment: prior period depreciation*partial period adjustment + current year depreciation=123,305.
Capex Calculation: CapEx=-Ending PPE+opening PPE+depreciation =-1571951+1557260+123305
I do not understand what the excel is showing at all. Please help.
Modi velit necessitatibus similique laboriosam rerum voluptatem. Dolorem voluptatum delectus aspernatur autem reiciendis modi doloribus. Veritatis in delectus exercitationem occaecati quos quasi suscipit.
Neque facere et voluptatem voluptas repudiandae doloribus. Aut officia voluptate voluptatem quod pariatur earum voluptatem tempora. Ut enim eveniet provident voluptatem. Rerum expedita sint debitis dignissimos nesciunt magni nobis. Similique temporibus pariatur maiores fugit.
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...