Compute and insert the missing figures in the colored spaces. (Use Excel and Show Formula)

Balance Sheet as at December 31, 2015 - 2019
	Kshs. Millions
	2015	2016	2017	2018	2019
Assets
Non-current Assets:
Property, plant and equipment	1,920.00	2,263.00	2,548.00	2,502.00	2,445.00
Investments	358.00	358.00	358.00	358.00	358.00
Intangible assets	93.00	54.00	42.00	146.00	106.00
Total non - current assets
Current Assets:
Inventories	3,381.00	3,900.00	3,084.00	6,428.00	3,654.00
Accounts receivable	2,164.00	4,513.00	4,068.00	5,536.00	5,846.00
Cash and cash equivalents	436.00	320.00	1,346.00	1,343.00	886.00
Total Current Assets
Total Assets
Equity and Liabilities
Capital and Reserves
Share capital	893.00	930.00	930.00	930.00	930.00
Share premium	1,850.00	2,090.00	2,090.00	2,090.00	2,090.00
Revenue reserves	1,172.00	1,320.00	1,885.00	1,936.00	2,028.00
Proposed dividends	465.00	465.00
Total capital and reserves
Long-term Liabilities
Debenture	638.00	585.00	531.00	956.00	1,010.00
Mortgage	106.00	160.00	213.00	224.00	276.00
Total Long-term Liabilities
Current Liabilities
Trade creditors and others	1,858.00	2,388.00	1,293.00	4,850.00	4,011.00
Short-term borrowings	1,370.00	3,271.00	4,505.00	5,327.00	2,950.00
Total Current Liabilities
Total Liabilities
Total Equity and Liabilities