贷款利率

輸入貸款金額年利率月利率貸款年期月數條件5,000,000

9.00%

0.75%

20

240

＊ 每月應付本本息金額之平均攤還率

=(((1+月利率)^月數)*月利率)/(((1+月利率)^月數)-1)

0.90%＊ 平均每月應攤付本息金額

=貸款本金*每月應付本息金額平均攤還率

44,986每月應付利息金額=本金餘額*月利率本金餘額利息本金本利15,000,00037,5007,484,98624,992,51437,4447,244,98634,984,97137,3877,59944,984,977,37237,3307,6,986,969,71637,2737,71344,986,962,00337,2157,77144,98674,9,23237,1577,83044,98684,946,40237,0987,88844,98694,938,51437,0397,94744,986104,930,56636,9798,00744,986114,922,55936,9198,06744,986124,914,49236,8598,12844,986134,906,336,7988,144,986144,8,17636,7368,25044,9861,8,92636,6748,31244,9861,881,61436,6128,37444,986174,873,24036,98,43744,986184,8,80336,4868,50044,986194,856,30336,4228,4,986204,847,73936,3588,62844,986214,839,11036,2938,69344,986224,830,41736,2288,75844,986234,821,65936,1628,82444,986244,812,83536,0968,044,98625

4,803,94536,0308,957

44,986

計算二：

輸入條件

123456710111213141516171819202122232425

2,794,9274,785,965284,776,873294,767,713304,758,485314,749,187324,739,820334,730,382344,720,8743,711,2943,701,2374,691,919384,682,122394,672,251404,662,307414,652,288424,2,194434,632,024444,621,7784,611,45,601,0474,590,5784,580,019494,569,383504,558,667514,7,871524,536,993534,526,0344,514,9935,503,8705,492,662574,481,371584,469,995594,458,534604,446,986614,435,352624,423,631634,411,8224,399,9256,387,9386,375,861674,363,694684,351,435694,339,08535,96235,535,82735,75835,635,61935,935,47835,40735,33535,26235,135,11635,04234,96734,234,81634,74034,66334,58634,50834,42934,35034,27034,19034,10934,02733,94533,86233,77933,69533,61033,52533,43933,35233,26533,17733,032,99932,91032,81932,72832,63632,39,0249,0929,1609,22,29,3679,43,50,5809,6529,7249,7979,8709,94444,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,98626272829303132333435363738394041424344474849505152535556575859606162636566676869

10,01910,09410,17010,24610,32310,40010,47810,55710,63610,71610,79610,87710,95911,04111,12411,20711,29111,37611,46111,711,63411,72111,80911,811,98712,07712,16712,25912,35112,443704,326,1714,314,105724,301,474734,288,749744,275,9287,263,0127,249,998774,236,887784,223,677794,210,368804,196,960814,183,451824,169,840834,156,128844,142,3128,128,3938,114,370874,100,241884,086,0074,071,666904,057,217914,042,660924,027,993934,013,217943,998,330953,983,331963,968,220973,952,995983,937,656993,922,2023,906,6333,0,9463,875,1423,859,2193,843,1773,827,0153,810,7313,794,3253,777,7963,761,1433,744,3663,727,4623,710,4323,693,27432,45032,35632,26132,16632,06931,97331,87531,77731,67831,57831,47731,37631,27431,17131,06730,96330,85830,75230,530,53730,42930,32030,21030,09929,98729,87529,76229,729,53229,41729,30029,18229,028,94428,82428,70328,58028,45728,33328,20928,08327,95627,82827,70012,53612,63112,72512,82112,91713,01413,11113,21013,30913,40913,50913,61013,71213,81513,91914,02314,12914,23414,34114,44914,55714,66614,77614,88714,99915,11115,22515,33915,415,57015,68715,80415,92316,04216,16216,28416,40616,52916,65316,77816,90417,03017,15817,28744,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,986707172737475767778798081828384858687809192939495969799100101102103104105106107108109110111112113100101102103104105106107108109110111112113

