Sensitivity Analysis

Hi Im doing work on a Subdivsion and have made a sensitivity analysis to gain a range of end values based whether expenses and values are increasing/decreasing.
I have finished a table and it seems to work correctly, but am wondering for future use there must be a better way to set this up???
I have read Excel Help but havnt been able to get anywhere.
If anyone is able to help, that would be great!

Here is what I have done for now.

Subdivision.xls

Thanks

As a general suggestion, name your cells!!

I played arround with your formula :-

(I colorcoded your 2 constants below, not sure if they will always be the same) if so it could possibly be simplified further!

Please Login or Register  to view this content.

It makes it more readable to change!

By naming the variables across the side and top eg k10:q10 as GrossRealisation you can use it in your formula! And still copy between the cells, but its easier to maintain!

also a little math and simplification :-

Please Login or Register  to view this content.

With Names:-

Please Login or Register  to view this content.