I've been building a simple projection as a practice, but right now I'm stuck with this unbalanced balance sheet projection. My L&E ended up slightly larger than my asset.
I think I'm losing sight of the forest for the trees here.
Any help is greatly appreciated.
Thanks!
Edit : I can post link now. Here is the Link to Model
| Attachment | Size |
|---|---|
| The File 33.28 KB | 33.28 KB |
| +379 | Evercore Intern Seizure | 56 | 1h |
| +74 | JPM M&A is Gone??? Purely Coverage Banking??? | 33 | 1h |
| +62 | Is DCM actually underrated ? | 26 | 23m |
| +53 | How do I understand vs. just memorizing? | 9 | 2h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 1d |
| +42 | Associate & Above IB exits | 16 | 4d |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 8h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
| +24 | Thoughts on PEI Global Partners? | 4 | 2d |
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.
Hi mate try this https://www.wallstreetoasis.com/forums/what-to-do-when-balance-sheet-do…
Please attach the model
Kamoroun Thanks for replying. I've tried the suggestions from the link that you gave and I still didn't find my error. Maybe I need a pair of fresh eyes.
lifeboat Here's the link to the file. Thanks for your reply!
https://drive.google.com/file/d/1l5lCksgZPDNynC3w7-s3NxaHE6x9bOoA/view?…</a">Link to Model
Deltas of “Others” at assets don’t flow through cash flow statement
In addition some other items of the historic BS do not come back in your forecast BS. “Pajak Tangguhan”, “Accrued expense” “Liabilitas Pajak” but these conincidentialy cancel each other out.
Culpa voluptates quasi sed nihil est necessitatibus beatae. Soluta magni officia sed omnis. Dicta saepe ratione magnam fuga. Qui consequatur incidunt illum fuga harum porro quia. Laborum modi cum nostrum quae.
Consectetur quia harum quia. Adipisci dolore hic aut unde aut maiores. Ea deleniti debitis sed provident.
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...