My model isn't balancing.. I think it has something to do with my minimum cash balance or my bank revolver.
Can someone please help me figure this out.. I just spent 4 hours trying to and I gave up at this point.
Thank you!
| Attachment | Size |
|---|---|
| model.xls 208.5 KB | 208.5 KB |
| +229 | Downfall of Qatalyst | 45 | 4h |
| +168 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 23 | 3h |
| +111 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 1d |
| +82 | Lincoln International Return Offers | 42 | 2d |
| +59 | London IB BB is a challenge | 35 | 39m |
| +53 | so confused about 28 SA timeline | 27 | 6d |
| +38 | momentum of Rx groups | 12 | 4h |
| +37 | Fired during interview | 6 | 1d |
| +32 | VP Lifestyle at Top BB Coverage Groups | 16 | 5h |
| +30 | SharePoint makes IB hours HELL | 14 | 3h |
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.
1) 'Cash Flow Statement' tab "Excess over/(under) Minimum Cash Balance" - row 20 It should be calculated as BOP cash + FCF - Min Cash. Think BOP cash item is linking incorrectly
2) 'Balance Sheet' tab "Notes Payable" - row 20 Flatline the 416 figure from 2016 to 2020
Should balance after that
A couple things stick out:
Investor thoughts: What is the purpose of this model? Practice or valuation? Either way, I'd encourage you to make better assumptions. What is General Mills going to do over the next year or too that's going to a) increase growth, b) slow down COGS growth and c) greatly increase EBIT/EBITDA YoY? Cost of capital is way too low. Let me ask you this, would you be okay with owning GM and getting a 4.5% return? That's what you're saying when you use a 4.5% CoC. I tossed in 7% and it gave me a value lower than today, and I would never make an investment decision off 7%, no matter how mature the company.
Your SG&A also makes no economic sense.
Model specifics: a) Current LT is not going to be straightlined. You need to project it out since you have all of the loan data. b) Your revolver is likely going to be 80% of AR and Inventory so a revolver value over 3B is not going to happen. c) Depreciation is wrong. You're projecting a big change increase in CAPEX but lower depreciation? That makes no sense. I would go back and calculated depreciation as a % of CAPEX and see if that's a pretty constant percentage. d) You could project out DTLs or just use it as a plug if you're close. Could also use NP as a plug.
It does balance if you do what dukebanker said, but your cash goes negative and since you have a true minimum over 1.75B, that's really bad.
Amet temporibus accusantium rem quae. Autem id nulla aut in dolor numquam aut ipsum. Vero recusandae et sunt optio quod eos. Ex ut rerum non dolores at. Fugit nemo et voluptatibus recusandae. Corrupti occaecati dolorum eum temporibus.
Voluptatem enim ducimus qui. Praesentium tempore laboriosam consectetur incidunt.
Suscipit omnis reprehenderit qui ad saepe illum perspiciatis quod. Ipsum et non minima autem. Quis repellendus consequatur voluptatem dignissimos assumenda. Minus rerum nobis fuga aliquam quo consequatur. Qui est qui et est temporibus praesentium. Laboriosam dolores laborum ratione. Qui reprehenderit ea perspiciatis vitae quos et.
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...