Question
On the EBITDA forecast tab, provide an EBITDA forecast for FYE Feb 2008.Use the Adjusted2007 column results as a basis for the forecast.Assume Sales grow
On the EBITDA forecast tab, provide an EBITDA forecast for FYE Feb 2008.Use the Adjusted2007 column results as a basis for the forecast.Assume Sales grow 6%.Carry forward the gross profit margin percentage and operating income margin percentage from the Adjusted 2007 column.Use these to find the dollar amounts for COGS and SG&A.For example, calculate $COGS as 100% minus Adjusted 2007 gross profit percentage, times the sales amount (you will not have the adjustment items like inventory impairment in the forecast year).Hold the depreciation percentage constant.Use the resulting EBITDA to calculate a forward EV/EBITDA multiple, using the $7.3B transaction value as enterprise value.Record this as the base case value.Next, assume the gross margin reaches its 2005 high of 29.5% and SGA% of sales declines back to 22%.Calculate this best-case multiple
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started