Posts by: Guest 1
Core Model Enhancements - Tax Schedule
In the tax schedule tab, the formula for cells G18:K18: Why is amortization of other intangibles not also added to Pre-Tax Income (GAAP) to calculate the Income Tax Expense (GAAP)? To be more specific, the current formula in G18 is =(G7+G10)*$G$25. Is there any reason why =(G7+G10+G11)*$G$25 wou... Read More
In the tax schedule tab, the formula for cells G18:K18: Why is amortization of other intangibles not also added to Pre-Tax Income (GAAP) to calculate the Income Tax Expense (GAAP)? To be more specific, the current formula in G18 is =(G7+G10)*$G$25. Is there any reason why =(G7+G10+G11)*$G$25 wou... Read More
How to u treat of amortization of intangibles and taxation?
Full Question:
What is the correct treatment of amortization of intangibles and taxation in a M&A deal?
Full Question:
What is the correct treatment of amortization of intangibles and taxation in a M&A deal?
RE: Monthly Model Balance Sheet Drivers
Would you recommend setting up schedules for a seasonal
business that has a wide variation in monthly revenue throughout the year?
i.e. December revenue is much greater than June revenue, for example.
Would you recommend setting up schedules for a seasonal
business that has a wide variation in monthly revenue throughout the year?
i.e. December revenue is much greater than June revenue, for example.
RE: Deal Comps Analysis: Quick model formatting question
For the adjustments for normalizing, can we have a separate support page (in addition to commenting) with adjust EBIT, adjust EPS, and adjust net income columns? Or is this just out of the norm?
For the adjustments for normalizing, can we have a separate support page (in addition to commenting) with adjust EBIT, adjust EPS, and adjust net income columns? Or is this just out of the norm?
Advanced Excel for Data Analysis--newer version?
Hi--I am currently doing the self study on the course Acvanced Excel for Data Analysis. I can't help but notice the videos were done in Excel 2003. Is there an updated version of the videos for 2007? I'm struggling to find some of the options/menus and follow along. I also worry I will have the same... Read More
Hi--I am currently doing the self study on the course Acvanced Excel for Data Analysis. I can't help but notice the videos were done in Excel 2003. Is there an updated version of the videos for 2007? I'm struggling to find some of the options/menus and follow along. I also worry I will have the same... Read More
Explain the difference between Stock vs Asset deals.
Full Question:
What are the different treatment of Stock vs Asset sales and how does it affect the M&A model?
Full Question:
What are the different treatment of Stock vs Asset sales and how does it affect the M&A model?
RE: Debt and Capex
To be honest i have foudn another way whivch will make the model more dynamic, instead of hardcoding the figures as you said. However in WMT case we needed to increase Capex just fro demonstrational purposes. In the attached file is the mdeo you have given, only i have altered the calculation in... Read More
To be honest i have foudn another way whivch will make the model more dynamic, instead of hardcoding the figures as you said. However in WMT case we needed to increase Capex just fro demonstrational purposes. In the attached file is the mdeo you have given, only i have altered the calculation in... Read More
Re: Core Model Enhancements - Tax Schedule
Thank you for your quick reply.
Based on your answer, I have a further question--then why is this same line item (Amortization of Other Intangibles) added back in order to calculate Pre-NOL taxable income? G12=sum(G7:G11)
Regards,
Illana
Thank you for your quick reply.
Based on your answer, I have a further question--then why is this same line item (Amortization of Other Intangibles) added back in order to calculate Pre-NOL taxable income? G12=sum(G7:G11)
Regards,
Illana
Explain 338(h)10 elections and the impact on a M&A deal.
Full Question:
Explain 338(h)10 elections and the impact on a M&A deal.
Full Question:
Explain 338(h)10 elections and the impact on a M&A deal.
To clarfiy: I would need to insert a column next to 2007 (before the Adjustments column) for, say, the 6/30/08 balance sheet; this would come under the "Actual" section. Then have the adjustments apply to that new column, which then gives the Proforma("2008"? or "2007"?) column? WOuld I still ke... To clarfiy: I would need to insert a column next to 2007 (before the
Adjustments column) for, say, the 6/30/08 balance sheet; this would come
under the "Actual" section. Then have the adjustments apply to that new
column, which then gives the Proforma("2008"? or "2007"?) column? WOuld I
still keep the separate "Estimanted 2008" column following (the model
hardwires the column title to be the year following the last year under
Actual)? Read More