The capitalized cost of a new machine, straight-line, declining-balance, sum-of-the-years'-digits and units-of-production depreciation, capitalized interest on a construction project, the two-step ASC 360 impairment test with its allocation, assets held for sale and disposals, an asset retirement obligation, deferred tax and a full roll-forward of property, plant and equipment: ten tabs, one fictional manufacturer, no macros.
Enter your invoices, lives and rates. The workbook builds the case's press at $1,351,800 and depreciates it by $86,000 a year, capitalizes $158,858.33 of interest on a $4,600,000 clean room, writes a production line down by $1,240,000 with the loss allocated asset by asset, measures a $196,709.58 asset retirement obligation and rolls the balance forward to $32,948,132.43. A Checks tab ties 41 figures to the book.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 136 free models.
Fixed_Asset_Register_Workbook.xlsx (27 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
the Press 14 invoices, salvage value and life; the Pine Street price, appraisals and closing costs; the Clean Room B payments, months and component costs; the construction loan and term loan; the medical mold's cost, rated cycles and 2025 cycles; the Press 7 figures; the CNC group's old and new estimates; the Line 3 carrying amounts, cash flows and fair values; the Elm Street, Press 3 and granulator figures; the ARO scenarios, inflation and discount rates; the tax rate; and the opening balances and other depreciation of the roll-forward.
Cost
the capitalized cost of Press 14 line by line, and the relative fair value allocation of the Pine Street purchase.
Depreciation
Press 14 under straight line, double-declining balance and sum-of-the-years'-digits; the medical mold by units of production; the laptop pool; the Press 7 rebuild; the CNC change in estimate.
Interest
weighted-average accumulated expenditures, the specific and general layers of avoidable interest, the ceiling, and the allocation of the interest to the clean room's components with their depreciation.
Impairment
the recoverability test, the loss, the pro rata allocation with the fair value floor for the presses, the new cost bases and the depreciation after the impairment.
Disposals
the Elm Street warehouse at classification and at sale, Press 3, and the granulator with its insurance recovery.
ARO
the expected cost, inflation to settlement, discounting, accretion and the depreciation of the asset retirement cost.
Tax
Press 14 in the book and tax registers, the temporary difference and the deferred tax liability.
RollForward
the roll-forward by class, from the opening balances through additions, transfers, depreciation, disposals and impairment to the closing balances, with capital expenditures and the ratio to depreciation.
Checks
a list of controls that compare the workbook's results with the figures printed in this book, ending in a single cell that reads ALL CHECKS OK when every one passes.
Every assumption is shaded in a light color on the Inputs tab; every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own assets; the Checks tab will then show differences from the book by design.