Documentation/Calc Functions/AMORDEGRC

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

AMORDEGRC

Category:

Financial Analysis

Summary:

Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here.

Syntax:

AMORDEGRC(Cost; Date Purchased; First Period; Salvage; Period; Rate; Basis)

Returns:

Arguments:

Cost is the acquisition costs.

Date Purchased is the date of acquisition.

First Period is the end date of the first settlement period.

Salvage is the salvage value of the capital asset at the end of the depreciable life.

Period is the settlement period to be considered.

Rate is the rate of depreciation.

Basis (optional) is chosen from a list of options and indicates how the year is to be calculated.

Basis Calculation
0 or missing US method (NASD), 12 months of 30 days each
1 Exact number of days in months, exact number of days in year
2 Exact number of days in month, year has 360 days
3 Exact number of days in month, year has 365 days
4 European method, 12 months of 30 days each

Additional details:

Examples:

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: