如何用excel制作复利终值系数表 excel已知终值求现值用哪个公式？

如何用excel制作复利终值系数表

excel已知终值求现值用哪个公式？

excel已知终值求现值用哪个公式？

复利现值公式，即:PF(1 i)^n。F终值，P现值，i利率或折现率，N计息期数。

复利系数表怎么来的？

复利现值的计算公式是PF/(1 i)n。其中：P为现值、F为终值、i为利率、n为期限。

计算方法

复利的现值是指付款的价值。例如，如果年利率为10%，从第一年到第三年，每年年底1元的价值计算如下：

一年后1元现值1/（1 10%）0.909（人民币）

2年后，现值11/（1 10%）（1 10%）0.83（人民币）

3年后，现值11/（1 10%）（1 10%）（1 10%）0.751（人民币）

复利现值的计算公式为：Pf*1/（1 I）^n，其中1/（1 I）^n为复利现值系数，记录为（P/F，I，n），其中I是利率（贴现率），N是年数，根据这两个条件，可以得到具体的复利现值系数。

或：Ps×（110 I）-n

（10I）-N是将最终值换算成现值的系数，称为复利现值系数，或1元复利现值，用符号（P/s，I，N）表示，例如，（P/s，10%，5）是利率为10%时5个期间复利的现值系数。

复利现值表完整版？

复利现值系数表完整版

此复利现值系数表由本站精心制作，保留了四小数，已经过四舍五入处理。利率由1%-30%，期次由1期-50期。

期次t1%t2%t3%t4%t5%t6%

1期t0.9901t0.9804t0.9709t0.9615t0.9524t0.9434

2期t0.9803t0.9612t0.9426t0.9246t0.9070t0.8900

3期t0.9706t0.9423t0.9151t0.8890t0.8638t0.8396

4期t0.9610t0.9238t0.8885t0.8548t0.8227t0.7921

5期t0.9515t0.9057t0.8626t0.8219t0.7835t0.7473

6期t0.9420t0.8880t0.8375t0.7903t0.7462t0.7050

7期t0.9327t0.8706t0.8131t0.7599t0.7107t0.6651

8期t0.9235t0.8535t0.7894t0.7307t0.6768t0.6274

9期t0.9143t0.8368t0.7664t0.7026t0.6446t0.5919

10期t0.9053t0.8203t0.7441t0.6756t0.6139t0.5584

11期t0.8963t0.8043t0.7224t0.6496t0.5847t0.5268

12期t0.8874t0.7885t0.7014t0.6246t0.5568t0.4970

13期t0.8787t0.7730t0.6810t0.6006t0.5303t0.4688

14期t0.8700t0.7579t0.6611t0.5775t0.5051t0.4423

15期t0.8613t0.7430t0.6419t0.5553t0.4810t0.4173

16期t0.8528t0.7284t0.6232t0.5339t0.4581t0.3936

17期t0.8444t0.7142t0.6050t0.5134t0.4363t0.3714

18期t0.8360t0.7002t0.5874t0.4936t0.4155t0.3503

19期t0.8277t0.6864t0.5703t0.4746t0.3957t0.3305

20期t0.8195t0.6730t0.5537t0.4564t0.3769t0.3118

21期t0.8114t0.6598t0.5375t0.4388t0.3589t0.2942

22期t0.8034t0.6468t0.5219t0.4220t0.3418t0.2775

23期t0.7954t0.6342t0.5067t0.4057t0.3256t0.2618

24期t0.7876t0.6217t0.4919t0.3901t0.3101t0.2470

25期t0.7798t0.6095t0.4776t0.3751t0.2953t0.2330

26期t0.7720t0.5976t0.4637t0.3607t0.2812t0.2198

27期t0.7644t0.5859t0.4502t0.3468t0.2678t0.2074

28期t0.7568t0.5744t0.4371t0.3335t0.2551t0.1956

29期t0.7493t0.5631t0.4243t0.3207t0.2429t0.1846

30期t0.7419t0.5521t0.4120t0.3083t0.2314t0.1741

40期t0.6717t0.4529t0.3066t0.2083t0.1420t0.0972

50期t0.6080t0.3715t0.2281t0.1407t0.0872t0.0543

期次t7%t8%t9%t10%t11%t12%

1期t0.9346t0.9259t0.9174t0.9091t0.9009t0.8929

2期t0.8734t0.8573t0.8417t0.8264t0.8116t0.7972

3期t0.8163t0.7938t0.7722t0.7513t0.7312t0.7118

4期t0.7629t0.7350t0.7084t0.6830t0.6587t0.6355

5期t0.7130t0.6806t0.6499t0.6209t0.5935t0.5674

6期t0.6663t0.6302t0.5963t0.5645t0.5346t0.5066

7期t0.6227t0.5835t0.5470t0.5132t0.4817t0.4523

8期t0.5820t0.5403t0.5019t0.4665t0.4339t0.4039

9期t0.5439t0.5002t0.4604t0.4241t0.3909t0.3606

