Loan Calculator
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Loan Calculator as PDF for free.
More details
- Words: 453
- Pages: 8
Simple Loan Calculator
No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Loan amount Annual interest rate Loan period in years Start date of loan
Enter Values $100,000.00 12.500% 4 8/22/2007
Monthly payment Number of payments Total interest Total cost of loan
$2,658.00 48 $27,583.99 $127,583.99
Payment Date 9/22/2007 10/22/2007 11/22/2007 12/22/2007 1/22/2008 2/22/2008 3/22/2008 4/22/2008 5/22/2008 6/22/2008 7/22/2008 8/22/2008 9/22/2008 10/22/2008 11/22/2008 12/22/2008 1/22/2009 2/22/2009 3/22/2009 4/22/2009 5/22/2009 6/22/2009 7/22/2009 8/22/2009 9/22/2009 10/22/2009 11/22/2009 12/22/2009 1/22/2010 2/22/2010 3/22/2010
Beginning Balance $100,000.00 98,383.67 96,750.50 95,100.31 93,432.94 91,748.20 90,045.91 88,325.89 86,587.95 84,831.91 83,057.58 81,264.76 79,453.27 77,622.91 75,773.48 73,904.79 72,016.63 70,108.80 68,181.10 66,233.32 64,265.25 62,276.68 60,267.40 58,237.18 56,185.82 54,113.09 52,018.77 49,902.63 47,764.45 45,603.99 43,421.04
Payment $2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00
Principal $1,616.33 1,633.17 1,650.18 1,667.37 1,684.74 1,702.29 1,720.02 1,737.94 1,756.04 1,774.33 1,792.82 1,811.49 1,830.36 1,849.43 1,868.69 1,888.16 1,907.83 1,927.70 1,947.78 1,968.07 1,988.57 2,009.28 2,030.21 2,051.36 2,072.73 2,094.32 2,116.14 2,138.18 2,160.45 2,182.96 2,205.70
Interest $1,041.67 1,024.83 1,007.82 990.63 973.26 955.71 937.98 920.06 901.96 883.67 865.18 846.51 827.64 808.57 789.31 769.84 750.17 730.30 710.22 689.93 669.43 648.72 627.79 606.64 585.27 563.68 541.86 519.82 497.55 475.04 452.30
Ending Balance $98,383.67 96,750.50 95,100.31 93,432.94 91,748.20 90,045.91 88,325.89 86,587.95 84,831.91 83,057.58 81,264.76 79,453.27 77,622.91 75,773.48 73,904.79 72,016.63 70,108.80 68,181.10 66,233.32 64,265.25 62,276.68 60,267.40 58,237.18 56,185.82 54,113.09 52,018.77 49,902.63 47,764.45 45,603.99 43,421.04 41,215.34
Payment No. Date 32 4/22/2010 33 5/22/2010 34 6/22/2010 35 7/22/2010 36 8/22/2010 37 9/22/2010 38 10/22/2010 39 11/22/2010 40 12/22/2010 41 1/22/2011 42 2/22/2011 43 3/22/2011 44 4/22/2011 45 5/22/2011 46 6/22/2011 47 7/22/2011 48 8/22/2011
Beginning Balance 41,215.34 38,986.67 36,734.78 34,459.43 32,160.38 29,837.39 27,490.19 25,118.55 22,722.20 20,300.89 17,854.36 15,382.34 12,884.57 10,360.79 7,810.71 5,234.08 2,630.60
Payment 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00
Principal 2,228.67 2,251.89 2,275.35 2,299.05 2,323.00 2,347.19 2,371.64 2,396.35 2,421.31 2,446.53 2,472.02 2,497.77 2,523.79 2,550.07 2,576.64 2,603.48 2,630.60
Interest 429.33 406.11 382.65 358.95 335.00 310.81 286.36 261.65 236.69 211.47 185.98 160.23 134.21 107.92 81.36 54.52 27.40
Ending Balance 38,986.67 36,734.78 34,459.43 32,160.38 29,837.39 27,490.19 25,118.55 22,722.20 20,300.89 17,854.36 15,382.34 12,884.57 10,360.79 7,810.71 5,234.08 2,630.60 (0.00)
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Loan amount Annual interest rate Loan period in years Start date of loan
Enter Values $100,000.00 12.500% 4 8/22/2007
Monthly payment Number of payments Total interest Total cost of loan
$2,658.00 48 $27,583.99 $127,583.99
Payment Date 9/22/2007 10/22/2007 11/22/2007 12/22/2007 1/22/2008 2/22/2008 3/22/2008 4/22/2008 5/22/2008 6/22/2008 7/22/2008 8/22/2008 9/22/2008 10/22/2008 11/22/2008 12/22/2008 1/22/2009 2/22/2009 3/22/2009 4/22/2009 5/22/2009 6/22/2009 7/22/2009 8/22/2009 9/22/2009 10/22/2009 11/22/2009 12/22/2009 1/22/2010 2/22/2010 3/22/2010
Beginning Balance $100,000.00 98,383.67 96,750.50 95,100.31 93,432.94 91,748.20 90,045.91 88,325.89 86,587.95 84,831.91 83,057.58 81,264.76 79,453.27 77,622.91 75,773.48 73,904.79 72,016.63 70,108.80 68,181.10 66,233.32 64,265.25 62,276.68 60,267.40 58,237.18 56,185.82 54,113.09 52,018.77 49,902.63 47,764.45 45,603.99 43,421.04
Payment $2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00
Principal $1,616.33 1,633.17 1,650.18 1,667.37 1,684.74 1,702.29 1,720.02 1,737.94 1,756.04 1,774.33 1,792.82 1,811.49 1,830.36 1,849.43 1,868.69 1,888.16 1,907.83 1,927.70 1,947.78 1,968.07 1,988.57 2,009.28 2,030.21 2,051.36 2,072.73 2,094.32 2,116.14 2,138.18 2,160.45 2,182.96 2,205.70
Interest $1,041.67 1,024.83 1,007.82 990.63 973.26 955.71 937.98 920.06 901.96 883.67 865.18 846.51 827.64 808.57 789.31 769.84 750.17 730.30 710.22 689.93 669.43 648.72 627.79 606.64 585.27 563.68 541.86 519.82 497.55 475.04 452.30
Ending Balance $98,383.67 96,750.50 95,100.31 93,432.94 91,748.20 90,045.91 88,325.89 86,587.95 84,831.91 83,057.58 81,264.76 79,453.27 77,622.91 75,773.48 73,904.79 72,016.63 70,108.80 68,181.10 66,233.32 64,265.25 62,276.68 60,267.40 58,237.18 56,185.82 54,113.09 52,018.77 49,902.63 47,764.45 45,603.99 43,421.04 41,215.34
Payment No. Date 32 4/22/2010 33 5/22/2010 34 6/22/2010 35 7/22/2010 36 8/22/2010 37 9/22/2010 38 10/22/2010 39 11/22/2010 40 12/22/2010 41 1/22/2011 42 2/22/2011 43 3/22/2011 44 4/22/2011 45 5/22/2011 46 6/22/2011 47 7/22/2011 48 8/22/2011
Beginning Balance 41,215.34 38,986.67 36,734.78 34,459.43 32,160.38 29,837.39 27,490.19 25,118.55 22,722.20 20,300.89 17,854.36 15,382.34 12,884.57 10,360.79 7,810.71 5,234.08 2,630.60
Payment 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00 2,658.00
Principal 2,228.67 2,251.89 2,275.35 2,299.05 2,323.00 2,347.19 2,371.64 2,396.35 2,421.31 2,446.53 2,472.02 2,497.77 2,523.79 2,550.07 2,576.64 2,603.48 2,630.60
Interest 429.33 406.11 382.65 358.95 335.00 310.81 286.36 261.65 236.69 211.47 185.98 160.23 134.21 107.92 81.36 54.52 27.40
Ending Balance 38,986.67 36,734.78 34,459.43 32,160.38 29,837.39 27,490.19 25,118.55 22,722.20 20,300.89 17,854.36 15,382.34 12,884.57 10,360.79 7,810.71 5,234.08 2,630.60 (0.00)
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
No.
Payment Date
Beginning Balance
Payment
Principal
Interest
Ending Balance
Related Documents
Loan Calculator
May 2020 14
Car Loan Calculator
May 2020 16
Personal Loan Emi Calculator
April 2020 13
Loan
November 2019 51