1143,675,9871153,658,5711163,1,0231173,623,3451183,605,5341193,587,51203,569,5091213,551,2941223,532,9431233,514,41243,495,8261253,477,0581263,458,1501273,439,1001283,419,9071293,400,5701303,381,0881313,361,4591323,341,6841333,321,7601343,301,6871353,281,41363,261,0881373,240,5601383,219,8781393,199,0411403,178,0471413,156,61423,135,5871433,114,1181443,092,4871453,070,6941463,048,7381473,026,6181483,004,3311492,981,8771502,959,2551512,936,4631522,913,5001532,0,36512,867,0571552,843,5731562,819,9141572,796,07727,57027,43927,30827,17527,04226,90726,77126,63526,49726,35826,21926,07825,93625,79325,925,50425,35825,21125,06324,91324,76324,61124,45824,30424,14923,99323,83523,67723,51723,35623,19423,03022,86622,70022,53222,322,19422,02321,85121,67821,50321,32721,14920,97117,41617,717,67917,81117,94518,07918,21518,35218,418,62818,76818,90819,05019,19319,33719,48219,62819,77519,92420,07320,22420,37520,52820,68220,83720,99321,15121,31021,46921,63021,79321,95622,12122,28722,422,62222,79222,96323,13523,30923,48323,65923,83724,014,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,9861141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531155156157

1582,772,0611592,747,8651602,723,4881612,698,9281622,674,1831632,9,25312,624,1371652,598,8311662,573,3361672,7,6501682,521,7711692,495,6981702,469,4291712,442,91722,416,3001732,3,4361742,362,3701752,335,1021762,307,6291772,279,9501782,252,0631792,223,9671802,195,6611812,167,1421822,138,4091832,109,4611842,080,2951852,050,9111862,021,3071871,991,4801881,961,43011,931,1551901,900,6521911,869,9211921,838,9591931,807,7651941,776,3371951,744,6731961,712,7711971,680,6311981,8,2491991,615,6252001,582,7562011,9,020,79020,60920,42620,24220,05619,86919,68119,49119,30019,10718,91318,71818,52118,32218,12217,92117,71817,51317,30717,10016,016,68016,46716,216,03815,82115,60215,38215,16014,93614,71114,48414,25514,02413,79213,55813,32313,08512,84612,60512,36212,11711,87111,62224,19624,37724,56024,74424,93025,11725,30525,49525,68625,87926,07326,26926,46626,626,827,06627,26927,47327,67927,88728,09628,30728,51928,73328,94829,16529,38429,60429,82630,05030,27630,50330,73130,96231,19431,42831,631,90132,14132,38232,62432,86933,11633,344,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,98615815916016116216311651661671681691701711721731741751761771781791801811821831841851861871881190191192193194195196197198199200201

2021,516,2762031,482,6622041,448,7962051,414,6752061,380,2992071,345,6652081,310,7712091,275,6162101,240,1972111,204,5122121,168,5592131,132,3372141,095,8432151,059,0762161,022,033217984,7122147,111219909,228220871,061221832,607222793,8662237,833224715,508225675,888226635,971227595,755228555,236229514,414230473,286231431,850232390,102233348,042234305,666235262,972236219,958237176,621238132,96023988,97024044,651

2410

11,37233,61411,12033,86610,86634,12010,61034,37610,35234,63410,09234,49,83135,1569,56735,4199,30135,6859,03435,9528,736,2228,49336,4948,21936,7677,94337,0437,66537,3217,38537,6017,10337,8836,81938,1676,53338,4536,24538,7425,939,0325,66139,3255,36639,6205,06939,9174,77040,2174,46840,5184,140,8223,85841,1283,55041,4373,23941,7472,922,0612,61042,3762,29242,6941,97243,0141,65043,3371,323,66299743,966744,319334,65144,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,984,986

202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245

246247248249250251252253225525625725825926026126226322652662672682692702712722732742752762772782792802812822832842852862872882

290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333

3343353363373383393403413423433443453463473483493503513523533355356357358359360361

算二：

貸款金額10,000,000

年利率3.00%

月利率0.25%

貸款年期30

月數360

每月應付本本息金額之平均攤還率

=(((1+月利率)^月數)*月利率)/(((1+月利率)^月數)-1)

0.42%平均每約應攤付本息金額

=貸款本金*每月應付本息金額平均攤還率

42,160每月應付利息金額=本金餘額*月利率本金餘額利息本金10,000,00025,00017,1609,982,84024,95717,2039,965,63624,91417,2469,948,39024,87117,29,931,10124,82817,3339,913,76824,78417,3769,6,39224,74117,4199,878,97224,69717,4639,861,51024,617,5079,844,00324,61017,5509,826,45224,56617,5949,808,85824,52217,63,791,22024,47817,6829,773,53824,43417,7279,755,81124,39017,7719,738,04024,34517,8159,720,22524,30117,8609,702,36524,25617,9049,684,46124,21117,9499,666,51124,16617,9949,8,51724,12118,0399,630,47824,07618,0849,612,39424,03118,1299,594,223,98618,1759,576,09023,94018,220

