--%>
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 : How does the market find out the fair

    How does the market find out the fair value of a bond?The fair value of bond is the present value of the bond's coupon interest payments plus the present value of the face value payment at maturity, discounted at the market's required rate of re

    		•
  • Q : Fixed Income I need solution by Tuesday

    I need solution by Tuesday evening March 18, 6 pm EST

    		•
  • Q : Which ratios would banker is most

    Which ratios would banker is most interested while considering whether to approve an application for short-term business loan? Describe.Bankers and other lenders employ liquidity ratios to distinguish whether to extend short-term credit to a fir

    		•
  • Q : What is Appropriation Without Regard To

    What is Appropriation Without Regard To Fiscal Year (AWRTFY): The appropriation for a particular amount that is obtainable from year to year until completely expended.

    		•
  • Q : Increased common stock cash dividend

    Do you trust an increased common stock cash dividend can send any signal to the common stockholders? If so, what signal might it send? An increase in cash dividends is frequently seen as a positive signal. A company would be unlikely to raise

    		•
  • 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 : Multiplier effect Normal 0 false false

    Normal 0 false false

    		•
  • Q : Employ the aggregate demand-aggregate

    Normal 0 false false

    		•
  • Q : Describe trustworthy collateral from

    Describe trustworthy collateral from the lenders' perspective? Describe whether accounts receivable and inventory are trustworthy collateral. Assets which are readily marketable, of stable value, and not likely to "disappear" make for trustwort

    		•
  • Q : What is Change Book System Change Book

    Change Book System: The system the Department of Finance employs to record all the legislative modifications (comprising changes stated by the Administration and approved by the Legislature) made to the Governor's Budget and the last actions on the bu

    		•