当前位置：文档之家 › 月均还款计算器

月均还款计算器

  • 格式：xls
  • 大小：603.00 KB
  • 文档页数：8

期数月均还款本金利息月均还款本金利息119847.749640.6510207.0824309.6514102.5610207.08219847.749685.3810162.3524244.2214102.5610141.65319847.749730.3210117.4224178.7914102.5610076.22419847.749775.4610072.2724113.3614102.5610010.79519847.749820.8210026.9224047.9314102.569945.36619847.749866.389981.3623982.5014102.569879.93719847.749912.169935.5823917.0714102.569814.50819847.749958.149889.5923851.6414102.569749.07919847.7410004.359843.3923786.2114102.569683.641019847.7410050.769796.9723720.7814102.569618.211119847.7410097.399750.3423655.3514102.569552.781219847.7410144.249703.4923589.9214102.569487.351319847.7410191.319656.4323524.4914102.569421.921419847.7410238.599609.1523459.0614102.569356.491519847.7410286.099561.6423393.6314102.569291.061619847.7410333.829513.9223328.2014102.569225.631719847.7410381.769465.9823262.7714102.569160.201819847.7410429.939417.8123197.3414102.569094.771919847.7410478.329369.4223131.9114102.569029.342019847.7410526.939320.8023066.4814102.568963.912119847.7410575.779271.9623001.0514102.568898.482219847.7410624.849222.9022935.6214102.568833.052319847.7410674.149173.6022870.1914102.568767.622419847.7410723.669124.0822804.7614102.568702.192519847.7410773.419074.3222739.3314102.568636.762619847.7410823.409024.3422673.9014102.568571.332719847.7410873.618974.1222608.4714102.568505.902819847.7410924.068923.6722543.0414102.568440.472919847.7410974.748872.9922477.6114102.568375.043019847.7411025.668822.0722412.1814102.568309.613119847.7411076.828770.9222346.7514102.568244.183219847.7411128.218719.5322281.3214102.568178.753319847.7411179.848667.9022215.8914102.568113.323419847.7411231.718616.0322150.4614102.568047.893519847.7411283.828563.9222085.0314102.567982.463619847.7411336.178511.5622019.6014102.567917.03

贷款总额p(元)2200000贷款期限n(月)156年利率%5.5675月利率‰4.639583333等额本息还款总额(元)3096246.72等额本息负担利息总额(元)896246.72

等额本息还款表等额本金还款表等额本金还款总额(元)3001256.04等额本金负担利息总额(元)801256.043719847.7411388.778458.9721954.1714102.567851.603819847.7411441.618406.1321888.7414102.567786.173919847.7411494.698353.0521823.3114102.567720.744019847.7411548.028299.7121757.8814102.567655.314119847.7411601.608246.1421692.4514102.567589.884219847.7411655.438192.3121627.0214102.567524.454319847.7411709.508138.2321561.5914102.567459.024419847.7411763.838083.9121496.1614102.567393.594519847.7411818.418029.3321430.7314102.567328.164619847.7411873.247974.5021365.3014102.567262.734719847.7411928.337919.4121299.8714102.567197.304819847.7411983.677864.0721234.4414102.567131.874919847.7412039.277808.4721169.0114102.567066.445019847.7412095.137752.6121103.5814102.567001.015119847.7412151.247696.4921038.1514102.566935.585219847.7412207.627640.1220972.7214102.566870.155319847.7412264.267583.4820907.2914102.566804.725419847.7412321.167526.5820841.8614102.566739.295519847.7412378.327469.4120776.4314102.566673.865619847.7412435.757411.9820711.0014102.566608.435719847.7412493.457354.2820645.5714102.566543.005819847.7412551.417296.3220580.1414102.566477.575919847.7412609.657238.0920514.7114102.566412.146019847.7412668.157179.5820449.2814102.566346.716119847.7412726.937120.8120383.8514102.566281.286219847.7412785.977061.7620318.4214102.566215.856319847.7412845.307002.4420252.9914102.566150.426419847.7412904.896942.8420187.5614102.566084.996519847.7412964.776882.9720122.1314102.566019.566619847.7413024.926822.8220056.7014102.565954.136719847.7413085.356762.3919991.2714102.565888.706819847.7413146.066701.6819925.8414102.565823.276919847.7413207.056640.6919860.4114102.565757.847019847.7413268.336579.4119794.9814102.565692.417119847.7413329.886517.8519729.5514102.565626.987219847.7413391.736456.0119664.1214102.565561.557319847.7413453.866393.8719598.6914102.565496.127419847.7413516.286331.4519533.2614102.565430.697519847.7413578.996268.7419467.8314102.565365.267619847.7413641.996205.7419402.4014102.565299.837719847.7413705.296142.4519336.9714102.565234.407819847.7413768.876078.8619271.5414102.565168.977919847.7413832.756014.9819206.1114102.565103.548019847.7413896.935950.8019140.6814102.565038.118119847.7413961.415886.3319075.2514102.564972.688219847.7414026.185821.5519009.8214102.564907.258319847.7414091.265756.4818944.3914102.564841.82

