Complete in excel please

Here is the full question, please complete in excel Thank you!

5. Suppose the bond above were to sell for $1080 today. What would its yield-to-maturity be if this were the case? 6. Find the price of a stock that is expected to pay a $4 dividend next year, $4.50 in year 2, $5 in year 3, if it is expected to sell for $35 in year 3 and the required return on the stock based on its risk is 9 percent. Raket. They are well de graded or completeness and wanty of content as well as form. Plan proefriad carefully for per and to say that you wae the most precise term. 2. All work wit le bouw watly including equations and formal, sep, and grand properly draww and labeled. 3. Ur Exel FUNCTIONS (og PV, IRR, de..wber patible) 4. You must w a data table for each problem. 5. You certify that all work it your oww -- you are not permitted to consult anyone. Any attempt at beating will result in failure in the course, 1. You would like to have $1 million in 40 years. (a) How much do you need to invest in a single lump sum amount today if you can carn 7 percent interest per year, (b) SEPARATELY, how much do you need to invest each year for the next 30 years if you can earn 7 percent interest per year. 2 You borrow $3500 from a friend who expects you to repay her $4500 in 8 years. What interest Tate is your friend charging you? 3. Find the NPV of $2000 now, $400 a year in years 1 to 3, $1000 in year 6, $800 in year 7 if you can earn 8 percent. 4. Find the price of a $1000 face value bond with a 5 year life if it is expected to pay a 6 percent coupon each year and has a yield-to-maturity of 9 percent. 5. Suppose the bond above were to sell for $1080 today. What would its yield-to-maturity be if this were the casei 6. Find the price of a stock that is expected to pay a $4 dividend next year, $4.50 in year 2, $5 in year 3, if it is expected to sell for $35 in year 3 and the required return on the stock based on its risk is 9 percent