Depreciation Schedule & Fixed Asset Register
Depreciation is usually filed under accounting chores. It is better understood as the monthly instalment on equipment you will have to buy again — and this register shows both halves: what each asset is worth today, and what replacing it is going to cost.
The first sheet is the register. One row per asset with cost, salvage value and useful life; the sheet returns annual depreciation, how long it has been in service, accumulated depreciation, book value and the years it has left. Change the as-of date at the top and the whole register moves with it, which is what you want when closing a year or preparing figures for a lender.
Two columns do most of the work. Book value tells you what you are still carrying — in the sample data, 106,476 of an original 211,300, so half the asset base is already written off. Years left feeds the figure underneath: the cost of every asset with two years or less of life in it. That number, 23,800 in the sample, is a replacement wave that is already on the books whether or not anyone has budgeted for it.
Then the uncomfortable section. Monthly depreciation is 2,115, which is what the equipment costs you every month even though nothing leaves the bank. Against that sits what you actually set aside — for most owners, close to nothing. The sheet shows the gap and compounds it over three years: 58,156 in the sample, which is the size of the loan or lease that replaces the fund nobody built.
The second sheet takes one machine and depreciates it three ways: straight line, declining balance at double the rate, and units of production. All three write off exactly the same 46,000 — the only difference is timing. Declining balance charges 10,400 in year one against straight line's 4,600, which matters for tax and for how your P&L reads in the early years, and not at all for the total. Finmap keeps the asset register and the cash plan in the same place, so the replacement wave shows up in the forecast rather than in a surprise.
