Asset Data Compilation

Consider these details about asset data compilation:

• When compiling Asset Report data, only Depreciable Asset records that meet these conditions are retrieved:

  • Municipal is assigned to the Subsidiary selected from Report Request.

  • Legal Year of Acquisition <= (Reporting Year - 1)

  • Legal Year of Retirement is empty OR Legal Year of Retirement >= (Reporting Year - 2)

• When compiling Asset Report data, the Estimated Value of depreciable assets is calculated with the following logic:

  • If Reporting Year - Legal Year of Acquisition = 1:

    • Applicable Depreciation Rate = (Rate A from Depreciation Rate instance with the same Useful Life).

    • Estimated Value = Acquisition Cost x Applicable Depreciation Rate.

    • Round down after the decimal point.

    • If Estimated Value is less than Depreciable Amount Limit, Depreciable Amount Limit is copied.

  • If Reporting Year - Legal Year of Acquisition > 1:

    • Applicable Depreciation Rate = (Rate B from Depreciation Rate instance with the same Useful Life).

    • If Previous Estimated Value (Estimated Value of the DA from previous Reporting Year) isn't empty, Estimated Value = Previous Estimated Value x Applicable Depreciation Rate. Otherwise, Estimated Value = Acquisition Cost x Applicable Depreciation Rate.

    • Round down after the decimal point.

    • If Estimated Value is less than Depreciable Amount Limit, Depreciable Amount Limit is copied.

General Notices