the efeche-ilesentmetied Alesd the chaientents Requirements 1. Use the PV function in Excel to caiculate the iswe price of the bonds. 2. Prepare a bobd amontiason labie for Ew frit four nemiarnus interent penisdi. 1. Ficone the iasumoe of bonds peydble on Junt 30,2021 : the pornet of milerat on December 31, 2001; and the parment of mberest on Jine 30 2022 The ibiue trice of the bunds is lourfal ertrow. Glart by recording the iesuaves of the bonts on lune 30. 2021 : Phocend the semiarna ireorell paytnene an December 31, 26at Alocord the aemiannual intermat permest on Jure 30 , 2022