Question: 7. Amortization table: Below are 2 sections from a loan amortization table, the first 5 months and last 6 months, refer to the table to
7. Amortization table: Below are 2 sections from a loan amortization table, the first 5 months and last 6 months, refer to the table to answer the questions (21 points) Amortization table for $200,000.00 borrowed on Jan 01, 2012 Balance Month/Year Principal Paid Payment Paid $199.000.00 $1,300.00 $183. 31,100.67 31.105.71 Total Interest $1,100.67 $2.332.38 $1,497.13 1.800.91 31,830.80 $184.89 Pol. 2012 Mar. 2012 Apr 2012 May 2012 June 2012 $199,671.17 $1,330.00 $10.00 $1,166.75 $199.505 31 31.330.00 3108.02 $1,183.70 $199.138.49 31,800.00 $167.30 $1,162.31 55.82171 $199,170.60 MA BIA RES 51.284.97 345.63 3270.902.94 $8.50 Aug 2041 Sept. 2041 31.330.00 $1,330.00 $1.292.47 $38.14 5278.541.07 95.245.70 Oct. 2011 31.330.80 $1.300.01 $273.971.87 33.945.09 Nov. 2041 $1,330.00 31.307.59 5278.94 $2.838.10 323.02 $15.39 Deo 2041 $1.330.00 $1,315.22 5279,010.08 31. 122.9 Jan 2010 $1,300.00 $1,322 9 37.72 327901780 50.00 a What is the monthly payment? ANSWER: b. How much of the 5' payment goes to principal? ANSWER: c. How much of the 5" payment goes to interest? ANSWER: d How much is the original loan amount? ANSWER: e What is the loan balance during the May 2012 payment? ANSWER: How much interest will be paid over the life of the loan? ANSWER: g The total cash paid to the bank over the life of the loan will be
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
