Syntax
=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])Arguments
| Argument | Required | Description |
|---|---|---|
cost | Required | The cost of the asset |
date_purchased | Required | The purchase date |
first_period | Required | The end date of the first period |
salvage | Required | The value at the end of its life |
period | Required | The period |
rate | Required | The depreciation rate |
basis | Optional | The day count basis (0, 1, 3 or 4) |
How to use AMORLINC
AMORLINC takes 6 required arguments and 1 optional argument. Type =AMORLINC( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 1)Result Related financial functions
- ACCRINTReturns the interest accrued on a security that pays periodic interest.
- ACCRINTMReturns the interest accrued on a security that pays interest at maturity.
- AMORDEGRCReturns the depreciation of an asset for an accounting period with the French declining balance system.
- COUPDAYBSReturns the days from the start of the coupon period to the settlement date.
- COUPDAYSReturns the number of days in the coupon period that contains the settlement date.
- COUPDAYSNCReturns the days from the settlement date to the next coupon date.
- COUPNCDReturns the next coupon date after the settlement date.
- COUPNUMReturns the number of coupons payable between the settlement date and maturity.
- COUPPCDReturns the coupon date on or before the settlement date.