合集下载

买房子贷款利息怎么算 贷款利息计算

买房子贷款利息怎么算 贷款利息计算

买房子贷款利息怎么算贷款利息计算1、等额本息计算公式：〔贷款本金×月利率×(1+月利率)^还款月数〕÷〔(1+月利率)^还款月数-1〕。

2、等额本金计算公式：每月还款金额=(贷款本金÷还款月数)+(本金—已归还本金累计额)×每月利率，其中^符号表示乘方。

现在大多数开发商都是在销售期房，导致很多购房者采用贷款的方式购买房屋。

而且现在贷款买房成为了主流，但是还是有很多人不知道我国买房子贷款利息怎么算，所以在下文就为大家浅要的分析一下，希望对大家有所帮助。

一、我国买房子贷款利息怎么算在银行贷款买房的情况下，贷款利息的计算主要取决于首付数额、还款方式(等额本息还款或者等额本金还款)、按揭念书、银行利率等。

由于国家对房地产市场的政策在发生变化，所以银行利率和首付数额都是可能会变化的。

那么，在计算银行贷款买房利息时，则应当根据最新的数据进行计算。

由于银行贷款买房利息的计算比较专业，涉及到一些金融计算公式，所以为了方便广大购房者计算购房贷款利息，很多网站都提供了购房贷款利息计算器。

购房者只需在相应的地方填写具体数据，然后点击“计算”，就可以轻松计算出银行贷款买房的利息。

二、贷款利息计算方法(一)等额本息还款法“等额本息还款法”又称“月均等额还款法”，目前较为常用，它是在你还贷期限内，以固定的数目每月还贷。

也就是说，不仅每年每月本金保持不变，而且每年每月利息保持不变。

