Create a series of common sized income statements

Assignment Help Operation Management

Reference no: EM132146301

Assignment

1. Calculate the Geometric average rate of growth in Revenue for company.

2. Create a series of common sized income statements for all prior years.

3. Develop pro forma income statements for the next 5 years using the Revenue data from exhibit 3 &4.

4. Estimate Free Cash Flow for the next 5 years assuming depreciation of 5% of sales and capital expenditures of 4% of Sales.

5. Construct a pie chart of the firm's capital structure (market values) and calculate the Weighted average cost of capital assuming the following data:

a. Market Value of Equity: 108 B

b. Beta: 1.2

c. Expected Return on the market: 9%

d. Risk Free rate: 1.8%

e. Assume a marginal tax rate of 33%

f. Use the data from exhibit 4 for the firm's debt

6. Calculate the value of the firm using the following assumptions:

a. Terminal growth rate: 3%

b. Terminal weighted average cost of capital: 11%

7. Construct Pro forma balance sheets and statements of cash flow for the next 5 years.

8. The firm is considering issuing a 10 year 3 Billion note denominated in Swiss Francs (CHF) in 2019. The exchange rate is $1 = 1CHF.

The proceeds will be used to build a factory in the U.S. The coupon rate is expected to be 1.5%.

The factory will produce a new product to be sold in the U.S. Product D is expected to add $1 billion in sales per year starting in 2020 with a 40% cost of goods sold.

Additionally, selling, general, and administrative costs are expected to increase by $90 million per year. Please illustrate the impact to firm's overall value as well as the change in the capital structure and cost of capital.

The company offers 3 products sold in three markets. Please use the data below to develop the sales forecast for the pro forma income ststatements.

Attachment:- Final Project.rar

Reference no: EM132146301

Questions Cloud

What are the pros and cons of each : 1. Why is strategic control important in the strategy implementation process?

Use multiple sources when writing research paper : Why is it critical to use multiple sources when writing a research paper?

How would you assess for suicidality : Why is identifying the "real story" important for effective counseling? What difficulties could occur if you do not focus your counseling on the "real story?"

Terms of processes and lateral capabilities : What kind of challenges and opportunities is Four Seasons Hotels facing in terms of processes and lateral capabilities?

Create a series of common sized income statements : MBA 7294: Estimate Free Cash Flow for the next 5 years assuming depreciation of 5% of sales and capital expenditures of 4% of Sales.

Define key elements for successful therapeutic relationship : The textbook and the readings for this first topic begin to describe some of the key elements for a successful therapeutic relationship.

Compute net sales and gross profit for january : Kramer Corp. uses a perpetual inventory system and the FIFO inventory costing method. Compute net sales and gross profit for January 2017

Calculate the optimal probability of not stocking out : Calculate the optimal probability of not stocking out during lead time (a.k.a, probability that demand is less than your quantity of inventory).

Body discussing three main points and conclusion : Must have an introduction with a clear thesis statement, a body discussing the three main points and a conclusion

User Account

All Pages