Cash Flow Sensitivity Analysis

Use this template to prepare a cash flow sensitivity analysis. Prepare your expected cash flow projections and by entering a percentage change assumption, the spreadsheet will automatically prepare a pessimistic and optimistic set of cash flow scenarios. Under the pessimistic scenario, cash receipts will be lowered by the percentage and disbursements will be increased by the same percentage. Under the optimistic scenario, receipts will be increased while disbursements will be decreased by the percentage assumption.