Just created a 3 statement models with a debt schedule, but my check is off. I have checked all of the cash flow statement line items, and the change in cash seems to be correct, so I believe there is a mistake within the debt schedule or change in ppe which I may not be recognizing. If anyone has advice or can take a look it would be greatly appreciated.
| +384 | Evercore Intern Seizure | 59 | 6h |
| +75 | JPM M&A is Gone??? Purely Coverage Banking??? | 35 | 11h |
| +64 | Is DCM actually underrated ? | 28 | 42m |
| +53 | How do I understand vs. just memorizing? | 10 | 6h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +42 | Associate & Above IB exits | 17 | 5h |
| +37 | The good and bad with Wells Fargo | 7 | 9h |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 21h |
| +29 | Tech to IB Pivot | 20 | 10h |
| +28 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 18 | 1h |
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.
Your balance sheet and cash flow statement should be one and the same. You have not checked all of the cash flow statement items against the balance sheet, or you would not be asking this question. Take the Period 2 Balance Sheet and subtract the Period 1 Balance Sheet from it. Every single one of those figures from the CFS should be pulling into the balance sheet. Flex the assumptions on every figure until you find what is jacking up the check calc.
I checked this and I’m pretty sure that all the changes are reflected in the cfs that are on the balance sheet. Each year when I take the difference also does add up, I’m thinking the mistake may be in the debt pay down but I am not sure where to go from there.
Post the link to the model.
I would prefer not to post a link due to anonymity reasons, but if you could pm me I would be thankful for the help. Have been looking at the model all day and just can’t find the error
Consequatur cupiditate voluptatem vitae ut. Nihil accusantium sit aliquam error non molestiae quaerat. Id vel vel asperiores.
Excepturi quibusdam rem animi nihil et ex. Amet voluptatem qui est ab recusandae. Quas fugiat illum ut consequatur qui distinctio.
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...