AMORLINC

The AMORLINC function in Google Sheets returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.

Function Syntax and Parameters

Syntax: AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])

Parameters:

• cost: The initial cost of the asset.
• purchase_date: The date when the asset was purchased.
• first_period_end: The end date of the first period.
• salvage: The salvage value at the end of the asset's life.
• period: The number of periods to calculate depreciation.
• rate: The rate of depreciation.
• [basis]: [Optional] The day count basis to use.

Use Cases and Scenarios

1. Accounting: Calculate the prorated depreciation based on the purchase date and period.
2. Asset Management: Determine the depreciation amount for accounting purposes.
3. Financial Planning: Calculate the impact of depreciation on overall financial statements.

Related Functions

• ACCRINT: Calculates the accrued interest for a security with periodic interest payments.
• ACCRINTM: Calculates the accrued interest for a security that pays interest at maturity.

That's the .mdx content for the AMORLINC function.