The values in the table below refer to West-Star, Inc.'s last ten daily cash flows. Use this information to answer the questions below.
DAY CF -$15,000,000 -$5,000,000 $4,000,000 $20,000,000 $7,000,000 $9,000,000 $500,000 $1,000,000 $2, 500,000 -$7,000,000
Use Excel to calculate West-Star's average daily cash flow.
Use Excel to calculate the standard deviation of West-Star's daily cash flow.
Calculate West-Star's lambda, assuming cash and equivalents of $1,000,000 and an unused line of credit of $1, 500,000.
What sum of cash and equivalents and unused credit line will allow West-Star to have a lambda of 2.50?