In this, the last of my three posts on uncertainty, I complete the cycle I started with a look at the responses (healthy and unhealthy) to uncertainty and followed up with an examination of the Margin of Safety, by taking a more extended look at one approach that I have found helpful in dealing with uncertainty, which is to run simulations. Before you read this post, I should warn you that I am not an expert on simulations and that the knowledge I bring to this process is minimalist and my interests are pragmatic. So, if you are an expert in statistics or a master simulator, you may find my ramblings to be amateurish and I apologize in advance.

**Setting the Stage**
The tools that we use in finance were developed in simpler times, when data was often difficult (or expensive) to access and sophisticated statistical tools required machine power that was beyond the reach of most in the finance community. It should come as no surprise then that in discounted cash flow valuation, we have historically used point estimates ( single numbers that reflect best judgments at the time of the valuation) for variables that have probability distributions attached to them. To illustrate, in my valuation of Apple in February 2016, I used a revenue growth rate of 2.2% and a target operating margin of 25%, to arrive at my estimate of value per share of $129.80.

It goes without saying (but I will say it anyway) that I will be wrong on both these numbers, at least in hindsight, but there is a more creative way of looking at this estimation concern. Rather than enter a single number for each variable, what if I were able to enter a probability distribution? Thus, my estimate for revenue growth would still have an expected value of 2.2% (since that was my best estimate) but would also include a probability distribution that reflected my uncertainty about that value. That distribution would capture not only the magnitude of my uncertainty (in a variance or a standard deviation) but also which direction I expect to be wrong more often (whether the growth is more likely to be lower than my expected value or higher). Similarly, the expected value for the operating margin can stay at 25% but I can build in a range that reflects my uncertainty about this number.

Once you input the variables as distributions, you have laid the foundations for a probabilistic valuation or more specifically, for a simulation, where in each run, you pick one outcome out of each distribution (which can be higher or lower than your expected values) and estimate a value for the company based on the drawn outcomes. Once you have run enough simulations, your output will be a distribution of values across simulations. If the distributions of your variables are built around expected values that match up to the numbers that you used in your point estimate valuation, the expected value across the simulations will be close to your point estimate value. That may seem to make the simulation process pointless, but there are side benefits that you get from simulations that enrich your decision process. In addition to the expected value, you will get a measure of how much variability there is in this value (and thus the risk you face), the likelihood that you could be wrong in your judgment of whether the stock is under and over valued and the potential payoffs to be right and wrong.

**Statistical Distributions: A Short Preview**

It is a sad truth that most of us who go through statistics classes quickly consign them to the “I am never going to use this stuff” heap and move on, but there is no discipline that is more important in today’s world of big data and decision making under uncertainty. If you are one of those fortunate souls who not only remembers your statistics class fondly but also the probability distributions that you encountered during the class, you can skip this section. If, like me, the only memory you have of your statistics class is of a bell curve and a normal distribution, you need to expand your statistical reach beyond a normal distribution, because much of what happens in the real world (which is what you use probability distributions to capture) is not normally distributed. At the risk of over simplifying the choices, here are some basic classifications of uncertainties/ risks::

__Discrete versus Continuous Distributions__: Assume that you are valuing an oil company in Venezuela and that you are concerned that the firm may be nationalized, a risk that either occurs or does not, i.e., a discrete risk. In contrast, the oil company's earnings will move with oil prices but take on a continuum of values, making it a continuous risk. With currency risk, the risk of devaluation in a fixed exchange rate currency is discrete risk but the risk in a floating rate currency is continuous.__Symmetric versus Asymmetric Distributions (Symmetric, Positive skewed, Negative skewed):__While we don't tend to think of upside risk, risk can deliver outcomes that are better than expected or worse than expected. If the magnitude and likelihood of positive outcomes and negative outcomes is similar, you have a symmetric distribution. Thus, if the expected operating margin for Apple is 25% and can vary with equal probability from 20% to 30%, it is symmetrically distributed. In contrast, if the expected revenue growth for Apple is 2%, the worse possible outcome is that it could drop to -5%, but there remains a chance (albeit a small one) that revenue growth could jump back to 25% (if Apple introduces a disruptive new product in a big market), you have an a positively skewed distribution. In contrast, if the expected tax rate for a company is 35%, with the maximum value equal to the statutory tax rate of 40% (in the US) but with values as low as 0%, 5% or 10% possible (though not likely), you are looking at a negatively skewed distribution.__Extreme outcome likelihood (Thin versus Fat Tails)__: There is one final contrast that can be drawn between different risks. With some variables, the values will be clustered around the expected value and extreme outcomes, while possible, don't occur very often; these are thin tail distributions. In contrast, there are other variables, where the expected value is just the center of the distribution and actual outcome that are different from the expected value occur frequently, resulting in fat tail distributions.

