FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -It is also termed as the principal of a loan. Fv (optional argument) – This is the future value or a cash balance we want to attain after the last payment is made. If Fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Detailed explanation-2: -FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. Use the Excel Formula Coach to find the future value of a series of payments.

Detailed explanation-3: -What Is Future Value? Future value (FV) is a financial concept that assigns a value to an asset based on estimated variables such as future interest rates or cashflows. It may be useful for an investor to know how much their investment may be in five years given an expected rate of return.

Detailed explanation-4: -In the PMT function, to what does the Nper argument refer? the number of payments that will be made.

Detailed explanation-5: -This argument can be defined with either a 1 or a 0. The number 1 is used if payments are made at the beginning of each period. A 0 is used if payments are made at the end of each period.