IdeaTV:Tools to Power Your Business
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
- the um reason why we developed this tool was because uh the world is getting more
- uncertain and it's getting more uncertain every day and managers are faced with how do I make investments in
- the face of this uncertainty not only that competition is on the increase and so any investment that I make today uh
- is going to get eventually get attacked by competition if it's profitable and I'm going to see my my profits erode
- 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
- 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
- that takes into account that sort of competitive wave with the overlay of uncertainty now this competitive wave as
- you can see in the first chart um and first graphic is uh comprises uh you know four pieces launch from the
- time that you think of making the investment until the time You' actually got the operation going to where You' be
- getting sales so this is where you're putting your money in then you have a ramp up you start off with relatively
- low sales and that kind of ramps up to either a steady growth condition or a steady state condition once you've got
- through the ramp up period is your exploit exploitation period and this is the time that you you're
- making your money but uh alas Along Comes competition and in the erosion period competitors enter and they erode
- away whatever profits you have and your challenge then is to come up with the next
- investment uh what we want to try to do is give managers tools to very rapidly uh and easily assess uh whether whether
- an investment is worth pursuing or not and we allow them to input the the basically 11 pieces of data and very
- rapidly assess what the net present value is the total value uh discounting all your cash flows over time of that
- investment so let's have a look at how this works in the next graphic we show you the judgments on timing dimensions
- and as you can see here in this particular project management or the people who did the first plan have uh
- two years for launch they have three years for the ramp up they have four years for competitive impact and then
- after 14 years uh the the competition has eroded away all the profits and you better be on to something else or I'll
- see you in bankruptcy court uh and that's a judgment we we have to use managerial judgment to make
- our best estimates of what those timings are and uh what I want to try to stress
- here is that the purpose of this tool is to help you be roughly right rather than
- 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
- investment's worth and the places where you can be uh you need to be most sensitive uh to the uh uh being wrong
- you can't be right but you you you can worry about and work on how to make yourself roughly
- 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
- that uh the market charges you to to provide you with capital either in the for of equity or debt and you better
- deliver a better return than that otherwise the Market's going to walk away from you and with an uncertain
- Venture you're going to be expecting that uh cost of capital to be pretty darwn high in this particular project
- they asking 25% and then what you have is a number of investment decisions now the
- investment can take one of two conditions one is where I just keep on putting in money like maintaining a
- research team or running a research lab or whatever the case may be and then second one is tranches of investment
- that I put in say to build a pilot plant or build a plant or buy the land and the
- 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
- million after 6 months and 2 million after 18 months and uh this then specifies when you're putting money in
- in the launch phase hopefully very soon after that you start selling and the ramp up stay starts and that's uh the
- second uh sorry the next graphic and what we're looking at here is under steady state conditions uh what
- are the main drivers of revenues and costs as you can see uh in this particular project they're putting in
- about $7 million uh in fixed costs a year there's a maximum demand rate uh in units per year uh of
- 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
- price that you get of $400 in addition to this when you ramp up your project you also have to build
- up inventory and receiv receivables and that's part of your investment and in this particular project they estimated
- that about 33% of the uh revenues that the compan is making is going to appear either as inventory or
- receivables so that's your operations condition and now what we can do is do the valuation now what this little
- software does is it takes all those data it estimat Ates the net present value of
- that whole profile over time in micros seconds and uh it allows you to get on with discussing what you uh your
- sensitivity and and and what you agree or disagree with with respect to those initial inputs notice I'm not concerned
- about being right here because I know I'm wrong uncertain Investments are wrong and so what I'm going to be doing
- 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
- to do in a project like this is bring on board people with different kinds of expertise that I respect and the deal
- that I cut with them is that if there's any number that they think is wrong they
- need to tell me now not later and they need to give me a best alternative number and the reason why so we can
- listen to the presentation uh of what people have to say and together make a judgment as to what uh the most
- appropriate number might be and notice it now becomes their plan or our plan and not just my
- plan uh in this particular case as you can see at the bottom of the graphic uh if those numbers pan out like I
- initially put in you have a $330,000 Net Present Value positive uh which if you think about it is a little
- bit tricky because if you look up at the uh launch phase we putting about $3 million into this project and we only
- getting 330,000 out so technically you know what I should do is invest but the reality is that little much little by
- 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
- right away is at risk which means I now need to do some sensitivity analysis and
- once again these sensitivity analysis can be done in micros seconds so let's say we got into a discussion if you have
- a look at the next chart about the cost of capital and someone or the group group agrees that you know given the
- riskiness of this project it should be even higher if you put in 30% return return uh required as opposed to
- 25% uh your Net Present Value goes straight south from a $300,000 positive to a $715,000
- negative so this project is very very sensitive to cost of capital alternatively if we look at the
- next graphic what happens if we delay the project in this particular case and this actually in actually happened in a
- real case recently management wanted to delay the project by 6 months while they
- made up the their minds and we said well let's put in what the impact is going to
- be of delaying firstly the uh ramp up time because we're going to wait longer to ramp up and then secondly delaying
- the exploitation time because it's going to take longer to to get exploitation and of course competition is not going
- 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
- around for 6 months trying to make up your mind your project goes from a $330,000 positive to a $693,000
- negative and so this is the cost of indecision a place where you often worried about being wrong is you know
- will we get the demand that we anticipated and here what you can see is that we're going to move from 50,000
- 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
- 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
- getting better estimates of what the demand might be before I start throwing big money at the project and I'd rather
- spend a couple of hundred th000 to find I was dead wrong and to spend $35 million to find out I was dead
- wrong finally uh what we might be concerned about is how quickly are the competitors going to respond and this is
- increasingly a problem for uh people today is competition is getting really aggressive and they come in from all
- parts of the world so in this particular case what said is what happens if these
- 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
- uh takes away your positive Net Present Value and gives you a modest negative but uh overall what we've been able to
- do now is very rapidly uh input management judgments about what the appropriate numbers might be and then do
- very very rapid sensitivity analysis of the outcomes that we get and we can also
- now take this project and compare it to other projects so that we can choose the
- projects that seem to have the best bang for the buck in terms of Net Present Value in relation to initial investment
- [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.
Episode highlights
- Competition and Profit ErosionCompetition can quickly erode profits, making timely decisions crucial.“You better be on to something else or I'll see you in bankruptcy court.”2:40Nov 13, 2009
- Cost of IndecisionDelaying project decisions can lead to significant financial losses.“The cost of indecision can be devastating.”8:34Nov 13, 2009
Tension
40/ 100Low tension





