Definition. This function returns the capital value for a series of not-necessarily periodic surpluses (as the difference between deposits and disbursements) in the intra-annual scope.
Rate (required) The annual interest rate for the calculation. This can be a balance interest rate, an interest rate on a current account, or a market interest rate—whatever best defines the initial situation.
Values (required) The (actual and/or expected) surpluses from disbursements and deposits, arranged without gaps in a column. Each value stands for a date. Negative surpluses have a minus sign.
Dates (required) The dates for the surpluses. The order must correspond to the payments in the Values argument. The first ...