Business · Calculator companion · By K Imports
Capital-project NPV: practical guide
This guide explains how to use the Count.ie capital-project npv. Discount annual investment cash flows and calculate the profitability index. Follow the inputs, method and worked example below, then compare your own scenario.
Guide written .
Open the Capital-project NPV calculatorWhat to prepare
- Gather supplier quotes, invoices, time records and the actual scope of the job or business decision.
- Separate revenue from VAT, direct costs from overheads, and profit from the timing of cash receipts.
- Use the same accounting period and currency for related inputs.
Understand the inputs
- Annual net cash flows (€; commas)
- One amount per year; include the final disposal proceeds.
The calculation method
NPV = sum of annual cash flow ÷ (1 + discount rate)^year − initial investment.
Worked example
Illustrative inputs and their result.
Example inputs
- Initial investment (€)
- 50000
- Annual net cash flows (€; commas)
- 15000, 16000, 18000, 20000, 22000
- Annual discount rate (%)
- 8
Calculated example result
- Net Present Value
- €21,568.72
- Present Value Of Cash Flows
- €71,568.72
- Profitability Index
- 1.4314×
How to interpret the result
A profitable estimate can still create a cash shortfall. Read the cost and timing assumptions as well as the headline profit, price or return; the result is a scenario, not a sales forecast.
Keep the scope constant while changing price, volume, supplier cost or time. A lower-sales or higher-cost case helps show whether the decision depends on an optimistic assumption.
Common mistakes to avoid
- Do not confuse markup on cost with margin on selling price.
- Include work that is easy to miss, such as travel, setup, rework and administration, where the model supports it.
- Do not treat tax collected or an unpaid invoice as freely available cash.
Assumptions and sources
Use incremental after-tax cash flows at each year end. Nominal cash flows require a nominal discount rate.
If your case falls outside this scope, use a more suitable calculator or contact us about an unclear method.