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.

Cash Flow Sensitivity

Microsoft Excel 2010
Family Budget Planner Spreadsheet
Cash Flow Sensitivity
Download Download

Created On

Template Details

Created By: Admin
License: Private Use
(Only for personal Use)

Description

Download free excel template and don't forget to like our Facebook page for latest updates.

Write a comment for this product!

Please Write your Comments
Rating for product: