Please complete Data table and explain the steps.

1.please provide cell reference in D15?

2.The row input in the data table?

3.The colum input required in the data table?

Income Statement for Lemonade Co.
	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018
Revenues	1,000.0	1,070.0	1,144.9	1,225.0	1,310.8
Expenses	500.0	524.3	549.6	588.0	629.2
Net profit	500.0	545.7	595.3	637.0	681.6
Revenue Growth		7.0%	7.0%	7.0%	7.0%
COGS %	50.0%	49.0%	48.0%	48.0%	48.0%
		Revenue %
		10.0%	8.0%	6.0%	4.0%
	52.0%
COGS %	48.0%
	46.0%
	44.0%