Current location - Loan Platform Complete Network - Loan consultation - The loan is 480,000 yuan, the loan term is 5 years and the annual interest rate is 12.5%. Which financial function in EXCEL should be used to request the total repayment amount due within five years?
The loan is 480,000 yuan, the loan term is 5 years and the annual interest rate is 12.5%. Which financial function in EXCEL should be used to request the total repayment amount due within five years?
The financial function FV can be used.

=-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.