--%>
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 Bill Bill : It is a draft of

    Bill: It is a draft of proposed law represented to the Legislature for performance. (A bill has bigger legal formality and standing than a resolution.) OR An invoice, or document statement, of an amount owing for s

    		•
  • Q : Inflationary expenditure gap or

    Normal 0 false false

  • Q : Generalization Normal 0 false false

    Normal 0 false false

  • Q : Assignments i want to write final state

    i want to write final state report. My state is Texas. You can use the resources that i attached, also you can use another resources to cover the outlines.

    		•
  • Q : State Schedule 11 Schedule 11 : It is

    Schedule 11: It is the outdated word for “Supplementary Schedule of Operating Expenses and Equipment.”

    		•
  • 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 relationship among a bonds

    Describe relationship among a bond's market price and its promised yield to maturity? Describe.A bond's market price based on its yield to maturity (YTM). While a bond has YTM greater than its coupon rate, it sells at discount from its face va

    		•
  • Q : What is the Schedule of Operating

    Schedule of Operating Expenses and Equipment, Supplementary: The supplemental schedule proposed by department’s throughout budget preparation that details by object the expenses comprised in the Operating Expenses and Equipment class.

    		•
  • Q : What do you mean by the term Year of

    Year of Appropriation (YOA): It refers to the initial year of an appropriation.

    		•
  • Q : Health finance 7.2 The audiology

    7.2 The audiology department at Randall Clinic offers many services to the clinic's patients. The three most common, along with cost and utilization data, are as follows: Service Variable Cost Annual Direct Annual # Visits per Service Fixed Costs Basic exam $5 $50,000 3,000 Advanced examination $7 $

    		•