Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Managerial Finance

Authors: Chad J. Zutter, Scott B. Smart

15th edition

013447631X, 134476315, 9780134478197 , 978-0134476315

More Books

Students also viewed these Finance questions

Question

Create an array in matlab

Answered: 1 week ago