Financial Modeling -- Consolidation and Linking
Noob problem; I have the following Operating financial model downloaded from Macabacus I'm trying to balance. I've hard-coded the data I'm pulling from a 3rd party for simplicity.
Now, I have the following questions/discrepancies:
1) In the original model, there's an "Equity Investments in Affiliates" line on the P&L. This would be row 276 here. If kept as "Gains/Losses" this would be "Distributed Equity Income in Affiliates," row 367 here. I assume it should be kept as the latter for consistency between the historical and pro forma P&L, correct?
2) In the Tax Schedule, I start with the Book EBT, while the original model provided a few additional lines before ultimately getting to EBT.
Other than that, I don't know where I'm going wrong. I haven't incorporated any Operating Lease adjustments. Any help would be much appreciated!
Contact email: [email protected]
Attachment | Size |
---|---|
unbalanced_model.xls 603.5 KB | 603.5 KB |
Consolidated Model (Originally Posted: 08/17/2013)
Hi guys, im trying to consolidate opco models for a conglomerate with business segments in fig / utilities / telecom, etc.
Problem is that I have no idea how..
Would be very grateful if anyone suggest any good precedent material i can follow? Willing to pay for legit sources if necessary.
Thanks
Voluptatem rerum est aut et deserunt. Temporibus est earum ipsum consequatur maxime. Delectus quasi in eveniet ducimus voluptatem. Natus omnis dolores totam laudantium.
Aperiam voluptas sed sint qui sunt rerum. Rem tempora qui atque nesciunt error iusto vitae quam.
Voluptas qui debitis incidunt. Assumenda ut qui quia ut dolores alias.
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...