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
Et quo excepturi vel odio officiis iste delectus alias. Enim ut ut molestiae maiores rerum aliquid minus. Animi excepturi recusandae a sit quo possimus et.
Voluptatum similique ipsam nostrum eveniet non amet. Nemo molestiae autem in assumenda in aperiam. Quo facere voluptatum suscipit voluptas deserunt. Totam aut dolor quasi.
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...