The Covid-19 coronavirus pandemic has suddenly triggered a global health crisis, large numbers of human lives continues to be tragically lost until today. There is still deep uncertainty on how the Covid-19 vaccines can be realized to be immediately deployed and effectively used to defeat the disease. This pandemic has also tremendously challenged the global business community, damaging severely both in economic and social context. The impact of the restraints in social interaction and strict lockdown measures used to contain the pandemic outbreak, triggered a sudden collapse of the economic activity. Other than the few essential critical services and businesses, most businesses had to suspend activities whilst people were forced to stay home. It is inevitable that the number of business failures have drastically increased. Paradoxically there are also a number of businesses that have endured during this pandemic period. One such case is within the food processing industry, namely in the frozen foods sector as well other downstream food processing business offering value-added products enhanced home cooking process up to Ready Meals. These trends have been carefully been observed by the management of PT. Mega Food Tbk. This company started from a small, family-run business, focusing in raising chickens to produce poultry and eggs. In its development over the last four decades PT. Mega Food has since expanded in terms of both their scale and market reach as well as through vertical integration and product differentiation into the processed poultry product lines. They are now able to offer a variety of frozen chicken meat and processed chicken products such as Chicken Nuggets, Chicken Meatballs, Chicken Strips, Chicken Wings and Chicken Loaf. Presently PT. Mega Food owns 5 production plants strategically located around 4 of the largest cities in Indonesia. This is further supported by solid distributor and reseller network covering the entire span of Indonesia. PT. Mega Food management team is currently lead by Mr. Surtono. Besides serving as the CEO, being the third generation member of the Surtono family who founded the company he is also a major shareholder of the company. He is seen as a very capable leader and has been credited for the successful execution of highly complex and strategic initiatives of the company. Leading the company not only during the transition from second to third generation ownership, but also the further the transition from a private to a public company through IPO and indirectly as public company; increased transparency and credibility of PT. Mega Food management. The company intends to further seek further avenue of growth, by advancing downstream and to expand its product lines from frozen Ready-to-Cook into frozen Ready-to-eat products. It has been a very dominant trend emerging from the Covid-19 pandemic, as a solution to serve the customers during the recent social restriction. Ms. Chintia, as Head of Business Development for PT. Mega Food is currently focusing the company's business strategy into the new market. Together with the members of the development team, they have completed a thorough analysis of the opportunities and constraints and formulated the business plan to produce and enter the market to serve Ready-Meal products. Mr. Surtono has requested Chief Financial Officer, Mr. Malik to provide comprehensive analysis of PT. Mega Food financial condition. The information will be used to evaluate and assess the feasibility to advance with the proposed business expansion. In this regard, Mr. Malik has directed his team to compile the necessary data on the company's finances. PT. Mega Food Financial Reports are further present below: PT. Mega Food 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 income taxes Taxes expense (benefit) 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. Mega Food Statement of Financial Position 31 December 2020 (internal estimation) and 2019 2020 ASSETS Current Assets 2019 Cash & Cash Equivalent Accounts Receivable Inventories Other Current Assets Total Current Assets Net PPE Goodwill Intangible Assets Other Assets Total Assets Rp96,800,000,000 434,600,000,000 821,600,000,000 80,800,000,000 1,433,800,000,000 1.456,400,000,000 2,168,800,000,000 1,407,400,000,000 153,000,000,000 6,619,400,000,000 Rp54,000,000,000 344,600,000,000 702,600,000,000 36,400,000,000 1,137,600,000,000 1,233,800,000,000 1,947,800,000,000 1,351,800,000,000 150,800,000,000 5,821,800,000,000 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 Question : Before going into live production to bring the new Ready-Meal menu offering to the market, Mr. Surtono had requested Mr. Malik to run a detailed analysis of the company's financial performance. You have been assigned as member of Mr. Malik's team. Please prepare a comprehensive financial ratio analysis of PT. Mega Food (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. Mega Food presently, b. Include also present Du Pont analysis to support your argument on the matter. LIABILITIES & S/H EQUITY Current Liabilities Current Debt 420,400,000,000 382,200,000,000 385,200,000,000 338,800,000,000 Account Payable Other current liabilities 285,200,000,000 297,000,000,000 1,102,600,000,000 Total current Liabilities 1,006,200,000,000 Long Term Debt 1,966,000,000,000 1,592,400,000,000 421,400,000,000 Differed income taxes Other Liabilities 471,200,000,000 234,400,000,000 239,600,000,000 3,259,600,000,000 TOTAL LIABILITIES 3,774,200,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