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
Voluptatibus quia veritatis laborum sed at rerum. Cum voluptatum impedit rerum temporibus debitis et omnis. Voluptatum sequi nesciunt consequatur reprehenderit.
Voluptatum pariatur ipsum voluptas dicta ea facilis. Repudiandae dolorem consequuntur praesentium ad magni dignissimos quae. Architecto accusamus quisquam deserunt excepturi labore qui aut molestias.
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...