Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 15. Financial Functions

• ACCRINT()

• ACCRINTM()

• AMORDEGRC()

• AMORLINC()

• COUPDAYBS()

• COUPDAYS()

• COUPDAYSNC()

• COUPNCD()

• COUPNUM()

• COUPPCD()

• CUMIPMT()

• CUMPRINC()

• DB()

• DDB()

• DISC()

• DOLLARDE()

• DOLLARFR()

• DURATION()

• EFFECT()

• FV()

• FVSCHEDULE()

• INTRATE()

• IPMT()

• IRR()

• ISPMT()

• MDURATION()

• MIRR()

• NOMINAL()

• NPER()

• NPV()

• ODDFPRICE()

• ODDFYIELD()

• ODDLPRICE()

• ODDLYIELD()

• PMT()

• PPMT()

• PRICE()

• PRICEDISC()

• PRICEMAT()

• PV()

• RATE()

• RECEIVED()

• SLN()

• SYD()

• TBILLEQ()

• TBILLPRICE()

• TBILLYIELD()

• VDB()

• XIRR()

• XNPV()

• YIELD()

• YIELDDISC()

• YIELDMAT()

The basic financial calculations in Microsoft Excel can be divided into the following areas:

• Simple interest calculation. Simple interest calculation is characterized by the fact that the interest is not added to the capital at the due date. This kind of calculation is mostly used ...