--%>
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 is Bond Funds Bond Funds : For

    Bond Funds: For legal basis budgeting aims, funds utilized to account for the receipt and disbursement of non-self liquidating common obligation bond proceeds. Such funds do not account for the debt retirement as the liability made by the sale of bond

    		•
  • Q : What is Indirect Costs Indirect Costs :

    Indirect Costs: The costs which by their nature can’t be readily related with a particular organization unit or program. Similar to general administrative expenses, indirect costs are dispersed to the organizational unit(s) or programs that bene

    		•
  • Q : Legal factors to restrict a corporation

    Are there any legal factors which could restrict a corporation in its attempt to pay cash dividends to common stockholders? Describe. A firm may be legally limited as to the dividends it can pay through existing bond indentures or loan agreemen

    		•
  • Q : Describe usual pattern of cash flows

    Describe usual pattern of cash flows for share of preferred stock? How does the market fidn out the value of a share of preferred stock, given these promised cash flows?Preferred stock contains no maturity date hence, it has no maturity value.

    		•
  • Q : Describe compensating balances its need

    Describe compensating balances and why do banks needs them from some customers? Under what situation would banks be most likely to impose compensating balances? Compensating balances are funds that a bank needs a customer to maintain in a non-i

    		•
  • Q : Explain Budget Bill Budget Bill : The

    Budget Bill: The legislation symbolizing the Governor’s proposal for spending authorization for the subsequent fiscal year. The Budget Bill is all set by the Department of Finance and submitted to each house of the Legislature i

    		•
  • Q : Finance End of Chapter Problems Page

    End of Chapter Problems Page 150 5.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 per service Annual Direct Fixed cost Annual Number of Visits Basic

    		•
  • Q : How do mergers influence communities

    How do mergers influence communities?While a locally controlled bank is merged into a bank headquartered elsewhere (an out-of-market merger), some of the apprehension regarding the institution's future commitment to the local community is bound

    		•
  • Q : Use of obtainable resources Normal 0

    Normal 0 false false

  • Q : What is Legislative Analysts Office

    Legislative Analyst’s Office (LAO): A non-partisan organization which gives advice to the Legislature on the fiscal and policy matters. For illustration, the LAO annually publishes a full analysis of the Governor's Budget and this document becom

    		•