Case Study: You have been hired to analyze the debt securities of your organization. The firm has multiple outstanding loans and bonds. Both Long-term bonds make Semi-Annual payments. The rates that are provided are the Annual Percentage Rate for each debt instrument, also known as APR (or NOM). The Fixed-Payment loan requires Monthly payments. In order to get the Period Rate of a debt instruments, you need to divide it by the number of periods per year. More specifically, you must adjust the N,I/Y, and PMT buttons (values) from AnnualDatatoPeriod Length Data. A review of the balance sheet shows the following liabilities of the firm: 1. How much interest (\$) would the firm pay each year on the annual simple-interest loan? 2. How much would you write a check for to pay off the entire simple loan in one year? 3. What is the monthly payment needed to pay off the fixed-payment loan? Case Study: You have been hired to analyze the debt securities of your organization. The firm has multiple outstanding loans and bonds. Both Long-term bonds make Semi-Annual payments. The rates that are provided are the Annual Percentage Rate for each debt instrument, also known as APR (or NOM). The Fixed-Payment loan requires Monthly payments. In order to get the Period Rate of a debt instruments, you need to divide it by the number of periods per year. More specifically, you must adjust the N,I/Y, and PMT buttons (values) from AnnualDatatoPeriod Length Data. A review of the balance sheet shows the following liabilities of the firm: 1. How much interest (\$) would the firm pay each year on the annual simple-interest loan? 2. How much would you write a check for to pay off the entire simple loan in one year? 3. What is the monthly payment needed to pay off the fixed-payment loan