The notes to the Mann Ltd. financial statements reported the following data on December 31 , Year 1 (end of the fiscal year): (Click the icon to view the financial statement data.) Mann amortizes bond discounts using the effective-interest method and pays all interest amounts at December 31. Read the reguirements. Requirement 1. Assume the market interest rate is 6% on January 1 of year 1 , the date the bonds are issued. (Round your answers to the nearest whole dollar.) a. Using the PV function in Excel, what is the issue price of the bonds? The issue price of the bonds is Data table bonds are issued a. Using the Py functon in Excel, what is the issuo poce of tho bonds? b. What is the matunty value ci the bonds? c. What is Mann's anneal cash ntorest payment on the bonds? d. What s tre carreg amount of the bands at Docember 31, year 17 2. Prepare an arrotzabon table though December 31 , Year 4 for the bonds con the conas tor the yoar ended Decerrber 31, Year 4 ? 3. Show thow Mana would weport these bonds and notos at Deccenter 31. Year 4