# Finance-AW-Q52

## Finance-AW-Q52 Online Services

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 January 1, 2016â€”that is, you do not have to worry about partial year calculations. Round your answers to the nearest 1,000 (consistent with lst year’s 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.

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.
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.
Supervalue’s marginal cost of debt is 7.9%, 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.

You can read more about our case study assignment help services here.

## How it Works

#### How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

## Case Approach

#### Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

## Related Services

Required

(A) 15 points. In Excel, create a pro forma income statement and balance sheet for Supervalue for 2013 through 2017.

(B) 15 points. 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) 10 points. Based on your previous answers and using a DCF analysis, what is Supervalue’s current (beginning 2013) enterprise value? Equity value? Use the EBITDA multiple method to calculate the terminal value. The appropriate EBITDA multiple is 7x.

(D) 4 points. 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

“An income statement, balance sheet, subsidiary schedules and assumptions page have been provided for you. 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’.

You may be tempted to try to reuse this spreadsheet for other assignments, not a good idea. Certainly you can use it for ideas. Of course, do not share ideas, data, etc. with others while working on this exam.”

Product Code-Finance-AW-Q52