Analysis the balance sheet and make horizontal/vertical analysis in EXCEL

Bank BTB Open Joint-Stock Company Consolidated Statement of Financial Position as at 31 December 2018 2018 2017* Notes AZN 000 AZN'000 ASSETS Cash and cash equivalents 11 20,255 25,717 Due from banks and other financial institutions 12 26,674 27,980 Investment securities 13 3,383 2,627 Loans to customers 14 192,467 142,247 Investment property 15 13,376 13,574 Property, equipment and intangible assets 16 51,684 52,019 Other financial assets 17 1,055 935 Other assets 17 961 709 Total assets 309,855 265,808 LIABILITIES Deposits and balances from banks 18 5,835 5,540 Current accounts and deposits from customers 19 128,239 99,154 Other borrowed funds 20 123,303 108,516 Other liabilities 1,093 1,182 Total liabilities 258,470 214,392 EQUITY Share capital 21 66,450 66,450 Accumulated deficits (15,065) (15,034) Total equity 51,385 51,416 Total liabilities and equity 309,855 265,808 *The Group has initially applied IFRS 9 and IFRS 15 at 1 January 2018. Under the transition methods chosen, comparative information is not restated (see Note 29). As a result of adoption of IFRS 9 the Group changed presentation of certain captions, comparative information is re-presented accordingly (see Note 3(r))