King Fisher Aviation - Scenario 2 Problems Complete the five problems and prepare the spreadsheet template with your solutions. Consider each problem independently, without reference to the previous problem. The problems cover material from Modules 4 and 5. Each problem is worth 20 points, for a total of 100 points. Show your work, for the opportunity to receive partial credit in the case of an incorrect answer. Scenario 2 - Spreadsheet Template la Go back to 4.5: King Fisher Aviation Project. Scenario 2 V Expand All A Collapse All Problem 1 As the new Financial Manager, the CEO of King Fisher has asked you to review some bonds. What is the price of a 15 year, semi-annual zero coupon bond, paying $1000 at maturity if the YTM is: 896 10% 12% Fill in the values in the spreadsheet. Problem 2 Problem 3 Problem 4 Problem 5 5/113217/pages/king-fisher-aviation-module-5-scenario-2-problems O arch