Preview

Scor eStore.com

Good Essays
Open Document
Open Document
677 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Scor eStore.com
Q1: Is the NPV that is generated by the simulation macro the firm value or from the perspective of Mr.
Bernard?
A: The Simulation tab calculates NPV from the perspective of Mr. Bernard. If you look at the inputs at the top left of the worksheet, Bernard's stake and investment are needed. These are used in the NPV formulas in rows 36 to 39. Please try to understand the formulas.
While this course cannot cover coding for simulations, please do go through the formulas to get an understanding of how optimal action and NPV are being calculated given random outcomes in green cells for Page Views, Conversion Rate, Margin, and Monthly Operating Cost. This does not require any knowledge of simulation. In particular, try to verify
1.
2.
3.
4.
5.

valuation without and with expansion in cells M29 and M30 expansion criterion in cell B31 value of buyout option in cells M32 and M33 which outcome occurs in cells B36 to B39
NPV in cells C36 to C39

The only thing that simulation part does is it keeps on refreshing the spreadsheet, getting a new set of random numbers in each iteration, and keeps track of the outcomes and NPV in iterations. This is a mechanical step that you don't need to verify. Q2: Secondly, we are a bit unclear on the way in which the decision trees can be applied to this case.
Are we correct in assuming that they can be used to generate an expected value, similar to the simulation only simplified?
A: Decision trees can be very useful in understanding what actions Mr. Bernard should take under what scenarios. See an example at the end of this document. Students aren't expected to do a full‐blown analysis of decision trees. They should however
1. create one or more decision trees to visualize the uncertainties (green circles) and decisions
(lavender squares)
2. calculate Bernard's value in some simple scenarios

You May Also Find These Documents Helpful

  • Good Essays

    Lockheed Hbr Case

    • 2679 Words
    • 11 Pages

    NPV = Difference between the present value of cash inflows and the present value of cash outflows.…

    • 2679 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    BGA1 Task 4

    • 343 Words
    • 2 Pages

    Net present value (NPV) method is used to decide whether or not a company should take on a new project or acquisition. The formula for NPV is the difference between the present value of a project’s cash inflows and its cash outflows. To calculate the present values the future cash flows are discounted using the time value of money method. For the project to be accepted the NPV should be positive, because it means the return is greater than the required rate of return; or zero, because that means the return is equal to the required rate of return. However, if negative the project should be rejected, because its return is less than the required rate of return. This required rate of return is also referred to as the cost of capital.…

    • 343 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    NPV is a process in which a company makes an analysis of pros and cons when making investments. Companies use this analysis due to the fact of its efficiency and effectiveness which assist those involved in the investment to perceive the future of that investment. Some of the many benefits in using the technique in NPV when making investment 's for a company is the negative and positive outcome and its effects on the company 's investment, which can determine whether it is a good idea to venture in the investment of the company.…

    • 1228 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    QRB501 Week 5 CAse Study

    • 367 Words
    • 2 Pages

    In this case, investors want to know what corporation is a better investment Corporation A or Corporation B. Calculating year one through five for both companies determined NPV for both corporations. Corporation A NPV= $20,979.21 and Corporation B MPV= $48,035.14. Based on the information provided, Corporation B is the better investment as the company has a higher NPV than Corporation A.…

    • 367 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Math 540 Midterm

    • 2038 Words
    • 9 Pages

    | A decision tree is a diagram consisting of circles decision nodes, square probability nodes, and branches.Answer…

    • 2038 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    Ethics Game

    • 1346 Words
    • 9 Pages

    The simulation will use the following decision model with the indicated critical decision points. You will want to take notes about your decisions and/or make a copy of the screen when you complete the work to assure that you have the information needed to write your reflection at the end of the simulation.…

    • 1346 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    Megastat

    • 6791 Words
    • 28 Pages

    5 Output ............................................................................................................................ 5 Repeat Last Option....................................................................................................... 5 Generate Random Numbers ........................................................................................ 6 Utilities ........................................................................................................................... 6 Insert descriptive information ..........................................................................................6 ChartDataSheet utilities ..................................................................................................…

    • 6791 Words
    • 28 Pages
    Powerful Essays
  • Satisfactory Essays

    From the case study, Case 1.3, compare and contrast the benefits of the influence diagram and decision tree displayed in Figure C1.3. Explain why these two problem representations are good examples of descriptive and normative decision theory.…

    • 2173 Words
    • 8 Pages
    Satisfactory Essays
  • Powerful Essays

    From the case study, Case 1.3, compare and contrast the benefits of the influence diagram and decision tree displayed in Figure C1.3. Explain why these two problem representations are good examples of descriptive and normative decision theory.…

    • 4208 Words
    • 14 Pages
    Powerful Essays
  • Better Essays

    Merck & Co

    • 1066 Words
    • 5 Pages

    2. Build a decision tree that shows the cash flows and probabilities at all stages of the FDA approval process…

    • 1066 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    The NPV and IRR were calculated both with and without NOBPT. Furthermore the replicated NPV was incorrect and as such was corrected using a revised NPV function. The Excel NPV function does not correspond to the finance use of the term NPV. To correct this NPV should be calculated as the present value of future cash flows minus the initial payment, the initial payment is later added outside the parenthesis of the function.…

    • 928 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Smart Steering Support

    • 4248 Words
    • 17 Pages

    On a sunny May morning, Marc Binton, CEO of Bay Area Automobile Gadgets (BAAG), enters the conference room on the 40th floor of the Gates building in San Francisco, where BAAG’s offices are located. The other executive officers of the company have already gathered. The meeting has only one item on its agenda: planning a research and development project to develop a new driver support system (DSS). Brian Huang, Manager of Research and Development, is walking around nervously. He has to inform the group about the R&D strategy he has developed for the DSS. Marc has identified DSS as the strategic new product for the company. Julie Aker, Vice President of Marketing, will speak after Brian. She…

    • 4248 Words
    • 17 Pages
    Powerful Essays
  • Better Essays

    Decision Tree

    • 1076 Words
    • 5 Pages

    You start a Decision Tree with a decision that you need to make. Draw a small square to represent this on the left hand side of a large piece of paper, half way down the page. From this box draw out lines towards the right for each possible solution, and write a short description of the solution along the line. Keep the lines apart as far as possible so that you can expand your thoughts.…

    • 1076 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Table of figures |7 |Figure 2.1 Context Diagram | |9 |Figure 2.2 Parent Diagram | |12 |Figure 2.3 Child diagram, process 1 | |14 |Figure 2.4 Child diagram, process 2 | |15 |Figure 2.5 Child diagram, process 3 | |18 |Figure 2.6 Entity relationship | |19 |Figure 2.7 Use Case Model | |21 |Figure 2.8 Decision tree | |27 |Figure 3.1 ER Diagram | |28 |Figure 3.2 Physical Model | |29 |Figure 3.3 Data Dictionary | |30 |Figure 3.4 Interface design, using Microsoft Word | |30 |Figure 3.5 Interface design, using Visual Basic | |34 |Figure 4.1 Appointment Schedule Table | |35 |Figure 4.2…

    • 3982 Words
    • 16 Pages
    Powerful Essays
  • Powerful Essays

    Compiler Construction

    • 2658 Words
    • 11 Pages

    Brainstorm each of the variables in the decision you want the decision tree to help you make. Write them down on a sheet of paper, or in the margin of your main sheet.…

    • 2658 Words
    • 11 Pages
    Powerful Essays