2026-10-20 · AI-drafted · Finance · Modeling · Accounting · 6 min read
Build the Capital Expenditure Schedule That Keeps Your Model Honest
The capital expenditure schedule is where most three-statement models quietly fall apart. Depreciation flows to the income statement, net book value flows to the balance sheet, and cash paid flows to the cash flow statement — and if any one of those links is wrong, your model ties out by coincidence, not by construction. I'll show you how to build an asset schedule that is structurally honest, using worked examples drawn from a German manufacturer reporting under IFRS and an Indian IT services firm reporting under Ind AS.
Why the Asset Schedule Is the Structural Core
A three-statement model has one job: every euro, rupee, or real of economic activity must appear in exactly the right place on exactly the right statement. The asset schedule enforces that discipline for long-lived assets. It tracks gross asset value, accumulated depreciation, and net book value (NBV — the carrying amount after subtracting accumulated depreciation from the original cost) for every asset class you model.
When you skip a proper schedule and hard-code depreciation as a percentage of revenue, you sever the link between the balance sheet and the cash flow statement. The model may still balance — accountants call this 'plugging' — but it balances because you forced it to, not because the underlying mechanics are correct. A reviewer who stress-tests your assumptions will find the plug immediately.
The fix is straightforward: build a roll-forward (a schedule that starts with the opening balance, adds activity during the period, and arrives at the closing balance) for each asset class. Opening NBV plus additions minus disposals minus depreciation equals closing NBV. That closing NBV feeds the balance sheet. Depreciation feeds the income statement. Cash paid for additions feeds the investing section of the cash flow statement. Three statements, one source of truth.
IFRS vs. US GAAP: Two Rules That Change the Numbers
The mechanics of a roll-forward are universal, but the accounting rules that govern what goes into it differ by reporting regime. Under IFRS (International Financial Reporting Standards, used in over 140 countries), IAS 16 permits revaluation of property, plant, and equipment to fair value. Under US GAAP (Generally Accepted Accounting Principles), revaluation above historical cost is not permitted. If you model a German manufacturer that revalues its factory every three years, you need a revaluation surplus line in equity — and your model must reflect that.
Component depreciation is a second difference. IFRS requires that significant components of an asset be depreciated separately. A turbine manufacturer might depreciate the turbine body over 25 years and the blades over 8 years. US GAAP permits but does not require component depreciation. In practice, a model built for an IFRS reporter needs more asset-class rows than an equivalent US GAAP model.
Neither regime is harder to model — they are just different. The discipline is to know which rules apply before you build, not after. Label your inputs sheet clearly: 'Depreciation method: straight-line. Useful life: 10 years. Residual value: 5% of cost. Reporting standard: IFRS (IAS 16).' A reader who opens your model six months later should not have to guess.
A Worked Example: EUR 40m Manufacturer
Consider a manufacturer with EUR 40m of gross property, plant, and equipment at the start of the year, accumulated depreciation of EUR 15m, and NBV of EUR 25m. The company plans EUR 6m of new capital expenditure during the year, all in machinery with a 10-year useful life and zero residual value. Straight-line depreciation on the existing base is EUR 2.5m (EUR 25m divided by 10 years, simplified). New machinery adds EUR 0.6m of depreciation (EUR 6m divided by 10 years, pro-rated for a full year in this example).
End-of-year gross assets: EUR 46m. End-of-year accumulated depreciation: EUR 18.1m (EUR 15m plus EUR 3.1m). End-of-year NBV: EUR 27.9m. That EUR 27.9m appears on the balance sheet under non-current assets. The EUR 3.1m depreciation charge appears on the income statement, reducing EBIT (earnings before interest and taxes). The EUR 6m cash outflow appears in the investing section of the cash flow statement. Every statement reflects the same economic event — that is what 'ties out' means.
Now run a scenario: the company defers EUR 3m of the planned capex to the following year. Depreciation falls by EUR 0.3m. EBIT rises by EUR 0.3m. Cash used in investing falls by EUR 3m. NBV falls by EUR 3.3m relative to the base case. A model with a proper schedule propagates that change automatically. A model with hard-coded depreciation requires you to remember to update three separate cells — and you will eventually forget one.
Ind AS and the Indian IT Services Context
India's Ind AS (Indian Accounting Standards, converged with IFRS since 2016) follows IAS 16 for tangible assets. An Indian IT services firm carries relatively little physical plant — servers, leasehold improvements, and office equipment dominate. But it may carry significant right-of-use assets under Ind AS 116 (the lease standard), which requires lessees to recognize a lease liability and a corresponding right-of-use asset on the balance sheet.
In a model for such a firm, the asset schedule needs a separate section for right-of-use assets. The depreciation of the right-of-use asset flows to the income statement (or, for some leases, to cost of revenue). The interest on the lease liability flows to finance costs. The principal repayment flows to financing activities in the cash flow statement. If you lump lease depreciation into a single depreciation line without separating the cash flow treatment, your model will misstate free cash flow — a number that analysts and lenders use directly.
The practical rule: one roll-forward per asset class, clearly labeled, with the accounting standard and method documented in the inputs sheet. For a firm reporting INR 8,000m of right-of-use assets, a 1% error in the depreciation rate produces an INR 80m error in EBIT. That is not a rounding issue — it is a modeling failure.
The Three Checks That Confirm Your Schedule Is Correct
First, the balance sheet check: closing NBV on your asset schedule must equal the property, plant, and equipment line on your balance sheet. Build a dedicated tie-out cell that subtracts one from the other and flags any non-zero result in red. If it is ever non-zero, stop and find the error before you move forward.
Second, the cash flow check: the sum of all capex additions on your asset schedule must equal the 'purchase of property, plant, and equipment' line in your investing activities section, adjusted for any non-cash additions (assets acquired through business combinations, for example). Again, a tie-out cell, not a visual inspection.
Third, the depreciation check: total depreciation on your asset schedule must equal the depreciation line on your income statement plus any depreciation capitalized into inventory (relevant for manufacturers). This third check catches the error that most modelers miss — depreciation embedded in cost of goods sold rather than shown as a separate line. A model that passes all three checks is structurally honest. One that passes two out of three is not.
What This Means for Course 2
Module 6 of Course 2 — Capital Expenditure and the Asset Schedule — builds this roll-forward from a blank sheet. You start with an inputs section that captures asset class, useful life, residual value, depreciation method, and reporting standard. You build the roll-forward row by row. You wire depreciation to the income statement, NBV to the balance sheet, and cash additions to the cash flow statement. Then you add the three tie-out checks.
By the time you reach Module 8 — Balance Sheet and Cash Flow Tie-Out — the asset schedule is already doing its job. The model does not balance because you forced it to. It balances because every link is explicit, every assumption is documented in one place, and every output is derived rather than entered. That is the difference between a model that survives a review and one that does not.
The courses are pure education, not credentialing. We use AI heavily and we're transparent about it.
A Note on What This Course Is — and Isn’t
We don’t pursue CE accreditation. The courses are pure education, not credentialing.
Nothing in this course constitutes personalized financial, legal, or investment advice. You’ll learn frameworks and analytical tools — what you do with them is your decision.
We use AI heavily and we’re transparent about it.
Drafted with AI from the outline of Dr. Kareem Tannous’s Course 2. Published automatically under his editorial standards.
$189 per course. $504 for the bundle of three.
100% refund within 3 days of enrollment AND zero module access. Accessing any module — even briefly — waives the right to a refund permanently. Decisions are final; no appeals.
Course 2: Excel Modeling for Financial Decisions →
New to financial statements? Start with Course 1 →
Instructor: Kareem — DBA International Business · MS Applied Economics & Predictive Analytics · MBA Finance & Accounting · Series 65 · university-level instructor since 2014.
— Dr. Kareem Tannous