--%>
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 : Define the term floor Floor: The

    Floor: The Assembly or Senate chambers or the word employed to explain the location of a bill or the kind of session. Matters might be termed to as “on the floor”.

    		•
  • Q : Describe benefits of collecting early

    Describe benefits of "collecting early" and how do companies effort to do this? Money contains time value. The sooner cash is gathered, the better. Companies employ regional collection centres and lock boxes to facilitate this.

    		•
  • Q : Conditions in which warrants value high

    Under what conditions is a warrant's value high? Describe. A warrant's value would be great when the stock price, time to expiration, and/or expected stock price volatility is great.

    		•
  • Q : Define General Fund General Fund (GF):

    General Fund (GF): For lawful basis accounting and budgeting aims, the predominant fund for the financing state government programs, employed to account for revenues that are not particularly designated to be accounted for by another fund. The main so

    		•
  • Q : Define Pooled Money Investment Board

    Pooled Money Investment Board (PMIB): The board included of the Director of Finance, State Treasurer, and the State Controller, the aim of which is to design an efficient cash management and investment program, employing all monies fl

    		•
  • Q : What is Policy Adjustments Policy

    Policy Adjustments: The changes to existing law or Administration policies. Such adjustments need action by the Governor and/or Legislature and change the workload budget.

    		•
  • Q : State Section 30.00 Section 30.00 : It

    Section 30.00: It is a Control Section of Budget Act which amends Government Code Section 13340 to tha sunset continuous appropriations.

    		•
  • Q : Employ the aggregate demand-aggregate

    Normal 0 false false

    		•
  • Q : Relationship which MPC bear to the size

    Normal 0 false false

    		•
  • Q : Define Programs Programs : The

    Programs: The activities of an association grouped on the basis of common objectives. The programs are included of elements that can be further classified into tasks and components.

    		•