We have income statement of a company projected for a couple of years as the raw data.

In the first step, the table is formatted (highlighting, changing color, ...) and total and average columns are added which are based on a couple of periods. The number of periods can be defined by the users. Three periods is used in this case.

Now, an upside and downside case are added based on 10% increase and decrease in revnue (the rest of items are unchanged)

Now, drop downs are added, so the user may select the scenario (upside, basic or downside) as well as number of periods.