Make Vertical analysis, Horizontal analysis and income statement analysis in EXCEL

Bank BTB Open Joint-Stock Company Consolidated Statement of Profit or Loss and Other Comprehensive Income for the year ended 31 December 2018 2017* 2018 AZN'000 Notes AZN'000 4 19,572 14,449 4 (10,887) (9,504) 8,685 4,945 5 4,007 2,157 6 (516) (260) 3,491 1,897 2,061 2,298 (42) (823) 520 (9) 14,715 8,308 1,038 4,262 (7,504) (6,304) (5,749) (5,796) 2,500 470 2,500 470 Interest income calculated using the effective interest method Interest expense Net interest income Fee and commission income Fee and commission expense Net fee and commission income Net gain on trading in foreign currencies Net foreign exchange loss Other operating income (loss) Operating income Impairment recovery Personnel expenses Other general administrative expenses Profit before income tax Income tax expenses Total comprehensive income for the year 7 8 9 10