USE EXCEL PLEASE

2. Ken Soree is the CEO of Black Bear, Inc. Although this firm was only recently incorporated, Ken's firm is already struggling. Among the firm's many problems, Ken notes that 1) customer demand is low for the firm's products, 2) middle management has mis-managed costs, and 3) the liquidity position is far too weak (current cash holdings equal $10,000 and the firm does not have a credit line). Recognizing that Black Bear is quickly falling behind rival firms, Ken hires a consultant to examine the firm's liquidity position using . Suppose that Ken provides the firm's historical daily cash flows (shown in the table below). Use this information to answer the questions below. c. Calculate Black Bear's and the associated probability of illiquidity. d. Assume that an error in accounting reveals that Black Bear really only has $5,000 in cash holdings. Re-calculate Black Bear's and the associated probability of illiquidity. e. What do you find interesting about your calculations from part d? What is causing these interesting values