Excel Actmfy: Band Viluabon Cat onf Cark w a recent cetire who is interested in investing some of his savings in corporate bonds. Iks finanoal phanner has saggested the followng bonds: - Dond A has a 94 antual covpon, matures in 12 years, and has a $1,000 face value. - Hond 8 has a 7 Wh annigal coupen, matures in 12 years, and has a $1,000 tace vahie, - Hend C has an B\% annual coupon, matures in 12 years, and has a $1,000 face value. Each bond has a yodd so maturity of By. The data bas been collected in the Macrosoft Excel fle below. Downbad the goresdsheet and perform the sequired anslysis to answer the izuestions briow. Do nat round b. Calculate the price of each of the three bonds, Round your answeis to the nearest cent. Price (Bond A): $ Price (Bond B): 5 Price (Hond C ): $ c. Cilaulate the carrent yied for each of the three bonds. (Hint: The expected current yich is calcilated as the annual interest divided by the price of the bond.) Round your answers to two deamal places. Current yeld (Bond A): Current yield (Bond B): Current yield (Bond C): d. If the yidd to maturity for each bond remains at 8%, what will be the price of each bond 1 year from now? Round your answers to the nearest cent. Price ( Bond A):$ Price (Bond B): 5 Price (Bond C): 5