Exercise 14-1 The yellow cells in column F will indicate whether an entry is correct or incorrect. Your investment department has researched possible investments in corporate debt securities. Among the available investments are the following $100,000,000 bond issues, each dated January 1, 2021. Prices were determined by underwriters at different times during the last few weeks. $ Each of the bond issues matures on December 31, 2040, and pays interest semiannually on June 30 and December 31. For bonds of similar risk and maturity, the market yield at January 1, 2021, is 9%. 1 2 Company BB Corp. DD Corp. GG Corp. Bond Price 110 million 100 million 90 million Stated Rate 10 % 9 % 8 % $ 3 $ 1. What is the present value (price) of the BB Corp bonds? $120, 120,871 Incorrect 2. What is the present value (price) of the DD Corp bonds? $100,000,000 Correct 3. What is the present value (price) of the GG Corp bonds? $81,719,287 Incorrect Show your work below for calculating the amounts. You may type amounts in from present value tables OR use Excel functions