多次提前还款计算器演示教学

1、总贷款金额贷款类型利率折扣贷款期数还款方式首次还款月利率变更日448000商业贷款1.00360等额本息2014/021月1日当前还款日期执行利率月供金额提前还款当月利息当月本金期数还款金额期数调整0N/AN/A0.000.0000.000.0012014/026.550%2846.412445.33401.0822014/036.550%2846.412443.14403.2732014/046.550%2846.412440.94405.4742014/056.550%2846.412438.73407.6852014/066.550%2846.412436.50409.9162014/0

2、76.550%2846.412434.27412.1472014/086.550%2846.412432.02414.3982014/096.550%2846.412429.76416.6592014/106.550%2846.412427.48418.93102014/116.550%2846.412425.19421.22112014/126.550%2846.412422.90423.51122015/016.550%2846.412420.58425.83132015/026.550%2846.412418.26428.15142015/036.550%2846.412415.9243

3、0.49152015/046.550%2846.412413.57432.84162015/056.550%2846.4150000.00-242411.2150435.20172015/066.550%2589.572135.92453.65182015/076.550%2589.572133.44456.13192015/086.550%2589.572130.95458.62202015/096.550%2589.572128.45461.12212015/106.550%2589.5780000.00-362125.9380463.64222015/116.550%2159.68168

4、6.73472.95232015/126.550%2159.681684.15475.53242016/016.550%2159.681681.56478.12252016/026.550%2159.681678.95480.73262016/036.550%2159.681676.32483.36272016/046.550%2159.681673.69485.99282016/056.550%2159.681671.03488.65292016/066.550%2159.681668.37491.31302016/076.550%2159.681665.68494.00312016/086

5、.550%2159.681662.99496.69322016/096.550%2159.681660.28499.40332016/106.550%2159.681657.55502.13342016/116.550%2159.681654.81504.87352016/126.550%2159.681652.05507.63362017/016.550%2159.681649.28510.40372017/026.550%2159.681646.50513.18382017/036.550%2159.681643.70515.98392017/046.550%2159.681640.885

6、18.80402017/056.550%2159.681638.05521.63412017/066.550%2159.681635.20524.48422017/076.550%2159.681632.34527.34432017/086.550%2159.681629.46530.22442017/096.550%2159.681626.57533.11452017/106.550%2159.681623.66536.02462017/116.550%2159.681620.73538.95472017/126.550%2159.681617.79541.89482018/016.550%

7、2159.681614.83544.85492018/026.550%2159.681611.86547.82502018/036.550%2159.681608.87550.81512018/046.550%2159.681605.86553.82522018/056.550%2159.681602.84556.84532018/066.550%2159.681599.80559.88542018/076.550%2159.681596.74562.94552018/086.550%2159.681593.67566.01562018/096.550%2159.681590.58569.10

8、572018/106.550%2159.681587.47572.21582018/116.550%2159.681584.35575.33592018/126.550%2159.681581.21578.47602019/016.550%2159.681578.05581.63612019/026.550%2159.681574.88584.80622019/036.550%2159.681571.68588.00632019/046.550%2159.681568.48591.20642019/056.550%2159.681565.25594.43652019/066.550%2159.

9、681562.00597.68662019/076.550%2159.681558.74600.94672019/086.550%2159.681555.46604.22682019/096.550%2159.681552.16607.52692019/106.550%2159.681548.85610.83702019/116.550%2159.681545.51614.17712019/126.550%2159.681542.16617.52722020/016.550%2159.681538.79620.89732020/026.550%2159.681535.40624.2874202

10、0/036.550%2159.681531.99627.69752020/046.550%2159.681528.57631.11762020/056.550%2159.681525.12634.56772020/066.550%2159.681521.66638.02782020/076.550%2159.681518.18641.50792020/086.550%2159.681514.67645.01802020/096.550%2159.681511.15648.53812020/106.550%2159.681507.61652.07822020/116.550%2159.68150

11、4.05655.63832020/126.550%2159.681500.48659.20842021/016.550%2159.681496.88662.80852021/026.550%2159.681493.26666.42862021/036.550%2159.681489.62670.06872021/046.550%2159.681485.97673.71882021/056.550%2159.681482.29677.39892021/066.550%2159.681478.59681.09902021/076.550%2159.681474.87684.81912021/086

