Financial Analysis of Bank Rakyat, Assignment

Company  Select:

Choose ONE (1) Public Listed Bank in Malaysia (the company chosen MUST be different from other group) and identify 3 years of the company’s most recent annual reports. We choose Bank Rakyat.
Company: Bank Rakyat (Public Listed Bank in Malaysia)

Objective:

Objective: Perform a financial analysis of Bank Rakyat by examining its most recent 3 years of annual reports. Using MS Excel, combine the relevant data into a workbook with separate sheets for the Income Statement, Balance Sheet, and Financial Analysis.

Tasks:

 MS Excel Workbook:

1. File Name: The workbook should be renamed with the name of the company you chose (Bank Rakyat).
2. Income Statement: Integrate the 3 years of data for Bank Rakyat’s income statement.
3. Balance Sheet: Integrate the 3 years of data for Bank Rakyat’s balance sheet.
4. Financial Analysis: Integrate the data from the Income Statement and Balance Sheet for financial ratio analysis.

 Financial Ratios:

a. Liquidity Ratios:

1. Current Ratio: Current Assets / Current Liabilities
2. Net Working Capital: Current Assets – Current Liabilities
3. Quick Ratio: (Current Assets – Inventories) / Current Liabilities

b. Efficiency Ratios:

1. Inventory Turnover Ratio: COGS / Inventory
2. Average Collection Period: (Accounts Receivables / Sales) × 365
3. Average Payment Period: (Accounts Payable / COGS) × 365
4. Total Asset Turnover: Sales / Total Assets
5. Fixed Asset Turnover: Sales / Fixed Assets

c. Debt Ratios:

1. Debt Ratio: Total Liabilities / Total Assets × 100
2. Debt-to-Equity Ratio: Total Liabilities / Shareholders’ Equity
3. Times Interest Earned: EBIT / Interest Expense

d. Profitability Ratios:

Answer

Request Answer of this Assignment