I know that this is a very cursory breakdown, but if you are interested, I do have a short paper on the basics of statistical distributions (link below), written specifically with simulations in mind.

**Simulation Tools**

I was taught simulation in my statistics class, the old fashioned way. My professor came in with three glass jars filled with little pieces of paper, with numbers written on them, representing the different possible outcomes on each variable in the problem (and I don't even remember what the problem was). He then proceeded to draw one piece of paper (one outcome) out of each jar and worked out the solution, with those numbers and wrote it on the board. I remember him meticulously returning those pieces of paper back into the jar (sampling with replacement) and at the end of the class, he proceeded to compute the distribution of his solutions.

While the glass jar simulation is still feasible for simulating simple processes with one or two variables that take on only a few outcomes, it is not a comprehensive way of simulating more complex processes or continues distributions. In fact, the biggest impediment to using simulation until recently would have been the cost of running one, requiring the use of a mainframe computer. Those days are now behind us, with the evolution of technology both in the form of hardware (more powerful personal computers) and software. Much as it is subject to abuse, Microsoft Excel has become the lingua franca of valuation, allowing us to work with numbers with ease. There are some who are conversant enough with Excel's bells and whistles to build simulation capabilities into their spreadsheets, but I am afraid that I am not one of those. Coming to my aid, though, are offerings that are add-ons to Excel that allow for the conversion of any Excel spreadsheet almost magically into a simulation.

I normally don't make plugs for products and services, even if I like them, on my posts, because I am sure that you get inundated with commercial offerings that show up insidiously in Facebook and blog posts. I am going to make an exception and praise Crystal Ball, the Excel add-on that I use for simulations. It is an Oracle product and you can get a trial version by going here. (Just to be clear, I pay for my version of Crystal Ball and have no official connections to Oracle.) I like it simply because it is unobtrusive, adding a menu item to my Excel toolbar, and has an extremely easy learning curve.

My only critique of it, as a Mac user, is that it is offered only as a PC version and I have to run my Mac in MS Windows, a process that I find painful. I have also heard good things about @Risk, another excel add-on, but have not used it.

While the glass jar simulation is still feasible for simulating simple processes with one or two variables that take on only a few outcomes, it is not a comprehensive way of simulating more complex processes or continues distributions. In fact, the biggest impediment to using simulation until recently would have been the cost of running one, requiring the use of a mainframe computer. Those days are now behind us, with the evolution of technology both in the form of hardware (more powerful personal computers) and software. Much as it is subject to abuse, Microsoft Excel has become the lingua franca of valuation, allowing us to work with numbers with ease. There are some who are conversant enough with Excel's bells and whistles to build simulation capabilities into their spreadsheets, but I am afraid that I am not one of those. Coming to my aid, though, are offerings that are add-ons to Excel that allow for the conversion of any Excel spreadsheet almost magically into a simulation.

I normally don't make plugs for products and services, even if I like them, on my posts, because I am sure that you get inundated with commercial offerings that show up insidiously in Facebook and blog posts. I am going to make an exception and praise Crystal Ball, the Excel add-on that I use for simulations. It is an Oracle product and you can get a trial version by going here. (Just to be clear, I pay for my version of Crystal Ball and have no official connections to Oracle.) I like it simply because it is unobtrusive, adding a menu item to my Excel toolbar, and has an extremely easy learning curve.

My only critique of it, as a Mac user, is that it is offered only as a PC version and I have to run my Mac in MS Windows, a process that I find painful. I have also heard good things about @Risk, another excel add-on, but have not used it.

**Simulation in Valuation**

There are two aspects of the valuation process that make it particularly well suited to Monte Carlo simulations. The first is that uncertainty is the name of the game in valuation, as I noted in my first post in the series. The second is that valuation inputs are often estimated from data, and that data can be plentiful at least on some variables, making it easier to estimate the probability distributions that lie at the heart of simulations. The sequence is described in the picture below:

**Step 1: Start with a base case valuation**The first place to start a simulation is with a base case valuation. In a base case valuation, you do a valuation with your best estimates for the inputs into value from revenue growth to margins to risk measures. Much as you will be tempted to use conservative estimates, you should avoid the temptation and make your judgments on expected values. In the case of Apple, the numbers that I use in my base case valuation are very close to those that I used just a couple of months ago, when I valued the company after its previous earnings report and are captured in the picture below:

Download spreadsheet |

**Step 2: Identify your driver variables**
While there are multiple inputs into valuation models that determine value, it remains true that a few of these inputs drive value and that the rest go along for the ride. But how do you find these value drivers? There are two indicators that you can use. The first requires trial and error, where you change each input variable to see which ones have the greatest effect on value. It is one reason that I like parsimonious models, where you use fewer inputs and aggregate numbers as much as you can. The second is more intuitive, where you focus on the variable that investors in the company seem to be most in disagreement about. My Apple valuation is built around four inputs: revenue growth (growth), operating margin (profitability), the sales to capital ratio (investment efficiency) and cost of capital (risk). The graph below captures how much value changes as a function of these inputs:

As you can see the sales to capital ratio has little effect on value per share, largely because the base case growth rate that I use for Apple is so low. Revenue growth and operating margin both affect value significantly and cost of capital to a much lesser degree. Note that the value per share is higher than the current price though every single what-if analysis, but that reflects the fact that only variable at a time in being changed in this analysis. It is entirely possible that if both revenue growth and operating margins drop at the same time, the value per share will be lower than $93 (the stock price at the time of this analysis) and one of the advantages of a Monte Carlo simulation is that you can build in interconnections between variables. Looking at the variables through the lens that investors have been using to drive the stock price down, it seems like the front runner for value driver has to be revenue growth, as Apple reported its first year on year negative revenue growth in the last quarter and concerns grow about whether the iPhone franchise is peaking. Following next on the value driver list is the operating margin, as the competition in the smart phone business heats up.

**Step 3: The Data Assessment**
Once you have the value drivers identified, the next step is
collecting data on these variables, as a precursor for developing probability distributions. In developing the
distributions, you can draw on the following:

__Past data__: If the value driver is a macroeconomic variable, say interest rates or oil prices, you can draw on historical data going back in time. My favored site for all things macroeconomic is FRED, the Federal Reserve data site in St. Louis, a site that combines great data with an easy interface and is free. I have included data on interest rate, inflation, GDP growth and the weighted dollar for those of you interested in US data in the attached link. For data on other countries, currencies and markets, you can try the World Bank data base, not as friendly as FRED, but rich in its own way.__Company history__: For companies that have been in existence for a long time, you can mine the historical data to get a measure of how key company-specific variables (revenues, operating margin, tax rate) vary over time.__Sector data__: You can also look at cross sectional differences in key variables across companies in a sector. Thus, to estimate the operating margin for Amazon, you could look at the distribution of margins across retail companies.: If the value driver is a macroeconomic variable, say interest rates or oil prices, you can draw on historical data going back in time. My favored site for all things macroeconomic is FRED, the Federal Reserve data site in St. Louis, a site that combines great data with an easy interface and is free. I have included data on interest rate, inflation, GDP growth and the weighted dollar for those of you interested in US data in the attached link. For data on other countries, currencies and markets, you can try the World Bank data base, not as friendly as FRED, but rich in its own way.

In the case of Apple, I isolated my data assessment to three variables: revenue growth, operating margin and the cost of capital. To get some perspective on the range and variability in revenue growth rates and operating margins, I started by looking at the values for these numbers annually from 1990 to 2015:

This extended time period does distract from the profound changes wrought at Apple over the last decade by the iPhone. To takes a closer look at its effects, I looked at growth and margins at Apple for every quarter from 2005 to the first quarter of 2016 :

Superimposed on this graph of gyrating revenue growth, I have traced the introduction of the different iPhone models that have been largely responsible for Apple's explosive growth over the last decade. There are a few interesting patterns in this graph. The first is that revenue growth is clearly driven by the iPhone cycle, peaking soon after each new model is introduced and fading in the quarters after. The second is that the effect of a new iPhone on revenue growth has declined with each new model, not surprising given the scaling up of revenues as a result of prior models. The third is that the operating margins have been steady through the iPhone cycles, with only a midl dip in the last cycle. There is good news and bad news in this graph for Apple optimists. The good news is that the iPhone 7 will deliver an accelerator to the growth but the bad news is that it will be milder that the prior versions; if the trend lines hold up, you are likely to see only a 10-15% revenue growth in the quarters right after its introduction.

To get some perspective on what the revenue growth would look like for Apple, if it's iPhone franchise fades, I looked at the compounded annual revenue growth for US technology firms older than 25 years that were still listed and publicly traded in 2016:

Of the 343 firms in the sample, 26.2% saw their revenues decline over the last 10 years. There is a sampling bias inherent in this analysis, since the technology firms with the worst revenue growth declines over the period may not have survived until 2016. At the same time, there were a healthy subset of aging technology firms that were able to generate revenue growth in the double digits over a ten-year period.

**Step 4: Distributional Assumptions**There is no magic formula for converting the data that you have collected into probability distributions, and as with much else in valuation, you have to make your best judgments on three dimensions.

*Distribution Type:*In the section above, I broadly categorized the uncertainties you face into discrete vs continuous, symmetric vs skewed and fat tail vs thin tail. At the risk of being tarred and feathered for bending statistical rules, I have summarized the distribution choices based on upon these categorizations. The picture is not comprehensive but it can provide a road map though the choices:*Di**stribution Parameters:*Once you have picked a distribution, you will have to input the parameters of the distribution. Thus, if you had the good luck to have a variable be normally distributed, you will only be asked for an expected value and a standard deviation. As you go to more complicated distributions, one way to assess your parameter choices to look at the full distribution, based upon your parameter choices, and pass it through the common sense test.

Note the correlation between the two, which I will talk about in the next section.

*Step 5: Build in constraints and correlations*There are two additional benefits that come with simulations. The first is that you can build in constraints that will affect the company's operations, and its value, that are either internally or externally imposed. For an example of an external constraint, consider a company with a large debt load. That does not apply to Apple but it would to Valeant. If the company's value drops below the debt due, you could set the equity value to zero, on the assumption that the company will be in default. As another example, assume that you are valuing a bank and that you model regulatory capital requirements as part of your valuation. If the regulatory capital drops below the minimum required, you can require the company to issue more shares (thus reducing the value of your equity). The second advantage of a simulation is that you can build in correlations across variables, making it more real life. Thus, if you believe that bad outcomes on margins (lower margins than expected) are more likely to go with bad outcomes on revenue growth (revenue growth lower than anticipated), you can build in a positive correlation between the variables. With Apple, I see few binding constraints that will affect the valuation. The company has little chance of default and is not covered by regulatory constraints on capital. I do see revenues and operating margins moving together and I build in this expectation by assuming a correlation of 0.50 (lower than the historical correlation of 0.61 between revenues and operating margin from 1989 to 2015 at Apple).

**Step 6: Run the simulations**
Using my base case valuation of Apple (which yielded the value per share of $126.47) as my starting point and inputting the distributional assumptions for revenue growth and operating margin, as well as the correlation between the two, I used Crystal Ball to run the simulations (leaving the number at the default of 100,000) and generated the following distribution for value:

The percentiles of value and other key statistics are listed on the side. Could Apple be worth less than $93/share. Yes, but the probability is less than 10%, at least based on my assumptions. Having bought and sold Apple three times in the last six years (selling my shares last summer), this is undoubtedly getting old, but I am an Apple shareholder again. I am not a diehard believer in the margin of safety, but if I were, I could use this value distribution to create a more flexible version of it, increasing it for companies with volatile value distributions and reducing it for firms with more stable ones.

The most serious concern that I have, as an investor, is that I am valuing cash , which at $232 billion is almost a third of my estimated value for Apple, as a neutral asset (with an expected tax liability of $28 billion). Some of you, who have visions of Apple disrupting new businesses with the iCar or the iPlane may feel that this is too pessimistic and that there should be a premium attached for these future disruptions. My concern is the opposite, i.e., that Apple will try to do too much with its cash, not too little. In my post on aging technology companies, I argued that, like aging movie stars in search of youth, some older tech companies throw money at bad growth possibilities. With the amount of money that Apple has to throw around, that could be deadly to its stockholders and I have to hope and pray that the company remains restrained, as it has been for much of the last decade.

The most serious concern that I have, as an investor, is that I am valuing cash , which at $232 billion is almost a third of my estimated value for Apple, as a neutral asset (with an expected tax liability of $28 billion). Some of you, who have visions of Apple disrupting new businesses with the iCar or the iPlane may feel that this is too pessimistic and that there should be a premium attached for these future disruptions. My concern is the opposite, i.e., that Apple will try to do too much with its cash, not too little. In my post on aging technology companies, I argued that, like aging movie stars in search of youth, some older tech companies throw money at bad growth possibilities. With the amount of money that Apple has to throw around, that could be deadly to its stockholders and I have to hope and pray that the company remains restrained, as it has been for much of the last decade.

**Conclusion**
Uncertainty is a fact of life in valuation and nothing is gained by denying its existence. Simulations offer you an opportunity to look uncertainty in the face, make your best judgments and examine the outcomes. Ironically, being more open about how wrong you can be in your value judgments will make you feel more comfortable about dealing with uncertainty, not less. If staring into the abyss is what scares you, take a peek and you may be surprised at how much less scared you feel.

Introductory Post: DCF Valuations: Academic Exercise, Sales Pitch or Investor Tool

**YouTube video**

**Attachments**- Paper on probability distributions
- Apple valuation - May 2016
- Link to Oracle Crystal Ball trial offer

**Uncertainty Posts**

- DCF Myth 3: You cannot do a valuation, when there is too much uncertainty
- The Margin of Safety: Excuse for Inaction or Tool for Action?
- Facing up to Uncertainty: Probabilities and Simulations

**DCF Myth Posts**

Introductory Post: DCF Valuations: Academic Exercise, Sales Pitch or Investor Tool

- If you have a D(discount rate) and a CF (cash flow), you have a DCF.
- A DCF is an exercise in modeling & number crunching.
- You cannot do a DCF when there is too much uncertainty.
- The most critical input in a DCF is the discount rate and if you don’t believe in modern portfolio theory (or beta), you cannot use a DCF.
- If most of your value in a DCF comes from the terminal value, there is something wrong with your DCF.
- A DCF requires too many assumptions and can be manipulated to yield any value you want.
- A DCF cannot value brand name or other intangibles.
*A*DCF yields a conservative estimate of value.- If your DCF value changes significantly over time, there is something wrong with your valuation.
- A DCF is an academic exercise.

Prof,

ReplyDeleteWith all due respect, I think your belief that Apple will try to do too much with its cash, not too little, is unsound.

If Apple's $204 billion net-tax cash is a company, it would be the world's 19th largest company in terms of market cap, bigger than Verizon, Novartis and Alibaba.

If Berkshire Hathaway has problem in deploying its (growing) $60 billion cash into viable investments, I don't see how Apple not having a bigger similar problem. I mean, spending $100 billion sanely is not easy.

I would value Apple's cash at discount, given its potentially lower returns vs cost of equity. But I may be wrong on Tim Cook.

Fung,

ReplyDeleteI am puzzled since you seem to be making the same point that I am. If you believe that Apple, if it tries to invest its cash in new businesses/investments is likely to be making bad investments, are you not also saying that your biggest fear is that Apple will try to do too much with its cash, not too little?

Prof,

ReplyDeleteSorry for the bad presentation of my idea.

I was actually saying that...

Apple has too much cash to spend, hence it is hard for them to find enough opportunities to generate adequate returns (a.k.a. "The Berkshire-Hathaway Problem")not...

Apple will make bad investments because they have too much to spendI don't think Apple's investment/capex acumen is bad. In fact, I think they are over prudent in deploying their cash. If they keep piling up their cash at this rate without making any significant $10-50bilion-ish investment and still not paying out the profits they don't need, Apple will become a 'cash company' in 1-2 years.

IMO, I think Apple should pay out 100% of their future earnings because they have more than enough cash to fund growth.

Bottom-line: I value Apple's cash at discount because there's nothing much they can do with it. The cash pile is simply too huge.

Awesome! Loving your work all the way from Auckland, NZ. Keep it coming and make a visit down here one day.

ReplyDeleteUnfortunately all this mathematical precision and numerical analysis is completely irrelevant, in fact dangerous in valuation and success in investing in any stock. Too much brain power dedicated to things that are of virtually zero importance.

ReplyDeleteFung,

ReplyDeleteIn this case, Warren Buffett is not wrong but he is being narrow in his approach. His approach, supposedly based upon the risk free rate as the discount rate and "predictable" owners' earnings as cash flows, is a version of DCF called certainty equivalent valuation (he does not call it that, but that is what it is). It may actually work if the only companies you ever value (and thus even look at) are mature or over-the-hill companies. Not surprisingly, if you try to to use Buffett's approach on a Facebook or a Google, it will never be cheap. Take a look at Berkshire Hathaway's portfolio over time and you see the consequences. They will keep loading up on IBM but have never ever held Amazon and Facebook at any point in time. The world of old-time value investing is shrinking by the day.

Hello Prof. Damodaran,

ReplyDeleteAgree with your comment that if one used "old-time" investing techniques, companies like Amazon and Facebook would have been ignored. Heck, even Apple in the late 90's would have been ignored.

Must admit, I should have loaded up on Facebook when the share price was in late teen's about 18+ months ago. That's my current regret. That company similar to Apple is a cash-cow and I don't use that term in any negative way.

Prof,

ReplyDeleteThanks for your response, although I think the topic was slightly deviated.

I think Mr. Buffett's reluctance to buy Facebook or Amazon has nothing to do with his valuation method, but rather his understanding in those businesses. He speaks highly on Bezos nowadays and he might finally got some clues on how to value Amazon, but it's too late to lay a dime.

On IBM, I'm pretty sure that most of Berkshire's subsidiaries are IBM's clients and Mr. Buffett knows very well how sticky his subsidiaries are to IBM. Given Berkshire's size, IBM is a decent investment - 3% dividend yield for a USD13.8 billion investment = USD421 million income (and growing). Tell me if you can find a better deal today if you have USD13.8 billion to deploy. (Todd and Ted think Apple is the answer)

Many people forgot that Berkshire's opportunity costs are getting lower and lower due to its size (same goes to Apple), so they bashed Mr. Buffett for buying IBM. Try putting on his cap and you'll why he has no choice.

Fung,

ReplyDeleteYou can believe whatever you want to believe but I have a question for you. Name me the last great growth company that Buffett bought for its growth. I cannot name one. The man is a great investor in his space, which is mature, cash-generating companies with solid moats but don't give him credit for things he does not do. The face that he really likes and gets along with Bill Gates does not obscure the reality that he never invested in Microsoft when it was a great growth company. If he invests in it now, it is only because it has become a cash cow (and that is my point about IBM as well).

Prof,

ReplyDeleteMy apology for speculating on Mr. Buffett's mind, which I shouldn't. As you can tell by now, I'm a huge fan of Mr. Buffett.

Well, I guess different people define 'growth' differently. Most people did not realize that, since BRK started buying IBM in 2011, the trend of dividend per share was $2.90, 3.30, 3.70, 4.25 and 5.00, a CAGR of 14.6%. Sure, it looked like rubbish to the 30-50% annual growth of FB/AMZN, but at least BRK didn't pay a lot for that growth.

In the end, it boils down to opportunity costs. Try imagine this - if Mr. Buffett somehow say yes to AMZN and FB, and he had $13.8 billion X2 to allocate to both stocks in the past 5 years, do you think he can accumulate them at attractive valuation?

If you are good at imagination, you'll probably be trembling to think about betting $13.8 billion into some unpredictable growth, at gung-ho valuation.

P/s: prof don't get me wrong, I'm a huge fan of both AMZN and FB

The world of old-time value investing is shrinking by the day.

ReplyDeleteProf D: This is a comment you made somewhere, above. Would you please expoud/elaborate the thought further? Thank you

Regarding investing in growth companies using DCF, CAPM, i almost never can find a growth company, even using aggressive revenue and margin assumptions that justify buying a stock vs. the market price. Can you respond to this? Is it as simple as waiting for over priced stocks vs. fundamental assumptions to correct? Sometimes that may take quite some time.

ReplyDeleteThank you.

Dear Prof. Damodaran,

ReplyDeleteI have read one of your papers on taxes in valuation, namely dealing with deferred tax liabilities (both current and the PV of future ones based on the difference between marginal and effective tax rates), and have been able to fully grasp the logic. However, I was surprised to see it was not incorporated in your valuation model that you had provided (on Apple, in this very case). I would appreciate if you could clarify the reason (perhaps, it is insignificant and ignored on purpose)?

Kind regards,

Tim

Professor,

ReplyDeleteWith Monte Carlo simulations, one should use Dependency Ranking. This technique highlights which assumptions are more important, by order.

The process to run dependency ranking is quite simple: test each assumption individually and find the stress-point for each (say, the point where Apple's value is <= $90/share). Then, simply calculate the variance in percentage points from that stress point to the base case assumption.

The smaller the variances, the more sensitive the assumption is (and therefore the ones with the highest impact on value).

It is quite easy to build a macro using VBA to run such a test. If you are interested, I can adapt your model.