Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

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?

WHAT OUR CURRENT CUSTOMERS SAY

  • Google
  • Sitejabber
  • Trustpilot
Zahraa S
Zahraa S
Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.
Stuart L
Stuart L
Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!
Mindi D
Mindi D
Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.
Samuel Y
Samuel Y
I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.
Cindy L
Cindy L
You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.
Got an A and plagiarism percent was less than 10%! Thanks!

ORDER NOW


Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant
BSN

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

Our Top Experts

See Why Our Clients Hire Us Again And Again!


OVER

10.3k
Reviews

RATING
4.89/5
Average

YEARS
13
Mastery

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!

Reliable

Professional

Affordable

Quick

Using this writing service is legal and is not prohibited by any law, university or college policies. Services of Elite Academic Research are provided for research and study purposes only with the intent to help students improve their writing and academic experience. We do not condone or encourage cheating, academic dishonesty, or any form of plagiarism. Our original, plagiarism-free, zero-AI expert samples should only be used as references. It is your responsibility to cite any outside sources appropriately. This service will be useful for students looking for quick, reliable, and efficient online class-help on a variety of topics.