Hi All,
I need some help in balancing the 3 statements on a financial projection which i did. I went through courses ( course material and actual things are 2 different animals). I would greatly appreciate if someone could take a look at them and help me on - balancing and where i went wrong and what i should have done - financial modelling etiquettes
understand this would take a considerable amount of time, but i would greatly appreciate it. ( u can see it as helping to test your own understanding)
Thanks!
| Attachment | Size |
|---|---|
| workings_v2.xlsx 2.81 MB | 2.81 MB |
I assume your historic BS does balance. From there, any change on your BS should be reflected in your IS or CF statement, so it can never not balance. Go through your BS line by line and see if every change is covered.
I have covered all the BS line by line.
Wondering if anyone could help me go through. your help will be greatly appreciated. I have attached file for reference in my original post!
You still need this? No time now, but might have later. Start with deducting dividends from your equity.
Yes please i would appreciate some help thanks!!
I have tried to rework everything from scratch. it looks much better, but it still doesnt balance. Thanks for taking time to look it through, i really spent q alot of time and will do anything to improve. thanks!!!!
You don't have your projected year cash and cash equivalents linked to the balance sheet, my dawg! The line item is missing altogether from your rework page, H66. It's about the right amount, growing at a consistent pace Y/Y. That's what I'd guess, without too much deeper of a dive.
Sit minus molestiae et eum fugit. Numquam magnam occaecati veniam deleniti recusandae. Quas consequatur enim sequi. Eius sunt eos minus. Consequuntur necessitatibus illum sint ad porro alias. Cum eveniet deserunt quia sit et quis autem.
Quibusdam dolor ut quia laboriosam. Ducimus est quas vero odit.
Hic id accusamus illum incidunt. Qui itaque est dolorem itaque voluptatibus. Deleniti dicta illum eligendi dignissimos amet corporis voluptas. Voluptas sed dolor inventore et cupiditate ea tempora vitae. Praesentium aut explicabo molestiae quia tempora neque eum. Distinctio laborum delectus sint voluptatum perferendis.
Deserunt eos eveniet earum et rem eum. Nemo eum ut ut qui quos. Et provident magnam necessitatibus et expedita. Adipisci ut nemo provident qui temporibus similique provident. Voluptatem officiis eligendi maiores tempore rerum ut aspernatur.
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...