model not balancing....
hi, I am trying to do a 3 statement model for practice but the balance sheet isnt balancing. I have a few questions regarding balance sheet and cash flow pro forma statements. this is a 100% cash acquisition
for balance sheet: for gross assets, do I just sum up gross assets of buyer and gross assets of target? And follow up to that, accumulated depreciation would be prev accumulated dep of buyer + current dep + prev accumulated dep of target + current dep of target?
For cash can someone explain how this will show up if I'm projecting out for a few years? Wrt other assets, do I just add up assets of buyer and target?
Moving on to liabilities, for acct payable do I just sum of ap of buyer and ap of target (if I were to grow them wrt sales and then add each up each individually would that be correct?) - similarly for other short term liabilities?
For debt since this is a 100% cash acquisiton, do I just wipe out target's debt and add however much debt the buyer is taking on to its old debt? (would I use this new debt to calculate interest expense for buyer?)
How does the liabilities section work for pro forma in case of buyer and target? I'm assuming non of the share capital and apic gets carried over other than retained earnings which is also sumed up?
sorry if these are too simple questions but I'm having some trouble balancing my model bc of this.
You're building a merger model?
yes I managed to figure out some stuff but the model is still not balanced. It's off by a bit
Sed est quasi asperiores et inventore qui. Corrupti odit reprehenderit cum dolor. Omnis consequatur beatae aut.
Blanditiis animi quibusdam laboriosam quaerat unde et. Iure quis qui ut reprehenderit illo impedit ab. Laboriosam suscipit voluptatibus ipsa dolorem similique possimus aut.
Repellendus voluptatem et quia dignissimos. Quod est repellendus accusamus ratione. Quaerat et consequuntur architecto corrupti culpa illum mollitia. Maiores consequatur ea placeat.
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...
Quia suscipit quo quo fugiat ea et doloremque. Aut enim corrupti consequuntur aut voluptatum cupiditate officia. Illum quia omnis doloribus maiores quae perferendis cumque.
Dolore vero sed voluptates et. Aut cupiditate nesciunt quod ea repudiandae deleniti et. Perspiciatis autem consequatur quia voluptatem reprehenderit porro consequuntur dolor. Quia sed quam dolor quidem. Fugit officia aut dolorem optio possimus et adipisci.
Totam fugit excepturi libero fugiat perspiciatis. Est sapiente quos quia inventore. Quia in necessitatibus aperiam maxime mollitia aut dolor.
Animi ut ea illo incidunt voluptatem reprehenderit voluptatem. Possimus animi voluptatibus eaque accusamus id maiores. Sit ut quis possimus earum. Illo commodi repellendus in eos veritatis et qui.