--%>
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 CALSTARS CALSTARS : The acronym

    CALSTARS: The acronym for the California State Accounting and Reporting System that is the state's primary accounting system. Most of the departments presently use CALSTARS.

    		•
  • Q : Pros and cons of commercial paper

    Describe pros and cons of commercial paper associated to bank loans for a company seeking short-term financing? Usually commercial paper is a cheaper source of short-term financing for a firm, compared to bank loans. Also, a larger amount of fu

    		•
  • Q : Define Budget Year Budget Year (BY) :

    Budget Year (BY): The next state fiscal year, starting July 1 and ending June 30, for which the Governor's Budget is proposed (that is, the year following the present fiscal year).

    		•
  • Q : Describe proprietorship-partnership and

    Briefly describe the terms proprietorship, partnership, and corporation.A proprietorship is a business owned by one person. Two or more people who join together to develop a business make up a partnership. It can be done on an inf

    		•
  • Q : Describe Reappropriation

    Reappropriation: The expansion of an appropriation’s accessibility for encumbrance and/or expenses beyond its set annihilation date and/or for a new point. Re-appropriations are usually authorized by statute for 1-year at a time however might be

    		•
  • Q : Revision Order #2 Hello, You folks

    Hello, You folks recently completed an order for me. I'm very impressed and much thanks in advance. I'd like to submit more problems (8 attached) if you can have the same expert work on these please? Some of the #'s were slightly modified from my previous order, so should be easier than starting

    		•
  • Q : Define Reserve Reserve: The amount of a

    Reserve: The amount of a fund balance set sideways to give for expenditures from the unencumbered balance for ongoing appropriations, future apportionments, and economic uncertainties, pending salary or price raise appropriations, and appropriations f

    		•
  • Q : Graphically combined transactions and

    Normal 0 false false

  • 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 : Describe utilization of a risk-adjusted

    Describe how utilizing a risk-adjusted discount rate develop capital budgeting decision making compared to utilizing a single discount rate for all projects? The risk-adjusted discount rate develop capital budgeting decision making compared to t

    		•