Developer : Millennium Software Inc.
Excel Templates for accounting
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.
Attitional Information
Built-in Excel Lookup functions
Gain/loss at the date of disposal
Accumulated depreciation and book value balances at any selected month end
Asset costs, useful lives, current monthly depreciation, cumulative depreciation
Disposal gains & losses records, audit verification
Annual and monthly declining balance tables
System Requirements
Platform : Windows XP/Me/9x/NT/2000/2003 or Mac OS
Web Data Requires:
Excel 2000 or later and MS Windows XP/2000/2003 or later.
Order
Please note that you also may want to purchase our 'Financial Excel All Programs Edition' - large collection of financial programs - as it contains this product.
30-day Money Back Guarantee!
Additional Information |
|||
|
Fixed Asset Accounting with MACRS for Excel |
|
||
|
|
|||
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates
Copyright © Millennium Software All Rights Reserved