Question

Mini Case 2: Excel Hydro Inc. Unit 8 (6% of the grade) Excel Hydro took a...

Mini Case 2: Excel Hydro Inc.

Unit 8 (6% of the grade)

Excel Hydro took a loan contract which requires a payment of $40 million plus interest two years after the contract's date of issue. The interest rate on the $40 million face value is 9.6% compounded quarterly. Before the maturity date, the original lender sold the contract to a pension fund for $43 million. The sale price was based on a discount rate of 8.5% compounded semi-annually from the date of sale

Excel Hydro is also considering building a nuclear power plant, which will be ready for production in 2030. The country's governing body is also considering a decommissioning liability law for the operator to put aside $1 million every month towards decommissioning cost. If the production life of the plant is 60 years and the operator puts the money at the end of the month in a savings account, earning 7.25% compounded monthly.

During the 60 years of production life of the plant, the operator will put $1 million at the end of the month in a savings account, earning 7.25% compounded monthly. At the end of the production life of the plant, there are no more contributions and the money is expected to grow at the rate of 6% compounded quarterly for the next 30 years.

  1. How many months before the maturity date did the sale take place?
  2. What will be the value of the decommissioning fund after 60 years of production?

It is an ordinary simple annuity problem

  1. What will be the value of the decommissioning fund in 2120?
  2. How much interest is included in the future value in 2120?

Six years ago, Excel Hydro Inc purchased a mailing machine at a cost of $368,000. This equipment is currently valued at $172,200 on today's statement of financial position but could actually be sold for $211,400. This is the only fixed asset the firm owns. Net working capital is $121,000 and long-term debt is $82,500. The Vice President of Excel Hydro, Inc. wants to improve the current ratio on the company's next financial statement.

  1. What is the book value of shareholders' equity?
  2. Explain what the Vice President can legitimately do now to help accomplish this goal. Provide specific examples in your answer.

Excel Hydro plans to raise $6.2 million to expand their business. To accomplish this, they plan to sell 20-year, $1,000 face value, zero-coupon bonds. The bonds will be priced to yield 9.5%. The company plans on depositing $10,000 a year in real terms into your investment account for the next four years. The relevant nominal discount rate is 7.5% and the inflation rate is 4.2%.

  1. What is the minimum number of bonds they must sell to raise the $6.2 million they need?
  2. What are the deposits worth in today's dollars?

Excel Hydro Inc. has just issued dividends at $2 per share. There are 500,000 shares outstanding. The recently released Income statement shows net earnings of $1200,000. Dividends will grow at the rate of 10% for the next four years. The required rate of return is 12%.

          9.Calculate the EPS of the company.

          10. Calculate the Present value of the stock.

Homework Answers

