Microsoft Office Tutorials and References
In Depth Information
ACCRINTM
ACCRINTM
ACCRINTM returns accrued interest for securities that pay interest at the maturity date.
=ACCRINTM(issue,maturity,rate,par,basis)
The ACCRINTM function is found only if the Analysis Toolpak is installed. In addition, it must be
turned on in the Add-Ins command from the Tools menu. Notice the example in Figure 6.2. The
example is setup with cell referencing so that you can make adjustments to dates, percentages,
par values, and so on. By using cell referencing instead of applying the dates in the formula,
your formula becomes more flexible.
The date of the security issue.
ISSUE
The date the security matures.
MATURITY
The securities annual coupon rate.
RATE
The securities par value. If you omit par, ACCRINT uses the default of $1,000.
PAR
The day count basis to use. If omitted, the function uses 0. See Figure 6.2
for a list of choices.
BASIS
The ACCRINTM formula can be calculated with:
Figure 6.2
The ACCRINTM
function returns the
accrued interest for
the security that pays
interest at maturity.
A
Another function
built with cell
referencing
AMORDEGRC
AMORDEGRC returns the depreciation for each accounting period within the formula.
=AMORDEGRC(cost,date_purchased,first_period,salvage,period,rate,basis)
The AMORDEGRC function is provided for the French accounting system. If an asset is
purchased within the middle of the accounting period, the prorated depreciation is taken into
account. The AMORDEGRC function is found only if the Analysis Toolpak is installed. It must be
Search JabSto ::




Custom Search