Make cash flow statement analysis in EXCEL

Calculate RATO

We make comprehensive financial statement analysis. for this anlaysis,what can we find or calculate from cash flow statement. Pls calculate ratio or smth for comprehensive financial statement analysis

Bank BTB Open Joint-Stock Company Consolidated Statement of Cash Flows for the year ended 31 December 2018 2018 2017* Notes AZN'000 AZN'000 18,899 14,877 (10,251) (9,976) 4,007 2,157 (516) (260) 2,061 2,298 520 (2) (7,504) (6,304) (4,014) (4,389) 1,338 9,961 (41,626) (12,755) (152) (144) 290 23 28,571 20,806 (135) 1,528 (8,512) 17,820 (891) (17,716) (850) (2,606) 103 (1,638) (20,322) 33,278 22,955 (28,486) (14,880) 4,792 8,075 (5,358) 5,573 (104) (1,086) 25,717 21,230 20,255 25,717 CASH FLOWS FROM OPERATING ACTIVITIES Interest receipts Interest payments Fee and commission receipts Fee and commission payments Net receipts from foreign exchange Other receipts (payments) Personnel expenses payments General administrative expenses payments (Increase) decrease in operating assets Due from banks and other financial institutions Loans to customers Other assets Increase (decrease) in operating liabilities Deposits and balances from banks Current accounts and deposits from customers Other liabilities Cash flows (used in) from operations CASH FLOWS FROM INVESTING ACTIVITIES Net acquisition of premises, equipment, investment property and intangible assets Purchases of investment securities Proceeds from sale and repayment of investment securities Cash flows used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES Receipts of other borrowed funds Repayment of other borrowed funds Cash flows from financing activities Net (decrease) increase in cash and cash equivalents Effect of changes in exchange rates on cash and cash equivalents Cash and cash equivalents as at the beginning of the year Cash and cash equivalents as at the end of the year 20 20 11