This Template automate the calculation of Periodic Depreciation Charge,Accumulated Depreciation and Carrying amount of Individual Assets no matter the number of assets involved.
It also auto generates fixed asset schedule for reporting purpose. It flexible to accommodate more asset category as the user desires.
The Template allow for periodic calculation of Fixed Asset cost analysed into:
Also, for the movement in the accumulated depreciation categorised into:
KEY Inputs are:
Cost of the asset
Scrap value (if any)
Depreciation rate; useful life,
Asset disposal date
Disposal of asset proceed,
Selling expenses (if any)
The model was developed to offer the following maximum benefit to users:
* Flexible Accurate and Simple Fixed Asset Report Automation
* Recording of Asset Acquisition, Addition and Disposal during the month and year
* Asset Carrying Value Computation
*Automated Calculations of Gain or loss on Asset disposal
*Periodic Fixed Asset Schedule for Financial Reporting
*Automated Accumulated Depreciation Calculation
*Data Input Validation to ensure data integrity
*Limited User Input
*Collaborate on Excel Online/Excel for the Web
The Excel file is compatible with Excel 2007 and above and also with Microsoft 365.
The use of Table structure Reference is adopted to optomize the model.