Answer #1
Given Data,
A. Net Earnings as per recently released data = $1,200,000
B. Outstanding No. of Shares = 500,000
C. Dividend paid recently = $2 per share
D. Required rate of return = 12% P.A.
E. Growth rate of Dividend = 10% P.A.
Answer to Question numbered 9:
Earnings per share of the Co. = Total Earnings of the Co./Total Outstanding share of the Co.
= $1,200,000/500,000
= 2.4
Answer to Question numbered 10:
Present Value of Stock as per Gordons model = D0(1+g)/r-g
where, D0 = Dividend paid recently ($2 Per Share)
r = required rate of return (12% P.A.)
g = Growth rate of Dividend (10%)
Therefore value of Stock = (2*(1+0.10))/0.12-0.10
= 110 Per Share
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mini-Case Analysis 2: Excel Hydro Inc. Excel Hydro took a loan contract which requires a payment...
Mini-Case Analysis 2: Excel Hydro Inc. Excel Hydro took a loan contract which requires a payment of $40 million plus interest two years after the contract's date of issue. The interest rate on the $40 million face value is 9.6% compounded quarterly. Before the maturity date, the original lender sold the contract to a pension fund for $43 million. The sale price was based on a discount rate of 8.5% compounded semi-annually from the date of sale. Excel Hydro is...
Exercise 11-10 Disposal of property, plant, and equipment [LO11-2] Mercury Inc. purchased equipment in 2016 at...
Exercise 11-10 Disposal of property, plant, and equipment [LO11-2] Mercury Inc. purchased equipment in 2016 at a cost of $315,000. The equipment was expected to produce 570,000 units over the next five years and have a residual value of $30,000. The equipment was sold for $160,500 part way through 2018. Actual production in each year was: 2016 = 81,000 units; 2017 = 129,000 units; 2018 = 65,000 units. Mercury uses units-of-production depreciation, and all depreciation has been recorded through the...
Develop a response in either Word or Excel and follow the instructions outlined in the Assignments...
Develop a response in either Word or Excel and follow the instructions outlined in the Assignments Menu for submission. Answer each of the following unrelated questions: On January 1, 2007, Sandstone Corporation sold a building that cost $250,000 and had accumulated depreciation of $100,000 on the date of sale. A $300,000 non-interest-bearing note due on January 1, 2013 was received as consideration. The prevailing rate of interest for a note of this type on January 1, 2007 was 11%. At...
Mini Case: The table below gives the balance sheet for Travellers Inn Inc. (TII), a company...
Mini Case: The table below gives the balance sheet for Travellers Inn Inc. (TII), a company that was formed by merging a number of regional motel chains. Travellers Inn: December 31, 2013 (Millions of Dollars) Cash $ 10 Accounts payable $ 10 Accounts receivable 20 Accruals 10 Inventories    20 Short-term debt      5 Current assets $ 50 Current liabilities $ 25 Net fixed assets 50 Long-term debt 30 Preferred stock 5 Common equity Common stock $ 10 Retained earnings...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new three-year expansion project that requires an initial fixed asset investment of $195.5 million. The fixed assets will be depreciated straight-line to zero over its three-year tax life. The fixed assets will have a market value of $95,871,755 at the end of the project. The project is estimated to generate following revenues during those three years: $84,563,662 for year one, $66,352,100 for year two, and...
The City of Rochester signed a 30-year agreement with East Coast Real Estate, Inc. to lease...
The City of Rochester signed a 30-year agreement with East Coast Real Estate, Inc. to lease a newly-constructed building for city services. The city agrees to make an initial payment of $1,600,000 and annual payments of $755,260 for the next 29 years. Using an assumed borrowing rate of 6 percent, the present value of the lease payments is approximately $11,864,600. At the time the lease agreement is signed, the building had an appraised market value of $13 million and an...
1. A company borrowed cash from the bank by signing a 6-year, 8% installment note. The...
1. A company borrowed cash from the bank by signing a 6-year, 8% installment note. The present value for an annuity (series of payments) at 8% for 6 years is 4.6229. The present value of 1 (single sum) at 8% for 6 years is .6302. Each annual payment equals $75,100. The present value of the note is: A.48,735.64 B.16,245.21 C.119,168..52 D. 450,600 E. 347,179.79 2. Barber and Atkins are partners in an accounting firm and share net income and loss...
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into...
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into an account paying 8% compounded quarterly. How much will be the total you have at the end of the time? 2. How much money will you have to deposit now if you wish to have $5,000 at the end of 8 years. Interest is to be at the rate of 6% compounded semiannually? 3. In the California “Million Dollar Lottery” a winner is paid...
2. Your stockbroker has called has called you about Netflix, Inc. (NFLX). She tells you that...
2. Your stockbroker has called has called you about Netflix, Inc. (NFLX). She tells you that Netflix is selling for $370.00 per share and that she expects the price in one year to be $395.00. The expected return on NFLX has a standard deviation of 20 percent. The market risk premium for the S & P 500 has averaged 6.0 percent. The beta for NFLX is 1.14. The ten-year Treasury bond rate is 3 percent. NFLX does not pay a...
Section 2 - CASE ANALYSIS (30 marks) INSTRUCTIONS: 1. Read the case below carefully and answer...
Section 2 - CASE ANALYSIS INSTRUCTIONS: 1. Read the case below carefully and answer ALL the questions which follow. 2. Your answers may be entered using a Microsoft Excel spreadsheet OR may be entered in a table format using Microsoft Word. HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT