How are the totals after the question calculated in Microsoft Excel?

9.You have the opportunity to make a$180,000 investment that will pay you 8% interest for 25 years and then will pay back the full $180,000. How much are the monthly payments? PMT = $1,200

10.You have the opportunity to make a $180,000 investment that will pay you a fixed amount monthly for 25 years. Each payment will consist of interest and principal repayment. Your required rate of return is 8%. What payment amount will you accept?PMT = $1,389.27

11.Calculate the mortgage payments for a $180,000 level payment mortgage loan amortized for 25 years at 8% interest if the payments are made annually.PMT = $16,862.18

12.How much of the first year's payment would be principal and how much would be interest? Int =$14,400Prin = $2,462.18

13.If the mortgage is for 25 years with monthly amortization, what are the monthly payments? PMT = $1,389.27

14.If the payments are monthly, what is the total annual debt service?$16,671.23

15.How much of the first month's payment is principal repayment and how much is interest? Int =$1,200Prin = $189.27

16.How much of the second month's payment is principal repayment and how much is interest? Int =$1,198.74Prin = $190.53

17.At the end of the first year, how much interest and how much principal will have been paid?Int =$14,314.86Prin = $2,356.38

18.Presume that the borrowers decide to pay off the loan when they sell the house in five years.Calculate the remaining loan balance at that time.Loan Bal = $166,093.07

19.How much has the borrower paid in total payments over the five years?Total = $83,356.20