Please use excel spreadsheet alone with formula step inside for the excel please I need a correct answer for this assignment. No making mistakes. I post one my homework 3 last time and got my grade back I got an c which is bad grade. Also please read the question clearly and follow the direction correct way.

Homework #4: Bond and Stock Valuations 1. A 20-year bond has a face value (principal) of $1,000 and an annual coupon rate (APR) of 6%, but it pays interest every month. The bond is always traded at par. (A) (20 pints) if you invest $500 in the bond, how much is the principal you are entitled to? (B) (20) how much interest would you be able to accumulate in a year if you could re-invest every interest payment back to the bond? 2. Assume that the current price of a stock could be expressed as D1 So = (r -9) , where r is the discount rate and g is the dividend growth rate. A. (20 points) If D1= $1, r = 10%, and g = 5%, what is the current stock price (So)? B. (20) what is the stock price at the end of year 5? C. (20) At the end of year 5, investors suddenly become more optimistic about the company and revise their expected annual rate of return on the stock (i.e., r) from 10% to 8% on a permanent basis. If dividends continue its original path of 5% annual growth rate what