Construct a pro-forma income statement

Assignment Help Financial Management
Reference no: EM13835004

Question 1

You are a financial manager that wants to know projected cash flows next year for decision-making purposes. Below is some financial statement information that is loosely based on General Electric (symbol: GE) for the year ended December 31, 2014:

Income Statement (in millions $)
Year Ended December 31, 2014

Sales

Cost of Sales

148,600

83,900

Gross Income

64,700

Selling, General, Administrative Expenses

28,700

Depreciation Expenses

9,300

Operating Income (EBIT)

26,700

Interest Expense

9,500

Pre-tax Income

17,200

Tax

1,800

Net Income

15,400

Balance Sheet (in millions $)
Year Ended December 31, 2014

Cash

Net Receivables Inventory

138,100 257,100 17,700

Accounts Payable

Short Term Debt

Other Current Liabilities

31,200 101,700 75,500

Current Assets

412,900

Current Liabilities

208,400

Net Property, Plant, Equipment

72,700

Long Term Debt

200,400

Goodwill and Intangibles

90,700

 

 

Other Long Term Assets

72,000

Other Long Term Liabilities

111,300

 

 

Total Liabilities

520,100

 

 

Total Stockholders' Equity

128,200

Total Assets

648,300

Total Liabilities and Equity

648,300

Assume the following: (1) net property, plant, and equipment for the year ended December 31, 2013 was $68,900 (in millions); (2) long-term debt for the year ended December 31, 2013 was $221,700 (in millions); (3) goodwill and intangibles, other long-term assets, short-term debt, other current liabilities, and other long term liabilities will remain unchanged next year.

a) Construct a pro-forma income statement for next year based on the assumption that sales will grow by 2.0 percent next year. Be clear about your work and assumptions.

b) Construct a pro-forma balance sheet for next year. Assume that the firm will buy another $16,000M in property, plant, and equipment. Also assume that a dividend of $13,000M will be paid out next year. If total assets are greater than total liabilities plus equity, correct this imbalance (i.e. the net funding need) by adding to long-term debt. If total assets are less than total liabilities plus equity, correct this imbalance by retiring long-term debt. Be clear about your work and assumptions and report how much you add to or subtract from long-term debt.

c) What is the projected free cash flow (FCF) for December 31, 2015? Use the following equation to solve for FCF:

FCF = OCF -Capex - ΔNWC,

where OCF = Net Income + interset + Depreciation. Make sure to show the individual numbers used in this equation. The free cash flows are the cash flows available for distribution to the firm's investors (stockholders and bondholders).

d) The free cash flow is the cash available to pay out to your investors (i.e. your bondholders and stockholders). According to your pro-formas, how much do you plan to pay your investors in 2015 (this will be the sum of interest and dividend payments)? By how much does this exceed the free cash flow you calculated in part (c)?

e) Suppose that debt markets are not available to cover the net funding need calculated in part (b). Instead, you announce a reduction in capital expenditures in 2014 by this corresponding amount. The public believes this will reduce your long-term competitive position and thus revises its expectation of your long-term regular dividend growth rate downward. Specifically, the public originally thought the dividend growth rate was 6.5 percent, but because of this announcement, it now believes the growth rate is 6.0 percent.

What is the change in the stock price of GE due to this announcement? Assume that the public values GE equity as a growing perpetuity with a $9.2B regular dividend payout next year. Also assume GE's equity beta is 1.35, a risk-free rate of 3 percent, and a market risk premium of 6 percent. GE has 10B shares outstanding.

Question 2

Suppose you want to create a "Condor Spread" option strategy based on GE call options. The butterfly spread will involve the following:

- Buying a call option with strike price $23
- Selling a call option with strike price $24
- Selling a call option with strike price $25
- Buying a call option with strike price $26

You want all of these options to have the same maturity of approximately 3 months.

