OpenFileTools
Browse tools
Free · Runs on your device · No signup

Loan Amortization Schedule Calculator

Generate a month-by-month loan amortization schedule with principal, interest, remaining balance and downloadable data.

Private by design. Inputs and calculations stay in this browser tab. No financial or property values are uploaded.

Scenario inputs

Amortization Calculator

Each monthly payment is split between interest on the current balance and principal reduction.

Calculated view
Monthly payment$2,022.62
Total interest$408,142.36
Total paid$728,142.36
Sensitivity analysis

Scenario lab

Changes only Annual interest rate while holding the other assumptions constant.

80% input5.2
Primary result: 1,757.15
90% input5.85
Primary result: 1,887.81
100% input6.5
Primary result: 2,022.62
110% input7.15
Primary result: 2,161.3
120% input7.8
Primary result: 2,303.59
Detailed schedule

Calculation table

360 rows
MonthPaymentPrincipalInterestBalance
12,022.62289.281,733.33319,710.72
22,022.62290.851,731.77319,419.86
32,022.62292.431,730.19319,127.44
42,022.62294.011,728.61318,833.43
52,022.62295.61,727.01318,537.82
62,022.62297.21,725.41318,240.62
72,022.62298.811,723.8317,941.8
82,022.62300.431,722.18317,641.37
92,022.62302.061,720.56317,339.31
102,022.62303.71,718.92317,035.62
112,022.62305.341,717.28316,730.27
122,022.623071,715.62316,423.28
132,022.62308.661,713.96316,114.62
142,022.62310.331,712.29315,804.29
152,022.62312.011,710.61315,492.28
162,022.62313.71,708.92315,178.58
172,022.62315.41,707.22314,863.18
182,022.62317.111,705.51314,546.07
192,022.62318.831,703.79314,227.24
202,022.62320.551,702.06313,906.69
212,022.62322.291,700.33313,584.4
222,022.62324.041,698.58313,260.36
232,022.62325.791,696.83312,934.57
242,022.62327.561,695.06312,607.02
252,022.62329.331,693.29312,277.69
262,022.62331.111,691.5311,946.57
272,022.62332.911,689.71311,613.67
282,022.62334.711,687.91311,278.96
292,022.62336.521,686.09310,942.43
302,022.62338.351,684.27310,604.09
312,022.62340.181,682.44310,263.91
322,022.62342.021,680.6309,921.89
332,022.62343.871,678.74309,578.01
342,022.62345.741,676.88309,232.28
352,022.62347.611,675.01308,884.67
362,022.62349.491,673.13308,535.17
372,022.62351.391,671.23308,183.79
382,022.62353.291,669.33307,830.5
392,022.62355.21,667.42307,475.3
402,022.62357.131,665.49307,118.17
412,022.62359.061,663.56306,759.11
422,022.62361.011,661.61306,398.1
432,022.62362.961,659.66306,035.14
442,022.62364.931,657.69305,670.22
452,022.62366.91,655.71305,303.31
462,022.62368.891,653.73304,934.42
472,022.62370.891,651.73304,563.53
482,022.62372.91,649.72304,190.63
492,022.62374.921,647.7303,815.71
502,022.62376.951,645.67303,438.76
512,022.62378.991,643.63303,059.77
522,022.62381.041,641.57302,678.73
532,022.62383.111,639.51302,295.62
542,022.62385.181,637.43301,910.44
552,022.62387.271,635.35301,523.17
562,022.62389.371,633.25301,133.8
572,022.62391.481,631.14300,742.33
582,022.62393.61,629.02300,348.73
592,022.62395.731,626.89299,953
602,022.62397.871,624.75299,555.13
612,022.62400.031,622.59299,155.1
622,022.62402.191,620.42298,752.91
632,022.62404.371,618.24298,348.53
642,022.62406.561,616.05297,941.97
652,022.62408.771,613.85297,533.2
662,022.62410.981,611.64297,122.23
672,022.62413.211,609.41296,709.02
682,022.62415.441,607.17296,293.58
692,022.62417.691,604.92295,875.88
702,022.62419.961,602.66295,455.93
712,022.62422.231,600.39295,033.69
722,022.62424.521,598.1294,609.18
732,022.62426.821,595.8294,182.36
742,022.62429.131,593.49293,753.23
752,022.62431.451,591.16293,321.77
762,022.62433.791,588.83292,887.98
772,022.62436.141,586.48292,451.84
782,022.62438.51,584.11292,013.34
792,022.62440.881,581.74291,572.46
802,022.62443.271,579.35291,129.19
812,022.62445.671,576.95290,683.52
822,022.62448.081,574.54290,235.44
832,022.62450.511,572.11289,784.93
842,022.62452.951,569.67289,331.98
852,022.62455.41,567.21288,876.58
862,022.62457.871,564.75288,418.71
872,022.62460.351,562.27287,958.36
882,022.62462.841,559.77287,495.52
892,022.62465.351,557.27287,030.17
902,022.62467.871,554.75286,562.3
912,022.62470.411,552.21286,091.89
922,022.62472.951,549.66285,618.94
932,022.62475.521,547.1285,143.42
942,022.62478.091,544.53284,665.33
952,022.62480.681,541.94284,184.65
962,022.62483.281,539.33283,701.37
972,022.62485.91,536.72283,215.47
982,022.62488.531,534.08282,726.93
992,022.62491.181,531.44282,235.75
1002,022.62493.841,528.78281,741.91
1012,022.62496.521,526.1281,245.4
1022,022.62499.211,523.41280,746.19
1032,022.62501.911,520.71280,244.28
1042,022.62504.631,517.99279,739.65
1052,022.62507.361,515.26279,232.29
1062,022.62510.111,512.51278,722.18
1072,022.62512.871,509.75278,209.31
1082,022.62515.651,506.97277,693.66
1092,022.62518.441,504.17277,175.22
1102,022.62521.251,501.37276,653.96
1112,022.62524.081,498.54276,129.89
1122,022.62526.911,495.7275,602.97
1132,022.62529.771,492.85275,073.21
1142,022.62532.641,489.98274,540.57
1152,022.62535.521,487.09274,005.05
1162,022.62538.421,484.19273,466.62
1172,022.62541.341,481.28272,925.28
1182,022.62544.271,478.35272,381.01
1192,022.62547.221,475.4271,833.79
1202,022.62550.181,472.43271,283.6
1212,022.62553.161,469.45270,730.44
1222,022.62556.161,466.46270,174.28
1232,022.62559.171,463.44269,615.1
1242,022.62562.21,460.42269,052.9
1252,022.62565.251,457.37268,487.65
1262,022.62568.311,454.31267,919.34
1272,022.62571.391,451.23267,347.96
1282,022.62574.481,448.13266,773.47
1292,022.62577.591,445.02266,195.88
1302,022.62580.721,441.89265,615.16
1312,022.62583.871,438.75265,031.29
1322,022.62587.031,435.59264,444.26
1332,022.62590.211,432.41263,854.04
1342,022.62593.411,429.21263,260.64
1352,022.62596.621,426262,664.01
1362,022.62599.851,422.76262,064.16
1372,022.62603.11,419.51261,461.06
1382,022.62606.371,416.25260,854.69
1392,022.62609.651,412.96260,245.03
1402,022.62612.961,409.66259,632.07
1412,022.62616.281,406.34259,015.8
1422,022.62619.621,403258,396.18
1432,022.62622.971,399.65257,773.21
1442,022.62626.351,396.27257,146.86
1452,022.62629.741,392.88256,517.12
1462,022.62633.151,389.47255,883.97
1472,022.62636.581,386.04255,247.39
1482,022.62640.031,382.59254,607.37
1492,022.62643.491,379.12253,963.87
1502,022.62646.981,375.64253,316.89
1512,022.62650.481,372.13252,666.41
1522,022.62654.011,368.61252,012.4
1532,022.62657.551,365.07251,354.85
1542,022.62661.111,361.51250,693.74
1552,022.62664.691,357.92250,029.04
1562,022.62668.291,354.32249,360.75
1572,022.62671.911,350.7248,688.84
1582,022.62675.551,347.06248,013.28
1592,022.62679.211,343.41247,334.07
1602,022.62682.891,339.73246,651.18
1612,022.62686.591,336.03245,964.59
1622,022.62690.311,332.31245,274.28
1632,022.62694.051,328.57244,580.23
1642,022.62697.811,324.81243,882.42
1652,022.62701.591,321.03243,180.84
1662,022.62705.391,317.23242,475.45
1672,022.62709.211,313.41241,766.24
1682,022.62713.051,309.57241,053.19
1692,022.62716.911,305.7240,336.27
1702,022.62720.81,301.82239,615.48
1712,022.62724.71,297.92238,890.78
1722,022.62728.631,293.99238,162.15
1732,022.62732.571,290.04237,429.58
1742,022.62736.541,286.08236,693.04
1752,022.62740.531,282.09235,952.51
1762,022.62744.541,278.08235,207.97
1772,022.62748.571,274.04234,459.39
1782,022.62752.631,269.99233,706.76
1792,022.62756.711,265.91232,950.06
1802,022.62760.81,261.81232,189.25
1812,022.62764.931,257.69231,424.33
1822,022.62769.071,253.55230,655.26
1832,022.62773.241,249.38229,882.02
1842,022.62777.421,245.19229,104.6
1852,022.62781.631,240.98228,322.96
1862,022.62785.871,236.75227,537.1
1872,022.62790.131,232.49226,746.97
1882,022.62794.41,228.21225,952.57
1892,022.62798.711,223.91225,153.86
1902,022.62803.031,219.58224,350.82
1912,022.62807.381,215.23223,543.44
1922,022.62811.761,210.86222,731.68
1932,022.62816.151,206.46221,915.53
1942,022.62820.581,202.04221,094.95
1952,022.62825.021,197.6220,269.93
1962,022.62829.491,193.13219,440.44
1972,022.62833.981,188.64218,606.46
1982,022.62838.51,184.12217,767.96
1992,022.62843.041,179.58216,924.92
2002,022.62847.611,175.01216,077.31
2012,022.62852.21,170.42215,225.11
2022,022.62856.811,165.8214,368.3
2032,022.62861.461,161.16213,506.84
2042,022.62866.121,156.5212,640.72
2052,022.62870.811,151.8211,769.91
2062,022.62875.531,147.09210,894.38
2072,022.62880.271,142.34210,014.1
2082,022.62885.041,137.58209,129.06
2092,022.62889.841,132.78208,239.23
2102,022.62894.661,127.96207,344.57
2112,022.62899.51,123.12206,445.07
2122,022.62904.371,118.24205,540.7
2132,022.62909.271,113.35204,631.42
2142,022.62914.21,108.42203,717.23
2152,022.62919.151,103.47202,798.08
2162,022.62924.131,098.49201,873.95
2172,022.62929.131,093.48200,944.82
2182,022.62934.171,088.45200,010.65
2192,022.62939.231,083.39199,071.42
2202,022.62944.311,078.3198,127.11
2212,022.62949.431,073.19197,177.68
2222,022.62954.571,068.05196,223.11
2232,022.62959.741,062.88195,263.37
2242,022.62964.941,057.68194,298.42
2252,022.62970.171,052.45193,328.26
2262,022.62975.421,047.19192,352.83
2272,022.62980.711,041.91191,372.13
2282,022.62986.021,036.6190,386.11
2292,022.62991.361,031.26189,394.75
2302,022.62996.731,025.89188,398.02
2312,022.621,002.131,020.49187,395.89
2322,022.621,007.561,015.06186,388.33
2332,022.621,013.011,009.6185,375.32
2342,022.621,018.51,004.12184,356.82
2352,022.621,024.02998.6183,332.8
2362,022.621,029.57993.05182,303.24
2372,022.621,035.14987.48181,268.09
2382,022.621,040.75981.87180,227.34
2392,022.621,046.39976.23179,180.96
2402,022.621,052.05970.56178,128.9
2412,022.621,057.75964.86177,071.15
2422,022.621,063.48959.14176,007.67
2432,022.621,069.24953.37174,938.43
2442,022.621,075.03947.58173,863.39
2452,022.621,080.86941.76172,782.53
2462,022.621,086.71935.91171,695.82
2472,022.621,092.6930.02170,603.22
2482,022.621,098.52924.1169,504.71
2492,022.621,104.47918.15168,400.24
2502,022.621,110.45912.17167,289.79
2512,022.621,116.46906.15166,173.32
2522,022.621,122.51900.11165,050.81
2532,022.621,128.59894.03163,922.22
2542,022.621,134.71887.91162,787.51
2552,022.621,140.85881.77161,646.66
2562,022.621,147.03875.59160,499.63
2572,022.621,153.24869.37159,346.39
2582,022.621,159.49863.13158,186.89
2592,022.621,165.77856.85157,021.12
2602,022.621,172.09850.53155,849.04
2612,022.621,178.44844.18154,670.6
2622,022.621,184.82837.8153,485.78
2632,022.621,191.24831.38152,294.55
2642,022.621,197.69824.93151,096.86
2652,022.621,204.18818.44149,892.68
2662,022.621,210.7811.92148,681.98
2672,022.621,217.26805.36147,464.72
2682,022.621,223.85798.77146,240.87
2692,022.621,230.48792.14145,010.39
2702,022.621,237.14785.47143,773.25
2712,022.621,243.85778.77142,529.4
2722,022.621,250.58772.03141,278.82
2732,022.621,257.36765.26140,021.46
2742,022.621,264.17758.45138,757.3
2752,022.621,271.02751.6137,486.28
2762,022.621,277.9744.72136,208.38
2772,022.621,284.82737.8134,923.56
2782,022.621,291.78730.84133,631.78
2792,022.621,298.78723.84132,333
2802,022.621,305.81716.8131,027.18
2812,022.621,312.89709.73129,714.3
2822,022.621,320702.62128,394.3
2832,022.621,327.15695.47127,067.15
2842,022.621,334.34688.28125,732.81
2852,022.621,341.56681.05124,391.25
2862,022.621,348.83673.79123,042.41
2872,022.621,356.14666.48121,686.28
2882,022.621,363.48659.13120,322.79
2892,022.621,370.87651.75118,951.92
2902,022.621,378.29644.32117,573.63
2912,022.621,385.76636.86116,187.87
2922,022.621,393.27629.35114,794.6
2932,022.621,400.81621.8113,393.79
2942,022.621,408.4614.22111,985.39
2952,022.621,416.03606.59110,569.36
2962,022.621,423.7598.92109,145.66
2972,022.621,431.41591.21107,714.24
2982,022.621,439.17583.45106,275.08
2992,022.621,446.96575.66104,828.12
3002,022.621,454.8567.82103,373.32
3012,022.621,462.68559.94101,910.64
3022,022.621,470.6552.02100,440.04
3032,022.621,478.57544.0598,961.47
3042,022.621,486.58536.0497,474.89
3052,022.621,494.63527.9995,980.27
3062,022.621,502.72519.8994,477.54
3072,022.621,510.86511.7592,966.68
3082,022.621,519.05503.5791,447.63
3092,022.621,527.28495.3489,920.35
3102,022.621,535.55487.0788,384.8
3112,022.621,543.87478.7586,840.94
3122,022.621,552.23470.3985,288.71
3132,022.621,560.64461.9883,728.07
3142,022.621,569.09453.5382,158.98
3152,022.621,577.59445.0380,581.39
3162,022.621,586.14436.4878,995.25
3172,022.621,594.73427.8977,400.53
3182,022.621,603.36419.2575,797.16
3192,022.621,612.05410.5774,185.11
3202,022.621,620.78401.8472,564.33
3212,022.621,629.56393.0670,934.77
3222,022.621,638.39384.2369,296.38
3232,022.621,647.26375.3667,649.12
3242,022.621,656.18366.4365,992.94
3252,022.621,665.16357.4664,327.78
3262,022.621,674.18348.4462,653.6
3272,022.621,683.24339.3760,970.36
3282,022.621,692.36330.2659,278
3292,022.621,701.53321.0957,576.47
3302,022.621,710.75311.8755,865.73
3312,022.621,720.01302.6154,145.71
3322,022.621,729.33293.2952,416.38
3332,022.621,738.7283.9250,677.69
3342,022.621,748.11274.548,929.58
3352,022.621,757.58265.0447,171.99
3362,022.621,767.1255.5145,404.89
3372,022.621,776.67245.9443,628.22
3382,022.621,786.3236.3241,841.92
3392,022.621,795.97226.6440,045.94
3402,022.621,805.7216.9238,240.24
3412,022.621,815.48207.1336,424.76
3422,022.621,825.32197.334,599.44
3432,022.621,835.2187.4132,764.24
3442,022.621,845.14177.4730,919.09
3452,022.621,855.14167.4829,063.95
3462,022.621,865.19157.4327,198.77
3472,022.621,875.29147.3325,323.47
3482,022.621,885.45137.1723,438.03
3492,022.621,895.66126.9621,542.36
3502,022.621,905.93116.6919,636.43
3512,022.621,916.25106.3617,720.18
3522,022.621,926.6395.9815,793.55
3532,022.621,937.0785.5513,856.48
3542,022.621,947.5675.0611,908.92
3552,022.621,958.1164.519,950.81
3562,022.621,968.7253.97,982.09
3572,022.621,979.3843.246,002.71
3582,022.621,990.132.514,012.6
3592,022.622,000.8821.732,011.72
3602,022.622,011.7210.90

