Build a spreadsheet simulation model to track cash flows month by month. Enter the probability distributions (type and parameters) for the assumption cells directly into the spreadsheet. Simulate 1,000 iterations for the year 2010, and paste your results into the spreadsheet. Toys Adventure management wants information about what the company's net worth will be at the end of 2010, including the possibility that the net worth will be greater than zero. (Net worth is defined here as the cash balance plus interest on savings and accounts receivable less all loans and interest payable.) Display the results of your simulation run in part (a) in any way that you find useful to management in analyzing this issue.

Arrangements must be made to obtain a specific credit limit from the bank for short-term loans that might be needed during 2010. Therefore, Adventure Toys management would also like information about the size of the largest short-term loan that might be needed during 2010. Display the results of your simulation run in part a) in any way that you find useful to management in analyzing this issue.