Microsoft Office Tutorials and References
In Depth Information
ACCRINTM returns accrued interest for securities that pay interest at the maturity date.
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.
The date the security matures.
The securities annual coupon rate.
The securities par value. If you omit par, ACCRINT uses the default of $1,000.
The day count basis to use. If omitted, the function uses 0. See Figure 6.2
for a list of choices.
The ACCRINTM formula can be calculated with:
function returns the
accrued interest for
the security that pays
interest at maturity.
built with cell
AMORDEGRC returns the depreciation for each accounting period within the formula.
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