10期t0.5083t0.4632t0.4224t0.3855t0.3522t0.3220

11期t0.4751t0.4289t0.3875t0.3505t0.3173t0.2875

12期t0.4440t0.3971t0.3555t0.3186t0.2858t0.2567

13期t0.4150t0.3677t0.3262t0.2897t0.2575t0.2292

14期t0.3878t0.3405t0.2992t0.2633t0.2320t0.2046

15期t0.3624t0.3152t0.2745t0.2394t0.2090t0.1827

16期t0.3387t0.2919t0.2519t0.2176t0.1883t0.1631

17期t0.3166t0.2703t0.2311t0.1978t0.1696t0.1456

18期t0.2959t0.2502t0.2120t0.1799t0.1528t0.1300

19期t0.2765t0.2317t0.1945t0.1635t0.1377t0.1161

20期t0.2584t0.2145t0.1784t0.1486t0.1240t0.1037

21期t0.2415t0.1987t0.1637t0.1351t0.1117t0.0926

22期t0.2257t0.1839t0.1502t0.1228t0.1007t0.0826

23期t0.2109t0.1703t0.1378t0.1117t0.0907t0.0738

24期t0.1971t0.1577t0.1264t0.1015t0.0817t0.0659

25期t0.1842t0.1460t0.1160t0.0923t0.0736t0.0588

26期t0.1722t0.1352t0.1064t0.0839t0.0663t0.0525

27期t0.1609t0.1252t0.0976t0.0763t0.0597t0.0469

28期t0.1504t0.1159t0.0895t0.0693t0.0538t0.0419

29期t0.1406t0.1073t0.0822t0.0630t0.0485t0.0374

30期t0.1314t0.0994t0.0754t0.0573t0.0437t0.0334

40期t0.0668t0.0460t0.0318t0.0221t0.0154t0.0107

50期t0.0339t0.0213t0.0134t0.0085t0.0054t0.0035

期次t13%t14%t15%t16%t17%t18%

1期t0.8850t0.8772t0.8696t0.8621t0.8547t0.8475

2期t0.7831t0.7695t0.7561t0.7432t0.7305t0.7182

3期t0.6931t0.6750t0.6575t0.6407t0.6244t0.6086

4期t0.6133t0.5921t0.5718t0.5523t0.5337t0.5158

5期t0.5428t0.5194t0.4972t0.4761t0.4561t0.4371

6期t0.4803t0.4556t0.4323t0.4104t0.3898t0.3704

7期t0.4251t0.3996t0.3759t0.3538t0.3332t0.3139

8期t0.3762t0.3506t0.3269t0.3050t0.2848t0.2660

9期t0.3329t0.3075t0.2843t0.2630t0.2434t0.2255

10期t0.2946t0.2697t0.2472t0.2267t0.2080t0.1911

11期t0.2607t0.2366t0.2149t0.1954t0.1778t0.1619

12期t0.2307t0.2076t0.1869t0.1685t0.1520t0.1372

13期t0.2042t0.1821t0.1625t0.1452t0.1299t0.1163

14期t0.1807t0.1597t0.1413t0.1252t0.1110t0.0985

15期t0.1599t0.1401t0.1229t0.1079t0.0949t0.0835

16期t0.1415t0.1229t0.1069t0.0930t0.0811t0.0708

17期t0.1252t0.1078t0.0929t0.0802t0.0693t0.0600

18期t0.1108t0.0946t0.0808t0.0691t0.0592t0.0508

19期t0.0981t0.0829t0.0703t0.0596t0.0506t0.0431

20期t0.0868t0.0728t0.0611t0.0514t0.0433t0.0365

21期t0.0768t0.0638t0.0531t0.0443t0.0370t0.0309

22期t0.0680t0.0560t0.0462t0.0382t0.0316t0.0262

23期t0.0601t0.0491t0.0402t0.0329t0.0270t0.0222

24期t0.0532t0.0431t0.0349t0.0284t0.0231t0.0188

25期t0.0471t0.0378t0.0304t0.0245t0.0197t0.0160

26期t0.0417t0.0331t0.0264t0.0211t0.0169t0.0135

27期t0.0369t0.0291t0.0230t0.0182t0.0144t0.0115

28期t0.0326t0.0255t0.0200t0.0157t0.0123t0.0097

29期t0.0289t0.0224t0.0174t0.0135t0.0105t0.0082

30期t0.0256t0.0196t0.0151t0.0116t0.0090t0.0070

40期t0.0075t0.0053t0.0037t0.0026t0.0019t0.0013

50期t0.0022t0.0014t0.0009t0.0006t0.0004t0.0003

期次t19%t20%t21%t22%t23%t24%

1期t0.8403t0.8333t0.8264t0.8197t0.8130t0.8065

2期t0.7062t0.6944t0.6830t0.6719t0.6610t0.6504

3期t0.5934t0.5787t0.5645t0.5507t0.5374t0.5245

