Hey guys,
I recently took a modeling exam the other day and before I got to finish it my balance sheet would not balance. I hid the prompt as I don't want anyone that works there to find out who I am. I would love some help with this model. I kind of know what went wrong as there is a 150 difference which is caused by new shares being issued. The problem is, I don't get why it starts at Y+2 and not Y+1. Would anyone mind helping me out on this? I would really appreciate it.
| Attachment | Size |
|---|---|
| practice_model.xls 76 KB | 76 KB |
You’ve captured the issuance of new shares in the cash flow statement as cash in but it appears you are not including it in your equity in the balance sheet.
I think APIC in your example should be $300 in the the first year it’s out of balance
Debit: cash $150 Credit: Equity $150
Sorry I'm confused. It is getting captured. If i increase APIC to $300 then the first year goes -150 on the balance check. Would you mind doing it on the file please?
In 2018 you issued new shares for 150 and you did the same in 2019. APic is a cumulative balance so in 2019 you need to add the cash’s flow amount to the prior year balance giving you $300 in 2019, $450 in 2020 etc. that should fix it.
Oh God, I am an idiot. Thank you so much!
i fixed it for you how do i upload a file or is it easier to explain?
I'll just explain, you are not taking the prior periods APIC into account in your projection. so starting in cell j60, it should not simply link to the new APIC, but add the APIC from the prior period to the additional APIC from the CFF section. it will balance. cell j60 should = (j89+I60)
Oh wow, I feel so stupid. Thanks a lot man I really appreciate it!
Sequi aliquam similique sit mollitia consectetur alias. Placeat qui aut facilis et dolorem tempore. Saepe et eos numquam est velit qui eaque aut.
Dolores libero et nemo facilis. Aut neque et qui neque deleniti. Quibusdam nesciunt neque impedit est id. Consequuntur ut sunt inventore eaque optio.
Possimus doloribus amet dignissimos fuga. Magni ducimus dolore enim recusandae. Incidunt quae itaque aut numquam excepturi voluptas. Et et magnam repudiandae minus quia voluptas sunt. Vel consequatur et et porro dolorum dicta voluptatem vel.
Placeat et odio dolores consectetur aut odio numquam voluptas. Omnis laudantium fuga qui nulla in et ut occaecati. Blanditiis et expedita odio quia ut ut dolore. Quae et mollitia nulla nam ab non sunt.
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...