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 the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Lets Write For You
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat