What is it?
Keep track of the depreciation of your assets with this template. You can track the monthly depreciation and the total value of your assets.
Creating a Fixed Assets Template
Under a Workbook
Click the "+" button to open the Create dropdown
Select Fixed Assets Template
How is monthly Fixed Asset depreciation calculated?
Monthly values show the monthly depreciation of the asset. Values are calculated by taking the total value of the asset and dividing it by the life of the asset. The depreciation values start on the In-Service Date and end after the number of months set within Life (if the Sale Date is not before the end of life).
Output Fixed Asset Metrics
Total Depreciation Fixed Asset
The sum of the monthly value of depreciation for all line items for the month.
Total Fixed Asset
Total purchase price of all line items on purchase month.
Fixed Asset Template Dimensions
Name
Name of the asset - not used in calculations.
Purchase Price
The total value of the asset when purchased. Used to calculate the monthly values as well as the Total Fixed Asset metric.
Purchase Date
When the asset was purchased. Determines when the asset should be calculated for Total Fixed Assets.
In-Service Date
When the asset was put into service. Determines when depreciation for the asset starts.
Life
The number of months the asset will last. Used to calculate the monthly depreciation values as a calculation of Purchase Price / Life.
Sale Date
Date when the asset is removed from the books. Determines when to stop including depreciation for the asset.
Integrations Available
This template does not support integrations.
Common Add-ons
N/A
Limitations
N/A