- Picture and text skills
- Case
Returns the future value of an investment based on a fixed interest rate and equal installments.
Syntax
FV(rate,nper,pmt,pv,type)
rate is the interest rate of each period.
nper is the total investment (or loan) period , that is, the total number of payment periods for the investment (or loan).
pmt is the amount payable in each period , whose value remains unchanged throughout the annuity period.
Usually pmt includes principal and interest, but does not include other fees and taxes. If pmt is omitted, the pv parameter must be included.
pv is the current value, that is, from the item The amount of money that has been accounted for when an investment begins, or the cumulative sum of the current value of a series of future payments, also called principal.
If PV is omitted, its value is assumed to be zero, and the pmt parameter must be included.
type number 0 or 1 to specify Whether the payment of each period is at the beginning or end of the period.
Description
• The specified rate and nper units should be confirmed to be consistent. For example, the same four-year loan with an annual interest rate of 12%, If paid monthly, rate
Should be 12%/12, nper should be 4*12; if paid annually, rate should be 12%, nper should be 4.
• In all parameters, outgoing payments, such as bank deposits, are expressed as negative numbers; income payments, such as dividend income, are expressed as positive numbers.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-FV-han-shu-ji-suan-tou-zi-wei-lai-zhi.html
支付宝扫一扫 
评论列表（196条）
测试