12、.550%2159.681471.14688.54922021/096.550%2159.681467.38692.30932021/106.550%2159.681463.60696.08942021/116.550%2159.681459.80699.88952021/126.550%2159.681455.98703.70962022/016.550%2159.681452.14707.54972022/026.550%2159.681448.28711.40982022/036.550%2159.681444.39715.29992022/046.550%2159.681440.497

13、19.191002022/056.550%2159.681436.56723.121012022/066.550%2159.681432.62727.061022022/076.550%2159.681428.65731.031032022/086.550%2159.681424.66735.021042022/096.550%2159.681420.64739.041052022/106.550%2159.681416.61743.071062022/116.550%2159.681412.55747.131072022/126.550%2159.681408.48751.201082023

14、/016.550%2159.681404.38755.301092023/026.550%2159.681400.25759.431102023/036.550%2159.681396.11763.571112023/046.550%2159.681391.94767.741122023/056.550%2159.681387.75771.931132023/066.550%2159.681383.54776.141142023/076.550%2159.681379.30780.381152023/086.550%2159.681375.04784.641162023/096.550%215

15、9.681370.76788.921172023/106.550%2159.681366.45793.231182023/116.550%2159.681362.12797.561192023/126.550%2159.681357.77801.911202024/016.550%2159.681353.39806.291212024/026.550%2159.681348.99810.691222024/036.550%2159.681344.57815.111232024/046.550%2159.681340.12819.561242024/056.550%2159.681335.648

16、24.041252024/066.550%2159.681331.15828.531262024/076.550%2159.681326.62833.061272024/086.550%2159.681322.08837.601282024/096.550%2159.681317.50842.181292024/106.550%2159.681312.91846.771302024/116.550%2159.681308.28851.401312024/126.550%2159.681303.64856.041322025/016.550%2159.681298.96860.721332025

17、/026.550%2159.681294.27865.411342025/036.550%2159.681289.54870.141352025/046.550%2159.681284.79874.891362025/056.550%2159.681280.02879.661372025/066.550%2159.681275.22884.461382025/076.550%2159.681270.39889.291392025/086.550%2159.681265.54894.141402025/096.550%2159.681260.65899.031412025/106.550%215

18、9.681255.75903.931422025/116.550%2159.681250.81908.871432025/126.550%2159.681245.85913.831442026/016.550%2159.681240.86918.821452026/026.550%2159.681235.85923.831462026/036.550%2159.681230.81928.871472026/046.550%2159.681225.74933.941482026/056.550%2159.681220.64939.041492026/066.550%2159.681215.519

19、44.171502026/076.550%2159.681210.36949.321512026/086.550%2159.681205.18954.501522026/096.550%2159.681199.97959.711532026/106.550%2159.681194.73964.951542026/116.550%2159.681189.46970.221552026/126.550%2159.681184.17975.511562027/016.550%2159.681178.84980.841572027/026.550%2159.681173.49986.191582027

20、/036.550%2159.681168.11991.571592027/046.550%2159.681162.69996.991602027/056.550%2159.681157.251002.431612027/066.550%2159.681151.781007.901622027/076.550%2159.681146.281013.401632027/086.550%2159.681140.751018.931642027/096.550%2159.681135.181024.501652027/106.550%2159.681129.591030.091662027/116.5

21、50%2159.681123.971035.711672027/126.550%2159.681118.321041.361682028/016.550%2159.681112.631047.051692028/026.550%2159.681106.921052.761702028/036.550%2159.681101.171058.511712028/046.550%2159.681095.391064.291722028/056.550%2159.681089.581070.101732028/066.550%2159.681083.741075.941742028/076.550%2

22、159.681077.871081.811752028/086.550%2159.681071.971087.711762028/096.550%2159.681066.031093.651772028/106.550%2159.681060.061099.621782028/116.550%2159.681054.061105.621792028/126.550%2159.681048.021111.661802029/016.550%2159.681041.951117.731812029/026.550%2159.681035.851123.831822029/036.550%2159.

23、681029.721129.961832029/046.550%2159.681023.551136.131842029/056.550%2159.681017.351142.331852029/066.550%2159.681011.121148.561862029/076.550%2159.681004.851154.831872029/086.550%2159.68998.541161.141882029/096.550%2159.68992.201167.481892029/106.550%2159.68985.831173.851902029/116.550%2159.68979.4

24、21180.261912029/126.550%2159.68972.981186.701922030/016.550%2159.68966.511193.171932030/026.550%2159.69959.991199.701942030/036.550%2159.68953.441206.241952030/046.550%2159.69946.861212.831962030/056.550%2159.68940.241219.441972030/066.550%2159.69933.581226.111982030/076.550%2159.68926.891232.791992

25、030/086.550%2159.68920.161239.522002030/096.550%2159.68913.401246.282012030/106.550%2159.69906.591253.102022030/116.550%2159.68899.751259.932032030/126.550%2159.68892.881266.802042031/016.550%2159.69885.961273.732052031/026.550%2159.68879.011280.672062031/036.550%2159.69872.021287.672072031/046.550%

26、2159.68864.991294.692082031/056.550%2159.69857.921301.772092031/066.550%2159.68850.821308.862102031/076.550%2159.69843.671316.022112031/086.550%2159.68836.491323.192122031/096.550%2159.68829.271330.412132031/106.550%2159.69822.011337.682142031/116.550%2159.68814.711344.972152031/126.550%2159.69807.3

27、61352.332162032/016.550%2159.68799.981359.702172032/026.550%2159.69792.561367.132182032/036.550%2159.68785.101374.582192032/046.550%2159.69777.601382.092202032/056.550%2159.68770.051389.632212032/066.550%2159.69762.471397.222222032/076.550%2159.69754.841404.852232032/086.550%2159.68747.171412.512242

28、032/096.550%2159.68739.461420.222252032/106.550%2159.68731.711427.972262032/116.550%2159.69723.921435.772272032/126.550%2159.69716.081443.612282033/016.550%2159.68708.201451.482292033/026.550%2159.69700.281459.412302033/036.550%2159.69692.311467.382312033/046.550%2159.68684.301475.382322033/056.550%

29、2159.69676.251483.442332033/066.550%2159.68668.151491.532342033/076.550%2159.69660.011499.682352033/086.550%2159.68651.821507.862362033/096.550%2159.68643.591516.092372033/106.550%2159.68635.321524.362382033/116.550%2159.69627.001532.692392033/126.550%2159.69618.631541.062402034/016.550%2159.68610.2

30、21549.462412034/026.550%2159.69601.761557.932422034/036.550%2159.68593.261566.422432034/046.550%2159.68584.711574.972442034/056.550%2159.69576.111583.582452034/066.550%2159.68567.471592.212462034/076.550%2159.69558.781600.912472034/086.550%2159.68550.041609.642482034/096.550%2159.69541.251618.442492

31、034/106.550%2159.68532.421627.262502034/116.550%2159.69523.541636.152512034/126.550%2159.68514.611645.072522035/016.550%2159.69505.631654.062532035/026.550%2159.69496.601663.092542035/036.550%2159.69487.521672.172552035/046.550%2159.68478.391681.292562035/056.550%2159.68469.221690.462572035/066.550%

32、2159.69459.991699.702582035/076.550%2159.68450.711708.972592035/086.550%2159.69441.381718.312602035/096.550%2159.68432.011727.672612035/106.550%2159.69422.581737.112622035/116.550%2159.69413.091746.602632035/126.550%2159.68403.561756.122642036/016.550%2159.68393.971765.712652036/026.550%2159.68384.3

33、41775.342662036/036.550%2159.69374.651785.042672036/046.550%2159.69364.901794.792682036/056.550%2159.68355.111804.572692036/066.550%2159.69345.261814.432702036/076.550%2159.69335.351824.342712036/086.550%2159.68325.391834.292722036/096.550%2159.68315.381844.302732036/106.550%2159.68305.321854.362742

