Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" that apparently is the correct name.

      Add formula as given at http://wiki.services.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SYD_function

      To calculate depreciation, SYD adds the year numbers during the asset's life; the year numbers taken backward and divided by that sum give the proportion of the total loss of value to assign to depreciation that year.

      SYD = (originalcost - salvagevalue) * (lifetime+1 - year) * 2 / ((lifetime+1) * lifetime)

      Show
      Change "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" that apparently is the correct name. Add formula as given at http://wiki.services.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_SYD_function To calculate depreciation, SYD adds the year numbers during the asset's life; the year numbers taken backward and divided by that sum give the proportion of the total loss of value to assign to depreciation that year. SYD = (originalcost - salvagevalue) * (lifetime+1 - year) * 2 / ((lifetime+1) * lifetime)
    • Resolution:
      Hide

      Changed "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" in both, Summary and Semantics.

      Added math formula
      SYD =

      {(Cost - Salvage) cdot (LifeTime+1 - Period) cdot 2}

      over

      {(LifeTime+1) cdot LifeTime}
      Show
      Changed "sum-of-years' digits method" to "Sum-of-the-Years'-Digits method" in both, Summary and Semantics. Added math formula SYD = {(Cost - Salvage) cdot (LifeTime+1 - Period) cdot 2} over {(LifeTime+1) cdot LifeTime}

      Description

      Broken out from OFFICE-916

      SYD

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              erack Eike Rathke (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: