By the end of this lesson, you will be able to

• Apply investment appraisal techniques to a range of capital budgeting scenario

• Able to make appropriate recommendations

So now, let's rewind our past discussion

WHAT IF?

Sensitivity analysis typically involves asking ‘what if?’ questions.

WHAT IF?

For example, what if demand fell by 10% compared to our original forecasts? Would the project still be viable?

FORMULA =

To make a better understanding, let test our knowledge....

Here is a given situation

• You are considering an investment that would cost you RM7,000,000

• Sales of the product is expected to be RM6,500,000 for the next TWO (2) years

• Fixed cost is RM 2,000,000

• Discount rate is 8%

So what is the NPV of this investment?

INITIAL INVESTMENT = (-RM7,000,000)

Remember! Initial investment is our cost. So it is a negative value.

PV for Cash Flow = RM 11,589,500

Remember! Cash Flow is consistent and you must use PV Annuity table

PV for Fixed Cost = (-RM3,566,000)

Yes correct! It is a cost ,thus it is a negative value.

What is our next step?

You have calculated PV

Year 0 = Initial Investment =(RM 7,000,000)

Year 1 -2 = Cash Flow = RM 11,589,500

Year 1 -2 = Fixed Cost =(RM 3,566,000)

Your NPV is RM1,023,500

Because it is a POSITIVE, we should accept this project because it brings us PROFIT!

Now it is time to calculate Sensitivity Analysis

FORMULA

Your sensitivity to INITIAL INVESTMENT IS 14.6%

• Therefore, the initial investment can rise by 14.6% before NPV becomes negative

Your sensitivity to CONTRIBUTION IS 8.83%

• Therefore, the selling price can fall by 8.83% before NPV becomes negative.

Your sensitivity to FIXED COST IS 28.7%

• Therefore, operating costs can rise by 28.7% before NPV becomes negative.

NEXT you have to calculate sensitivity to COST OF CAPITAL

But before that , you need to calculate your IRR

Recommendation

This means that cost of capital can increase by 18.66% before NPV becomes negative.

PROBABILITY ANALYSIS

Let's rewind a little bit about probability analysis

PROBABILITY ANALYSIS

• When there are several possible outcomes for a decision and probabilities can be assigned to each, a probability distribution of expected cash flows can often be estimated. 

• This recognises there are several possible outcomes, not just one.  

The FORMULA for calculating an EV is

EV =∑px

PROBABILITY ANALYSIS

You have to chose between 3 mutually exclusive project

PROJECT 3 should be undertaken

However it should be noted that Project 3 is also the most risky option as it has the widest range of potential outcomes.