5-90). How would you answer the following question using the Microsoft Excel functions that are the in the photo I've included? "An investor is considering buying a 20-year corporate bond. The bond has a face value of $1000 and pays 6% interest per year in two semiannual payments. To receive 8% interest, compounded semiannually, how much should he be paid for the bond?"

10 O HBl solar panels angled to best catch the sua will yield 2.6 MW of power and will cost $87 million initially with first-year operating costs at $2 million, growing $250,000 annually. It will produce electricity worth $6.9 million the first year and will increase by 8% each year thereafter. is 8% hterest com- pounded semiannually, what is the bond's price? 92 A Treasury bond with a face value of $5000 and a coupon rate of 6% payable semiannually was bought when the market's nominal rate was 8%. The bond matures 20 years from now. What was paid for the bond? Design 2: Mechanized Solar Panels NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate (Does not include year zero) PV Returns the present value of an investment (PlA,i,n), (PIFin) PMT Returns the periodic payment for an annuity (A/P.i,n), (AlFin) FV Returns the future value of an investment (FIA,i,n), (FIP.in) IRR Returns the internal rate of return for a series of cash flows (IRR) MIRR Returns the internal rate of return where positive and negative cash flows are financed at different rates (ERR?)