Page 403 - Excel 2013 All-in-One For Dummies

Analysis ToolPak Financial Functions 385
I used the same basic procedure to create the formulas using the DB and DDB depreciation methods in the cell ranges D8:D17 and E8:E17, respec- tively. Cell D8 contains the following DB formula:
=D7-DB($C$3,$C$5,$C$4,$A8)
Cell E8 contains the following DDB formula:
=E7-DDB($C$3,$C$5,$C$4,$A8)
Note that, like the SYD function, both of these depreciation functions require the use of a period argument, which is supplied by the list of years in the cell range A8:A17. Note also that the value in cell C4, which supplies the life argu- ment to the SYD, DB, and DDB functions, matches the year units used in this cell range.
Analysis ToolPak Financial Functions
By activating the Analysis ToolPak add-in (see Book I, Chapter 2), you add
a whole bunch of powerful financial functions to the Financial button’s drop-down menu on the Formulas tab of the Ribbon. Table 4-1 shows all the financial functions that are added to the Insert Function dialog box when the Analysis ToolPak is activated. As you can see from this table, the Analysis ToolPak financial functions are varied and quite sophisticated.
Table 4-1 Financial Functions in the Analysis ToolPak
Function
ACCRINT(issue,first_interest, settlement,rate,[par],frequency, [basis],[calc_methd])
ACCRINTM(issue,maturity,rate, [par],[basis])
AMORDEGRC(cost,date_ purchased,first_period,salvage,perio d,rate,[basis]) and AMORLINC(cost, date_purchased,first_period,salvage ,period,rate,[basis])
COUPDAYBS(settlement,maturity, frequency,[basis])
What It Calculates
Calculates the accrued interest for a security that pays periodic interest.
Calculates the accrued interest for a security that pays interest at maturity.
Used in French accounting systems for calculating depreciation. AMORDEGRC and AMORLINC return the depre- ciation for each accounting period. AMORDEGRC works like AMORLINC except that it applies a deprecia-
tion coefficient in the calculation that depends upon the life of the assets.
Calculates the number of days from the beginning of a coupon period to the settlement date.
(continued)
Book III Chapter 4
Financial Formulas