| Enter values | Instructions | ||||||||
| Loan amount | $ 1,820,000.00 | Must be between 1 and 30 years. | |||||||
| Annual interest rate | 9.750% | If your extra payments vary, enter them in the table below. | |||||||
| Loan period in years | 11 | ||||||||
| Start date of loan | 11/10/2009 | ||||||||
| Optional extra payments | |||||||||
| Scheduled monthly payment | $ 22,529.49 | ||||||||
| Scheduled number of payments | 132 | ||||||||
| Actual number of payments | 17 | ||||||||
| Total of early payments | $ 1,590,000.00 | ||||||||
| Total interest | $ 143,274.48 | ||||||||
| No. | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Saving |
| 1 | 11/10/2009 | $ 1,820,000.00 | $ 22,529.49 | $ - | $ 22,529.49 | $ 7,741.99 | $ 14,787.50 | $ 1,812,258.01 | 91000 |
| 2 | 12/10/2009 | $ 1,812,258.01 | $ 22,529.49 | $ 250,000.00 | $ 272,529.49 | $ 257,804.89 | $ 14,724.60 | $ 1,554,453.12 | 182000 |
| 3 | 1/10/2010 | $ 1,554,453.12 | $ 22,529.49 | $ - | $ 22,529.49 | $ 9,899.56 | $ 12,629.93 | $ 1,544,553.56 | 91000 |
| 4 | 2/10/2010 | $ 1,544,553.56 | $ 22,529.49 | $ - | $ 22,529.49 | $ 9,979.99 | $ 12,549.50 | $ 1,534,573.57 | 182000 |
| 5 | 3/10/2010 | $ 1,534,573.57 | $ 22,529.49 | $ 250,000.00 | $ 272,529.49 | $ 260,061.08 | $ 12,468.41 | $ 1,274,512.49 | 273000 |
| 6 | 4/10/2010 | $ 1,274,512.49 | $ 22,529.49 | $ - | $ 22,529.49 | $ 12,174.08 | $ 10,355.41 | $ 1,262,338.41 | $114,000.00 |
| 7 | 5/10/2010 | $ 1,262,338.41 | $ 22,529.49 | $ - | $ 22,529.49 | $ 12,272.99 | $ 10,256.50 | $ 1,250,065.43 | 205000 |
| 8 | 6/10/2010 | $ 1,250,065.43 | $ 22,529.49 | $ 250,000.00 | $ 272,529.49 | $ 262,372.71 | $ 10,156.78 | $ 987,692.72 | 296000 |
| 9 | 7/10/2010 | $ 987,692.72 | $ 22,529.49 | $ - | $ 22,529.49 | $ 14,504.49 | $ 8,025.00 | $ 973,188.23 | $137,000.00 |
| 10 | 8/10/2010 | $ 973,188.23 | $ 22,529.49 | $ - | $ 22,529.49 | $ 14,622.33 | $ 7,907.15 | $ 958,565.90 | 228000 |
| 11 | 9/10/2010 | $ 958,565.90 | $ 22,529.49 | $ 320,000.00 | $ 342,529.49 | $ 334,741.14 | $ 7,788.35 | $ 623,824.76 | 319000 |
| 12 | 10/10/2010 | $ 623,824.76 | $ 22,529.49 | $ - | $ 22,529.49 | $ 17,460.91 | $ 5,068.58 | $ 606,363.84 | $ 90,000.00 |
| 13 | 11/10/2010 | $ 606,363.84 | $ 22,529.49 | $ - | $ 22,529.49 | $ 17,602.78 | $ 4,926.71 | $ 588,761.06 | 181000 |
| 14 | 12/10/2010 | $ 588,761.06 | $ 22,529.49 | $ 270,000.00 | $ 292,529.49 | $ 287,745.81 | $ 4,783.68 | $ 301,015.25 | 272000 |
| 15 | 1/10/2011 | $ 301,015.25 | $ 22,529.49 | $ - | $ 22,529.49 | $ 20,083.74 | $ 2,445.75 | $ 280,931.51 | $ 93,000.00 |
| 16 | 2/10/2011 | $ 280,931.51 | $ 22,529.49 | $ - | $ 22,529.49 | $ 20,246.92 | $ 2,282.57 | $ 260,684.59 | 184000 |
| 17 | 3/10/2011 | $ 260,684.59 | $ 22,529.49 | $ 250,000.00 | $ 272,529.49 | $ 270,411.43 | $ 2,118.06 | $ (9,726.83) | 275000 |
| 18 | 4/10/2011 | $ (9,726.83) | $ 22,529.49 | $ - | $ 22,529.49 | $ 22,608.52 | $ (79.03) | $ (32,335.35) | |
Monday, November 9, 2009
Home Track #1
Subscribe to:
Comments (Atom)