Microsoft Office Tutorials and References
In Depth Information
AMORLINC
turned on using the Add-Ins command from the Tools menu. Notice the example in Figure
6.3, where the depreciation on a machine cost of $36,234 with a 15% rate of depreciation is
$11,857. By using cell referencing instead of applying the dates in the formula, your formula
becomes more flexible.
The cost of the asset.
COST
The date the asset was purchased.
DATE_PURCHASED
The date at the end of the first period.
FIRST_PERIOD
The salvage value of the asset at the end of the asset life.
SALVAGE
The period of depreciation.
PERIOD
The rate of the asset depreciation.
RATE
The year basis to use.
BASIS
Figure 6.3
AMORDEGRC returns
the depreciation for
each accounting
period within the
formula.
A
A function built with
cell referencing
AMORLINC
AMORLINC returns the depreciation for each accounting period.
=AMORLINC(cost,date_purchased,first_period,salvage,period,rate,basis)
The AMORLINC 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 AMORLINC function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu. Notice the example in Figure 6.4. The
depreciation on the cost of the the $36,234 machine at the end of the first period is $5,435
with a 15% rate of depreciation. By using cell referencing instead of applying the dates in the
formula, your formula becomes more flexible.
The cost of the asset.
COST
The date the asset was purchased.
DATE_PURCHASED
The date at the end of the first period.
FIRST_PERIOD
Search JabSto ::




Custom Search