Yes – because changes in sales volume change both the revenue and the variable costs. Changes in the selling price only affects the revenue.
Simone Azzopardisays
Dear John, thank you for your lectures, they are great 馃檪 I have a question with regards to the units of production. Your example above is 15,000 per year, but what if i have different numbers of units per year, do i add the total and continue following the rest of the equation? Thank you
Thank you for your reply. My scenario is for 5 years with different units per year, i add the total of all units and use the cumulative pv table at 12% for 5 years, is this correct? Thank you once again
No – you can only use the annuity tables if there is an equal cash flow each year. If the units change each year then you discount using the present value tables for each year separately.
sir you said that the rule to obtain sensitivity is npv/ pv of flows affected. what would happen if say more than one flows get affected ? will pv of of both the flows be added up and substituted in the formula you mentioned to get sensitivity?
I used Discount factor at 17% and NPV is -2231, IRR is 16.41 (15%+(5329/7560 x 2%) So Sensitivity of capital= (16.41-15) / 15 x 100% = 9.4% Am I right? Thanks sir.
If there are more than one critical factors, hence the investment has high uncertainty. Can we decide after sensitivity analysis that we should not go ahead with this investment as we may most probably lose money?
To further confirm our decision, should we perform some of the below analysis:? 1. Probability analysis – Expected values 2. Using risk-adjusted discount RATE 3. Adjusted payback PERIOD 4. Simulation
So before accepting an investment from the proposed investments/projects, we do the above analysis to assess its risk and then decide to accept it or not.
You are correct, except that you will not automatically decide not to do a project – it is just that the more uncertainty there is the more you might decide not to risk going ahead.
It is not a problem in the exam – you accept or reject based on whether the NPV is positive or negative. But for written parts you must be able to discuss the relevance of uncertainty.
You certainly have to read the question carefully. In the lease buy question it is made very clear that the scrap value is only relevant if the machine is purchased. In the sensitivity question is says that the final scrap value is 15,000, and scrapping can obviously only occur at the end of the projects life!
Hello, Mr. Moffat! I got the overall idea, but confused with sensitivity for sales volume. Can we use PV of revenue instead of contribution? Follow the same logics: if sales volume fall by 10%, revenue fall by 10% and PV fall by 10%. Same as for contribution. Why don’t we have the same answer as for contribution, if everthing else remain constant? (The question appeared while practicing specimen exam for Sept.2016, question 2). Thank you in advance!
It depends whether increasing the flow is what will cause problems (in which case it is + ) or whether the flow decreasing will cause problems ( in which case it is – )
Mr. Moffat, am I correct in saying that when calculating the PV for Cash inflow in Question 1 (a) only using contribution and not price can only be done if price (and variable cost) remain constant?
Something that worries me is that I understood the whole lecture but I got parts iv and v wrong because in both cases I divided the NPV by the fixed costs (15,000) in part iv and by the scrap value (15,000) in part v and consequently got the wrong answer.
But my understanding was that I wanted to know the percentage change in fixed costs or scrap value because that would ultimately bring the present value of that particular flow down by the same percentage resulting in a NPV of zero and that’s what we are doing, aren’t we. Where am I wrong then?
For the NPV to end up at zero, the PV of the relevant flow has to change by the amount of the current NPV.
So, for example, if the NPV is 100, and the PV of the fixed costs is 1,000. Then for the NPV to fall by 100 to zero, the PV of the fixed costs will have to increase by 100. In percentage terms this is 100/100 = 10% It is always the NPV divided by the PV of the flows that change (expressed as a %).
It should be clear that it would be silly to divide a % by a PV. For cost of capital we have to go back to the basis logic and divide the change needed (0.84) by the current value (15)
Hi John, permit me ask you this question. how do you go about calculating the sensitivity of the price. I mean the percentage of the price change that will lead to the NPV falling to zero thank you
For this particular example we can not, because we do not know the estimated selling price. In general terms you would take the same approach as the others i.e. express the NPV as a % of the present value of those cash flows that would change (which in the same of the price would be the sales revenue flows).
you mean NPV/ present value of sales revenue? this will give me the percentage change in sales revenue. I am preparing for P4 and there is this question Dec 2012 question that asked for this. when i tried going through the solution i didnt understand how it was solved. If use this your approach i will get the percentage change in sales revenue but the question asked for sales price
But surely, if the sales price changes by 10% then the revenue changes by 10% as well! (I know it could be affected by other things, but with sensitivity we can only consider one item at a time)
One other thing is that if there is tax in the question, then the flows that will change if the selling price changes will be the revenue and the tax on the revenue. So you need the net PV of these two. Then express the NPV of the project as a % of it.
Thanks John, an issue here,when we are calculating the sensitivity of change on for example part (iii) which is contribution p.u, why do we put that negative sign yet in our table the final value was a positive??
Now the F9 carries a MCQ do I need to read the text book from cover to cover, or your notes, lectures and the kit will be sufficient to help me pass the exam.
Hello Sir, why lower the sensitivity—> the more worried about item.? how about the higher sensitivity, is the higher sensitivity more optimal? could u plz explain it again. thanks
Its not really a question of calling it the optimum.
The problem is that we are making a decision on forecasts of cash flows, and therefore the actual cash flows may turn out to be different – if they are different then the NPV might turn out to be negative and then we will have made the wrong decision.
The higher the sensitivity the less the chance is of that flow changing enough to affect the decision. However if the sensitivity is low, then it means that even just a small change in the flow will affect the decision. Therefore the lower the sensitivity the more risk we are taking and therefore the more we will try to estimate the flow accurately (or else maybe decide not to take the risk).
dineise18 says
Hello teacher,
I have an issue, why changes in sales volume e contribuition a negative? -2.21%
Thanks in advance
John Moffat says
Because there is only a problem if the sales volume falls or contribution falls – if it were to increase then the NPV gets better and better.
loukasierides says
dear Sir,
thank you for another great lecture. Shouldn’t the volume sensitivity be the NPV / 15000u*sales price?
John Moffat says
No, because if the volume changes then both the revenue and the variable costs will change.
loukasierides says
thank you very much. So. just to be clear, if the question asks for sales volume sensitivity , would that be different from selling price sensitivity?
John Moffat says
Yes – because changes in sales volume change both the revenue and the variable costs. Changes in the selling price only affects the revenue.
Simone Azzopardi says
Dear John, thank you for your lectures, they are great 馃檪
I have a question with regards to the units of production. Your example above is 15,000 per year, but what if i have different numbers of units per year, do i add the total and continue following the rest of the equation?
Thank you
John Moffat says
Thank you for the comment.
The approach remains exactly the same 馃檪
Simone Azzopardi says
Thank you for your reply. My scenario is for 5 years with different units per year, i add the total of all units and use the cumulative pv table at 12% for 5 years, is this correct?
Thank you once again
John Moffat says
No – you can only use the annuity tables if there is an equal cash flow each year. If the units change each year then you discount using the present value tables for each year separately.
rakhi2rakhi says
sir you said that the rule to obtain sensitivity is npv/ pv of flows affected. what would happen if say more than one flows get affected ? will pv of of both the flows be added up and substituted in the formula you mentioned to get sensitivity?
John Moffat says
We can only calculate the sensitivity of one flow at a time (unless two or more flows are directly connected, in which case we would add them up).
mayzin1707 says
Dear Sir,
I used Discount factor at 17% and NPV is -2231, IRR is 16.41 (15%+(5329/7560 x 2%)
So Sensitivity of capital= (16.41-15) / 15 x 100% = 9.4%
Am I right? Thanks sir.
John Moffat says
There is an answer at the back of the lecture notes.
salman7 says
Dear sir,
If there are more than one critical factors, hence the investment has high uncertainty. Can we decide after sensitivity analysis that we should not go ahead with this investment as we may most probably lose money?
To further confirm our decision, should we perform some of the below analysis:?
1. Probability analysis – Expected values
2. Using risk-adjusted discount RATE
3. Adjusted payback PERIOD
4. Simulation
So before accepting an investment from the proposed investments/projects, we do the above analysis to assess its risk and then decide to accept it or not.
Please see if I need correction. Thanks.
John Moffat says
You are correct, except that you will not automatically decide not to do a project – it is just that the more uncertainty there is the more you might decide not to risk going ahead.
It is not a problem in the exam – you accept or reject based on whether the NPV is positive or negative. But for written parts you must be able to discuss the relevance of uncertainty.
pejz says
dear John
my question about the scrap value is why was the value of 15000 discounted and not taken as 15000. thank you for your valued response
John Moffat says
Because the project is scrapped at the end of its life, and so the 15,000 is received in 15 years time.
Candy says
Mr Moffat,
But why in previous example such as Lease vs Buy did we not discount the Scrap?
John Moffat says
But it was discounted – it is always discounted. Obviously not when the asset is leased because then there are no scrap proceeds.
Candy says
I take from this that we have to be extremely careful with reading the question and determining what is being stated.
In Lease buy example it states “will have a scrap value after 4 years of $10,000.”
Whereas in this example it states “final scrap value of $15000”.
I do find this tricky, because if someone tells me there will be a final value of拢xxxx. I take that to mean that is the amount that will be available.
John Moffat says
You certainly have to read the question carefully.
In the lease buy question it is made very clear that the scrap value is only relevant if the machine is purchased.
In the sensitivity question is says that the final scrap value is 15,000, and scrapping can obviously only occur at the end of the projects life!
maria says
Hello, Mr. Moffat!
I got the overall idea, but confused with sensitivity for sales volume. Can we use PV of revenue instead of contribution? Follow the same logics: if sales volume fall by 10%, revenue fall by 10% and PV fall by 10%. Same as for contribution.
Why don’t we have the same answer as for contribution, if everthing else remain constant?
(The question appeared while practicing specimen exam for Sept.2016, question 2).
Thank you in advance!
Moloantoa says
hallo JOHN!!
i did not get the meaning of -/+ sings on the percentages when deriving the sensitivity
regards
John Moffat says
It depends whether increasing the flow is what will cause problems (in which case it is + ) or whether the flow decreasing will cause problems ( in which case it is – )
auret says
Mr. Moffat, am I correct in saying that when calculating the PV for Cash inflow in Question 1 (a) only using contribution and not price can only be done if price (and variable cost) remain constant?
John Moffat says
Yes – you are correct 馃檪
Arun says
Hi John,
Something that worries me is that I understood the whole lecture but I got parts iv and v wrong because in both cases I divided the NPV by the fixed costs (15,000) in part iv and by the scrap value (15,000) in part v and consequently got the wrong answer.
But my understanding was that I wanted to know the percentage change in fixed costs or scrap value because that would ultimately bring the present value of that particular flow down by the same percentage resulting in a NPV of zero and that’s what we are doing, aren’t we. Where am I wrong then?
Thanks in advance!
John Moffat says
For the NPV to end up at zero, the PV of the relevant flow has to change by the amount of the current NPV.
So, for example, if the NPV is 100, and the PV of the fixed costs is 1,000. Then for the NPV to fall by 100 to zero, the PV of the fixed costs will have to increase by 100.
In percentage terms this is 100/100 = 10%
It is always the NPV divided by the PV of the flows that change (expressed as a %).
Kelvin says
Mr John nice to know you
I greatly need your help on sensitivity analysis
It on the fact that how to calculate sensitivity of selling price
John Moffat says
You take exactly the same approach as for the others.
Calculate the present value of the revenue flows (because they are the flows that will change if the selling price changes).
The sensitivity is then the NPV as a percentage of the PV just calculated.
aliimranacca007 says
Dear sir in example in solution for senstivity of cost of capital
by using IRR rate 15.84% and given rate is 15%
in calculation of senstivity of cost of capital you do.
0.84梅15 why you do like this bcoz by formola as you told it will be NPV 梅 pv of variables
John Moffat says
It should be clear that it would be silly to divide a % by a PV. For cost of capital we have to go back to the basis logic and divide the change needed (0.84) by the current value (15)
questforknowledge says
thank you sir John
questforknowledge says
Hi John, permit me ask you this question. how do you go about calculating the sensitivity of the price. I mean the percentage of the price change that will lead to the NPV falling to zero
thank you
John Moffat says
For this particular example we can not, because we do not know the estimated selling price.
In general terms you would take the same approach as the others i.e. express the NPV as a % of the present value of those cash flows that would change (which in the same of the price would be the sales revenue flows).
questforknowledge says
you mean NPV/ present value of sales revenue? this will give me the percentage change in sales revenue. I am preparing for P4 and there is this question Dec 2012 question that asked for this. when i tried going through the solution i didnt understand how it was solved. If use this your approach i will get the percentage change in sales revenue but the question asked for sales price
John Moffat says
But surely, if the sales price changes by 10% then the revenue changes by 10% as well!
(I know it could be affected by other things, but with sensitivity we can only consider one item at a time)
One other thing is that if there is tax in the question, then the flows that will change if the selling price changes will be the revenue and the tax on the revenue. So you need the net PV of these two. Then express the NPV of the project as a % of it.
brenda1 says
Thanks John,
an issue here,when we are calculating the sensitivity of change on for example part (iii) which is contribution p.u, why do we put that negative sign yet in our table the final value was a positive??
John Moffat says
To show that we are only worried about the contribution falling. (If the contribution increased then there would be no problem at all)
cartea says
Now the F9 carries a MCQ do I need to read the text book from cover to cover, or your notes, lectures and the kit will be sufficient to help me pass the exam.
John Moffat says
Our notes and lectures (together with lots of practice using a Revision Kit) are enough to be able to pass the exam.
cartea says
Thank you very much. I understand your lectures more than the text book and and my lecturer. I hope you keep on lecturing we need you.
arman90fy says
Hello Sir,
why lower the sensitivity—> the more worried about item.? how about the higher sensitivity, is the higher sensitivity more optimal? could u plz explain it again. thanks
John Moffat says
Its not really a question of calling it the optimum.
The problem is that we are making a decision on forecasts of cash flows, and therefore the actual cash flows may turn out to be different – if they are different then the NPV might turn out to be negative and then we will have made the wrong decision.
The higher the sensitivity the less the chance is of that flow changing enough to affect the decision. However if the sensitivity is low, then it means that even just a small change in the flow will affect the decision. Therefore the lower the sensitivity the more risk we are taking and therefore the more we will try to estimate the flow accurately (or else maybe decide not to take the risk).
arman90fy says
great explanation dear sir
thanks alot
mayzin1707 says
Sorry! My Apologist! I still did not get what you mean by lower sensitivity = more”worried” about item.
izhar says
Sir if calculation of tax given then how we calculate present value of relevant cash flow ?
jay0v says
Thank you sir! 馃榾
jay0v says
Sir, will the requirements be given in exam asking us which sensitivity to calculate, the initial investment, sales volume, selling price, etc.?
John Moffat says
Yes certainly:-)
If the question wants the sensitivity then it will specify of what.