--%>
Assignment Help - homework help

Mascot Simulation

Simulation with Crystal Ball


Provided Workbook: Mascot Simulation
Relevant Readings:"Discounted Cash Flow Modeling" folder + Textbook Chapter 4.
This is an individual assignment.

 


Mascot Industries (B)


Consider Mascot's investment decision modeled in HW2.
Mascot now realizes that some of the assumptions made are not quite correct.

For example, the projected receivables for both machines are rather unreliable. It is likely that such projections will diverge significantly from their originally estimated 4-year mean. A normal distribution around the mean, with twice the originally predicted 4-year standard deviation, sounds reasonable to reflect such uncertainty.

Also, the purchase price of the new machine is not guaranteed. Most likely, Mascot will pay the originally estimated amount but it is possible that the price be as low as $240,000 or as high as $270,000. Mascot agrees that the uncertain purchase price should follow a triangular distribution.

Mascot's CFO wants to evaluate how these uncertain variables might affect the project's net present value.


Using Crystal Ball, run a simulation in Workbook "Mascot Simulation B" and provide answers to the following questions. Make sure that you copy the full report of your simulation in a separate worksheet.
You will also be asked to load your spreadsheet at the end of this assignment.

Questions.
Using the distributions described above, set up a simulation in the "Crystal Ball Model B" worksheet.
Run 10,000 trials and attach the full report in a worksheet called "simulation B".

In the "Interpretation" worksheet, provide answers to the following questions:

1) Based on simulation results, are you 100% confident that Mascot should acquire the new machine? Explain.
2) How much effort should Mascot allocate at securing the lowest possible purchase price for the new machine? Explain using the simulation results.

   Related Questions in Finance Basics

  • Q : Describe the P-E valuation method

    Describe the P/E valuation method. Under what conditions a stock should be valued by using this method?The P/E ratio denotes how much investors are keen to pay for each dollar of a stock's earnings. A high P/E ratio denotes that investors belie

    		•
  • Q : What are Feeder Funds Feeder Funds :

    Feeder Funds: For lawful basis accounting purposes, funds into which some taxes or fees are deposited on collection. In some situations administrative costs, collection expenses, and refunds are paid. The balance of such funds is transferable at any t

    		•
  • Q : Unsustainable previous interest rate

    Normal 0 false false

  • Q : Reducing payroll costs It is likely

    It is likely that in the next few years, employers will face incresing pressures to reduce their payroll costs. critically evaluate the range of ways by which payroll costs can be reduced whilst taking into account the need to maintain a focus on the

    		•
  • Q : Correlate each to the New Economy

    Normal 0 false false

  • Q : Productivity growth in quantitative

    Normal 0 false false

    		•
  • Q : Are there security and soundness

    Are there security & soundness implications of mergers?No. All mergers needs regulatory approval and are subject to intense examination through regulators. If anything, the influence on safety and soundness is in general positive, as mergers

    		•
  • Q : Cause-and-effect chain Normal 0 false

    Normal 0 false false

    		•
  • Q : Explain Merger Merger : A merger takes

    Merger: A merger takes place whenever two companies unite to form a single company. This is very alike to an acquisition or takeover, apart from that the existing stock-holders of both companies comprised retain a shared interest in the latest corpora

    		•
  • Q : Advantages of corporation in countries

    Describe some primary advantages while a corporation has operations in countries other than its home country? Explain risks? Foreign operations may decrease a company's labour or material costs, and may raise its sales. Risks comprise possible

    		•