--%>
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 : What are Salaries and Wages Supplement

    Salaries and Wages Supplement: The annual publication issued in a while after the Governor's Budget, including a summary of all positions by department, unit, and categorization for the past, present, and budget years, as of July 1 of the present year

    		•
  • Q : Define Augmentation Augmentation : An

    Augmentation: An authorized raise to a formerly authorized appropriation or allotment. This augment can be authorized by the Budget Act provisional language, control sections, or other legislation. Generally a Budget Revision or an Ex

    		•
  • Q : Explain Merit Salary Adjustment Merit

    Merit Salary Adjustment (MSA): The cost factor resultant from the periodic raise in salaries paid to the personnel occupying authorized positions. The personnel usually receive a salary raise of 5 percent per year up to the upper sala

    		•
  • 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 present value of the firms

    Describe the term "present value of the firm's operations" (also known as Enterprise Value). What does this number expose? The current value of the company's free cash flows reveals the market value of the firm's core income generating operatio

    		•
  • Q : Cyclical unemployment Suppose that in a

    Suppose that in a specific year the natural rate of unemployment is 5 percent and the actual rate of unemployment is 9 percent. Employ Okun's law to fin out the size of the GDP gap in percentage-point terms. If the nominal GDP is $500 billion in that year, how much ou

    		•
  • Q : Explain Year of Budget Year of Budget

    Year of Budget (YOB): In this the fiscal year revenues and expenses are recognized. For revenues, this is usually the fiscal year whenever revenues are earned. For expenses, this is usually the fiscal year whenever obligations, compri

    		•
  • Q : Effect of bank charges discount

    What happens while a bank charges discount interest on a loan? While a bank charges discount interest on a loan the required interest payment is subtracted through the loan proceeds at the time the loan is made. It makes the effective interest

    		•
  • Q : Factors affecting option of maximum

    Describe the factors affecting the alternative of a maximum cash balance amount. The maximum cash balance amount is finding out by obtainable investment opportunities, the expected return on investments, and the transaction cost of making invest

    		•
  • Q : Surpluses drive prices up- shortages

    Normal 0 false false