Question

In: Finance

Please show all your work if you use the Calculator. If done in Excel, please send...

Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook.

  1. What is the market value of the following bond?

Coupon 8%

Maturity date 2038

Interest paid semiannually

Par Value $1000

Market interest rate 10%

  1. What is the market value of the following bond?

Coupon 9%

Maturity date 2028

Interest paid semiannually

Par Value $1000

Market interest rate 8%

  1. What is the yield to maturity of the following bond?

Coupon 9%

Maturity date   2027

Interest paid semiannually

Par Value $1000

Market price $955.00

  1. What is the current yield of bond in Question 3?
  1. The risk free rate is 7%, the return in the market is 10%, and the beta is 1.30. What return must you receive to be satisfied that you are being fairly compensated for the risk of the firm?
  1. What should a zero coupon bond maturing for $1000 in 9 years with a 7% market rate sell for?

Page Two

  1. Preferred stock has a dividend of $12 per year. The required return is 6%. What should be the price per share?
  1. Hurricane Corporation expects to grow its dividend by 5% per year. The current dividend is $2 per share. The required return is 8%.
  1. What is the estimated value of a share of common stock?
  2. If price is $40 and dividends were $1.50 per share but expected to grow at 4% per year, what would be the required rate of return?   
  1. Compute the expected return for the following investment

State of nature            Probability                  Return

                              Boom                    25%                             20%

                              Average                60%                             8%

                              Recession             15%                             0%

  1. The following are the expected returns on a portfolio of investments.    What is the expected rate of return on the portfolio?

Investment        # of shares         Price per share        Expected return

A.                    2000                            $20                              10%

B.                    3000                            $10                              15%

                        C.                    1000                            $15                              8%

  1. You take out a $200,000 mortgage for 20 years at 6%.
    What is your monthly payment?

What is the principle and interest on the first payment?

What is the principle and interest on the twelfth payment?

How much interest will you pay over the 20 years?

  1. You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with monthly payments which will pay off the loan when you make the last payment. The interest rate was 6%. What are your monthly payment and your current loan balance? How much interest will you pay in the upcoming year?  





Page Three

  1. You want to retire has a millionaire. How much do you need to put away each month if:
    1. You use common stocks and have an average return of 10%?
    2. You use corporate bonds and have an average return of 6%?
    3. You use government bonds and have an average return of 4%?
    4. You put your money in a CD at 2.5% interest rate?
      (Please use your own age. If you are over 45, please solve for saving a $100,000.)
  2. You are offered a contract with a signing bonus. If they offered you either $215,000 in cash or $2,000 a month for 15 years, guaranteed, which do you take (based strictly on the math)? Your safe rate of return is 7.5%.
  3. You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.

    Your plan is to go live in the tropics, on the beach, and live on coconuts and fishing. Also, you need to conclude your retirement savings at age 55 because all your spare money then will be going to your children’s education.  

    The question is how much money you will need to save each month between now and 55 so that you can quit contributing.   The expected return on your investments over the whole period is 10% per year. Please ignore inflation.

Solutions

Expert Solution

Compute the semi-annual interest, using the equation as shown below:

Semi-annual = Face value*Rate of interest/ 2

                     = $1,000*8%/ 2

                     = $40

Hence, the semi-annual interest rate is $40.

Compute the semi-annual market rate, using the equation as shown below:

Semi-annual market rate = Annual rate/ 2

                                        = 10%/ 2

                                        = 5%

Hence, the semi-annual rate is 5%.

The maturity date is 2038 and the issue date is 2020, thus the time period in maturity is 18 years.

Compute the present value annuity factor (PVIFA), using the equation as shown below:

PVIFA = {1 – (1 + Rate)-Number of periods}/ Rate

                   = {1 – (1 + 0.05)-36}/ 5%

             = 16.5468517047

Hence, the present value annuity factor is 16.5468517047.

Compute the price of the bond, using the equation as shown below:

Bond price = (Semi-annual interest*PVIFA) + {Maturity value/ (1 + Rate)Time}

                   = ($40*16.5468517047) + {$1,000/ (1 + 0.05)36}

                   = $661.874068188 + ($1,000/ 5.79181613558)

                   = $661.874068188 + $172.657414633

                   = $834.531482821

Hence, the price of the bond is $834.531482821.


Related Solutions

Please show all your work in Excel, please send me the spreadsheet / workbook. What is...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon 9% Maturity date   2027 Interest paid semiannually...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire...
Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire Rack, America’s leading online distributor of tires and wheels, conducts extensive testing to provide customers with products that are right for their vehicle, driving style, and driving conditions. In addition, the Tire Rack maintains an independent consumer survey to help drivers help each other by sharing their long-term tire experiences. The following data show survey ratings (1 to 10 scale with 10 the highest...
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond...
(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond with $1,000 principal, 20-year maturity, and 8% coupon (annual payments). Yields on comparable bonds are 10%.   Bob expects that two years from now, yields on comparable bonds will have declined to 9%. Find his expected yield, assuming the bond is sold in two years. 3. Calculate the duration of a $1,000, eight-year zero coupon bond using annual compounding and a current market rate of...
In EXCEL Please: you must show your work in Excel, which includes providing the formulas in...
In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 8 Reflection: The National Center for Education...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT