PLEASE SHOW HOW YOU WOULD SOLVE USING EXCEL SOFTWARE

Par SportsBet.com Corporation is building a $40 million office building in Las Vegas and is financing the construction at an 80% loan-to-value ratio, where the loan is in the amount of $32,000,000 This loan has a ten-year maturity, calls for quarterly payments, and has a stated annual interest rate of 7.2% APR. ortsBet.com mini-case Using this information, answer the following questions What is the quarterly payment? Construct a complete Amortization Schedule for this loan, see section 5.18 of your book for details on how to set up this table. How much of the first payment is interest? How much of the first payment is principal? How much will SportsBet.com Corporation owe on this loan after making quarterly payments for three years (the amount owed immediately after the twelfth payment)? Should this loan be refinanced after three years with a new seven-year 6% APR loan (with monthly payments), if the cost to refinance is $250,000? To make this decision calculate the new loan payments and then the present value of the difference in the loan payments at 6% APR Returning to the original ten-year 7.2% APR loan, how much is the loan payment if these payments are semi-annual rather than quarterly payments? For this loan with semi-annual payments, how much will SportsBet.com Corporation owe on this loan after making semi-annual payments for three years (the amount owed immediately after the sixth payment)? 1. 2. 3. 4. 5. 6