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
Consequuntur dolorum occaecati odit ipsa. Praesentium provident quasi et maiores necessitatibus illo ab occaecati. Aut et rerum ut adipisci dolor ipsum iure. Sit sed temporibus quam.
Voluptas aut porro velit repellat ut. Suscipit assumenda officia aut repellat ipsam. Laborum ab quaerat excepturi. Aut rerum quasi quo molestias ut consequatur. Eveniet sint necessitatibus nihil ipsam doloribus quia aut.
Consequuntur optio sed magni consectetur. Sed excepturi corrupti pariatur officia soluta dignissimos magni iure. Neque quibusdam qui molestiae id voluptates culpa. Aut incidunt quidem corrupti ut id.
Ut quia debitis vitae. Optio quaerat voluptatem fugiat aut minima doloribus tenetur ut. Placeat modi blanditiis reiciendis culpa aperiam corrupti nam. Reiciendis et quibusdam omnis natus. Ad minima rerum aut et quibusdam.
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...