Finance Homework that needs to be done in Excel

Problem 28-9 on Acquisition Analysis based on Chapter 28 Mergers and Acquisitions

(Excel file included)

Your company has earnings per share of $4. It has 1 million shares outstanding, each of which has a price of $40. You are thinking of buying TargetCo, which has earnings per share of $2, 1 million shares outstanding, and a price per share of $25. You will pay for TargetCo by issuing new shares. There are no expected synergies from the transaction.

a. If you pay no premium to buy TargetCo, what will your earnings per share be after the merger?

b. Suppose you offer an exchange ratio such that, at current preannouncement share prices for both firms, the offer represents a 20% premium to buy TargetCo. What will your earnings per share be after the merger?

c. What explains the change in earnings per share in part (a)? Are your shareholders any better or worse off?

d. What will your price-earnings ratio be after the merger (if you pay no premium)? How does this compare to your P/E ratio before the merger? How does this compare to TargetCo’s premerger P/E ratio?

Problem 16-8 on Managerial Decision based on Chapter 16 Financial Distress, Managerial Incentives, and Information  

(Excel file included)

As in Problem 1, Gladstone Corporation is about to launch a new product. Depending on the success of the new product, Gladstone may have one of four values next year: $150 million, $135 million, $95 million, or $80 million. These outcomes are all equally likely, and this risk is diversifiable. Suppose the risk-free interest rate is 5% and that, in the event of default, 25% of the value of Gladstone’s assets will be lost to bankruptcy costs. (Ignore all other market imperfections, such as taxes.)

a. What is the initial value of Gladstone’s equity without leverage?

Now suppose Gladstone has zero-coupon debt with a $100 million face value due next year.

b. What is the initial value of Gladstone’s debt?

c. What is the yield-to-maturity of the debt? What is its expected return?

d. What is the initial value of Gladstone’s equity? What is Gladstone’s total value with leverage?

Suppose Gladstone has 10 million shares outstanding and no debt at the start of the year.

e. If Gladstone does not issue debt, what is its share price?

f. If Gladstone issues debt of $100 million due next year and uses the proceeds to repurchase shares, what will its share price be? Why does your answer differ from that in part (e)?

Problem 16-9 on Financial Distress based on Chapter 16 Financial Distress, Managerial Incentives, and Information  

Kohwe Corporation plans to issue equity to raise $50 million to finance a new investment. After making the investment, Kohwe expects to earn free cash flows of $10 million each year. Kohwe currently has 5 million shares outstanding, and it has no other assets or opportunities.

Suppose the appropriate discount rate for Kohwe’s future free cash flows is 8%, and the only capital market imperfections are corporate taxes and financial distress costs.

a. What is the NPV of Kohwe’s investment?

b. What is Kohwe’s share price today?

Suppose Kohwe borrows the $50 million instead. The firm will pay interest only on this loan each year, and it will maintain an outstanding balance of $50 million on the loan. Suppose that Kohwe’s corporate tax rate is 40%, and expected free cash flows are still $10 million each year.

c. What is Kohwe’s share price today if the investment is financed with debt?

Now suppose that with leverage, Kohwe’s expected free cash flows will decline to $9 million per year due to reduced sales and other financial distress costs. Assume that the appropriate discount rate for Kohwe’s future free cash flows is still 8%.

d. What is Kohwe’s share price today given the financial distress costs of leverage?

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10