4期t0.4987t0.4823t0.4665t0.4514t0.4369t0.4230

5期t0.4190t0.4019t0.3855t0.3700t0.3552t0.3411

6期t0.3521t0.3349t0.3186t0.3033t0.2888t0.2751

7期t0.2959t0.2791t0.2633t0.2486t0.2348t0.2218

8期t0.2487t0.2326t0.2176t0.2038t0.1909t0.1789

9期t0.2090t0.1938t0.1799t0.1670t0.1552t0.1443

10期t0.1756t0.1615t0.1486t0.1369t0.1262t0.1164

11期t0.1476t0.1346t0.1228t0.1122t0.1026t0.0938

12期t0.1240t0.1122t0.1015t0.0920t0.0834t0.0757

13期t0.1042t0.0935t0.0839t0.0754t0.0678t0.0610

14期t0.0876t0.0779t0.0693t0.0618t0.0551t0.0492

15期t0.0736t0.0649t0.0573t0.0507t0.0448t0.0397

16期t0.0618t0.0541t0.0474t0.0415t0.0364t0.0320

17期t0.0520t0.0451t0.0391t0.0340t0.0296t0.0258

18期t0.0437t0.0376t0.0323t0.0279t0.0241t0.0208

19期t0.0367t0.0313t0.0267t0.0229t0.0196t0.0168

20期t0.0308t0.0261t0.0221t0.0187t0.0159t0.0135

21期t0.0259t0.0217t0.0183t0.0154t0.0129t0.0109

22期t0.0218t0.0181t0.0151t0.0126t0.0105t0.0088

23期t0.0183t0.0151t0.0125t0.0103t0.0086t0.0071

24期t0.0154t0.0126t0.0103t0.0085t0.0070t0.0057

25期t0.0129t0.0105t0.0085t0.0069t0.0057t0.0046

26期t0.0109t0.0087t0.0070t0.0057t0.0046t0.0037

27期t0.0091t0.0073t0.0058t0.0047t0.0037t0.0030

28期t0.0077t0.0061t0.0048t0.0038t0.0030t0.0024

29期t0.0064t0.0051t0.0040t0.0031t0.0025t0.0020

30期t0.0054t0.0042t0.0033t0.0026t0.0020t0.0016

40期t0.0010t0.0007t0.0005t0.0004t0.0003t0.0002

50期t0.0002t0.0001t0.0001t0t0t0

期次t25%t26%t27%t28%t29%t30%

1期t0.8000t0.7937t0.7874t0.7813t0.7752t0.7692

2期t0.6400t0.6299t0.6200t0.6104t0.6009t0.5917

3期t0.5120t0.4999t0.4882t0.4768t0.4658t0.4552

4期t0.4096t0.3968t0.3844t0.3725t0.3611t0.3501

5期t0.3277t0.3149t0.3027t0.2910t0.2799t0.2693

6期t0.2621t0.2499t0.2383t0.2274t0.2170t0.2072

7期t0.2097t0.1983t0.1877t0.1776t0.1682t0.1594

8期t0.1678t0.1574t0.1478t0.1388t0.1304t0.1226

9期t0.1342t0.1249t0.1164t0.1084t0.1011t0.0943

10期t0.1074t0.0992t0.0916t0.0847t0.0784t0.0725

11期t0.0859t0.0787t0.0721t0.0662t0.0607t0.0558

12期t0.0687t0.0625t0.0568t0.0517t0.0471t0.0429

13期t0.0550t0.0496t0.0447t0.0404t0.0365t0.0330

14期t0.0440t0.0393t0.0352t0.0316t0.0283t0.0254

15期t0.0352t0.0312t0.0277t0.0247t0.0219t0.0195

16期t0.0281t0.0248t0.0218t0.0193t0.0170t0.0150

17期t0.0225t0.0197t0.0172t0.0150t0.0132t0.0116

18期t0.0180t0.0156t0.0135t0.0118t0.0102t0.0089

19期t0.0144t0.0124t0.0107t0.0092t0.0079t0.0068

20期t0.0115t0.0098t0.0084t0.0072t0.0061t0.0053

21期t0.0092t0.0078t0.0066t0.0056t0.0048t0.0040

22期t0.0074t0.0062t0.0052t0.0044t0.0037t0.0031

23期t0.0059t0.0049t0.0041t0.0034t0.0029t0.0024

24期t0.0047t0.0039t0.0032t0.0027t0.0022t0.0018

25期t0.0038t0.0031t0.0025t0.0021t0.0017t0.0014

26期t0.0030t0.0025t0.0020t0.0016t0.0013t0.0011

27期t0.0024t0.0019t0.0016t0.0013t0.0010t0.0008

28期t0.0019t0.0015t0.0012t0.0010t0.0008t0.0006

29期t0.0015t0.0012t0.0010t0.0008t0.0006t0.0005

30期t0.0012t0.0010t0.0008t0.0006t0.0005t0.0004

40期t0.0001

分享到：