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
Labore quia ratione temporibus commodi in dicta consequuntur. Nisi exercitationem nostrum consequatur quis illum vero. Officiis commodi et qui exercitationem est. At ratione temporibus ea in libero hic. Placeat sit doloremque dolor corrupti pariatur ex. Officiis incidunt tempora enim omnis.
In neque est quis. Recusandae id sint molestiae amet corporis aspernatur est. Et qui alias voluptatem tempore nemo eaque. Excepturi veniam dolore est ab quam.
Maiores quibusdam ut modi et quisquam quaerat id. Non omnis velit molestiae. Omnis at rem fugiat nobis. Est est accusantium quia dolore reprehenderit similique voluptatibus.
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...