View the step-by-step solution to:

Question

Hello my tutor. Your assistance is kindly requested for this assignment. Please be accurate


/>

Instructions 1 Instructions & Comments Please consider the following assumptions: Supervalue expects the expansion will increase revenues and operating expenses by 20% in 2016, 15% in 2017, 10% in 2018 and 3% thereafter. Beginning in 2018, Supervalue will settle into a permanent free cash flow growth rate of 3% per year. Supervalue's marginal cost of debt is 7.9%, and WACC is 10.0%. The marginal tax rate is 35%. Make any other assumptions you feel are necessary to perform the following tasks, and explain why you are making them. Required: (A) In Excel, create a pro forma income statement and balance sheet for Supervalue for the next five years. Below are historical financial statements and other pertinent data for Supervalue Inc. Please use these data in the following exercises. You may assume for the purposes of your calculations that "today" is February 25, 2012—that is, you do not have to worry about partial year calculations. Round your answers to the nearest 1,000 (consistent with 2012 reporting). A recent article in the Wall Street Journal reports that Supervalue (owner of grocery stores such as Albertsons and Jewel-Osco) is considering putting itself up for sale. Supervalue's earnings have taken a hit in the most recent quarter, falling 45%. Its share price has been falling as well, and management seems to be abandoning its previously optimistic outlook. Let's say you are the CEO of a competing grocery store chain and are considering the acquisition of Supervalue. You are confident that you will be able to achieve synergies, and you plan to operate the target as a subsidiary. You are now ready to calculate the value of Supervalue to determine if these synergies will be enough to make this a deal worth pursuing, and what price you should offer. Use these assumptions and the provided historical financial statements to answer the following questions. The levels of cash and interest-bearing debt are expected to remain constant through 2017, then they will grow at the same rate as free cash flows. Any liabilities labeled as "other" are non-interest-bearing. (B) Refer to your pro forma income statement from part (a) and the pro forma balance sheet provided. All numbers are in thousands of dollars. What are Supervalue's free cash flows for 2016 through 2020? You may provide your answer using the attached template. (c) Based on your previous answers and using a DCF analysis, what is Supervalue's current (beginning 2016) enterprise value? Equity value? Use the EBITDA multiple method to calculate the terminal value. The appropriate EBITDA multiple is 7x. (D) Given your calculations in part (c), what is the maximum price (equity value) you would be willing to pay for Supervalue? Briefly explain why you wouldn't be willing to pay more than this. Fee free to comment on statements and schedules directly. They will be locked. You WILL have to modify the assumptions based on your judgment. That will change the income, assets, liabilities, and equity automatically. However,You WILL have to create the valuation sheet. A comment sheet is provided as the last tab to answer the text questions.
Background image of page 01
Instructions 2 2.) Do not attempt to input in protected cells nor break the protection security. Do not attempt to reformat the sheets. This template is designed to save you time and to minimize errors. You are to focus your time on analysis. You only have to format one sheet, the valuation. 3.) Your job is to change the assumptions to get the numbers you want in the Income Statement and Balance Sheet, which are formula driven. You will have to evaluate each assumption value and modify accordingly. Do NOT create a new Income Statements or Balance Sheet. 4.) You are required to create the valuation worksheet. The tab and empty sheet is provided for you. 5.) The Fle is formatted as xls, do not change it.
Background image of page 02
Show entire document
Hello My Tutor. I Have Provided An Excel File With The Instructions Please Read The Instructions Carefully And Please Be Accurate I Will Tip You Based On Accuracy
Background image of page 1

Sign up to view the entire interaction

Top Answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online