Tuesday, June 7, 2016

Minmalism in Spreadsheets

Data Tables (Alt D T) are the best way to run sensitivity across 2 value drivers for any variable you want to observe.

In this example, I want to see how ROA and ROE varies with I vary the assumed gross profit margin and the sales growth.

This way, we have a clean presentation. I always believe spreadsheets can be below 1mb and done neatly.