Hey all,
I have just started learning basic financial modeling and I'm having trouble balancing a simple three statement model. I'd be thankful if someone could tell me where to start looking for errors. Thanks!
Update: I'm really close now, still missing a small amount though.
| Attachment | Size |
|---|---|
| mc_dcf.xlsx 48.79 KB | 48.79 KB |
| +234 | UBS Healthcare | 48 | 5h |
| +62 | UBS MDs Treat Employees like Dogshit, Data to Prove it | 9 | 9h |
| +59 | More diversity needed in the industry | 11 | 2d |
| +57 | Shana tova - happy new year | 9 | 1d |
| +48 | NYC Wall Street Run Club | 13 | 2d |
| +24 | Lost all ambition / don’t care at all anymore | 7 | 3h |
| +21 | Feeling a bad pattern forming. I need some help | 3 | 3d |
| +21 | What is the role of an analyst at your firm? | 1 | 2d |
| +19 | Reaching out to interviewer who rejected me | 2 | 3d |
| +17 | "Don't include firm in Cover Letter's file name" | 5 | 21h |
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.
Most likely something on your statement of cash flow. Every single balance sheet item that is changing needs to show up on the cash flow somewhere
Thanks! I uploaded an updated version but I'm still not getting it. Is it possible that my statement of cash flows is oversimplified and I'm missing some items there? or is there a different way to calculate net cash flow?
I think you're cash on BS is off.
The forecasted part is not completed cause I couldn't balance the previous years with actual numbers. Maybe if I can get it to balance there, it'll be okay on the forecasted years
Where are you getting your historicals from? All the historicals should be easy to balance, in theory.
Hard codes are in black fonts and formulas are in blue fonts?...I don't think I like you.
lol forgot about the formatting
Never
Fixed it - notes below:
CF tab - F22 needs to link to P&L F19; you have it linked to P&L E19, so it's off by a year
BS tab - F5 needs to add cash from last year; you are just directly linking the change in CF
Should flow correctly after that.
Well, the historicals are still off so I'll have to keep checking that, but at least it's balancing now. Thank you so much! That was really helpful.
Voluptatem ea neque eveniet rerum dolorem non cum. Et atque quis dicta odio voluptates quod. Ipsum laboriosam voluptas non nulla odio nihil maxime.
Est at fugiat pariatur sit laborum sit. Sint eveniet non earum perferendis laudantium quam eos. Laboriosam atque et eaque sed iusto recusandae eos qui. Voluptatem adipisci quibusdam esse eos. Sit iusto incidunt iste est at quaerat quasi accusantium. Molestiae vitae natus eveniet id ea quam.
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...