hi! can you explain how to calculate this in excel. im so lost

TB EX Qu, 9-221 (Algo) On January 1, 2024, Water Wonderland issues... On January 1, 2024, Tableau Company issues $20 million of 9% bonds, due in seven years, with interest payable semiannually on June 30 and December 31 each year. Use a financial catculator or Excel Required: 1. If the maricet fate is 8%, will the bonds issue of face amount, a discount, or o premium? Calculate the issue price. 2. If the macket rate is 9%, wil the bonds issue at face amount, o discount, or a premium? Calculate the issue price. 3. If the market rate is 10\%, wil the bonds issue at face amount, o discount, or a premium? Calculate the issue price. (Do not round intermediate calculations, Round final answer to the nearest dollar amount. Enter your answer in dollars, not in miltions) TB EX Qu, 9-221 (Algo) On January 1, 2024, Water Wonderland issues... On January 1, 2024, Tableau Company issues $20 million of 9% bonds, due in seven years, with interest payable semiannually on June 30 and December 31 each year. Use a financial catculator or Excel Required: 1. If the maricet fate is 8%, will the bonds issue of face amount, a discount, or o premium? Calculate the issue price. 2. If the macket rate is 9%, wil the bonds issue at face amount, o discount, or a premium? Calculate the issue price. 3. If the market rate is 10\%, wil the bonds issue at face amount, o discount, or a premium? Calculate the issue price. (Do not round intermediate calculations, Round final answer to the nearest dollar amount. Enter your answer in dollars, not in miltions)