Talk:Documentation/Calc Functions/AMORLINC

    From The Document Foundation Wiki

    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)