Discounted Cash Flow Valuation for Capital Investment Training Course

Course overview

Capital investment proposals often fail scrutiny not because the project is weak, but because the financial model cannot withstand questions about cash flow timing, discount rates, tax assumptions, terminal value, inflation, risk, or alternative scenarios. Finance professionals need to distinguish value-creating investments from projects that merely appear attractive under optimistic assumptions. This course equips participants to build and defend discounted cash flow valuations for capital expenditure, acquisitions, expansion projects, asset replacement decisions, and long-term strategic investments.

Participants work through the full discounted cash flow process: defining incremental free cash flows, forecasting operating drivers, modelling capital expenditure and working capital, applying tax and depreciation effects, estimating weighted average cost of capital, calculating net present value, internal rate of return, profitability index, and discounted payback. They test assumptions through sensitivity, scenario, break-even, and Monte Carlo analysis, and learn how to treat inflation, foreign currency, salvage values, terminal values, financing effects, and risk-adjusted discount rates appropriately.

Delivery combines instructor-led valuation clinics with spreadsheet-based modelling, peer review, and investment committee case work. Participants use Microsoft Excel to construct an auditable DCF model with linked assumptions, cash-flow schedules, valuation outputs, sensitivity tables, and decision charts. They leave with a completed capital investment appraisal workbook, an investment-committee recommendation template, and a practical checklist for challenging valuation models before approval.

The course is designed for finance and investment professionals who already work with budgets, forecasts, financial statements, or business cases and now need to assess material investment decisions with greater technical rigour. It is equally valuable to operational leaders who sponsor capital projects and must present financially credible cases to finance teams and approval committees.

Course objectives

By the end of this course, participants will be able to:

• Construct an unlevered free cash flow forecast from operating, capital expenditure, tax, depreciation, and working-capital assumptions
• Calculate net present value, internal rate of return, modified internal rate of return, profitability index, and discounted payback for capital projects
• Estimate a project discount rate using weighted average cost of capital, capital asset pricing model inputs, and risk adjustments
• Build an auditable Microsoft Excel DCF model with linked assumptions, timeline controls, error checks, and scenario switches
• Separate relevant incremental cash flows from sunk costs, financing flows, accounting allocations, and non-cash charges
• Evaluate terminal value, salvage value, replacement cycles, and finite-life project cash flows using appropriate valuation methods
• Run sensitivity, scenario, break-even, and Monte Carlo analyses to quantify investment risk and key value drivers
• Prepare and defend an investment-committee recommendation supported by valuation evidence, assumptions, and downside analysis

Benefits of attending

Target competencies

Who should attend

• Financial Analysts — who build business cases and need to produce defensible project valuations
• Corporate Finance Managers — who review capital allocation proposals and challenge discount-rate and cash-flow assumptions
• FP&A Managers — who convert operating plans into investment forecasts and approval models
• Investment Analysts — who assess acquisitions, expansion opportunities, and long-horizon asset investments
• Project Finance and Capital Projects Managers — who must quantify the financial case for major infrastructure or equipment decisions
• Business Unit Leaders — who sponsor capital expenditure and need to present financially credible approval requests

Requirements and prerequisites

Participants should be comfortable reading an income statement, balance sheet, and cash flow statement, and should understand basic corporate-finance terms such as revenue, operating cost, depreciation, tax, capital expenditure, working capital, and cost of capital. Practical experience preparing budgets, forecasts, business cases, or investment proposals is helpful. Participants need working Microsoft Excel skills, including formulas, cell references, basic functions, and charts; advanced macros or programming are not required. No prior experience with Monte Carlo simulation, CAPM estimation, or specialist valuation software is assumed, as these methods are introduced and applied during the course.

Training methodology

The course is delivered through short instructor-led valuation sessions followed by structured Excel modelling labs. Participants build each component of a capital-project DCF model rather than only reviewing completed examples: operating drivers, tax, working capital, discount rates, terminal value, and risk analysis. Case studies include an asset replacement decision, a growth investment, and a project with uncertain demand. Teams act as an investment committee to challenge assumptions and compare proposals. On the final day, each participant completes an application plan identifying a live or upcoming investment decision to model using the course framework.

Course outline

Day 1: Cash flow foundations for capital investment decisions

• Capital budgeting decisions and the role of discounted cash flow
• Value creation, opportunity cost, and incremental cash flow principles
• Reconciling accounting profit, EBITDA, operating cash flow, and free cash flow
• Identifying relevant costs, sunk costs, cannibalisation, and side effects
• Project timelines, cash-flow timing conventions, and mid-year discounting
• Capital expenditure, depreciation tax shields, and asset disposal proceeds
• Microsoft Excel model architecture, assumptions sheets, and audit checks

Workshop: Build the first-year-to-five-year free cash flow schedule for an equipment replacement case and produce a reconciled cash-flow bridge.

Day 2: Forecasting project cash flows and operating drivers

• Revenue-driver modelling using volume, price, capacity, and ramp-up assumptions
• Operating cost forecasts and fixed-versus-variable cost behaviour
• Working capital investment, release, and cash conversion cycle modelling
• Taxable income, loss carry-forwards, capital allowances, and tax timing
• Inflation treatment using nominal and real cash flows
• Foreign currency cash flows and exchange-rate forecasting considerations
• Finite-life projects, replacement investment, salvage value, and decommissioning costs

Workshop: Develop a driver-based cash-flow forecast for a market expansion project, including working capital, tax, and end-of-life cash flows.

Day 3: Discount rates and core valuation measures

• Time value of money, discount factors, and present-value mechanics
• Net present value decision rules and mutually exclusive project ranking
• Internal rate of return, multiple IRRs, and reinvestment-rate limitations
• Modified internal rate of return, profitability index, and discounted payback
• Weighted average cost of capital and market-value capital structures
• Capital asset pricing model, beta, equity risk premium, and cost of equity
• Project-specific risk adjustments and consistency between cash flows and discount rates

Workshop: Calculate WACC and valuation metrics for two competing capital projects, then prepare a recommendation where NPV and IRR give different rankings.

Day 4: Risk analysis, terminal value, and model challenge

• Terminal value using perpetuity growth and exit multiple approaches
• Long-term growth assumptions and terminal-value reasonableness tests
• One-way and two-way sensitivity tables in Microsoft Excel
• Scenario analysis for base, upside, downside, and stress cases
• Break-even analysis for volume, price, cost, and investment thresholds
• Monte Carlo simulation with Palisade @RISK and probability distributions
• DCF model review techniques, error traps, and assumption challenge questions

Workshop: Create a sensitivity dashboard and Monte Carlo risk output for a renewable-energy investment, identifying the assumptions that most affect NPV.

Day 5: Investment committee decisions and valuation governance

• Structuring a capital investment paper for executive approval
• Communicating NPV, IRR, payback, risk exposure, and strategic rationale
• Comparing projects under capital constraints and portfolio prioritisation
• Post-investment review design and benefit-realisation tracking
• IFRS impairment indicators and links between project value and IAS 36 testing
• IFRS 13 fair-value concepts and their distinction from investment appraisal
• Personal model-improvement plan and workplace application roadmap

Workshop: Present a completed DCF investment case to a simulated investment committee and submit an auditable Excel model, recommendation paper, and implementation plan.

Tools & standards covered

Microsoft Excel, Palisade @RISK, IAS 36 Impairment of Assets, IFRS 13 Fair Value Measurement

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions