Use this template to prepare a cash flow sensitivity analysis. Prepare your expected cash flow projections and by entering a percentage change assumption, the template 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.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.