A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND...

Transcribed Image Text:

A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND EQUIVALENTS BUT HAS NO ACCESS TO A BANK LINE OF CREDIT. Day Cash Flow Day Cash Flow Day Cash Flow 1 11 2 3 4 5 6 7 9 $26,554.20 $23,110.38 10 -$8,227.22 $13,870.79 $86,705.92 $78,618.38 12 -$64,951.28 $16,518.43 $5,393.37 $14,726.99 -$5,660.26 17 $35,622.40 18 -$10,835.72 19 -$24,064.02 20 -$12,941.02 13 14 15 $23,904.57 16 21 22 23 24 25 26 -$63,396.45 -$17,653.18 8 $124,891.46 28 -$52,783.19 $53,915.35 $52,173.28 $35,184.53 30 $30,095.43 ACCESS THE EXCEL FILE IN THE LEARNING MANAGEMENT SYSTEM TO DO THE FOLLOWING ACTIVITIES: 27 -$4,256.05 $36,571.04 $85,506.95 $67,915.09 29 $10.52 $9,480.78 4. Using Lambda, calculate the probability of liquidity and illiquidity. 5. Interpret the result. 6. 1. Enter the historical daily cash flows in Excel. 2. Use the historical data to calculate expected future daily cash flow and historical cash flow volatility. 3. Calculate Lambda. Recalculate Lambda and the resulting liquidity outcomes backing into a desired amount of a line of credit for a desired Lambda. A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND EQUIVALENTS BUT HAS NO ACCESS TO A BANK LINE OF CREDIT. Day Cash Flow Day Cash Flow Day Cash Flow 1 11 2 3 4 5 6 7 9 $26,554.20 $23,110.38 10 -$8,227.22 $13,870.79 $86,705.92 $78,618.38 12 -$64,951.28 $16,518.43 $5,393.37 $14,726.99 -$5,660.26 17 $35,622.40 18 -$10,835.72 19 -$24,064.02 20 -$12,941.02 13 14 15 $23,904.57 16 21 22 23 24 25 26 -$63,396.45 -$17,653.18 8 $124,891.46 28 -$52,783.19 $53,915.35 $52,173.28 $35,184.53 30 $30,095.43 ACCESS THE EXCEL FILE IN THE LEARNING MANAGEMENT SYSTEM TO DO THE FOLLOWING ACTIVITIES: 27 -$4,256.05 $36,571.04 $85,506.95 $67,915.09 29 $10.52 $9,480.78 4. Using Lambda, calculate the probability of liquidity and illiquidity. 5. Interpret the result. 6. 1. Enter the historical daily cash flows in Excel. 2. Use the historical data to calculate expected future daily cash flow and historical cash flow volatility. 3. Calculate Lambda. Recalculate Lambda and the resulting liquidity outcomes backing into a desired amount of a line of credit for a desired Lambda.

Answer rating: 100% (QA)

01 Enter Historical Daily Cash Flows in Excel Open Excel and create a new sheet In column A enter th... View the full answer