--%>
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 : 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 : Define Obligations Obligations : The

    Obligations: The amounts that a governmental unit might legally be needed to pay out of its resources. Budgetary authority should be obtainable before obligations can be formed. For budgetary aims, obligations comprise payables for goods or services r

    		•
  • Q : How management incorporated in proforma

    Describe how management aims are incorporated into proforma financial statements.Management decide a target goal, and forecasters generate proforma financial statements under the assumption that the goal will be

    		•
  • Q : How does depreciation influence cash

    Normal 0 false false

    		•
  • Q : Clarify trade credit is free credit or

    Trade credit is free credit. Do you agree or conflicting with this statement? Clarify. Trade credit is not free. It contains a cost. Who bears that cost based on the terms of the transaction among the grantor and the recipient of the trade c

    		•
  • Q : Impact of an increase in the total

    Normal 0 false false

  • Q : Describe value investing Value

    Value investing is an investment strategy which involves buying securities whose shares appear underpriced by some form(s) of fundamental analysis, like stocks with low Price to Earning or Price to Book value. This strategy basically is of buying stoc

    		•
  • 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 : Shares Assignment Mina Patel has seen

    Assignment Mina Patel has seen attractive advertisements for Dixons Retail plc and its UK-based brands. She is also aware of the intense competition between retailers of electronic and electrical goods, at a time of global economic uncertainty. Mina has recently inherited several thousand pound

    		•
  • Q : Describe the sales forecasting procedure

    Describe the sales forecasting procedure.This is a group effort. Usually sales and marketing personnel provide assessments of demand and the competition. Usually, production personnel provide estimates of manufacturing capacity and other product

    		•