Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

Spreadsheet 10% annual interest rate and installments are made the monthly payments, then the interest rate per month is 10%/12, or 0.83%. The value for rate into the function will be 10%/12, or 0.83%, or 0.0083. Nper   is the total number of payment periods in an annuity. For example, if this loan is a four-year car loan and makes monthly payments, then loan has 4*12 (or 48) periods. The value for nper will be 48. Pmt   is the payment made each period and cannot be change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. For example, the monthly payments on an Rs.10, 000, for four-year car loan at 12 per cent are Rs. 263.33. We have to enter -263.33 into the function as the pmt. If pmt is omitted, then fv must be included in the argument. Fv   is the future value, or a cash balance to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). For example, if we want to save Rs. 50,000 to pay for a special project in 18 years, then Rs. 50,000 is the future value. Then it is necessary to guess an interest rate and determine how much to save each month. If fv is omitted, then pmt must be included as the argument. Type   is the number 0 or 1 and indicates when payments are due. The fv and type arguments are optional. The fv argument is the future value or cash balance that we want to have after making last payment. If we omit the fv argument, Excel assumes a future value of zero. The type argument indicates whether the payment is made at the beginning or end of the period: (0 or omit the type argument when the payment is made at the end of the period and use 1 when it is made at the beginning of the period). When using financial functions, keep in mind that the fv, pv, and pmt arguments can be positive or negative, depending on whether we are receiving the money or paying out the money. It may be noted that if we want to express the rate argument in the same units as the nper argument, so that if we make monthly payments on a loan and we express the nper as the total number of monthly payments, as in 360 (30×12) for a 30-year mortgage, we need to express the annual interest rate in monthly terms as well. Excel solves for one financial argument in terms of the others. If rate is not 0, then: nper If rate is 0, then: pv* (1+rate) + pmt(1+rate* type)* nper (pmt * nper) + pv + fv = 0 (1+rate) −1 + fv = C  rate    43 Reprint 2026-27