Accounting

Iqbal Zulkiflie, the CEO of Rancak Berdozza Berhad, requested you as the junior accountant to analyse the financial statements of the companyusing Microsoft Excel. The following information was provided by Iqbal: Rancakk Berdozza Berhad Statement of Profit or Loss for the year ended 31 December 2020 2021 RM 1000 RM '000 858 (513) 345 803 (509) 294 Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Selling Expense Administrative Expense Total Operating Expenses Operating Income Other Income and Expenses Interest Revenue Interest Expense Total Other Income and Expenses Income before Income Tax Income Tax Expenses Net Income 126 118 244 101 114 123 237 57 4 (24) (20) 81 33 48 0 (14) (14) 43 17 26 Rancakk Berdozza Berhad Statement of Financial Position as at 31 December 2020 2021 RM '000 RM '000 Assets Current Assets Cash and Cash Equivalents 29 32 Accounts Receivable 114 85 Inventory 113 111 Prepaid Expense 6 8 Total Current Assets 262 236 Property, Plant and Equipment 507 399 Long-term Investment 18 9 Total Assets 787 644 Liabilities Current Liabilities Accrued Payable 73 68 Accrued Liabilities 27 31 Notes Payable 42 27 Total Current Liabilities 142 126 Long-term Liabilities 289 198 Total Liabilities 431 324 Owners' Equities Ordinary Shares 186 186 Retained earnings Shareholders' Equities Total Liabilities and Shareholders' Equities 170 356 787 134 320 644 Required: Prepare the financial statements of Rancakk Berdozza Berhad in one worksheet. Rename the worksheet as Part A. Analyse the financial statementsby using: a) Horizontal and Vertical Analysis for the Statement of Profit or Loss for the year ended 2020 and 2021. b) Ratio Analysis (Profitability, Liquidity and Efficiency Ratios) for both Statement of Profit or Loss and Statement of Financial Positionfor the year 2021. ) Comment on the financial performance of the company for the three analyses. c)