Articles

How do you build the cash flows of a capital budgeting project?

A project's cash flows are the difference between the company with the project and without it, after tax. Sunk costs and allocations stay out; opportunity costs, side effects, working capital and the tax on salvage go in; interest stays out.

The net present value of a capital project is only as good as its cash flows, and most errors are made there, not in the discount rate. In the worked case below, a $4,500,000 production line has a net present value of $739,000 at an 11% hurdle rate and an internal rate of return of 15.0%. Four common mistakes would each move that value by more than half.

Worked in full in The Capital Budgeting Handbook by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback

The case

Ellsmere Plastics, a fictional packaging manufacturer, is considering Line 7, a thermoforming line for a product family that is selling out. The equipment costs $4,200,000 and installation $300,000. Revenue is $5,000,000 in year 1, growing 3% a year with inflation; variable costs are 60% of revenue; incremental fixed cash costs are $750,000 in year 1, also growing 3%. The line has an eight-year life and a salvage value of $400,000. The company's planning tax rate is 25%, and the hurdle rate for expansion projects is 11%.

Step 1: decide what is incremental

Step 2: taxes and depreciation

Depreciation is not a cash flow; the tax it saves is. Under section 168(k) as amended in July 2025, qualified property acquired after January 19, 2025 qualifies for 100% bonus depreciation, with no scheduled phase-down. Ellsmere deducts the whole $4,500,000 in year 1. Against year 1 EBITDA of $1,040,000, that creates a taxable loss of $3,460,000, which reduces the tax on Ellsmere's other income by $865,000. With MACRS 7-year depreciation instead, the net present value would be $514,000: the timing of the deduction is worth $225,000.

Check the states too. Several states do not follow federal bonus depreciation. South Carolina, where the case company is based, conforms to the Internal Revenue Code as amended through December 31, 2024 and does not adopt the 2025 changes to section 168(k), so its share of the tax rate, about 4 points of the 25%, follows MACRS 7-year. The adjustment costs $154,000 of extra state tax in year 1, recovered over the following seven years, and takes $36,000 off the net present value, which becomes $703,000. Small as it is, that is the kind of amount that decides a close call when projects compete for a fixed budget.

Step 3: working capital and salvage

Net working capital is 12% of the next year's revenue: $600,000 at year 0, growing with revenue to $738,000, and recovered in full at the end of year 8. The equipment, fully depreciated for tax, is sold for $400,000; the tax on the gain is $100,000, so the after-tax salvage is $300,000.

Line 7 net cash flows ($ thousands)
Year012345678
EBITDA1,0401,0781,1161,1561,1971,2391,2831,327
Tax (negative = saving)-865269279289299310321332
Increase in working capital60018191920202121-738
Capital and after-tax salvage-4,500300
Net cash flow-5,1001,8877908188478779089402,033

Step 4: discount

At 11%, the present values of years 1 to 8 add up to $5,839,000 against an outlay of $5,100,000: the net present value is $739,000. The internal rate of return is 15.0%, the payback 4.9 years and the discounted payback 7.2 years.

Four mistakes, measured on the same project: charging the allocated overhead turns the net present value to -$33,000; deducting interest on a loan for 60% of the cost as well as discounting at 11% cuts it to $30,000; leaving out working capital overstates it at $1,110,000; holding revenue and costs flat while discounting at the nominal rate cuts it to $318,000.

Takeaway

Free Excel template: Capital Project Appraisal Workbook (incremental cash flows, NPV, IRR, MIRR, sensitivity, lease versus buy and capital rationing).

Also on this site: NPV versus IRR conflicts · lease versus buy for equipment.

Questions readers ask

Should depreciation be included in capital budgeting cash flows?

Not as a cash outflow. Depreciation enters only through the tax it saves: tax is computed on EBITDA less tax depreciation, and the after-tax cash flow is EBITDA less that tax.

Is interest included in project cash flows?

No. The cost of financing is in the discount rate. Deducting interest from the cash flows and discounting at a rate that includes the cost of debt counts it twice.

How is working capital treated in capital budgeting?

The investment in receivables and inventory, net of payables, is an outflow when it builds and an inflow when it is recovered at the end of the project. Leaving it out overstates value because it goes out early and comes back late.

Is bonus depreciation 100% in 2026?

Yes for qualified property acquired after January 19, 2025, under section 168(k) as amended in July 2025, with no scheduled phase-down. A company can elect out by class of property. Confirm the treatment of your asset with your tax adviser.

Sources: IRC 168(k) as amended in July 2025, IRS Notice 2026-11, IRS Publication 946, Rev. Proc. 2025-32 and ASC 842, checked on 18 November 2026. Figures computed by the author's model for a fictional company. Education only, not tax, accounting or investment advice.

Read the whole case

This article is one calculation from The Capital Budgeting Handbook. The book follows one manufacturer's capital plan from the call for projects to the board's approval and a post-completion review, and every figure it prints is a live formula in the free workbook.

Get the PDF edition, $19.99 Paperback · Free companion files