Business Owner's Toolkit® Business Templates

Free Downloads of Customizable Forms

Cash Flow Sensitivity Analysis Worksheet


The file is a Microsoft Excel spreadsheet template.

Updated on Mar 12, 2019

This Cash Flow Sensitivity Analysis Worksheet is set up to be used for forecasting changes in your receipts and disbursements and the effects the changes will have on your cash requirements of your start-up new business. This worksheet will show you what will happen to your cash flow when your forecast is off by 5 percent. We've formatted the worksheet and put in most of the inflows (income) and outflows (disbursements) categories for you. All you have to do is put in your numbers and print it.

This worksheet lists all the descriptions of the cash inflows and outflows of the new business. If you need additional categories of expenses you can quickly modify it. Just plug in your amounts and the spreadsheet will automatically compute the totals.

Special Features:

  • Download this spreadsheet template just once, and be able to use it over and over again.
  • The spreadsheet contains the formatting for a cash flow sensitivity analysis.
  • The spreadsheet can be completely customized — you can quickly add or delete items or revise the format to meet your needs.
  • The spreadsheet is easy to use. Just plug in your inflows (income) and outflows (disbursements) and it will automatically show you what will happen to your cash flow when actual results are not what you expected.
  • The spreadsheet shows what will happen when your cash results are 5 percent better than what you expected.
  • The spreadsheet will also show you what will happen to your cash when sales are 5 percent less than what you forecasted and outflows (disbursements) are 5 percent more than what you forecasted.

Toolkit is providing these tools free of charge. Some of these forms contain technical language and create significant legal obligations. Do not use any form without first having an attorney review the form and determine that it is suitable for the purpose for which you intend it.