--%>
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 Special Items of Expense

    Special Items of Expense: It is an expenditure category which covers nonrecurring big expenditures or special aim expenditures which usually need a separate appropriation (or else need separation for clarity).

    		•
  • Q : Cause-and-effect chain Normal 0 false

    Normal 0 false false

    		•
  • Q : Explain Expenditures by Category

    Expenditures by Category: A budget display, for each and every department, which reflects actual precedent year, estimated present year, and proposed budget year expenses presented by the character of expenditure (example, State Operations and/or Loca

    		•
  • Q : What is Debt Financing Debt Financing :

    Debt Financing: Whenever a firm raises money for the working capital or capital expenses by selling bonds, bills, or notes to individual and or institutional investors. In return for lending money, the individuals or institutions become creditors and

    		•
  • Q : Use of obtainable resources Normal 0

    Normal 0 false false

  • Q : Why do businesses spend efforts to

    Why do businesses spend effort, time and money to generate forecasts?  Describe.Businesses succeed or fail based on how well prepared they are to deal along with the situations they confront in the future. Hence they expend considerable sum

    		•
  • Q : What is the Character of Expenditure

    Character of Expenditure: A classification recognizing the major purpose of expenditure, like State Operations, Local Assistance, Capital Outlay, or Unclassified.

    		•
  • Q : Describe the effect of stock dividends

    Describe the effect of stock (not cash) dividends and stock splits onto the market price of common stock? Why do corporations state stock splits and stock dividends? Stock splits & stock dividends decrease the price per share of the common

    		•
  • 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 : Depict the slope of the line Normal 0

    Normal 0 false false