a) Go to Yahoo! Finance and search for General Electric (symbol: GE), then click on "Options" on the left side of the screen, then select "December 18, 2015" in the dropdown box below the stock price to obtain a list of GE options with approximately three months to expiration.

The "Ask" price is the price at which you can buy an option while the "Bid" price is the price at which you can sell an option.

Report the bid and ask prices for each of the four call options described above. Also report the date, time, and stock price when you retrieved these options prices.

b) Like in class, provide the payoff function for each range of strike prices in which the stock price in could land in 3 months. (The stock price can land in five ranges: ???? < 23, 23 < ???? < 24, 24 < ???? < 25, 25 < ???? < 26, ???? > 26.)

c) Graph the payoff of the option strategy as a function of ????.

d) How much will this condor spread cost? Remember to use the bid price when you sell a call option, and the ask price when you buy a call option. You receive money when you sell an option and pay money when you buy an option.

e) What kind of price movements are we betting on with this strategy? (no calculations needed for this question)

f) Suppose you buy a GE call option that has a strike price equal to $23 and expiration on December 18, 2015. Because the strike price is less than the current stock price, this option is considered "in-the-money".

Report the strike price of this call option, the ask price, and the current price of GE stock.

Suppose you immediately exercise this call option. What is your payoff? Why do you think the payoff is less than the (ask) price at which you bought this option?

Question 3

You are the sole bondholder in a firm that will be liquidated next year. Your main concern is that you will not be paid back the $50M you are owed at that time. The current market value of the firm is $60M, although it is unknown what the market value will be next year.

a) Provide the payoff diagram for the bondholder with the final market value of the firm on the x- axis.

b) The financial manager of the firm currently has to make one of two choices:

- Do Nothing: under this choice, the market value of the firm will be equal to either $50M or $70M next year, with equal probability.
- Take A Huge Risk: under this choice, the market value of the firm will be equal to either $150M or zero next year with equal probability.

Assume that the bondholders and shareholders have to maintain their positions until firm liquidation next year. What is the expected payoff to bondholders and shareholders next year under each choice? If the manager is acting in the best interests of the shareholders, which choice would he make? Assume this choice is made for the rest of the problem.

c) The financial manager, acting in the shareholders' best interests, takes the huge risk, much to the detriment of you, the bondholder. If you were to completely protect yourself against the state of the world where the firm does not pay you back, would you buy a (call or put) option on the final market value of the assets of the firm, and at what strike price?

d) This option you purchase has a price of $20M. You decide to borrow the $20M, in order to pay for the option, at a 10% interest rate. The loan plus interest must be repaid in one year. What is your total expected payoff (bond + option - loan repayment) in one year? Would you be better off purchasing the option?

Firms that go bankrupt are typically unable to fully repay all bondholders. A bondholder can protect himself from this event by purchasing a "Credit Default Swap", an agreement in which he pays a third counterparty a fee (or a sequence of fees over time) and, in exchange, the third counterparty will repay the bondholder what he is owed in the event that the firm goes bankrupt and cannot repay what the bondholder is owed (you also hand over the bond to that third counterparty). "Credit Default Swaps" are, in essence, the option that you purchased in part (c).

Reference no: EM13835004

Questions Cloud

