 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
|||||||||||
|
|
|
|
||||||||
|
|||||||||||
|
|||||||||||
|
|||||||||||
 |
SPREADSHEET PROFESSIONAL HOME PAGE Testing tools l Spreadsheet Comparison tool l Spreadsheet Formula Tracer l Spreadsheet Painter l Sensitivity and breakeven analysis tool
|
||||||||||
|
This tool enables you to quickly produce and report sensitivity and breakeven analyses for any cell within the spreadsheet. The sensitivity analysis enables you to select any input cell and see the impact on any other cell within the spreadsheet. |
|
Description The breakeven analysis tool enables you to see what value the input cell has to be so that the other cell has a value of zero (or any other value that you are trying to achieve). This is particularly useful when you are trying to establish answer such questions as "How far can revenues drop before we stop making a profit". Using this breakeven analysis tool it is possible to run many analyses very quickly and produce answers and reports for discussion. |
The sensitivity and breakeven tool
By pressing the document button at the top left hand corner of the sensitivity tool, a report of the results can be quickly created.
A typical sensitivity report
|
Quote of the page: In the old days we were so poor we had to eat hamburgers. Now we're poor because we eat hamburgers.- Anon
|
|
|
|
|