answersLogoWhite

0

The RATE function returns the interest rate per period of a loan or an investment. It has the following syntax.

RATE(nper, pmt, pv, [fv], [type], [guess])

The RATE function syntax has the following arguments:

Nper Required. The total number of payment periods in an annuity.

Pmt Required. The payment made each period and cannot change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. If pmt is omitted, you must include the fv argument.

Pv Required. The present value - the total amount that a series of future payments is worth now.

Fv Optional. The future value, or a cash balance you want 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).

Type Optional. The number 0 or 1 and indicates when payments are due.

Set type equal to zero or leave blank if payments are due at the end of the period or 1 if they are due at the beginning of the period.

Guess Optional. Your guess for what the rate will be.

If you omit guess, it is assumed to be 10 percent.

If RATE does not converge, try different values for guess. RATE usually converges if guess is between 0 and 1.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How do I calculate compound average growth rate using excel?

use the rate function


What function in excel takes rate payment and loan amount and outputs a monthly loan payment amount?

The PMT function in Excel outputs a monthly loan payment amount.


Function takes rate payment and loan amount and outputs a monthly loan payment amount in excel?

The PMT function in Excel outputs a monthly loan payment amount.


Which function of Excel does not work with 3D formulas?

There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


What is NPER in Excel?

NPER is a financial function in Excel. It returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.


What interest rate should be applied to the PMT function in Excel?

There is no single answer to that. It will depend on the calculation you are trying to do. You could use whatever rate is appropriate. The function can use any rate, so that will be based on the particular situation you are working on and what interest rate is specified.


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


A formula prewritten by excel is called?

Function


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


What is the function of percentage in micro-soft Excel?

functions of excel