The location decision for these two entrepreneurs : Read the following situation then answer the questions as part of well written essay (250-500 words). Adhere to APA formatting and include sources and citations where appropriate as well as a reference list at the end of your essay.  (Remember to out..
What process should nursing homes follow : Which mental disorders may require the use of antipsychotic drugs for effective treatment? What process should nursing homes follow to determine if antipsychotic drugs are necessary for treatment of older adults
International business : Demonstration of your understanding of the basic problem(s) presented in this case Demonstration of your depth of understanding by analyzing quantitatively and qualitatively relevant information presented in the case Appropriate and logical recommend..
Describing basic experimental design for the proposal : Write a two-page paper describing a basic experimental design for the proposal. Design a basic experiment to assess a cause and effect relationship based on your research question. Include thefollowing information:
Construct a pro-forma income statement : Construct a pro-forma income statement for next year based on the assumption that sales will grow by 2.0 percent next year - What is the projected free cash flow for December 31, 2015?
Identify environmental hazards that may contribute to falls : Visit a local senior center, drug store, or other location that elderly people visit and identify environmental hazards that may contribute to falls. Describe how older adults utilize the services/products offered and potential fall risks at the s..
Consumers decision making can be reflective : After reading about the framing effect and preference reversals in the text, identify a product that is not a market leader and develop a marketing plan for which the framing effect could be used to encourage consumers to reverse their preferences. B..
Find the inverse of a and call it matrix x : Define the matrices: A = [12 16 4;23 1 21;9 10 1] and B = [2 7 14;3 11 2;-9 10 12]. Perform matrix multiplication AB. Perform matrix multiplication BA. Are the answers from Parts (a) and (b) the same? If yes, explain why. If not, explain why. Find th..
The forecast for may based on a weighted-moving average : What is the forecast for May based on a weighted-moving average applied to the following past demand data and using the weights 3, 2, and 1 (smallest weight is for most recent data)

Reviews

Write a Review

 

Financial Management Questions & Answers

  Present value of an uneven stream of payments

(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window: Assuming a discount rate of 17 percent, find the present value of each ..

  Exchange for a loan problem

You are offered $1000 (in nominal dollars) 6 years from now in exchange for a loan of $750 today. You expect inflation to run 3.3% per year, and your real hurdle rate is 5%. Should you make the loan? You have $1000 in an account that yields a nominal..

  What is the amount of the after-tax annual interest payment

The June Bug has a $16,000,000 bond issue outstanding. These bonds have a 7 percent coupon, pay interest semi annually in perpetuity, and have a current market price equal to 98.6 percent of face value. The tax rate is 39 percent. What is the amount ..

  Marketable securities portfolio but with interest rates up

Ralph, a treasurer for Ma nd M products, Inc., recently updated his firm's short-term cash forecast only to discover that the firm will suffer a cash shortabe of $15 million for a period of 30 days. One alternative is to liquidate a portion of his ma..

  Analyze two mutually exclusive projects-payback criterion

Your task is to analyze two mutually exclusive projects: Using the payback criterion, explain which investment should you chose? Using the discounted payback criterion, explain which investment should you chose? Using the NPV criterion, explain which..

  About executive compensation

Should we care about Executive Compensation or how much hedge fund managers earn? How should incentive compensation be changed? Should it be changed? Who can change it? Southwest Airline’s CFO hedged fuel prices and saved the company hundreds of mill..

  How much depreciation will blip write off in year

Blip Ind. purchased a new Bobber for $23,999. The new Bobber will be depreciated straight-line to $3,400 salvage over 6 years. How much depreciation will Blip write off in year 5?

  Management has already signed the contract and committed to

management has already signed the contract and committed to a project whichhas a large negative net present value. this

  Monthly overhead costs using the high-low method

Compute the fixed and variable components of the monthly overhead costs using the high-low method. Using the equation developed in (a) above. Project the overhead costs for the month of august if the direct costs for the month of august if direct lab..

  Calculate the value of fraziers stock

Frazier Manufacturing paid a dividend last year of $2, which is expected to grow at a constant rate of 5%. Frazier has a beta of 1.3. If the market is returning 11% and the risk-free rate is 4%, calculate the value of Frazier's stock.

  What is the net present value of the project

Ford Motors expects a new hybrid-engine project to produce incremental cash flows of $100 million each year and expects these to grow at 4% each year. The upfront project costs are $900 million and Ford's weighted average cost of capital is 9%. If th..

  Importance of knowing a companys wacc and npv

Calculate GBATT's WACC - using the WACC and the above cash flows, calculate the NPV of each project and justify the importance of knowing a company's WACC and NPV.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd