IdeaTV:Tools to Power Your Business

Knowledge at Wharton

Ask about Knowledge at Wharton

Episode Description

Wharton Professor Ian MacMillan demonstrates an innovative yet simple tool for business planning.

Read the full transcriptHide the full transcript
  1. the um reason why we developed this tool was because uh the world is getting more
  2. uncertain and it's getting more uncertain every day and managers are faced with how do I make investments in
  3. the face of this uncertainty not only that competition is on the increase and so any investment that I make today uh
  4. is going to get eventually get attacked by competition if it's profitable and I'm going to see my my profits erode
  5. over time so we have these two levels of uncertainty one is whether we're going to be able to get the costs and revenues
  6. that we uh anticipated and then the second one is how long we're going to be able to do it and we developed this tool
  7. that takes into account that sort of competitive wave with the overlay of uncertainty now this competitive wave as
  8. you can see in the first chart um and first graphic is uh comprises uh you know four pieces launch from the
  9. time that you think of making the investment until the time You' actually got the operation going to where You' be
  10. getting sales so this is where you're putting your money in then you have a ramp up you start off with relatively
  11. low sales and that kind of ramps up to either a steady growth condition or a steady state condition once you've got
  12. through the ramp up period is your exploit exploitation period and this is the time that you you're
  13. making your money but uh alas Along Comes competition and in the erosion period competitors enter and they erode
  14. away whatever profits you have and your challenge then is to come up with the next
  15. investment uh what we want to try to do is give managers tools to very rapidly uh and easily assess uh whether whether
  16. an investment is worth pursuing or not and we allow them to input the the basically 11 pieces of data and very
  17. rapidly assess what the net present value is the total value uh discounting all your cash flows over time of that
  18. investment so let's have a look at how this works in the next graphic we show you the judgments on timing dimensions
  19. and as you can see here in this particular project management or the people who did the first plan have uh
  20. two years for launch they have three years for the ramp up they have four years for competitive impact and then
  21. after 14 years uh the the competition has eroded away all the profits and you better be on to something else or I'll
  22. see you in bankruptcy court uh and that's a judgment we we have to use managerial judgment to make
  23. our best estimates of what those timings are and uh what I want to try to stress
  24. here is that the purpose of this tool is to help you be roughly right rather than
  25. what I say is precisely wrong you don't want to be wrong to four decimal places you want a pretty good idea of what this
  26. investment's worth and the places where you can be uh you need to be most sensitive uh to the uh uh being wrong
  27. you can't be right but you you you can worry about and work on how to make yourself roughly
  28. right in the next chart we look at the investment profile we uh have put in a cost of capital of 25% this is the money
  29. that uh the market charges you to to provide you with capital either in the for of equity or debt and you better
  30. deliver a better return than that otherwise the Market's going to walk away from you and with an uncertain
  31. Venture you're going to be expecting that uh cost of capital to be pretty darwn high in this particular project
  32. they asking 25% and then what you have is a number of investment decisions now the
  33. investment can take one of two conditions one is where I just keep on putting in money like maintaining a
  34. research team or running a research lab or whatever the case may be and then second one is tranches of investment
  35. that I put in say to build a pilot plant or build a plant or buy the land and the
  36. way this is structured you get three shots at the U investment in in in in lump sums 500,000 at the start uh a
  37. million after 6 months and 2 million after 18 months and uh this then specifies when you're putting money in
  38. in the launch phase hopefully very soon after that you start selling and the ramp up stay starts and that's uh the
  39. second uh sorry the next graphic and what we're looking at here is under steady state conditions uh what
  40. are the main drivers of revenues and costs as you can see uh in this particular project they're putting in
  41. about $7 million uh in fixed costs a year there's a maximum demand rate uh in units per year uh of
  42. 50,000 there's a variable production cost of $150 per unit for each one that you sell and there's a sales revenue or
  43. price that you get of $400 in addition to this when you ramp up your project you also have to build
  44. up inventory and receiv receivables and that's part of your investment and in this particular project they estimated
  45. that about 33% of the uh revenues that the compan is making is going to appear either as inventory or
  46. receivables so that's your operations condition and now what we can do is do the valuation now what this little
  47. software does is it takes all those data it estimat Ates the net present value of
  48. that whole profile over time in micros seconds and uh it allows you to get on with discussing what you uh your
  49. sensitivity and and and what you agree or disagree with with respect to those initial inputs notice I'm not concerned
  50. about being right here because I know I'm wrong uncertain Investments are wrong and so what I'm going to be doing
  51. is uh working with the team to help them help me think where uh they would like to change the input data and what I try
  52. to do in a project like this is bring on board people with different kinds of expertise that I respect and the deal
  53. that I cut with them is that if there's any number that they think is wrong they
  54. need to tell me now not later and they need to give me a best alternative number and the reason why so we can
  55. listen to the presentation uh of what people have to say and together make a judgment as to what uh the most
  56. appropriate number might be and notice it now becomes their plan or our plan and not just my
  57. plan uh in this particular case as you can see at the bottom of the graphic uh if those numbers pan out like I
  58. initially put in you have a $330,000 Net Present Value positive uh which if you think about it is a little
  59. bit tricky because if you look up at the uh launch phase we putting about $3 million into this project and we only
  60. getting 330,000 out so technically you know what I should do is invest but the reality is that little much little by
  61. way of return is a is an awful little return in the face of the big investment that you're making so I would treat this
  62. right away is at risk which means I now need to do some sensitivity analysis and
  63. once again these sensitivity analysis can be done in micros seconds so let's say we got into a discussion if you have
  64. a look at the next chart about the cost of capital and someone or the group group agrees that you know given the
  65. riskiness of this project it should be even higher if you put in 30% return return uh required as opposed to
  66. 25% uh your Net Present Value goes straight south from a $300,000 positive to a $715,000
  67. negative so this project is very very sensitive to cost of capital alternatively if we look at the
  68. next graphic what happens if we delay the project in this particular case and this actually in actually happened in a
  69. real case recently management wanted to delay the project by 6 months while they
  70. made up the their minds and we said well let's put in what the impact is going to
  71. be of delaying firstly the uh ramp up time because we're going to wait longer to ramp up and then secondly delaying
  72. the exploitation time because it's going to take longer to to get exploitation and of course competition is not going
  73. to let you off so they're going to come in you know just as as soon and that basically means is if you sit diddling
  74. around for 6 months trying to make up your mind your project goes from a $330,000 positive to a $693,000
  75. negative and so this is the cost of indecision a place where you often worried about being wrong is you know
  76. will we get the demand that we anticipated and here what you can see is that we're going to move from 50,000
  77. units down to 45,000 units and if that happens and we don't achieve our demand uh we're suddenly going to go to a
  78. negative uh $1.2 million so one of the things I'd be really worried about with this project is to spend some time I'm
  79. getting better estimates of what the demand might be before I start throwing big money at the project and I'd rather
  80. spend a couple of hundred th000 to find I was dead wrong and to spend $35 million to find out I was dead
  81. wrong finally uh what we might be concerned about is how quickly are the competitors going to respond and this is
  82. increasingly a problem for uh people today is competition is getting really aggressive and they come in from all
  83. parts of the world so in this particular case what said is what happens if these
  84. guys come in and start eating our lunch after 3.5 years instead of four years and as you can see what that does is it
  85. uh takes away your positive Net Present Value and gives you a modest negative but uh overall what we've been able to
  86. do now is very rapidly uh input management judgments about what the appropriate numbers might be and then do
  87. very very rapid sensitivity analysis of the outcomes that we get and we can also
  88. now take this project and compare it to other projects so that we can choose the
  89. projects that seem to have the best bang for the buck in terms of Net Present Value in relation to initial investment
  90. [Music]

Brief Summary

Investment strategies in uncertain markets using a new assessment tool are discussed, emphasizing sensitivity analysis and timely decision-making.

Key points

  • Investment Tool Development. A new tool was developed to help managers navigate increasing uncertainty in investments.
  • Competition and Profit Erosion. Competition can quickly erode profits, making timely decisions crucial.
  • Cost of Indecision. Delaying project decisions can lead to significant financial losses.

Tension

40/ 100Low tension

Related episodes