Historical Amortization Calculation Tool

The Historical Amortization Calculation Tool (Version 3.2, January 2006) is provided to school district staff to assist with amortization calculations for financial reporting, such as for the annual financial statements and Government Reporting Entity quarterly reports.  As in previous versions, the Historical Amortization Calculation Tool is populated with data specific to a school district up to and including the 2002/03 fiscal year.

Version 3.2 provides a minor correction to the tool where the data entry screen would not agree to the schedules the tool produces (the Version 3.1 schedules and journal entries were nevertheless correct).  Users can update their Amortization Tool from Version 3.1 to 3.2, with no need to re-enter data, by downloading a patch.  Tools The district-specific Tools and the Patch are available lower on this page.

In order to calculate accurate figures, it is imperative that the current version of the Historical Amortization Calculation Tool is used.  Beginning with version 3, the calculation of deemed disposals was revised to include net additions and prior period adjustments instead of net additions only.  As well, Version 3 was amended to include database adjustments for 31 districts to remove negative additions for Furniture & Equipment, Vehicles and Computers.

The Historical Amortization Calculation Tool allows school district staff to:

  • enter data for capital assets and deferred capital contributions (DCC) starting with the 2003/04 fiscal year
  • enter prior period adjustments for any class (in the year or original acquisition)
  • enter write-offs and disposals for buildings (in the year or original acquisition)
  • print reports for asset class schedules and journal entries at the change in accounting policy, July 1, 2004
  • print reports for asset class schedules and journal entries starting with the 2004/05 fiscal year

Using the Historical Amortization Calculation Tool

To enter additions, prior period adjustments, write-offs or disposals, select the database (capital assets or DCC) and database year, enter the new figures into the shaded editing areas, and select the option to save the new data.

Prior period adjustments, write-offs and disposals must be entered in the year of acquisition in order to calculate amortization in the current period correctly.  Amortization applicable to these transactions can be determined by taking the difference between the accumulated amortization before and after the transaction (see "Recording a disposal in year ended June 30, 200X").

To print a set of journal entries and supporting schedules, select the database, year and print option.  The Tool prints schedules and entries for the year after the year shown in the dropdown year selector. E.g., to print 2005 Journal Entries and supporting schedules, enter 2004 as the data year and then select Printing All Schedules and Journal Entries.

There are on-screen notes to help get you started--click on the Display Tips button on the screen.

Download

Historical Amortization Calculation Tool
Version 3.1 to 3.2 Patch

This Patch allows you to continue using the data already entered into Version 3.1 of the Historical Amortization Calculation Tool.

To update your Historical Amortization Tool version 3.1 to version 3.2, open the patch and follow the instructions.  The patch leaves your original Tool unchanged and will not update or erase any data you've saved to your database.  The Patch creates a new file on your disk.

Historical Amortization Tool Patch: Update v.3.1 to 3.2 (ZIP)

Historical Amortization Calculation Tool
Version 3.2 - January 2006 (XLS, 3.6 MB)

Note: the Tool is not a network application; data is not saved on a server.  If your web browser opens the Tool immediately upon download, you must save the Tool to an appropriate location on your computer's hard disk and work from that location.

System Requirements

Microsoft Excel 2000 or newer is required to run the Historical Amortization Calculation Tool and the

The Historical Amortization Calculation Tool is a Microsoft Excel workbook.  To run it, macros must be “enabled” in the Excel application.  If you receive an error message, select from the MS Excel menu Tools/Macro/Security..., and set security to “medium” or “low”.  Restart MS Excel.  Launch the tool.