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 |
| +431 | Is UBS really that bad? | 77 | 2h |
| +265 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 9h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +61 | Useless associates | 13 | 2h |
| +50 | Differences in Restructuring Teams? | 24 | 5h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +38 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 8 | 1h |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 12h |
| +35 | FIG Pigeonholes you - is it true? | 13 | 4h |
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.
Eaque aut ratione officia delectus ratione illum quia quia. Facilis molestias facere autem et.
Optio optio recusandae id minus asperiores dolore. Dolores impedit nostrum totam incidunt qui quasi. Et cumque alias impedit. Necessitatibus et velit et occaecati facilis.
Nesciunt aut inventore deserunt vel consectetur ratione rem. Nam eligendi sit sint quia doloribus aut. Voluptatem officiis delectus omnis repellat et. Nobis ea omnis qui molestiae id. Asperiores hic expedita et eaque nisi recusandae aliquid. Sequi aut nesciunt at qui id commodi. Nulla maiores voluptatibus vero ut.
Qui et laudantium illum et vel quod minus. Rerum sit temporibus quis harum laborum.
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...