NPV and IRR for Capital Budgeting Decisions

This video covers the following learning objectives:

Understand the Role of NPV and IRR in Capital Budgeting

• Explain why NPV and IRR are essential tools for evaluating long-term investments.

• Identify situations where capital budgeting is applicable (e.g., new projects, equipment purchases, expansions).

Certifications Aligned:

• CFA Level 1 (Corporate Finance)

• Canadian Securities Course (CSC)

• Certified Financial Planner (CFP)

• FRM (under corporate risk and investment evaluation)

Calculate NPV Using Excel

• Apply the =NPV() function in Excel to estimate the present value of future cash flows.

• Adjust calculations to account for the initial investment, which is not included in Excel’s NPV() function.

• Demonstrate how NPV changes with different discount rates.

Certifications Aligned:

• CFA Level 1

• CSC

• CFP

Calculate IRR Using Excel

• Use the =IRR() function to determine the internal rate of return based on a series of cash flows.

• Interpret IRR as the rate at which NPV = 0.

• Understand decision criteria: accept if IRR > required return.

Certifications Aligned:

• CFA Level 1

• CSC

• CFP

Compare Project Sensitivity Using Scenario Analysis

• Conduct sensitivity analysis by altering discount rates or cash flow assumptions.

• Use Excel’s Data Table feature to observe the effect on NPV and IRR.

• Evaluate how different projects perform under variable inputs.

Certifications Aligned:

• CFA Level 1

• FRM (risk management and capital budgeting)

Use a Financial Calculator to Verify NPV and IRR

• Match Excel functions with financial calculator steps (e.g., BA II Plus).

• Provide a cross-reference table of functions: NPV, IRR, PV, NPER.

• Reinforce understanding of both digital and handheld calculation tools.

Certifications Aligned:

• CFA Level 1

• CSC

• CFP