This calculator is an educational planning tool. Verify financing, tax, legal, investment and accounting decisions using the authoritative documents and professionals that apply to your situation.

Why this tool is different

Generate a month-by-month loan amortization schedule with principal, interest, remaining balance and downloadable data. OpenFileTools exposes the inputs, formulas and scenario effects so the estimate remains auditable.

Requirements and recommendations

Model the decision with explicit assumptions

  • Enter realistic assumptions instead of best-case values.
  • Use the scenario lab to see which assumption changes the result most.
  • Verify taxes, rates, fees, legal rules and market inputs from authoritative sources before making a real decision.
How OpenFileTools processes it

Local processing, explicit choices.

The browser evaluates the published calculation from your inputs and recomputes a bounded sensitivity range around the selected scenario variable. No external market feed or hidden scoring service is called.

Frequently asked

Questions, answered.

Is my data uploaded?

No. Batch 3 workbooks, trackers and calculators run locally in this browser tab and generate downloads on your device.

Are the results official advice?

No. These tools are planning and analysis aids. Verify important academic, financial, tax, legal, lending, employment or investment decisions with the relevant authoritative source or professional.

Related guide

Learn more about this task.

Read the related guide
Keep going

Related free tools

Browse all tools →
↗

Image Compressor

Compress JPG, JPEG, PNG, and WebP images to reduce file size locally in your browser with no upload.

Runs on your device↗

Mortgage Calculator

Estimate principal and interest plus taxes, insurance, HOA and mortgage insurance with a monthly housing-cost breakdown.

Runs on your device↗

Home Affordability Calculator

Estimate a housing-payment budget and approximate home-price range from income, debts, rate and down payment assumptions.

Runs on your device↗

Rent vs Buy Calculator

Compare projected renting and buying cash costs, home equity and opportunity assumptions over a selected holding period.

Runs on your device