=-FV( 12.5%,5,0,-480000,0)
Combat vehicle
Returns the future value of an investment based on a fixed interest rate and equal installments.
grammar
FV (interest rate, nper, pmt, pv, type)
For more information about the parameters in function FV and annuity function, please refer to function PV.
Rate is the interest rate of each period.
Nper is the total investment period, that is, the total payment period of the investment.
Pmt is the amount payable in each period, and its 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 present value, that is, the amount recorded when calculating the investment, or the cumulative sum of the present values of a series of future payments, also known as the principal. If PV is omitted, its value is assumed to be zero, and the pmt parameter must be included.
Enter the number 0 or 1 to specify whether the payment time of each cycle is at the beginning or the end. If type is omitted, its value is assumed to be zero.
The interest rate here is 12.5%, nper is 5, pmt is zero if it doesn't increase in the middle, PV present value is -480000, and Type starts with 0.