Talk:Documentation/Calc Functions/AMORLINC

SF Comments

 * (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.

--Stevefanning (talk) 2020-11-12T19:51:12 (UTC)