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.
|