List of Very Useful Excel Financial Functions

Microsoft Excel is a complete solution for Financial Problems because it provide you very useful list of Functions that can really work for you to make your Financial statements more effective and error free.

Today Financial expert, accountants and Professional use Microsoft Excel function for calculation of different financial values like yield, investment value, interest rates etc. It is not only easy to use these Financial Functions but its work very accurately to provide 100 % true and fair results.

As you know there are different kind of financial statements in same way financial functions are also different. For this you have to understand these functions with these categories.

Different Categories of Financial function

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

These are very useful Financial functions and I hope you find this productive for any kind of help kindly comments us.

List of Very Useful Excel Financial Functions