Our Fixed Asset Accounting workbook provides all you need to keep track of a maximum 3,000 asset depreciation records, book values and disposals with Excel 97-2003. It will save you hours of work calculating MACRS depreciation for tax purposes and deferred tax balance values for any month end date. It also includes capital lease accounting.
You can select straight line depreciation or the declining/double declining deprecation methods.

You can wind the month end back and forwards to calculate accounting depreciation, MACRS depreciation and deferred tax balances at any month end. The default calculation period is the current month end.

The MACRS depreciation rates are variable. They are set for US tax depreciation rules but you can enter any MACRS rates into the database which will apply to your calculations.

In the first workbook each asset is defined by location, accounting depreciation life, MACRS class and salvage percentage.

Individual assets can have their own unique depreciation life.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Disposal accounting included.

The Lease accounting section reports repayment status, interest and remaining balances for all capital leases at any month end. Lease terms can include pre-payments and final balloon payments.

The Zip download is a 6.67 MB file. After downloading unzip the three Excel Asset Accounting workbooks including the tutorial edition. The MACRS accounting is provided in a separate workbook (No: 2). CD shipping is also an option.

ASSET REGISTER

• Up to 3,000 assets.
  
• Copy asset lists directly into Excel columns.
  
• SL/DB/DDB depreciation options.
  
• Up to 100 Classes with fixed depn rates.
  
• Up to 100 Locations.
  
• Each asset can over-ride Class base depn.
  
• Assign each asset to a Class and Location.
  
• Variable month end adjustments to forecast depreciation and book value at any date.
  
• Sum monthly and total depreciation by all Classes.
  
• Sum monthly and total depreciation by all Locations.
  
• Sum Book values by all Classes and Locations.

LEASE REGISTER

• Up to 3,000 lease accounts
  
• Up to 100 Master Lease headers.
  
• Sub-Leases can be assigned to a master lease.
  
• Define repayment terms inclusive of upfront payments and final balloons.
  
• Calculates current and total principal repayments and interest to the selected month end.
  
• Variable month end adjustments to enable forecasts of principal and interest any any date.
  
• Sum principal, interest for the selected month and cumulative to the selected month for Master Leases and sub leases and standard leases

VARYING LEASETERMS- EFFECT OF REPAYMENT ACCELERATION, RATE CHANGES.

• The Lease Register provides a way to recalculate final repayment month, interest charges and repayment amounts without impacting the current register to asses the effects of rate changes, ballon payment changes and/or accelerated monthly repayments.
  
• The recalculations can be carried out at any month end so that if changes are anticipated in the future the total savings to the firm for an individual lease or all lease adjustments can be computer exactly.
  

• Summarises year to date depreciation balances and written down book values.
• Depreciation periods can be any number of months for each asset record. No limits.
• Calculates net gains/losses on disposals.
• Photo file album included.
• Demo files are provided with each version so that you can quickly learn how to set up and run your Asset Register.
• Really useful and easy to use Asset Register for small and medium sized organizations. Used by school boards, libraries, and small and large businesses in the USA, Canada, Australia and the United Kingdom.

You can copy existing records held in your Excel into Asset Register using Copy > Paste, and use Excel's Form to enter new record information.

The Asset Register.

Look up any asset record or Class ID for total month to date summaries. (The month end can be adjusted backwards or forwards).

Analyzing average costs per asset Class and numbers of assets per Class.

Year to date Summary Report.

Photo records can be stored in Asset Register, if required.

Millennium Software Inc. and Support

30 days money back guarantee.

• Windows 95/98/2000/ME or XP.
• Microsoft Excel 97 or more.