Excel Financial Functions

Financial software Print Email

Introduction to Excel Financial Functions

The excel financial functions have been made available to execute a variety of financial calculations, including calculations of yield, investment valuations, interest rates, internal rate of return, asset depreciation, and payments. These financial functions can be, however, classified into different categories so as to enable you to stumble on the required function.

There are generally four interrelated quantities that include:

1. Present Value (PV) equivalent to the value of the load or savings today. This function is used to estimate the loan size that could be paid off provided a periodic payment over a provided total number of payments and a provided periodic interest rate.

2. Interest Rate per period (RATE) equivalent to the interest rate, generally monthly. This function is used to calculate the periodic interest rate required to pay off a provided present value with a provided periodic payment and a total number of payments.

3. Number of payment periods (NPER) equivalent to number of payment periods. This function is used to evaluate the total number of payment periods required to pay off a given present value with a provided payment and periodic interest rate.

4. Periodic payment (PMT) equivalent to the payment per period. This function is used for calculating the fixed periodic payment with a given present value, periodic interest rate, and the total number of payments.

If any three of the aforesaid quantities are provided, the fourth one can be calculated easily.

Excel Financial Functions List

A list of Excel Financial Functions is provided below for your reference:

  • Investment value functions including

1. FV

2. FVSCHEDULE

3. NPV

4. PV

5. RECEIVED

6. XNPV

  • Internal rate of return functions including

1. IRR

2. MIRR

3. XIRR

  • Asset depreciation functions including

1. AMORDEGRC

2. AMORLINC

3. DB

4. DDB

5. SLN

6. SYD

7. VDB

  • Payment functions including

1. CUMIPMT

2. CUMPRINC

3. IPMT

4. ISPMT

5. PMT

6. PPMT

  • Dollar conversion including

1. DOLLARDE

2. DOLLARFR

  • Yield functions including

1. YIELD

2. YIELDDISC

3. YIELDMAT

4. ODDFYIELD

5. ODDLYIELD

6. TBILLEO

7. TBILLYIELD

  • Price functions including

1. PRICE

2. PRICEDISC

3. PRICEMAT

4. ODDFPRICE

5. ODDLPRICE

6. TBILLPRICEĀ 

Quote Guest, 19 April, 2014
very useful thanks

Login to ReadyRatios

 

Have you forgotten your password?

Are you a new user?

Login As
You can log in if you are registered at one of these services: