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 : Explain Section 26.00 Section 26.00 :

    Section 26.00: It is a Control Section of Budget Act which gives the authority for the transfer of funds from one class, program or function in a schedule to the other category, program or function in the similar schedule, subject to particular limita

  • Q : Resolving ranking conflict Describe how

    Describe how to resolve a "ranking conflict" among the net present value and the internal rate of return. Why should the conflict be resolved as you described?
    Whenever there is a ranking conflict among net present value and internal rate of re

  • Q : What are Governmental Cost Funds

    Governmental Cost Funds: For lawful basis accounting and budgeting aims, funds which derive revenue from the taxes, licenses, and fees.

  • Q : Estimation of expected incremental cash

    How do we estimate expected incremental cash flows for proposed capital budgeting project?
    We estimate expected incremental cash flows for proposed project through estimating the changes in sales and expenses which are incremental to the project

  • Q : Describe Form 9 Form 9 : It is the

    Form 9: It is the request by department for space planning services (example, new or extra space lease extensions, or renewals in non-institutional) and also evaluated by the Department of Finance.

  • Q : What is Department Department: The

    Department: The governmental organization, generally belonging to the third level of the state organizational hierarchy as stated in the Uniform Codes Manual.

  • 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 : Explain regulations Regulations: It is

    Regulations: It is a rule, order, or standard of common application issued by a state agency to interpret, implement, or make specific law enforced or managed by it, or to govern its measures. With state government, the procedure of adopting or modify

2015 ©TutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.