investment calculation

Calculating project profitability
: 5 methods,
a tool

Q: What is a typical discount rate?

For medium-sized companies in the DACH region, the WACC is typically between 6% and 12%. For high-risk projects, there is a 2-5 percentage point surcharge.

Q: What does a negative net present value mean?

A negative net present value means that the discounted cash flows do not cover the initial investment. Review assumptions or alternative approaches.

Q: How can Smartsheet help with investment calculations?

Smartsheet is ideal for actual vs. planned cash flow tracking, automatic budget variance alerts, and ROI dashboards for management.

Q: What is the difference between TAAR and IRR?

TAAR is a simplified indicator that does not take time value into account. IRR determines the actual interest rate, taking into account the distribution of cash flow over time.

Net present value, internal rate of return, payback period, ROI, and TAAR: Evaluate your investment using the methods that CFOs use.

methods

NPV

gold standard

0 €

Free of charge

computer

Dynamic investment analysis

Net present value method

Calculates the present value of all future cash flows minus the initial investment.

Initial investment (€)

Discount rate (%)

WACC or minimum return (typically 6-12% in Germany, Austria, and Switzerland)

Annual net cash flows (€)

Year 1

Year 2

Year 3

Year 4

Year 5

Result: Net present value method

–

Net present value (NPV)

–

Total cash flows

–

profitability index

return calculation

Internal rate of return

The IRR is the interest rate at which the net present value of an investment is exactly zero.

Initial investment (€)

Comparative interest rate (%)

WACC or minimum return

Annual net cash flows (€)

Year 1

Year 2

Year 3

Year 4

Year 5

Result: Internal rate of return

–

Internal rate of return (IRR)

–

NPV at comparative interest rate

–

Spread (IRR – WACC)

risk assessment

Payback period

Calculates after how many years the cumulative returns exceed the initial investment.

Initial investment (€)

Max. payback period (years)

Company policy / Target

Annual net cash flows (€)

Year 1

Year 2

Year 3

Year 4

Year 5

Result: Payback period

–

payback period

–

total return

–

surplus

profitability

Return on investment (ROI)

ROI measures the ratio of net profit to total investment as a percentage.

Total investment (€)

Expected total income (€)

Total returns over the project period

Project duration (years)

Result: Return on investment

–

ROI (total)

–

ROI (annual)

–

net profit

year-on-year comparison

TAAR (Total Annual Average Return)

The average annual return: average annual yield relative to the initial investment.

Initial investment (€)

Annual net cash flows (€)

Year 1

Year 2

Year 3

Year 4

Year 5

Result: TAAR

–

TAAR (annual)

–

Total ROI

–

Average cash flow per year

–

net profit

investment calculation

The right basis for decision-making:
Five methods compared

Before a company invests in a new project, it needs a sound economic analysis. Each method answers a different question:

method	question	Current value?	Ideal for
NPV	Does the project create absolute added value?	Yes	Project comparisons, long-term investments
IRR	What is the project return on investment?	Yes	Return vs. cost of capital
payback	When will the money be returned?	No	Quick risk assessment
return on investment	What is the percentage return on invested capital?	No	management communication
TAAR	What is the average annual return?	No	Comparison of the duration of various projects

methodology

How the calculation methods work

1. Net present value method (NPV)

The net present value method is the standard procedure for dynamic investment appraisal. All future cash flows are discounted to the present date using the discount rate.

NPV = -I₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + … + CFₙ/(1+r)ⁿ

Decision rule: NPV > 0 means that the project creates value. If there are several alternatives, choose the project with the highest positive net present value.

2. Internal rate of return (IRR)

The IRR is the interest rate at which the net present value is exactly zero. It is calculated iteratively using the Newton method.

0 = -I₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + … + CFₙ/(1+IRR)ⁿ

Decision rule: IRR > WACC = investment advantageous. The spread shows the excess return.

3. Payback period

Determine how many years it will take for the cumulative returns to reach the initial investment. The shorter the period, the lower the risk.

Amortization = Year in which: Sum(CF₁ + … + CFₙ) ≥ I₀

Limitation: Does not take into account the time value of money and ignores cash flows after the payback period.

4. Return on investment (ROI)

Compares net profit to capital employed.

ROI = (total return – total investment) / total investment × 100%

5. TAAR (Total Annual Average Return)

Calculates the average annual return. Enables comparison of projects with different durations.

TAAR = ((sum of all CFs – investment) / investment) / years × 100%

Advantage: Easy year-on-year comparison. Disadvantage: Does not take into account fair value or cash flow fluctuations.

Frequently asked questions

FAQ: What companies want to know

Which method should I use for my project?

For a complete evaluation, it is advisable to combine several methods. The net present value (NPV) is best suited for absolute value comparison. The IRR compares the return with your capital costs. The payback period provides a quick risk assessment. The ROI offers a simple basis for communication with management. The TAAR enables the comparison of projects with different durations.

What is a typical discount rate?

The discount rate should correspond to your company's weighted average cost of capital (WACC). For medium-sized companies in the DACH region, this is typically between 6% and 12%. For high-risk projects, a risk premium of 2-5 percentage points may be appropriate.

How can I realistically estimate future cash flows?

Use three scenarios: optimistic, realistic, and pessimistic. Base your estimates on historical data from comparable projects, market analyses, and expert surveys. A structured tool such as Smartsheet helps you systematically track actual values against planned values.

Why do NPV and ROI sometimes differ?

NPV and ROI consider different aspects: ROI shows the total return, but does not take into account when the returns are generated. €50,000 in year 1 is worth more than €50,000 in year 5. NPV discounts each cash flow individually and therefore provides a more realistic picture.

What does a negative net present value mean?

A negative net present value means that the investment is not economically viable under the given assumptions. Check whether the assumptions are realistic, whether strategic advantages compensate for the financial disadvantage, or whether an alternative approach would yield better results.

How can Smartsheet help with investment calculations?

Smartsheet is ideal for ongoing monitoring of project investments: track actual vs. planned cash flows in real time, receive automatic notifications in the event of budget deviations, and access dashboards for management with current ROI and amortization figures. Lighthouse Consultings implements customized solutions for project controlling.

What is the difference between TAAR and IRR?

TAAR is a simplified key figure that does not take time value into account. IRR, on the other hand, determines the actual interest rate, taking into account the timing of cash flows. For quick orientation: TAAR. For precise investment decisions: IRR.

Nico Roepnack

Founder, Lighthouse Consultings. 20+ years of operations in the manufacturing industry. Smartsheet ENGAGE 2025 speaker, Forbes Business Council, DHBW lecturer on digital transformation.

Next step

From calculation to implementation

Have you calculated your profitability? Now it's time to actually achieve the planned results. We support you with structured project controlling on Smartsheet.

Free initial consultation Or: Read FEW Automotive reference →

Sources: Brealey/Myers/Allen: Principles of Corporate Finance · APICS/ASCM Body of Knowledge · LHC practical experience (15+ implementations)

Calculating project profitability
: 5 methods,
a tool

The right basis for decision-making:
Five methods compared

How the calculation methods work

1. Net present value method (NPV)

2. Internal rate of return (IRR)

3. Payback period

4. Return on investment (ROI)

5. TAAR (Total Annual Average Return)

FAQ: What companies want to know

Nico Roepnack

From calculation to implementation

Schedule a consultation

Discuss results?

All project management is handled in Smartsheet

Calculating project profitability: 5 methods,a tool

The right basis for decision-making:Five methods compared

How the calculation methods work

1. Net present value method (NPV)

2. Internal rate of return (IRR)

3. Payback period

4. Return on investment (ROI)

5. TAAR (Total Annual Average Return)

FAQ: What companies want to know

Nico Roepnack

From calculation to implementation

Schedule a consultation

Discuss results?

All project management is handled in Smartsheet

Calculating project profitability
: 5 methods,
a tool

The right basis for decision-making:
Five methods compared