Go: How to use the FV function in an Excel table

Ext.: http://zhidao.baidu.com/link?url=lKFCYBW-zMC-pp8GkFXZnmwQf3YL_ Csylgo-0v2oaasszwjw40qrgeo0v8s2y3zcjte0z9ppl2arfanndkxm_lpmxtoibvleqn_cn2vrkhi

How to analyze the single-variable problem by using the simulation table in the worksheet, and use the FV function to calculate the function of "final deposit amount" through the change of "monthly deposit amount". Ask for detailed answers, thank you!!!

Syntax: PV (Rate,nper,pmt,fv,type).



Parameters: Rate is the deposit interest; NPer is the total deposit time, which is 3*12=36 months for three-year 0 deposit-taking deposits; PMT is the monthly deposit amount, and if PMT is omitted, the formula must contain parameters FV;FV the total amount of cash you wish to receive after the last deposit, If FV is omitted, the formula must contain the PMT parameter; Type is a number 0 or 1, which specifies whether the deposit time is at the beginning of the month or the end of the month.



Application Example: Installment yield function PV



If you deposit $500 in cash to the bank at the beginning of each month, 2.15% (monthly interest, i.e. monthly 2.15%/12). If you want to know what the total deposit is after 5 years, you can use the formula "=FV (2.15%/12,60,-500,0,1)" to calculate the result as ￥31,698.67.



The 2.15%/12 in the formula is monthly; 60 is the total payment time, in the case of monthly savings, the sum of the savings months;-500 is the amount of the monthly savings (-indicating expenditure); 0 indicates the amount on the account at the beginning of the deposit, or 0 if there is no penny on the account, otherwise the base amount should be entered  1 indicates whether the deposit time is at the beginning of the month or the end of the month, 1 at the beginning of 0 or ignored. Pick someone else's, hehe

Go: How to use the FV function in an Excel table