How are the totals after the question calculated in Microsoft Excel? 9.You have the opportunity to make
Question:
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
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill