chap10_ho1_amortization_solution

chap10_ho1_amortization_solution - LoanAmortizationSchedule...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Loan Amortization Schedule Enter values Loan summary Loan amount  $300,000.00  Scheduled payment  $1,704.95  Annual interest rate 6.25 %  Scheduled number of payments 390  Loan period in years 30  Actual number of payments 390  Number of payments per year 13  Total early payments  $-    Start date of loan 1/1/2009 Total interest  $364,929.39  Optional extra payments Lender name: Arthur L. Stone Jr. Payment Date Beginning Balance Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest 1 1/1/2009  $300,000.00   $1,704.95   $-     $1,704.95   $262.64   $1,442.31   $299,737.36   $1,442.31  2 2/1/2009  $299,737.36   $1,704.95   $-     $1,704.95   $263.90   $1,441.05   $299,473.46   $2,883.35  3 3/1/2009  $299,473.46   $1,704.95   $-     $1,704.95   $265.17   $1,439.78   $299,208.29   $4,323.13  4 4/1/2009  $299,208.29   $1,704.95   $-     $1,704.95   $266.45   $1,438.50   $298,941.84   $5,761.63  5 5/1/2009  $298,941.84   $1,704.95   $-     $1,704.95   $267.73   $1,437.22   $298,674.11   $7,198.85  6 6/1/2009  $298,674.11   $1,704.95   $-     $1,704.95   $269.01   $1,435.93   $298,405.10   $8,634.78  7 7/1/2009  $298,405.10   $1,704.95   $-     $1,704.95   $270.31   $1,434.64   $298,134.79   $10,069.42  8 8/1/2009  $298,134.79   $1,704.95   $-     $1,704.95   $271.61   $1,433.34   $297,863.19   $11,502.76  9 9/1/2009  $297,863.19   $1,704.95   $-     $1,704.95   $272.91   $1,432.03   $297,590.27   $12,934.80  10 10/1/2009  $297,590.27   $1,704.95   $-     $1,704.95   $274.22   $1,430.72   $297,316.05   $14,365.52  11 11/1/2009  $297,316.05   $1,704.95   $-     $1,704.95   $275.54   $1,429.40   $297,040.51   $15,794.93  12 12/1/2009  $297,040.51   $1,704.95   $-     $1,704.95   $276.87   $1,428.08   $296,763.64   $17,223.00  13 1/1/2010  $296,763.64   $1,704.95   $-     $1,704.95   $278.20   $1,426.75   $296,485.44   $18,649.75  14 1/1/2010  $296,485.44   $1,704.95   $-     $1,704.95   $279.54   $1,425.41   $296,205.90   $20,075.16  15 2/1/2010  $296,205.90   $1,704.95   $-     $1,704.95   $280.88   $1,424.07   $295,925.02   $21,499.23  16 3/1/2010  $295,925.02   $1,704.95   $-     $1,704.95   $282.23   $1,422.72   $295,642.79   $22,921.95  17 4/1/2010  $295,642.79   $1,704.95   $-     $1,704.95   $283.59   $1,421.36   $295,359.21   $24,343.31  18 5/1/2010  $295,359.21   $1,704.95   $-     $1,704.95   $284.95   $1,420.00   $295,074.25   $25,763.30  19 6/1/2010  $295,074.25   $1,704.95   $-     $1,704.95   $286.32   $1,418.63   $294,787.93   $27,181.93  20 7/1/2010  $294,787.93   $1,704.95   $-     $1,704.95   $287.70   $1,417.25 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/10/2010 for the course MGMT 400 taught by Professor Frankenstein during the Spring '10 term at DeVry Chicago O'Hare.

Page1 / 11

chap10_ho1_amortization_solution - LoanAmortizationSchedule...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online