FEASIBILITY STUDIES

Financial Appraisal

Evaluating the Financial Viability of Projects

Introduction to Financial Appraisal

Financial appraisal is a systematic process of evaluating a project's financial viability by analyzing costs, benefits, and risks to determine whether the project should be undertaken. It helps stakeholders make informed investment decisions.

Learning Outcomes

LO1: Understand the purpose and importance of financial appraisal
LO2: Prepare and analyze cash flow projections
LO3: Calculate and interpret key financial metrics (NPV, IRR, Payback Period)
LO4: Conduct sensitivity and risk analysis
LO5: Make investment recommendations based on financial analysis

Key Financial Appraisal Techniques

šŸ’°

Net Present Value (NPV)

The difference between the present value of cash inflows and outflows over the project's life.

Formula Variables:

CFt = Cash flow in period t

r = Discount rate (required rate of return)

t = Time period

n = Total number of periods

I0 = Initial investment (at t=0)

NPV = Ī£ [CFt / (1 + r)t] - I0 = CF0 + CF1/(1+r)1 + CF2/(1+r)2 + ... + CFn/(1+r)n

Step-by-Step Calculation:

Step 1: Identify all relevant cash flows (both inflows and outflows) over the project's life
Step 2: Determine the appropriate discount rate (r) that reflects the time value of money and risk
Step 3: For each period t, calculate the present value: PVt = CFt / (1+r)t
Step 4: Sum all the present values: Ī£PV = PV0 + PV1 + PV2 + ... + PVn
Step 5: NPV = Ī£PV - I0 (if I0 isn't already included in CF0)
Decision Rule

Accept project if NPV > 0 (positive NPV adds value to the firm)

Reject project if NPV < 0 (negative NPV destroys value)

Indifferent if NPV = 0 (project neither adds nor destroys value)

NPV Calculator

Results:

NPV: $0

Decision: -

Year Cash Flow Discount Factor Present Value
šŸ“ˆ

Internal Rate of Return (IRR)

The discount rate that makes the NPV of all cash flows equal to zero.

Formula Variables:

CFt = Cash flow in period t

IRR = Internal Rate of Return

t = Time period

n = Total number of periods

I0 = Initial investment (at t=0)

0 = Ī£ [CFt / (1 + IRR)t] - I0 = CF0 + CF1/(1+IRR)1 + CF2/(1+IRR)2 + ... + CFn/(1+IRR)n

Step-by-Step Calculation:

Step 1: Identify all relevant cash flows (both inflows and outflows) over the project's life
Step 2: Set up the NPV equation: NPV = Ī£ [CFt / (1 + IRR)t] - I0 = 0
Step 3: Solve for IRR by trial and error or using financial calculators/software. In practice, IRR is typically calculated using numerical methods (e.g., Newton-Raphson method)
Step 4: Compare IRR with the required rate of return (hurdle rate)
Decision Rule

Accept project if IRR > required rate of return (hurdle rate)

Reject project if IRR < required rate of return

Indifferent if IRR = required rate of return

IRR Calculator

Results:

IRR: 0%

Decision: -

ā±ļø

Payback Period

The time required to recover the initial investment from net cash inflows.

Formula Variables:

I0 = Initial investment

CFt = Cash flow in period t

CCFt = Cumulative cash flow up to period t

Payback Period = A + (B / C)

Where:

A = Last period with a negative cumulative cash flow

B = Absolute value of cumulative cash flow at the end of period A

C = Cash flow during the period after A

Step-by-Step Calculation:

Step 1: Identify the initial investment amount (I0)
Step 2: List the expected cash flows (CFt) for each period
Step 3: Calculate the cumulative cash flow (CCFt) for each period
Step 4: Identify the period (A) where CCFt changes from negative to positive
Step 5: Calculate the fraction of the period needed:
(Absolute value of CCFA) / CFA+1
Step 6: Payback Period = A + Fraction calculated in Step 5
Advantages

Simple to calculate and understand; emphasizes liquidity

Useful for quick assessment of risk and recovery timelines

Helpful for businesses with cash flow constraints

Limitations

Ignores the time value of money (simple payback method)

Ignores cash flows beyond the payback period

Doesn't measure profitability

Payback Period Calculator

Results:

Payback Period: 0 years

Year Cash Flow Cumulative Cash Flow
šŸ“Š

Profitability Index (PI)

The ratio of present value of future cash flows to initial investment.

Formula Variables:

PV = Present value of future cash flows

I0 = Initial investment

CFt = Cash flow in period t

r = Discount rate

t = Time period

PI = PV of Future Cash Flows / Initial Investment = Ī£ [CFt / (1 + r)t] / I0

Step-by-Step Calculation:

Step 1: Identify all relevant cash flows (CFt) over the project's life
Step 2: Determine the appropriate discount rate (r)
Step 3: Calculate the present value (PV) of all future cash flows:
PV = Ī£ [CFt / (1 + r)t]
Step 4: Identify the initial investment (I0)
Step 5: Calculate PI = PV / I0
Decision Rule

Accept project if PI > 1 (indicates value creation)

Reject project if PI < 1 (indicates value destruction)

Indifferent if PI = 1 (project neither adds nor destroys value)

Profitability Index Calculator

Results:

Present Value of Cash Flows: $0

Profitability Index: 0

Decision: -

Sample Financial Appraisal

Cash Flow Analysis
Financial Metrics
Cash Flow Visualization

5-Year Cash Flow Projection (in $000s)

Year 0 1 2 3 4 5
Initial Investment (1,500) - - - - -
Revenue - 800 950 1,100 1,200 1,300
Operating Costs - (500) (600) (700) (750) (800)
Net Cash Flow (1,500) 300 350 400 450 500
Cumulative Cash Flow (1,500) (1,200) (850) (450) 0 500

Key Financial Metrics

Metric Value Interpretation
NPV (10% discount rate) $295k Positive NPV indicates value creation
IRR 16.4% Exceeds 10% hurdle rate
Payback Period 4 years Reasonable recovery period
Profitability Index 1.20 Indicates value creation

Cash Flow Visualization

Annual Cash Flows Cash Flow ($000s) -1500 -1000 -500 0 500 1000 Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Negative Cash Flow Positive Cash Flow -1500 300 350 400 450 500

Risk and Sensitivity Analysis

šŸŽšļø

Sensitivity Analysis

Examining how changes in key variables (sales volume, costs, etc.) affect project outcomes.

Example

What if sales are 20% lower than projected? How does this impact NPV?

NPV Sensitivity Analysis Impact on NPV ($000s) from 10% change in each factor Change in NPV ($000s) -200 -100 -50 0 50 100 200 Discount Rate Initial Investment Revenue Growth Operating Costs Project Lifespan +120 -120 +150 -150 +180 -180 +100 -100 +80 -80 Positive Impact on NPV Negative Impact on NPV
šŸŽ²

Scenario Analysis

Evaluating project performance under different scenarios (best case, base case, worst case).

Performing Scenario Analysis:

Step 1: Define scenarios (e.g., best case, base case, worst case)
Step 2: Identify key variables for each scenario
Step 3: Calculate financial metrics for each scenario
Step 4: Evaluate the range of possible outcomes
šŸ“‰

Break-even Analysis

Determining the point at which revenues equal costs (no profit or loss).

Break-even Quantity = Fixed Costs / (Price - Variable Cost per Unit)

Break-even Analysis Steps:

Step 1: Identify fixed costs (costs that don't change with production volume)
Step 2: Calculate contribution margin (Price - Variable Cost per Unit)
Step 3: Calculate break-even quantity: Fixed Costs / Contribution Margin
Step 4: Calculate break-even revenue: Break-even Quantity Ɨ Price
Real-World Application: Solar Farm Project

Financial Analysis:

  • Initial investment: $12 million
  • Projected annual cash flows: $2.5 million for 10 years
  • Calculated NPV (8% discount rate): $4.78 million
  • IRR: 16.4%
  • Payback period: 5.2 years

Sensitivity Findings: Project remains viable even with 15% lower energy prices or 20% higher maintenance costs.

Key Concepts and Terminology

Time Value of Money: Concept that money available now is worth more than same amount in future

Discount Rate: Interest rate used to calculate present value of future cash flows

Cash Flow: Net amount of cash being transferred into and out of a project

Opportunity Cost: Potential benefits lost when choosing one alternative over another

Hurdle Rate: Minimum acceptable rate of return on an investment

Capital Budgeting: Process of planning expenditures on long-term assets

Working Capital: Short-term assets needed for day-to-day operations

Depreciation: Allocation of asset cost over its useful life

Interactive Learning

Knowledge Check

1. Which financial metric calculates the discount rate that results in an NPV of zero?

Net Present Value (NPV)
Internal Rate of Return (IRR)
Payback Period
Profitability Index

2. What is the primary purpose of sensitivity analysis in financial appraisal?

To determine the exact future cash flows
To examine how changes in key variables affect project outcomes
To calculate the average return on investment
To estimate tax liabilities

3. A project with an NPV of $250,000 should be:

Rejected because NPV should be zero
Accepted because positive NPV adds value
Rejected unless IRR is negative
Accepted only if payback period is less than 1 year

Additional Resources

ā† Back to Cost Estimation Next: Project Scheduling ā†’