34、036/116.550%2159.69295.191864.502752036/126.550%2159.69285.021874.672762037/016.550%2159.68274.781884.902772037/026.550%2159.68264.501895.182782037/036.550%2159.69254.151905.542792037/046.550%2159.69243.751915.942802037/056.550%2159.68233.291926.392812037/066.550%2159.68222.781936.902822037/076.550%

35、2159.69212.211947.482832037/086.550%2159.69201.581958.112842037/096.550%2159.69190.891968.802852037/106.550%2159.69180.141979.552862037/116.550%2159.68169.341990.342872037/126.550%2159.69158.472001.222882038/016.550%2159.68147.552012.132892038/026.550%2159.69136.572023.122902038/036.550%2159.69125.5

36、22034.172912038/046.550%2159.68114.422045.262922038/056.550%2159.69103.262056.432932038/066.550%2159.6992.032067.662942038/076.550%2159.6880.752078.932952038/086.550%2159.6969.402090.292962038/096.550%2159.6957.992101.702972038/106.550%2159.6846.522113.162982038/116.550%2159.6934.982124.712992038/12

37、6.550%2159.6823.382136.303002039/016.550%2159.6811.722147.96301 2039/02302 2039/03303 2039/04304 2039/05305 2039/06306 2039/07307 2039/08308 2039/09309 2039/10310 2039/11311 2039/12312 2040/01313 2040/02314 2040/03315 2040/04316 2040/05317 2040/06318 2040/07319 2040/08320 2040/09321 2040/10322 2040/

38、11323 2040/12324 2041/01325 2041/02326 2041/03327 2041/04328 2041/05329 2041/06330 2041/07331 2041/08332 2041/09333 2041/10334 2041/11335 2041/12336 2042/01337 2042/02338 2042/03339 2042/04340 2042/05341 2042/06342 2042/07343 2042/08344 2042/09345 2042/10346 2042/11347 2042/12348 2043/01349 2043/023

39、50 2043/03351 2043/04352 2043/05353 2043/06354 2043/07355 2043/08356 2043/09357 2043/10358 2043/11359 2043/12360 2044/01累计缴息累计提前还累计调整期数款343041.67-60130000.00累计偿还本累计缴纳利本金待还剩余期金息数0.000.00448000.00360说明:401.082445.33447598.92359绿色单元格是允许修改的参数,804.354888.47447195.65358其他为了防止失误加了保护 , 密1209.827329.41446790

40、.18357码1231617.509768.14446382.50356新利率发布后 , 可以在利率定义2027.4112204.64445972.59355的两个页面进行补充2439.5514638.91445560.453542853.9417070.93445146.06353支持根据利率变化自动选择3270.5919500.69444729.413523689.5221928.17444310.48351by cpiz 2011.07.134110.7424353.36443889.263504534.2526776.26443465.753494960.0829196.8444303

41、9.923482012.07.255388.2331615.10442611.77347- 修复自定利率执行日的 Bug5818.7234031.02442181.28346- 更新利率表6251.5636444.59441748.4434556686.7638855.80391313.243202012.01.1157140.4140991.72390859.59319- 增加自定义利率执行日57596.5443125.16390403.46318- 修复商贷 5年以下利率选择错58055.1645256.11389944.84317误的 Bug58516.2847384.56389483.

42、72316138979.9249510.49309020.082792011.09.11139452.8751197.22308547.13278- 修复了部分 Excel2003 不能正139928.4052881.37308071.60277确显示还款日期的 Bug140406.5254562.93307593.48276140887.2556241.88307112.75275141370.6157918.20306629.39274141856.6059591.89306143.40273142345.2561262.92305654.75272142836.5662931.29305

43、163.44271143330.5664596.97304669.44270143827.2566259.96304172.75269144326.6567920.24303673.35268144828.7869577.79303171.22267145333.6571232.60302666.35266145841.2872884.65302158.72265146351.6874533.93301648.32264146864.8676180.433011358477824.13300619.16262147899.6479465.01300100.36261148421.2781103.06299578.73260148945.7582738.26299054.25259149473.0984370.60298526.91258150003.3186000.06297996.69257150536.4287626.63297463.58256151072.4489250.29296927.56255151611.3990871.02296388.61254152153.2892488.81295846.72253152698.1394103.64295301.87252153245.9595715.5