等额本息法：计算公式月还款额=本金*月利率*[(1+月利率)^n/[(1+月利率)^n-1]式中n表示贷款月数，^n表示n次方，如^240，表示240次方(贷款20年、240个月) 月利率=年利率/12总利息=月还款额*贷款月数-本金等额本息的特点是：整个还款期内，每个月的还款额保持不变。

贷款人可以准确掌握每月的还款额，有计划的安排家庭的开支。

(二)等额本金法等额本金法：计算公式月还款额=本金/n+剩余本金*月利率总利息=本金*月利率*(贷款月数/2+0.5)等额本金的特点是：本金在整个还款期内平均分摊，利息则按贷款本金余额逐日计算。

个人贷款月供款计算表11.1

个人贷款月供款计算表11.1


2,406.33 2,038.29 2,033.25 2,028.21 2,023.17 2,018.13 2,013.08 2,008.04 2,003.00 1,997.96 1,992.92 1,987.88 1,982.83 1,977.79 1,972.75 1,967.71 1,962.67 1,957.63 1,952.58 1,947.54 1,942.50 1,937.46 1,932.42 1,927.38 1,922.33 1,917.29 1,912.25 1,907.21 1,902.17 1,897.13 1,892.08 1,887.04 1,882.00 1,876.96 1,871.92 1,866.88 1,861.83 1,856.79
累计还款金额 期数 归还本金数 归还利息数 还款金额 首期 累计还款金额
期数 归还本金数 归还利息数 还款金额 首期
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 32 33 34 35 36 37 38
2,406.33 4,444.63 6,477.88 8,506.08 10,529.25 12,547.38 14,560.46 16,568.50 18,571.50 20,569.46 22,562.38 24,550.25 26,533.08 28,510.88 30,483.63 32,451.33 34,414.00 36,371.63 38,324.21 40,271.75 42,214.25 44,151.71 46,084.13 48,011.50 49,933.83 51,851.13 53,763.38 55,670.58 57,572.75 59,469.88 61,361.96 63,249.00 65,131.00 67,007.96 68,879.88 70,746.75 72,608.58 74,465.38
按揭计算EXCEL-等额本金计算器

按揭计算EXCEL-等额本金计算器

商业等额本金按揭20年公积金贷款总额80万07485.31商业贷款总额85万07468.88公积金贷款利率 4.50%07452.45商业贷款利率0.0556*******.02老公公积金月存额007419.59老婆公积金月存额007403.15总月工资007386.72商业等额本息07370.29商业每月付款¥5,879.4907353.86商业付款总额¥1,411,078.7507337.43商业其中总利息¥561,078.7507320.99¥10,94107304.5607288.13公积金等额本息¥10,94107271.70公积金每月付款¥5,061.2007255.27公积金付款总额¥1,214,686.8007238.83公积金其中总利息¥414,686.8007222.4007205.9707189.54注：1.只需要在绿色部分填写相应数据。

07173.11 粉紫色是计算的结果。

07156.6807140.2407123.8107107.3807090.9507074.5207058.0807041.6507025.2207008.7906992.3606975.9206959.4906943.0606926.6306910.2006893.7706877.3306860.9006844.4706828.0406811.6106795.1706762.31 06745.88 06729.45 06713.02 06696.58 06680.15 06663.72 06647.29 06630.86 06614.42 06597.99 06581.56 06565.13 06548.70 06532.26 06515.83 06499.40 06482.97 06466.54 06450.11 06433.67 06417.24 06400.81 06384.38 06367.95 06351.51 06335.08 06318.65 06302.22 06285.79 06269.36 06252.92 06236.49 06220.06 06203.63 06187.20 06170.76 06154.33 06137.90 06121.47 06105.04 06088.60 06072.17 06055.74 06039.31 06022.8805990.01 05973.58 05957.15 05940.72 05924.29 05907.85 05891.42 05874.99 05858.56 05842.13 05825.69 05809.26 05792.83 05776.40 05759.97 05743.54 05727.10 05710.67 05694.24 05677.81 05661.38 05644.94 05628.51 05612.08 05595.65 05579.22 05562.79 05546.35 05529.92 05513.49 05497.06 05480.63 05464.19 05447.76 05431.33 05414.90 05398.47 05382.03 05365.60 05349.17 05332.74 05316.31 05299.88 05283.44 05267.01 05250.5805217.72 05201.28 05184.85 05168.42 05151.99 05135.56 05119.13 05102.69 05086.26 05069.83 05053.40 05036.97 05020.53 05004.10 04987.67 04971.24 04954.81 04938.37 04921.94 04905.51 04889.08 04872.65 04856.22 04839.78 04823.35 04806.92 04790.49 04774.06 04757.62 04741.19 04724.76 04708.33 04691.90 04675.46 04659.03 04642.60 04626.17 04609.74 04593.31 04576.87 04560.44 04544.01 04527.58 04511.15 04494.71 04478.2804445.42 04428.99 04412.56 04396.12 04379.69 04363.26 04346.83 04330.40 04313.96 04297.53 04281.10 04264.67 04248.24 04231.80 04215.37 04198.94 04182.51 04166.08 04149.65 04133.21 04116.78 04100.35 04083.92 04067.49 04051.05 04034.62 04018.19 04001.76 03985.33 03968.89 03952.46 03936.03 03919.60 03903.17 03886.74 03870.30 03853.87 03837.44 03821.01 03804.58 03788.14 03771.71 03755.28 03738.85 03722.42 03705.9903673.12 03656.69 03640.26 03623.83 03607.39 03590.96 03574.53 03558.10公积金等额本金6333.33第1期¥13,818.6#DIV/0!¥0.0¥13,818.66320.83第2期¥13,789.7#DIV/0!¥0.0¥13,789.76308.33第3期¥13,760.8#DIV/0!¥0.0¥13,760.86295.83第4期¥13,731.9#DIV/0!¥0.0¥13,731.96283.33第5期¥13,702.9#DIV/0!¥0.0¥13,702.96270.83第6期¥13,674.0#DIV/0!¥0.0¥13,674.06258.33第7期¥13,645.1#DIV/0!¥0.0¥13,645.16245.83第8期¥13,616.1#DIV/0!¥0.0¥13,616.16233.33第9期¥13,587.2#DIV/0!¥0.0¥13,587.26220.83第10期¥13,558.3#DIV/0!¥0.0¥13,558.36208.33第11期¥13,529.3#DIV/0!¥0.0¥13,529.36195.83第12期¥13,500.4#DIV/0!¥0.0¥13,500.46183.33第13期¥13,471.5#DIV/0!¥0.0¥13,471.56170.83第14期¥13,442.5#DIV/0!¥0.0¥13,442.56158.33第15期¥13,413.6#DIV/0!¥0.0¥13,413.66145.83第16期¥13,384.7#DIV/0!¥0.0¥13,384.76133.33第17期¥13,355.7#DIV/0!¥0.0¥13,355.76120.83第18期¥13,326.8#DIV/0!¥0.0¥13,326.86108.33第19期¥13,297.9#DIV/0!¥0.0¥13,297.96095.83第20期¥13,268.9#DIV/0!¥0.0¥13,268.96083.33第21期¥13,240.0#DIV/0!¥0.0¥13,240.06070.83第22期¥13,211.1#DIV/0!¥0.0¥13,211.16058.33第23期¥13,182.1#DIV/0!¥0.0¥13,182.16045.83第24期¥13,153.2#DIV/0!¥0.0¥13,153.26033.33第25期¥13,124.3#DIV/0!¥0.0¥13,124.36020.83第26期¥13,095.3#DIV/0!¥0.0¥13,095.36008.33第27期¥13,066.4#DIV/0!¥0.0¥13,066.45995.83第28期¥13,037.5#DIV/0!¥0.0¥13,037.55983.33第29期¥13,008.6#DIV/0!¥0.0¥13,008.65970.83第30期¥12,979.6#DIV/0!¥0.0¥12,979.65958.33第31期¥12,950.7#DIV/0!¥0.0¥12,950.75945.83第32期¥12,921.8#DIV/0!¥0.0¥12,921.85933.33第33期¥12,892.8#DIV/0!¥0.0¥12,892.85920.83第34期¥12,863.9#DIV/0!¥0.0¥12,863.95908.33第35期¥12,835.0#DIV/0!¥0.0¥12,835.05895.83第36期¥12,806.0#DIV/0!¥0.0¥12,806.05883.33第37期¥12,777.1#DIV/0!¥0.0¥12,777.15870.83第38期¥12,748.2#DIV/0!¥0.0¥12,748.25858.33第39期¥12,719.2#DIV/0!¥0.0¥12,719.25845.83第40期¥12,690.3#DIV/0!¥0.0¥12,690.35833.33第41期¥12,661.4#DIV/0!¥0.0¥12,661.45820.83第42期¥12,632.4#DIV/0!¥0.0¥12,632.45808.33第43期¥12,603.5#DIV/0!¥0.0¥12,603.5总贷款额占总收入比重公积金月存额补交差额5783.33第45期¥12,545.6#DIV/0!¥0.0¥12,545.6 5770.83第46期¥12,516.7#DIV/0!¥0.0¥12,516.7 5758.33第47期¥12,487.8#DIV/0!¥0.0¥12,487.8 5745.83第48期¥12,458.8#DIV/0!¥0.0¥12,458.8 5733.33第49期¥12,429.9#DIV/0!¥0.0¥12,429.9 5720.83第50期¥12,401.0#DIV/0!¥0.0¥12,401.0 5708.33第51期¥12,372.1#DIV/0!¥0.0¥12,372.1 5695.83第52期¥12,343.1#DIV/0!¥0.0¥12,343.1 5683.33第53期¥12,314.2#DIV/0!¥0.0¥12,314.2 5670.83第54期¥12,285.3#DIV/0!¥0.0¥12,285.3 5658.33第55期¥12,256.3#DIV/0!¥0.0¥12,256.3 5645.83第56期¥12,227.4#DIV/0!¥0.0¥12,227.4 5633.33第57期¥12,198.5#DIV/0!¥0.0¥12,198.5 5620.83第58期¥12,169.5#DIV/0!¥0.0¥12,169.5 5608.33第59期¥12,140.6#DIV/0!¥0.0¥12,140.6 5595.83第60期¥12,111.7#DIV/0!¥0.0¥12,111.7 5583.33第61期¥12,082.7#DIV/0!¥0.0¥12,082.7 5570.83第62期¥12,053.8#DIV/0!¥0.0¥12,053.8 5558.33第63期¥12,024.9#DIV/0!¥0.0¥12,024.9 5545.83第64期¥11,995.9#DIV/0!¥0.0¥11,995.9 5533.33第65期¥11,967.0#DIV/0!¥0.0¥11,967.0 5520.83第66期¥11,938.1#DIV/0!¥0.0¥11,938.1 5508.33第67期¥11,909.1#DIV/0!¥0.0¥11,909.1 5495.83第68期¥11,880.2#DIV/0!¥0.0¥11,880.2 5483.33第69期¥11,851.3#DIV/0!¥0.0¥11,851.3 5470.83第70期¥11,822.3#DIV/0!¥0.0¥11,822.3 5458.33第71期¥11,793.4#DIV/0!¥0.0¥11,793.4 5445.83第72期¥11,764.5#DIV/0!¥0.0¥11,764.5 5433.33第73期¥11,735.6#DIV/0!¥0.0¥11,735.6 5420.83第74期¥11,706.6#DIV/0!¥0.0¥11,706.6 5408.33第75期¥11,677.7#DIV/0!¥0.0¥11,677.7 5395.83第76期¥11,648.8#DIV/0!¥0.0¥11,648.8 5383.33第77期¥11,619.8#DIV/0!¥0.0¥11,619.8 5370.83第78期¥11,590.9#DIV/0!¥0.0¥11,590.9 5358.33第79期¥11,562.0#DIV/0!¥0.0¥11,562.0 5345.83第80期¥11,533.0#DIV/0!¥0.0¥11,533.0 5333.33第81期¥11,504.1#DIV/0!¥0.0¥11,504.1 5320.83第82期¥11,475.2#DIV/0!¥0.0¥11,475.2 5308.33第83期¥11,446.2#DIV/0!¥0.0¥11,446.2 5295.83第84期¥11,417.3#DIV/0!¥0.0¥11,417.3 5283.33第85期¥11,388.4#DIV/0!¥0.0¥11,388.4 5270.83第86期¥11,359.4#DIV/0!¥0.0¥11,359.4 5258.33第87期¥11,330.5#DIV/0!¥0.0¥11,330.5 5245.83第88期¥11,301.6#DIV/0!¥0.0¥11,301.6 5233.33第89期¥11,272.6#DIV/0!¥0.0¥11,272.6 5220.83第90期¥11,243.7#DIV/0!¥0.0¥11,243.75195.83第92期¥11,185.8#DIV/0!¥0.0¥11,185.8 5183.33第93期¥11,156.9#DIV/0!¥0.0¥11,156.9 5170.83第94期¥11,128.0#DIV/0!¥0.0¥11,128.0 5158.33第95期¥11,099.1#DIV/0!¥0.0¥11,099.1 5145.83第96期¥11,070.1#DIV/0!¥0.0¥11,070.1 5133.33第97期¥11,041.2#DIV/0!¥0.0¥11,041.2 5120.83第98期¥11,012.3#DIV/0!¥0.0¥11,012.3 5108.33第99期¥10,983.3#DIV/0!¥0.0¥10,983.3 5095.83第100期¥10,954.4#DIV/0!¥0.0¥10,954.4 5083.33第101期¥10,925.5#DIV/0!¥0.0¥10,925.5 5070.83第102期¥10,896.5#DIV/0!¥0.0¥10,896.5 5058.33第103期¥10,867.6#DIV/0!¥0.0¥10,867.6 5045.83第104期¥10,838.7#DIV/0!¥0.0¥10,838.7 5033.33第105期¥10,809.7#DIV/0!¥0.0¥10,809.7 5020.83第106期¥10,780.8#DIV/0!¥0.0¥10,780.8 5008.33第107期¥10,751.9#DIV/0!¥0.0¥10,751.9 4995.83第108期¥10,722.9#DIV/0!¥0.0¥10,722.9 4983.33第109期¥10,694.0#DIV/0!¥0.0¥10,694.0 4970.83第110期¥10,665.1#DIV/0!¥0.0¥10,665.1 4958.33第111期¥10,636.1#DIV/0!¥0.0¥10,636.1 4945.83第112期¥10,607.2#DIV/0!¥0.0¥10,607.2 4933.33第113期¥10,578.3#DIV/0!¥0.0¥10,578.3 4920.83第114期¥10,549.3#DIV/0!¥0.0¥10,549.3 4908.33第115期¥10,520.4#DIV/0!¥0.0¥10,520.4 4895.83第116期¥10,491.5#DIV/0!¥0.0¥10,491.5 4883.33第117期¥10,462.6#DIV/0!¥0.0¥10,462.6 4870.83第118期¥10,433.6#DIV/0!¥0.0¥10,433.6 4858.33第119期¥10,404.7#DIV/0!¥0.0¥10,404.7 4845.83第120期¥10,375.8#DIV/0!¥0.0¥10,375.8 4833.33第121期¥10,346.8#DIV/0!¥0.0¥10,346.8 4820.83第122期¥10,317.9#DIV/0!¥0.0¥10,317.9 4808.33第123期¥10,289.0#DIV/0!¥0.0¥10,289.0 4795.83第124期¥10,260.0#DIV/0!¥0.0¥10,260.0 4783.33第125期¥10,231.1#DIV/0!¥0.0¥10,231.1 4770.83第126期¥10,202.2#DIV/0!¥0.0¥10,202.2 4758.33第127期¥10,173.2#DIV/0!¥0.0¥10,173.2 4745.83第128期¥10,144.3#DIV/0!¥0.0¥10,144.3 4733.33第129期¥10,115.4#DIV/0!¥0.0¥10,115.4 4720.83第130期¥10,086.4#DIV/0!¥0.0¥10,086.4 4708.33第131期¥10,057.5#DIV/0!¥0.0¥10,057.5 4695.83第132期¥10,028.6#DIV/0!¥0.0¥10,028.6 4683.33第133期¥9,999.6#DIV/0!¥0.0¥9,999.6 4670.83第134期¥9,970.7#DIV/0!¥0.0¥9,970.7 4658.33第135期¥9,941.8#DIV/0!¥0.0¥9,941.8 4645.83第136期¥9,912.8#DIV/0!¥0.0¥9,912.8 4633.33第137期¥9,883.9#DIV/0!¥0.0¥9,883.94620.83第138期¥9,855.0#DIV/0!¥0.0¥9,855.0 4608.33第139期¥9,826.0#DIV/0!¥0.0¥9,826.0 4595.83第140期¥9,797.1#DIV/0!¥0.0¥9,797.1 4583.33第141期¥9,768.2#DIV/0!¥0.0¥9,768.2 4570.83第142期¥9,739.3#DIV/0!¥0.0¥9,739.3 4558.33第143期¥9,710.3#DIV/0!¥0.0¥9,710.3 4545.83第144期¥9,681.4#DIV/0!¥0.0¥9,681.4 4533.33第145期¥9,652.5#DIV/0!¥0.0¥9,652.5 4520.83第146期¥9,623.5#DIV/0!¥0.0¥9,623.5 4508.33第147期¥9,594.6#DIV/0!¥0.0¥9,594.6 4495.83第148期¥9,565.7#DIV/0!¥0.0¥9,565.7 4483.33第149期¥9,536.7#DIV/0!¥0.0¥9,536.7 4470.83第150期¥9,507.8#DIV/0!¥0.0¥9,507.8 4458.33第151期¥9,478.9#DIV/0!¥0.0¥9,478.9 4445.83第152期¥9,449.9#DIV/0!¥0.0¥9,449.9 4433.33第153期¥9,421.0#DIV/0!¥0.0¥9,421.0 4420.83第154期¥9,392.1#DIV/0!¥0.0¥9,392.1 4408.33第155期¥9,363.1#DIV/0!¥0.0¥9,363.1 4395.83第156期¥9,334.2#DIV/0!¥0.0¥9,334.2 4383.33第157期¥9,305.3#DIV/0!¥0.0¥9,305.3 4370.83第158期¥9,276.3#DIV/0!¥0.0¥9,276.3 4358.33第159期¥9,247.4#DIV/0!¥0.0¥9,247.4 4345.83第160期¥9,218.5#DIV/0!¥0.0¥9,218.5 4333.33第161期¥9,189.5#DIV/0!¥0.0¥9,189.5 4320.83第162期¥9,160.6#DIV/0!¥0.0¥9,160.6 4308.33第163期¥9,131.7#DIV/0!¥0.0¥9,131.7 4295.83第164期¥9,102.8#DIV/0!¥0.0¥9,102.8 4283.33第165期¥9,073.8#DIV/0!¥0.0¥9,073.8 4270.83第166期¥9,044.9#DIV/0!¥0.0¥9,044.9 4258.33第167期¥9,016.0#DIV/0!¥0.0¥9,016.0 4245.83第168期¥8,987.0#DIV/0!¥0.0¥8,987.0 4233.33第169期¥8,958.1#DIV/0!¥0.0¥8,958.1 4220.83第170期¥8,929.2#DIV/0!¥0.0¥8,929.2 4208.33第171期¥8,900.2#DIV/0!¥0.0¥8,900.2 4195.83第172期¥8,871.3#DIV/0!¥0.0¥8,871.3 4183.33第173期¥8,842.4#DIV/0!¥0.0¥8,842.4 4170.83第174期¥8,813.4#DIV/0!¥0.0¥8,813.4 4158.33第175期¥8,784.5#DIV/0!¥0.0¥8,784.5 4145.83第176期¥8,755.6#DIV/0!¥0.0¥8,755.6 4133.33第177期¥8,726.6#DIV/0!¥0.0¥8,726.6 4120.83第178期¥8,697.7#DIV/0!¥0.0¥8,697.7 4108.33第179期¥8,668.8#DIV/0!¥0.0¥8,668.8 4095.83第180期¥8,639.8#DIV/0!¥0.0¥8,639.8 4083.33第181期¥8,610.9#DIV/0!¥0.0¥8,610.9 4070.83第182期¥8,582.0#DIV/0!¥0.0¥8,582.0 4058.33第183期¥8,553.0#DIV/0!¥0.0¥8,553.0 4045.83第184期¥8,524.1#DIV/0!¥0.0¥8,524.14033.33第185期¥8,495.2#DIV/0!¥0.0¥8,495.2 4020.83第186期¥8,466.3#DIV/0!¥0.0¥8,466.3 4008.33第187期¥8,437.3#DIV/0!¥0.0¥8,437.3 3995.83第188期¥8,408.4#DIV/0!¥0.0¥8,408.4 3983.33第189期¥8,379.5#DIV/0!¥0.0¥8,379.5 3970.83第190期¥8,350.5#DIV/0!¥0.0¥8,350.5 3958.33第191期¥8,321.6#DIV/0!¥0.0¥8,321.6 3945.83第192期¥8,292.7#DIV/0!¥0.0¥8,292.7 3933.33第193期¥8,263.7#DIV/0!¥0.0¥8,263.7 3920.83第194期¥8,234.8#DIV/0!¥0.0¥8,234.8 3908.33第195期¥8,205.9#DIV/0!¥0.0¥8,205.9 3895.83第196期¥8,176.9#DIV/0!¥0.0¥8,176.9 3883.33第197期¥8,148.0#DIV/0!¥0.0¥8,148.0 3870.83第198期¥8,119.1#DIV/0!¥0.0¥8,119.1 3858.33第199期¥8,090.1#DIV/0!¥0.0¥8,090.1 3845.83第200期¥8,061.2#DIV/0!¥0.0¥8,061.2 3833.33第201期¥8,032.3#DIV/0!¥0.0¥8,032.3 3820.83第202期¥8,003.3#DIV/0!¥0.0¥8,003.3 3808.33第203期¥7,974.4#DIV/0!¥0.0¥7,974.4 3795.83第204期¥7,945.5#DIV/0!¥0.0¥7,945.5 3783.33第205期¥7,916.5#DIV/0!¥0.0¥7,916.5 3770.83第206期¥7,887.6#DIV/0!¥0.0¥7,887.6 3758.33第207期¥7,858.7#DIV/0!¥0.0¥7,858.7 3745.83第208期¥7,829.8#DIV/0!¥0.0¥7,829.8 3733.33第209期¥7,800.8#DIV/0!¥0.0¥7,800.8 3720.83第210期¥7,771.9#DIV/0!¥0.0¥7,771.9 3708.33第211期¥7,743.0#DIV/0!¥0.0¥7,743.0 3695.83第212期¥7,714.0#DIV/0!¥0.0¥7,714.0 3683.33第213期¥7,685.1#DIV/0!¥0.0¥7,685.1 3670.83第214期¥7,656.2#DIV/0!¥0.0¥7,656.2 3658.33第215期¥7,627.2#DIV/0!¥0.0¥7,627.2 3645.83第216期¥7,598.3#DIV/0!¥0.0¥7,598.3 3633.33第217期¥7,569.4#DIV/0!¥0.0¥7,569.4 3620.83第218期¥7,540.4#DIV/0!¥0.0¥7,540.4 3608.33第219期¥7,511.5#DIV/0!¥0.0¥7,511.5 3595.83第220期¥7,482.6#DIV/0!¥0.0¥7,482.6 3583.33第221期¥7,453.6#DIV/0!¥0.0¥7,453.6 3570.83第222期¥7,424.7#DIV/0!¥0.0¥7,424.7 3558.33第223期¥7,395.8#DIV/0!¥0.0¥7,395.8 3545.83第224期¥7,366.8#DIV/0!¥0.0¥7,366.8 3533.33第225期¥7,337.9#DIV/0!¥0.0¥7,337.9 3520.83第226期¥7,309.0#DIV/0!¥0.0¥7,309.0 3508.33第227期¥7,280.0#DIV/0!¥0.0¥7,280.0 3495.83第228期¥7,251.1#DIV/0!¥0.0¥7,251.1 3483.33第229期¥7,222.2#DIV/0!¥0.0¥7,222.2 3470.83第230期¥7,193.3#DIV/0!¥0.0¥7,193.3 3458.33第231期¥7,164.3#DIV/0!¥0.0¥7,164.33445.83第232期¥7,135.4#DIV/0!¥0.0¥7,135.4 3433.33第233期¥7,106.5#DIV/0!¥0.0¥7,106.5 3420.83第234期¥7,077.5#DIV/0!¥0.0¥7,077.5 3408.33第235期¥7,048.6#DIV/0!¥0.0¥7,048.6 3395.83第236期¥7,019.7#DIV/0!¥0.0¥7,019.7 3383.33第237期¥6,990.7#DIV/0!¥0.0¥6,990.7 3370.83第238期¥6,961.8#DIV/0!¥0.0¥6,961.8 3358.33第239期¥6,932.9#DIV/0!¥0.0¥6,932.9 3345.83第240期¥6,903.9#DIV/0!¥0.0¥6,903.93541.666667。

数学模型-第06章(第五版)市公开课一等奖省赛课获奖PPT课件

数学模型-第06章(第五版)市公开课一等奖省赛课获奖PPT课件

零存整取 累计存入金额180,000元 计算器 到期本息总额196,012.50元
勤俭节约、科学理财
第5页
单利和复利 按单利计算业务——零存整取
a~每个月存入金额, r ~月利率, n ~ 存期 (x月k ~)存入k个月后本息 x1=a+ar x2= x1+a+a2r
xk= xk-1+a+akr, k＝2,3,…, n k=n递推至k=１ xn= na+ar(1+2+…+n) a =3000, r =0.035/12, n =125 (月) xn= 196,012.50
a=7485.2(元), A1=1796447.27(元) 与房贷计算器给出相同
第10页
等额本息贷款和等额本金贷款
例２ “房贷计算器”选择等额本金还款, 输入: 商业 贷款总额100万元, 期限20年, 年利率6.55%. 点击“开 始计算”得到: 还款总额1657729.17元, 每个月还款金 额由第１月9625元逐月递减, 最终１月为4189.41元. 建立等额本金还款方式数学模型, 并作数值计算.
比两阶段计划时间长，吸 收热量突减对身体不利.
75kg
c =1时
c =14000时
w(40)=75kg w(72)=75kg
第27页
7. 到达目标体重所需时间与每七天吸收热量关系
k=1递推至k=n
w(n 1) (1 )n w(1) c[1 (1 ) (1 )n1] (1 )n[w(1) c / ] c /
1)r, n
k 1,2,n
第12页Βιβλιοθήκη 额本金还款模型x0 ~贷款总额 r ~月利率 n ~贷款期限(月)
xk ~第k月还款金额