本人今年11月用公积金贷款13万,贷款20年(240期),请问现在每期本金,利息分别是多少?

[复制链接]
查看11 | 回复2 | 2011-11-28 05:10:17 | 显示全部楼层 |阅读模式
回复

使用道具 举报

千问 | 2011-11-28 05:10:17 | 显示全部楼层
要钱的联系用户名赞同
回复

使用道具 举报

千问 | 2011-11-28 05:10:17 | 显示全部楼层
如果采取本息等额还款法,本金、利息的比例每期都不一样的。初期几乎全部是利息,后期几乎全部是本金。按现在的利率4.9%计算,每月还款额是:850.78元=PMT(4.9%/12,20*12,130000,0,0)=-850.78期次应还本金应还利息1319.94530.832321.25529.533322.56528.224323.88526.905325.20525.586326.53524.257327.86522.918329.20521.589330.55520.2310331.90518.8811333.25517.5312334.61516.1713335.98514.8014337.35513.4315338.73512.0516340.11510.6717341.50509.2818342.89507.8819344.29506.4820345.70505.0821347.11503.6722348.53502.2523349.95500.8324351.38499.4025352.82497.9626354.26496.5227355.70495.0728357.16493.6229358.61492.1630360.08490.7031361.55489.2332363.02487.7533364.51486.2734366.00484.7835367.49483.2936368.99481.7937370.50480.2838372.01478.7739373.53477.2540375.05475.7241376.59474.1942378.12472.6543379.67471.1144381.22469.5645382.77468.0046384.34466.4447385.91464.8748387.48463.2949389.07461.7150390.65460.1251392.25458.5352393.85456.9353395.46455.3254397.07453.7055398.70452.0856400.32450.4557401.96448.8258403.60447.1859405.25445.5360406.90443.8861408.56442.2162410.23440.5563411.91438.8764413.59437.1965415.28435.5066416.97433.8067418.68432.1068420.39430.3969422.10428.6870423.83426.9571425.56425.2272427.29423.4873429.04421.7474430.79419.9975432.55418.2376434.32416.4677436.09414.6978437.87412.9179439.66411.1280441.45409.3281443.26407.5282445.07405.7183446.88403.8984448.71402.0785450.54400.2486452.38398.4087454.23396.5588456.08394.7089457.94392.8390459.81390.9691461.69389.0992463.58387.2093465.47385.3194467.37383.4195469.28381.5096471.20379.5897473.12377.6698475.05375.7399476.99373.79100478.94371.84101480.89369.88102482.86367.92103484.83365.95104486.81363.97105488.80361.98106490.79359.98107492.80357.98108494.81355.97109496.83353.95110498.86351.92111500.90349.88112502.94347.84113504.99345.78114507.06343.72115509.13341.65116511.21339.57117513.29337.48118515.39335.39119517.49333.28120519.61331.17121521.73329.05122523.86326.92123526.00324.78124528.15322.63125530.30320.47126532.47318.31127534.64316.13128536.83313.95129539.02311.76130541.22309.56131543.43307.35132545.65305.13133547.88302.90134550.11300.66135552.36298.42136554.61296.16137556.88293.90138559.15291.62139561.44289.34140563.73287.05141566.03284.75142568.34282.44143570.66280.11144572.99277.78145575.33275.44146577.68273.10147580.04270.74148582.41268.37149584.79265.99150587.18263.60151589.57261.20152591.98258.80153594.40256.38154596.82253.95155599.26251.52156601.71249.07157604.17246.61158606.63244.14159609.11241.67160611.60239.18161614.09236.68162616.60234.18163619.12231.66164621.65229.13165624.19226.59166626.74224.04167629.29221.48168631.86218.91169634.44216.33170637.03213.74171639.64211.14172642.25208.53173644.87205.91174647.50203.27175650.15200.63176652.80197.98177655.47195.31178658.14192.63179660.83189.95180663.53187.25181666.24184.54182668.96181.82183671.69179.09184674.43176.34185677.19173.59186679.95170.82187682.73168.05188685.52165.26189688.32162.46190691.13159.65191693.95156.83192696.78153.99193699.63151.15194702.49148.29195705.35145.42196708.23142.54197711.13139.65198714.03136.75199716.95133.83200719.87130.90201722.81127.96202725.76125.01203728.73122.05204731.70119.07205734.69116.09206737.69113.09207740.70110.07208743.73107.05209746.76104.01210749.81100.96211752.8897.90212755.9594.83213759.0491.74214762.1488.64215765.2585.53216768.3782.40217771.5179.27218774.6676.12219777.8272.95220781.0069.78221784.1966.59222787.3963.39223790.6160.17224793.8356.94225797.0853.70226800.3350.45227803.6047.18228806.8843.90229810.1740.60230813.4837.29231816.8033.97232820.1430.64233823.4927.29234826.8523.93235830.2320.55236833.6217.16237837.0213.76238840.4410.34239843.876.91240847.323.46赞同
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836