Calculate supervalues free cash flows for next five years

Assignment Help Accounting Basics

Reference no: EM131468824

Problem -

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 Jan 1 of 2017-that is, you do not have to worry about partial year calculations. Round your answers to the nearest 1,000 (consistent with 2016 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.

Please consider the following assumptions:

Supervalue expects the expansion will increase revenues and operating expenses by 20% in 2017, 15% in 2018, 10% in 2019 and 3% thereafter.
The levels of cash and interest-bearing debt will grow at the same rate as free cash flows after the five year period. Any liabilities labeled as "other" are non-interest-bearing.
Supervalue's marginal cost of debt is 7.0%, and WACC is 11.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, modify the attached pro forma income statement and balance sheet for Supervalue for next five years after initial year by changing the assumptions.

(B) Refer to your pro forma income statement from part (a) and the pro forma balance sheet provided. All numbers are in millions of dollars. Calculate Supervalue's free cash flows for the next five years? 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 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 it.

An income statement, balance sheet, subsidiary schedules and assumptions page have been provided. You will not be able to change the financial 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. Do not forget to enter your name in the name field in the assumptions sheet, it is labeled 'Your name goes here'.

Attachment:- Assignment Files.rar

Reference no: EM131468824

Questions Cloud

Suppose the standard deviation : The mean IQ score of a sample of 73 students selected from a high school is 97. Suppose the standard deviation of IQ's at this school is 7.9.

Create a plan that organizes the physical needs : Create a plan that organizes the physical and monetary needs to accomplish the goal of 15% sales plan.

Compute the dictionary that results after one pivot : Consider the following dictionary: Using the largest coefficient rule to pick the entering variable, compute the dictionary that results after one pivot.

Qualitative or quantitative data for the variable : Consider methods for collecting a suitable sample of either qualitative or quantitative data for the variable.

Calculate supervalues free cash flows for next five years : Calculate Supervalue's free cash flows for the next five years? You may provide your answer using the attached template

Decide which space gets the scenic designer : You are in charge of a summer theatre held on a university campus. On that campus, you have one proscenium stage, one thrust stage, and one arena stage.

Compute the z-transforms : Compute, by long division, the first four sampled values of the functions represented by the following z-transforms.

What exactly does jihad mean : What exactly does jihad mean? And why are there two senses of the term? What elements of Muhammad's own life story?

Calculate supervalues free cash flows for next five years : Calculate Supervalue's free cash flows for the next five years? You may provide your answer using the attached template

Reviews

len1468824

4/20/2017 7:27:40 AM

HI I need help the attached question. It's a word document that spells out what needs to be done, and then an excel file that the work needs to be completed in. There is also an instruction tab on the excel file that match the instructions on the word document. Thanks!

4/20/2017 7:27:33 AM

You can only input in three areas, the student comments, assumptions and the valuation sheets. Be sure to type your name ONLY in the yellow highlighted entry in Assumptions, all of the other name references will change automatically. 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. 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 new Income Statements or Balance Sheets.

Write a Review

Required(*) Message

User Account

All Pages