Money, Bond Returns, and Mortgage Amortization Schedule (75 Points)1.You can purchase a T-bill that is 90 days from maturity for $9,970. The T-bill has a face value of $10,000.a. Calculate the T-bill’s quoted yield.b. Calculate the T-bill’s bond equivalent yield.c. Calculate the T-bill’s EAR.2.You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate is 5.25 percent. You will make a down payment of 20 percent of the purchase price.a. Calculate your monthly payments on this mortgage.b. Using an Excel Spreadsheet, construct the amortization schedule for the first 12 payments.c. Compute a breakdown of the total payments of the mortgage into interest and principal payment.3.As a portfolio manager for an insurance company, you are about to invest funds in one of three possible investments:a. 10-year coupon bonds issued by the U.S. Treasury,b. 20-year zero-coupon bonds issued by the Treasury, orc. One-year Treasury securities.4.Each possible investment is perceived to have no risk of default. You plan to maintain this investment for a one-year period. The return of each investment over a one-year horizon will be about the same if interest rates do not change over the next year. However, you anticipate that the U.S. inflation rate will decline substantially over the next year, while most of the other portfolio managers in the United States expect inflation to increase slightly.a. If your expectations are correct, how will the return of each investment be affected over the one-year horizon?b. If your expectations are correct, which of the three investments should have the highest return over the one-year horizon and why?Offer possible reasons you might not select the investment that would have the highest expected return over the one-year investment horizon.Complete your 2-4 page response using Microsoft Word or Excel. For calculations, you must show work to receive credit. Your well-written response should be formatted according to CSU-Global Guide to Writing and APA Requirements, with any sources properly cited. Upload your completed work to the Module 4 folder.