--%>
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 : Describe factors affecting minimum cash

    Describe the factors affecting the option of a minimum cash balance amount. The minimum cash balance amount is find out by how easy it is to increase funds when needed, how predictable the cash flows are, and how risk averse managers are.

    		•
  • Q : Advantages and disadvantages of working

    Describe the advantages and disadvantages of the aggressive working capital financing approach? An aggressive working capital financing approach generally results in a lower cost of funds for a firm however a higher level of risk.

    		•
  • Q : Describe Section 1.50 Section 1.50 : It

    Section 1.50: It is a section of the Budget Act which A) Identifies a certain style and format for the codes employed in the Budget Act, B) Authorizes the Department of Finance

    		•
  • Q : Explain the primary advantage of

    Explain the primary advantage to a corporation of investing some of its funds within working capital? Through investing in working capital a firm gets the liquidity it require helping it to pay its bills. Therefore the risk of the firm is reduce

    		•
  • Q : Define Cost-of-Living Adjustments

    Cost-of-Living Adjustments (COLA): Increases offered in state-funded programs which comprise periodic adjustments predetermined in state law (statutory, like K-12 education apportionments), or established at optional levels (that is discretionary) by

    		•
  • Q : Calculate the slope of the curve Normal

    Normal 0 false false

  • 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 : 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 : What is the schedule of Federal Funds

    What is the schedule of Federal Funds and Reimbursements, Supplementary: The supplemental schedule proposed by departments throughout budget preparation that exhibits the federal receipts and reimbursements through source.

    		•
  • Q : Describe GATT and its goal Describe

    Describe GATT, and its goal? GATT is the General Agreement on Tariffs & Trade. This is a treaty that seeks to decrease trade barriers among participant nations.

    		•