本利

42,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

9,557,8709,539,6049,521,2929,502,9359,484,5329,466,0839,447,58,429,0469,410,4599,391,8249,373,1449,3,4169,335,29,316,8209,297,9529,279,0369,260,0749,241,0639,222,0069,202,9009,183,7479,1,69,145,2979,126,0009,106,6559,087,2619,067,81,048,32,028,78,009,2008,9,5628,969,8768,950,1408,930,3558,910,5208,0,6368,870,7038,850,7198,830,6858,810,6028,790,4688,770,2838,750,0498,729,76323,523,84923,80323,75723,71123,66523,61923,57323,52623,48023,43323,38623,33923,29223,24523,19823,15023,10323,05523,00722,95922,91122,86322,81522,76722,71822,67022,62122,57222,52322,47422,42522,37522,32622,27622,22722,17722,12722,07722,02721,97621,92621,87521,82418,26618,31118,35718,40318,44918,49518,118,58818,63418,68118,72818,77418,82118,86818,91618,96319,01019,05819,10519,15319,20119,24919,29719,34519,39419,44219,49119,019,58819,63719,68619,73619,78519,83519,88419,93419,98420,03420,08420,13420,18420,23520,28520,332,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

8,709,4278,6,0418,668,6038,8,1148,627,5748,606,9828,586,3398,565,58,4,98,524,1008,503,2508,482,3488,461,3938,440,3878,419,3278,398,2158,377,0508,355,8328,334,5628,313,2388,291,8608,270,4298,248,9458,227,4078,205,8158,184,1698,162,4698,140,7158,118,9078,097,0438,075,1268,053,1538,031,1258,009,0437,986,9057,9,7127,942,4637,920,1597,7,7997,875,3837,852,9117,830,3837,807,7997,785,15821,77421,72321,67221,62021,56921,51721,46621,41421,36221,31021,25821,20621,15321,10121,04820,99620,94320,020,83620,78320,73020,67620,62220,56920,51520,46020,40620,35220,29720,24320,18820,13320,07820,02319,96719,91219,85619,80019,74419,68819,63219,57619,51919,46320,38720,43820,420,020,59120,320,69520,74620,79820,85020,90220,95521,00721,05921,11221,16521,21821,27121,32421,37721,43121,48421,53821,59221,621,70021,721,80921,86321,91821,97322,02822,08322,13822,19322,24922,30422,36022,41622,47222,52822,58422,122,69842,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

7,762,4607,739,7067,716,57,694,0277,671,1017,8,1197,625,0797,601,9817,578,8257,555,6127,532,3417,509,0117,485,6237,462,1777,438,6727,415,1087,391,4867,367,8047,344,0637,320,2637,296,4037,272,4847,248,5047,224,4657,200,3667,176,2077,151,9877,127,7067,103,3657,078,9637,0,5007,029,9767,005,3916,980,7446,956,0356,931,2656,906,4336,881,5386,856,5826,831,5636,806,4816,781,3376,756,1306,730,86019,40619,34919,29219,23519,17819,12019,06319,00518,94718,818,83118,77318,71418,65518,59718,53818,47918,42018,36018,30118,24118,18118,12118,06118,00117,94117,88017,81917,75817,69717,63617,57517,51317,45217,39017,32817,26617,20417,14117,07917,01616,95316,016,82722,722,81122,86822,92522,98323,04023,09823,15523,21323,27123,33023,38823,44623,50523,523,62323,68223,74123,80023,86023,91923,97924,03924,09924,15924,22024,28024,34124,40224,46324,52424,58524,724,70924,77024,83224,424,95725,01925,08125,14425,20725,27025,33342,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

6,705,5276,680,1306,6,6706,629,1466,603,5596,577,9076,552,1926,526,4126,500,5676,474,6586,448,6846,422,66,396,26,370,3736,344,1386,317,8386,291,4736,265,0416,238,36,211,9796,185,3496,158,6526,131,8886,105,0576,078,1596,051,1946,024,1625,997,0625,969,45,942,6585,915,3555,887,9835,860,25,833,0335,805,4555,777,8095,750,0935,722,3085,694,4535,666,5295,638,5355,610,4715,582,3365,5,13216,716,70016,63716,57316,50916,44516,38016,31616,25116,18716,12216,05715,99115,92615,86015,79515,72915,66315,59615,53015,46315,39715,33015,26315,19515,12815,06014,99314,92514,85714,78814,72014,65114,58314,51414,44514,37514,30614,23614,16614,09614,02613,95613,88525,39725,46025,52425,58825,65225,71625,78025,84425,90925,97426,03926,10426,16926,23426,30026,36626,43226,49826,526,63026,69726,726,83126,826,96527,03227,10027,16827,23627,30427,37227,44027,50927,57827,727,71627,78527,85527,92427,99428,028,13428,20528,272,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

