From The Document Foundation Wiki
- (1) General. Would it be worth adding a link to Wikipedia’s Amortization page?
- (2) Syntax. Suggest replacing with the following – “Calculates the amortization value using linear depreciation.”. I think the sense of the second sentence should be covered in the Additional details section, as it will be for AMORDEGRC. Also, I do not feel that the note box is important, and it should be deleted.
- (3) Arguments, Cost. Change “costs” to “cost”.
- (4) Arguments, FirstPeriod. Change “settlement” to “depreciation”.
- (5) Arguments, Salvage. Delete “capital”.
- (6) Arguments, Period. Change to reflect that this should be a non-negative integer. The value of 0 represents the period from the purchase date to the end of the first period. A value of 1 is the next year, and so on. Probably need to add a comment that real values are truncated.
- (7) Arguments, Rate. Mention that it can be specified as a percentage.
- (8) Arguments, Basis. I would include a link to Wikipedia’s “Day count convention” page.
- (9) Arguments, 1st bullet. Suggest the following re-word for better grammar – “If either of DatePurchased or FirstPeriod are not valid dates then the function returns a value (#VALUE!) error.”. However, may be worth mentioning that dates are essentially just numbers (search for "date and time functions" in the Help).
- (10) Arguments, 2nd bullet. Suggest the following re-word for better grammar – “If either Rate or Cost is less than or equal to 0 then the function will return an error value”.
- (11) Arguments, 3rd bullet. Suggest the following re-word for better grammar – “If either Salvage or Period is less than 0 then the function will return an error value.”.
- (12) Arguments, 4th bullet. Insert “the” before “DatePurchased”.
- (13) Arguments, 6th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.
- (14) Additional details. Please explain that if the asset was purchased in the middle of the period, the depreciation is factored accordingly.
- (15) Additional details. The information presented here (and in the ODF) is possibly correct but the order of presentation confused me. The facts are that for Period = 0, AMORLINC is as stated. For subsequent FULL periods AMORLINC = Cost * Rate. For the period immediately after the last full one, which may be a partial period, AMORLINC = Cost – Salvage – AccumulatedDepreciation, where AccumulatedDepreciation is the sum of the deprecation in all preceding periods. For later periods, which are beyond the depreciated life of the asset, AMORLINC=0. These periods are those greater than t, where t = (Cost – Salvage) / (Cost * Rate)
- (16) Examples, all examples. Delete “settlement”.
- (17) Examples, 3rd example. This example is incorrect. The value of 0 is returned because the asset depreciates rapidly because of the high Rate. Try Period = 0 or 1 to better see what is going on - you should get a non-zero return for both those values.
- (17) Examples, general. Maybe include some examples which use the DATE function, enter dates as numbers and use the % format for the Rate argument.