PART 1: Analysis and Entering of Data

Procedures:

• Open MS Excel and start new worksheet

Jollibee Foods Corporation's Annual Report The following data are derived from the annual report of Jollibee Foods Corporations (JFC) submitted to Securities and Exchange Commission (SEC) pursuant to section 17 of the Securities Regulation Code and section 141 of the Corporation Code of the Philippines. For the fiscal year ended Dec 31, 2018 Currency PHP (In Thousands) Balance Sheet Year Ending Previous Year Ending Dec 31, 2018 Dec 31, 2X17 Current Assets 42,738,201 37,328,920 Total Assets 113,851,822 89,783,895 Current Liabilities 34, 184,527 26,946,840 Total Liabilities 63,933,671 47,201,916 Retained Earnings/ (Deficit) 40,257,995 34,613, 140 Stockholders' Equity 49,918, 151 42,581,979 Stockholders' Equity - Parent 48,363,550 40,782,635 Book Value Per Share 45.85 39.24 Income Statement Year Ending Previous Year Ending Dec 31, 2018 Dec 31, 2X17 Gross Revenue 164,347,834 135,429, 194 Gross Expense 153,857,250 127,089,684 Non-Operating Income 3, 148,446 1,816, 108 Non-Operating Expense 473,458 146,253 Income/(Loss) Before Tax 10,490,584 8,339,510 Income Tax Expense 2,719,249 1,666,928 Net Income/ (Loss) After Tax 7,771,335 6,672,582 Net Income/ (Loss) Attributable to Parent 8,329,884 7, 109, 120 Equity Holder2018 2017 Basic Shares Outstanding 1,087,000 1,080,000 Diluted Shares Outstanding 1, 103,000 1,095,000 A Basic earnings per share for 2018 B Basic earnings per share for 2017 C Diluted earnings per share for 2018 D Diluted earnings per share for 2017 E Current ratio 2018 F Current ratio 2017 G Debt ratio 2018 H Debt ratio 2017 Return on equity 2018 C Return on equity 2017