5,525,8575,497,5115,469,0945,440,6075,412,0485,383,4175,3,7165,325,9425,297,0965,268,1795,239,15,210,1265,180,9915,151,7835,122,5025,093,1485,063,7215,034,2205,004,,974,99,945,2734,915,47,885,6044,855,6584,825,63,795,04,765,3694,735,1224,704,7994,674,4014,3,92,613,37,582,7494,552,04,521,26,490,4084,459,4734,428,4624,397,3724,366,20,334,9604,303,6374,272,23,240,75613,81513,74413,67313,60213,53013,45913,38713,31513,24313,17013,09813,02512,95212,87912,80612,73312,65912,58612,51212,43712,36312,212,21412,13912,011,911,91311,83811,76211,68611,61011,53311,45711,38011,30311,22611,14911,07110,99310,91610,83710,75910,68110,60228,34628,41728,48828,55928,63028,70228,77428,84628,91828,99029,06229,13529,20829,28129,329,42829,50129,57529,929,72329,79729,87229,94630,02130,09630,17230,24730,32330,39830,47430,55130,62730,70430,78030,85730,93431,01231,031,16731,24531,32331,40131,48031,55942,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

4,209,1984,177,5604,145,8444,114,0484,082,1734,050,2184,018,1833,986,0683,953,8733,921,5973,8,2413,856,8033,824,2853,791,6853,759,0043,726,2413,693,3963,660,4693,627,4603,594,3683,561,1943,527,9373,494,5963,461,1723,427,6653,394,0733,360,3983,326,6393,292,7953,258,8673,224,8533,190,7553,156,5713,122,3033,087,9483,053,5073,018,9812,984,3682,949,6682,914,8822,880,0092,845,0482,810,0012,774,86510,52331,63710,44431,71710,36531,79610,28531,87510,20531,95510,12632,03510,04532,1159,96532,1959,88532,2769,80432,3569,72332,4379,232,51,56132,6009,47932,6819,39832,7639,31632,8459,23332,9279,15133,0099,06933,0928,98633,1748,90333,2578,82033,3418,73633,4248,65333,5078,56933,5918,48533,6758,40133,7598,31733,8448,23233,9288,14734,0138,06234,0987,97734,1847,134,2697,80634,3557,72034,4417,63434,5277,734,6137,46134,6997,37434,7867,28734,8737,20034,9607,11335,0487,02535,1356,93735,22342,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

2,739,22,704,3312,668,9312,633,4432,597,8662,562,2012,526,4462,490,6012,4,6672,418,42,382,5302,346,3262,310,0312,273,62,237,1702,200,6022,163,9432,127,1932,090,3502,053,4162,016,31,979,2691,942,0571,904,7521,867,3531,829,8611,792,2761,7,5961,716,8221,678,91,0,9911,602,9331,5,7801,526,5311,488,1871,449,7471,411,2111,372,5791,333,8501,295,0241,256,1011,217,0811,177,9631,138,7486,84935,3116,76135,4006,67235,4886,58435,5776,49535,6666,40635,7556,31635,8446,22735,9346,13736,0246,04736,1145,95636,2045,86636,2955,77536,3855,68436,4765,59336,5675,50236,6595,41036,7515,31836,8425,22636,9355,13437,0275,04137,1194,94837,2124,85537,30,76237,3994,66837,4924,57537,58,48137,6804,38637,7744,29237,8684,19737,9634,10238,0584,00738,1533,91238,2483,81638,3443,72038,4403,62438,5363,52838,6323,43138,7293,33538,8263,23838,9233,14039,0203,04339,1182,94539,2152,84739,31442,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160

1,099,4341,060,0231,020,512980,903941,195901,388861,481821,474781,367741,160700,853660,444619,935579,325538,612497,799456,883415,8374,744333,520292,194250,7209,230167,593125,85184,002,055

0

2,74939,4122,65039,5102,55139,6092,45239,7082,35339,8072,25339,9072,140,0072,040,1071,95340,2071,85340,3081,75240,4081,65140,5091,55040,6111,44840,7121,34740,8141,24440,9161,14241,0181,04041,12193741,22483441,32773041,43062741,53352341,63741941,741311,84621041,950102,052,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,16042,160