Question

In: Finance

please answer from 6th question Excel Hydro took a loan contract which requires a payment of...

please answer from 6th question

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?

3. What will be the value of the decommissioning fund in 2120?

4. 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.

5. What is the book value of shareholders' equity?

6. 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%.

7. What is the minimum number of bonds they must sell to raise the $6.2 million they need?

8. 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.

Solutions

Expert Solution

Q.6) The vice president (VP) can improve the current ratio by increasing current asset or by decreasing current liabilities or both. For this purpose, he can raise money by issuing equity or long term debt or selling fixed assets.
Specific example: In this case, the VP can sell the mailing machine & receive cash of $211,400 so VP can increase the current ratio.

Q.7) Issue price of the bond = Face value/[(1+yield)^20year] = 1000/[(1+0.095)^20] = 1000/[1.095^20] = 1000/6.1416121 = $162.82
Minumim number of bonds to sell = Amount to be raised/Issue price of the bond = $6.2million/$162.82 = 38,079 bonds

Q.8) Present worth = Deposit*{1- [1/(1+r)^n]}/r = 10000*{1- [1/(1+0.075)^4]}/0.075 = 10000*{1- [1/(1.075^4)]}/0.075 = 10000*{1- [1/1.33546914]}/0.075 = 10000*{1- 0.7488}/0.075 = 10000*0.2512/0.075 = $33,493.33

Q.9) EPS = Net earnings/Shares outstanding = $1,200,000/500,000 = $2.4

Q.10) Dividend at the end of 1st year = Last dividend*(1+growth rate) = $2*(1+0.1) = $2*1.1 = $2.2
Dividend at the end of 2nd year = Dividend in year 1*(1+growth rate) = $2.2*(1+0.1) = $2.2*1.1 = $2.42
Dividend at the end of 3rd year = Dividend in year 2*(1+growth rate) = $2.42*(1+0.1) = $2.42*1.1 = $2.662
Dividend at the end of 4th year = Dividend in year 3*(1+growth rate) = $2.662*(1+0.1) = $2.662*1.1 = $2.9282
Terminal value at the end of year 4 = Dividend in year 5/required return = $2.9282/0.12 = $24.40 (Note: After 4years dividend is assumed as constant forever)
Present value of the stock = Year 1 dividend/(1+required return) + Year 2 dividend/[(1+required return)^2] + Year 3 dividend/[(1+required return)^3] + [Year 4 dividend+year 4 terminal value]/[(1+required return)^4] = 2.2/(1+0.12) + 2.42/[(1+0.12)^2] + 2.662/[(1+0.12)^3] + [2.9282+24.4]/[(1+0.12)^4] = [2.2/1.12] + [2.42/(1.12^2)] + [2.662/(1.12^3)] + [27.3282/(1.12^4)] = 1.9643+1.9292+1.8948+17.3676 = $23.1559


Related Solutions

Excel Hydro took a loan contract which requires a payment of $40 million plus interest two...
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...
Excel Hydro took a loan contract which requires a payment of $40 million plus interest two...
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...
Excel Hydro took a loan contract which requires a payment of $40 million-plus interest two years...
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,...
Please use the data to answer the following question: Compute the total loan amount, monthly payment,...
Please use the data to answer the following question: Compute the total loan amount, monthly payment, and total interest payment for different down payment amount. Plot payment and total interest, and discuss how they change with respect to down payment amount. Auto Loan Payment Calculator Inputs Auto Loan Amount $20,000 Annual Interest Rate 8.50% Term of Loan in Years 3 First Payment Date 2/1/18 Last Payment Date 1/1/21 Frequency of Payment Monthly Summary Number of Payments 36 Rate (per period)...
Please compute the additional payment. also please include the formula used in excel. Thanks! Auto Loan...
Please compute the additional payment. also please include the formula used in excel. Thanks! Auto Loan Payment Calculator Inputs Auto Loan Amount $20,000 Annual Interest Rate 8.50% Term of Loan in Years 3 First Payment Date 2/1/18 Last Payment Date 1/1/21 Frequency of Payment Monthly Summary Number of Payments 36 Rate (per period) 0.708% Payment (per period) $631.35 Total Interest $2,728.63 Total Payments $22,728.63 No. Due Date Payment Due Additional Payment Interest Principal Balance $20,000.00 1 2/1/18 631.35 0.00 141.67...
A borrower took out a loan of 100,000 and promised to repay it with a payment...
A borrower took out a loan of 100,000 and promised to repay it with a payment at the end of each year for 30 years. The amount of each of the first ten payments equals the amount of interest due. The amount of each of the next ten payments equals 150% of the amount of interest due. The amount of each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate...
A borrower took out a loan of 100,000 and promised to repay it with a payment...
A borrower took out a loan of 100,000 and promised to repay it with a payment at the end of each year for 30 years. The amount of each of the first ten payments equals the amount of interest due. The amount of each of the next ten payments equals 150% of the amount of interest due. The amount of each of the last ten payments is X. The lender charges interest at an annual effective rate of 10%. Calculate...
Detroit Fishing obtained a $40,000 loan for the construction of a trawler, The loan contract requires...
Detroit Fishing obtained a $40,000 loan for the construction of a trawler, The loan contract requires seven equal annual payments including interest at 11.830625% compounded annually. Construct the full amortization schedule for the loan.
Company X took a loan of $400,000 and wants to know the semiannual payment for the...
Company X took a loan of $400,000 and wants to know the semiannual payment for the next 10 years at the loan interest of 8% per year compounded quarterly. please find the simiannual payment showing all the steps.
[SHORT] In Excel: Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal...
[SHORT] In Excel: Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal annual payment Interest rate: Annual interest rate is 3.0% in year 1, and increases at 0.1% increment every year after that. So Year 2's rate will be 3.1%, Year 3's rate will be 3.2%, etc. Create a year-by-year table with Year, Beginning balance, PMT, interest, principal, and ending balance. Make sure to create a column to reflect floating interest rates. Make sure to utilize...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT