asset schedule depreciation A/D retirement

I am looking for an asset schedule that will show the following:
Cost
Date Acquired
Date in Service
Depreciation Start Date
Annual Depreciation (MACRS)
Annual Depreciation (Book)
Retired Assets
Accumulated Depreciation
Tangible Value
Tangible Condition
Salvage Value
Asset Life
(and anything else I'm not thinking of right now)

The spreadsheet should be able to handle asset retirements (full and partial), relief of A/D, gain or loss on sale. I've got this laid out pretty well but it's a high maintenance spreadsheet subject to error. Does anyone have a suggestion on where to find a downloadable model that handles these requirements? My spreadsheet is doing the job. It's just not doing it well any time there is a deviation from the original amortization schedule or the original life of the asset.

Hi Maureen,

You better post an empty copy of your sheet up here to get an answer on this.

Here's an attachment showing what I'm working with. I've removed all but one asset class. There's a page for each class, a page for each year of depreciation, and a page for each year's tangible return. This is a spreadsheet I inherited and I'm convinced that, short of buying asset software, Excel can handle this better. My particular concern is Asset 5 and the partial asset retirements in 2006.

Any suggestions on improving the format?

hi Maureen

My recommendation is simple - use a database. There are plenty available free on the 'Net, and shareware authors will be pleased to make mods based on your exact requirements.

James

Thank you everyone for your advice and your straightforward answers. I appreciate your input!

Thanks for the vote, DomB

Some more thoughts for Maureen:

1. Will it cope with Tax and Book Depreciation?
2. Will it allow fo changes in Depreciation rates?
3. Is it possible in the future you'll have more than one company/business - if so, you'll need to think about Inter-Company asset Transfers?
4. Consider how it will handle Land and Buildings - particularly an upwards revaluation, especially with additions and the required tax treatments in your part of the world.
5. Does it need to deal with partial disposals and sub-assets (looks like it to me).
6. Is there any requirement/benefit to link it (via ODBC, download/upload or some such) to any other system - Payables, General Ledger or Plant Maintenance/
7. Is there any special local requirement for some groups of assets: In Australia we have a nasssty tax called Fringe Benefits Tax (FBT) that demands close recording of use of Motor Vehicles, with different treatments for different categories (cars & utes, for example), and records of who used the vehicle over what period.

The link below is just one from a search of free "asset register" software :
http://www.freedownloadssource.com/asset-management.htm


James