1. Compute and insert the missing figures in the colored spaces. (Use Excel and show formula)

Income Statement for the periods 2015 - 2019
	Kshs. Millions
	2015	2016	2017	2018	2019
Gross sales	23,793.00	39,980.00	43,082.00	40,431.00	46,867.00
Indirect taxes and duties	(3,890.00)	(6,238.00)	(7,435.00)	(7,853.00)	(9,937.00)
Net sales
Cost of sales	(17,785.00)	(30,970.00)	(32,989.00)	(30,185.00)	(34,342.00)
Gross profit
Administration and selling expenses	(13100	(1,644.00)	(1,507.00)	(1,261.00)	(1,567.00)
Interest charges	(4.00)	(138.00)	(302.00)	(413.00)	(190.00)
Profit before taxation
Taxation	(263.00)	(377.00)	(283.00)	(203.00)	(274.00)
Profits after tax