Before going into live production to bring the new Ready-Meal menu offering to the market, Mr. Joon had requested Mr. Kook to run a detailed analysis of the companys financial performance. You have been assigned as member of Mr. Kooks team. Please prepare a comprehensive financial ratio analysis of PT. KFC (liquidity, profitability, efficiency, leverage, market); note: number of days in a year has been set as 365.
- a. In your assessment, based on the financial ratio of the company as compared to average in the industry, what is the overall financial condition of PT. KFC presently.
- b. Include also present Du Pont analysis to support your argument on the matter.
PT KFC Statement of Profit or Loss for the years Ended 31 December 2020 (internal estimation) and 2019 Sales COGS Gross Profit SGA Expense Operating income Interest income Interest expense Other income Total other(Income) expense Income before invoic Laxes Taxes expense (bencfit) Net Income 2020 Rp.8,481,000,000,000 7,476,600,000,000 1,004,400,000,000 439,000,000,000 565,400,000,000 (2.200.000.000) 92.400.000.000 (11.000.000.000) 79,200,000,000 486,200,000,000 79,200,000,000 407,000,000,000 2019 Rp.8,010,400,000,000 6,991,200,000,000 1,019,200,000,000 412,800,000,000 606,400,000,000 (1.400.000.000) 70.000.000.000 11.200.000.000 57,400,000,000 549,000,000,000 (56,400,000,000) 605,400,000,000 PT. KFC. Statement of Financial Position 31 December 2020 internal estimation) and 2019 2020 2019 ASSETS Current Assets Cash & Cash Equivalent Rp96,800,000,000 Rp54,000,000,000 Accounts Receivable 434,600,000,000 344,600,000,000 Inventories 821,600,000,000 702,600,000,000 Other Current Assets 80,800,000,000 36,400,000,000 Total Current Assets 1,433,800,000,000 1,137,600,000,000 Net PPE 1,456,400,000,000 1,233,800,000,000 Goodwill 2,168,800,000,000 1,947,800,000,000 Intangible Assets 1,407,400,000,000 1,351,800,000,000 Other Assets 153,000,000,000 150,800,000,000 Total Assets 6,619,400,000,000 5,821,800,000,000 LIABILITIES & S/H EQUITY Current Liabilities Current Debt 420,400,000,000 382,200,000,000 Account Payable 385,200,000,000 338,800,000,000 Other current liabilities 297,000,000,000 285,200,000,000 Total current Liabilities 1,102,600,000,000 1,006,200,000,000 Long Term Debt 1,966,000,000,000 1,592,400,000,000 Differed income taxes 471,200,000,000 421,400,000,000 Other Liabilities 234,400,000,000 239,600,000,000 TOTAL LIABILITIES 3,774,200,000,000 3,259,600,000,000 Share Holder Equity Common Stock 9,000,000,000 9,000,000,000 Capital in excess of par 875,600,000,000 877,400,000,000 Retained earnings 2,757,400,000,000 2,465,800,000,000 (23,400,000,000) (3,000,000,000) Acc. Other comprehensive gain loss Treasury Stock Total Equity (773,400,000,000) 2,845,200,000,000 (787,000,000,000) 2,562,200,000,000 6,619,400,000,000 5,821,800,000,000 TOTAL LIABILITIES & EQUITY Number of shares of C/S outstanding Market Price Per share 2,000,000,000 2,000,000,000 1.900 1.800 Average Industry data: Ratio Current Ratio Quick Ratio Inventory Turn Over Average Collection Period Total Assets Turn Over Debt Ratio Industry Norm 1.47 0.6 11.3 28.16 0.51 0.62 Times Interest Earned Gross Profit Margin Operating Profit Margin Net Profit Margin Return On Assets Return On Equity P/E Ratio M/B ratio 5.20 33% 14.53% 10.13% 7.20% 24% 22 18.62 PT KFC Statement of Profit or Loss for the years Ended 31 December 2020 (internal estimation) and 2019 Sales COGS Gross Profit SGA Expense Operating income Interest income Interest expense Other income Total other(Income) expense Income before invoic Laxes Taxes expense (bencfit) Net Income 2020 Rp.8,481,000,000,000 7,476,600,000,000 1,004,400,000,000 439,000,000,000 565,400,000,000 (2.200.000.000) 92.400.000.000 (11.000.000.000) 79,200,000,000 486,200,000,000 79,200,000,000 407,000,000,000 2019 Rp.8,010,400,000,000 6,991,200,000,000 1,019,200,000,000 412,800,000,000 606,400,000,000 (1.400.000.000) 70.000.000.000 11.200.000.000 57,400,000,000 549,000,000,000 (56,400,000,000) 605,400,000,000 PT. KFC. Statement of Financial Position 31 December 2020 internal estimation) and 2019 2020 2019 ASSETS Current Assets Cash & Cash Equivalent Rp96,800,000,000 Rp54,000,000,000 Accounts Receivable 434,600,000,000 344,600,000,000 Inventories 821,600,000,000 702,600,000,000 Other Current Assets 80,800,000,000 36,400,000,000 Total Current Assets 1,433,800,000,000 1,137,600,000,000 Net PPE 1,456,400,000,000 1,233,800,000,000 Goodwill 2,168,800,000,000 1,947,800,000,000 Intangible Assets 1,407,400,000,000 1,351,800,000,000 Other Assets 153,000,000,000 150,800,000,000 Total Assets 6,619,400,000,000 5,821,800,000,000 LIABILITIES & S/H EQUITY Current Liabilities Current Debt 420,400,000,000 382,200,000,000 Account Payable 385,200,000,000 338,800,000,000 Other current liabilities 297,000,000,000 285,200,000,000 Total current Liabilities 1,102,600,000,000 1,006,200,000,000 Long Term Debt 1,966,000,000,000 1,592,400,000,000 Differed income taxes 471,200,000,000 421,400,000,000 Other Liabilities 234,400,000,000 239,600,000,000 TOTAL LIABILITIES 3,774,200,000,000 3,259,600,000,000 Share Holder Equity Common Stock 9,000,000,000 9,000,000,000 Capital in excess of par 875,600,000,000 877,400,000,000 Retained earnings 2,757,400,000,000 2,465,800,000,000 (23,400,000,000) (3,000,000,000) Acc. Other comprehensive gain loss Treasury Stock Total Equity (773,400,000,000) 2,845,200,000,000 (787,000,000,000) 2,562,200,000,000 6,619,400,000,000 5,821,800,000,000 TOTAL LIABILITIES & EQUITY Number of shares of C/S outstanding Market Price Per share 2,000,000,000 2,000,000,000 1.900 1.800 Average Industry data: Ratio Current Ratio Quick Ratio Inventory Turn Over Average Collection Period Total Assets Turn Over Debt Ratio Industry Norm 1.47 0.6 11.3 28.16 0.51 0.62 Times Interest Earned Gross Profit Margin Operating Profit Margin Net Profit Margin Return On Assets Return On Equity P/E Ratio M/B ratio 5.20 33% 14.53% 10.13% 7.20% 24% 22 18.62
