• Create a new sheet named vertical analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate vertical analysis for the income statement and balance sheet.
• Create a new sheet named horizontal analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate horizontal analysis for the income statement and balance sheet.

BALANCE SHEET	2020-12-31	2019-12-31	2018-12-31	2017-12-31
Current Assets	340,079,000	320,122,000	339,609,000	213,006,000
Inventory	51,999,000	42,607,000	43,580,000	34,013,000
Investments	95,638,000	85,161,000	39,987,000	52,329,000
Fixed Assets	1,209,460,000	982,014,000	873,827,000	751,134,000
Other Assets	217,085,000	64,222,000	49,889,000	52,071,000
Total Assets	1,914,261,000	1,494,126,000	1,346,892,000	1,102,553,000
Current Liabilities	243,211,000	215,571,000	184,436,000	149,050,000
Non-Current Liabilities	569,956,000	232,320,000	134,021,000	127,189,000
Other Liabilities	-	-	-	-
Shareholders Equity	990,848,000	1,035,065,000	1,016,782,000	813,758,000
Total Liabilities and Shareholder Equity	1,914,261,000	1,494,126,000	1,346,892,000	1,102,553,000
Minority Interests	110,246,000	11,170,000	11,653,000	12,556,000
All figures are in	Thousands	Thousands	Thousands	Thousands
Currency	SAR	SAR	SAR	SAR
Last Update Date	2021-03-25	2020-03-19	2020-03-19	2019-12-10

STATEMENT OF INCOME	2020-12-31	2019-12-31	2018-12-31	2017-12-31
Sales	768,109,000	1,105,696,000	1,194,376,000	835,983,000
Sales Cost	-	-	-	-
Total Income	768,109,000	1,105,696,000	1,194,376,000	835,983,000
Other Revenues	93,982,000	131,089,000	152,641,000	150,176,000
Total Revenues	862,091,000	1,236,785,000	1,347,017,000	986,159,000
Admin and Marketing Expenses	46,970,000	36,647,000	31,250,000	29,606,000
Depreciation	76,208,000	50,266,000	41,334,000	36,894,000
Other Expenses	366,489,000	483,131,000	476,537,000	338,221,000
Total Expenses	489,667,000	570,044,000	549,121,000	404,721,000
Net Income Before Zakat	372,424,000	666,741,000	797,896,000	581,438,000
Zakat	188,661,000	336,048,000	381,378,000	296,819,000
Net Income	183,763,000	330,693,000	416,518,000	284,619,000
Balance First Period	-	-	-	-
Reserves	-	-	-	-
Cash Dividends	-	-	-	-
Other Distributions	-	-	-	-
Balance End Period	-	-	-	-
All figures are in	Thousands	Thousands	Thousands	Thousands
Currency	SAR	SAR	SAR	SAR
Last Update Date	2021-03-25	2020-03-19	2020-03-19	2019-12-10