Q5. Using the information in the Balance Sheet and Profit and Loss Statement below, calculate the following ratios and answer the questions (8 points in total) Safeway Stores Comparative Balance Sheets 2019 2018 $ $ 74,442 75,574 105,166 91,642 1,563,244 1,433,254 118,537 128,676 1,861,389 1,729,146 Increase or Decrease Amount Percentage $ % (1,132) (1.50) 13,524 14.76 129,990 9.07 (10,139) (7.88) 132,243 7.65 Assets Current Assets: Cash and short-term investments Receivables Merchandise inventories Prepaid expenses and other current assets Total Current Assets Property Land Buildings Leasehold improvments Fixtures and equipment Transport equipment Property under capital lease 236,876 210,427 345,001 305,006 557,504 459,711 2,023,914 1,789,136 186,485 173,576 1,144,4091 1,155,493 4,494,189 4,093,349 1,894,333 1,731,138 2,599,856 2,362,211 16,588 16,557 59,396 66,449 4,537,229 4,174,363 26,449 39,995 97,793 234,778 12,909 (11,084) 400,840 163,195 237,645 31 (7,053) 362,866 12.57 13.11 21.27 13.12 7.44 (0.96) 9.79 9.43 10.06 0.19 (10.61) 8.69 Less: Accumulated depreciation and ammortization Total property, net Excess of cost over net assets acquired Other Assets Total Assets (0.90) 2019 $ 44,913 45,427 48,274 1,038,268 167,739 193,509 20,431 1,558,561 2018 $ 50,156 45,841 24,723 1,017,094 163,021 154,373 43,081 1,498,289 Increase or Decrease Amount Percentage $ % (5,243) (10.45) (414) 23,551 95.26 21,174 2.08 4,718 2.89 39,136 25.35 (22,650) (52.58) 60,272 4.02 Liabilities and Stockholders' Equity Current Liabilities Notes Payable Current obligation under capital leases Current maturities of notes and debentures Accounts Payable Accrued Salaries and wages Other accrued expenses Income Taxes Payable Total Current Liabilities Long-term Debt Obligations under capital leases Notes and Debentures Total Long-term debt Accrued claims and other liabilities Total Liabilities Stockholders' Equity Common Stock Additional Paid-in Capital Cumulative translation adjustment Retaind Earnings Total Stockholders' Equity Total Liabilities and stockholders' Equity 746,178 646,532 1,392,710 116,935 3,068,206 765,307 422,362 1,187,669 98,051 2,784,009 (19,129) 224,170 205,041 18,884 284,197 (2.50) 53.08 17.26 19.26 10.21 99,756 97,933 246,964 222,851) (155,994) (114,087) 1,278,297 1,183,657 1,469,023 1,390,354 4,537,229 4,174,363 1,823 24,113 (41,907) 94,640 78,669 362,866 1.86 10.82 36.73 8.40 5.66 8.69 Safeway Stores, Inc. Comparative Statements of Income Sales Cost of sales Gross Profit Operating and administrative expenses Operating Profit Interest expense Other income (loss) Income before provision for income taxes Provision for income taxes Net Income Net Income per share 1) Calculate the following Liqudity Ratios 2019 2018 $ $ 19,642,201 18,585,217 15,004,547 14,249,843 4,637,654 4,335,374 4,214,443 3,920,736 423,211 414,638 151,263 134,270 26,874 20,565 298,822 300,933 113,811 117,630 185,011 183,303 3.12 3.26 Increase or Decrease Amount Percentage $ % 1,056,984 5.69 754,704 5.30 302,280 6.97 293,707 7.49 8,573 2.07 16,993 12.66 6,309 30.68 (2,111) (0.70) (3,819) (3.25) 1,708 0.93 (0.14) (4.29) Current ratio in year 2018 = Current ratio in year 2019 = Quick ratio in year 2018 = Quick ratio in year 2019 = 2) Calculate the following Solvency Ratios Debt to Equity ratio in year 2018 = Debt to Equity ratio in year 2019 = Times interest Earned Ratios in year 2018 = Times interest Earned Ratios in year 2019 = 2) Calculate the following Profitability Ratios Return on Invested Capital (ROIC) ratio in year 2018 = Return on Invested Capital (ROIC) ratio in year 2019 = Return on Owner's Equity (ROE) ratio in year 2018 = Return on Owner's Equity (ROE) ratio in year 2019 = Profit as Percentage of Sales ratio in year 2018 = Profit as Percentage of Sales ratio in year 2019 = 3) Based on the above ratio analysis, what conclusions/observations can you make regarding the financial situation of this company? TABLE B-1 PRESENT VALUE OF 1 PV = Formula Sheet ( + in (n) Periods 2% 24,% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 15% Profit as a Percentage of Sales Ratio Income before Taxes/Total Sales 1 RETURN ON INVESTED CAPITAL (ROIC) = Income before Taxes / Total Assets 0.98039 0.97561 0.97087 0.96154 0.95238 0.94340 0.93458 0.92593 0.91743 0.909090.90090 0.89286 0.86957 0.96117 0.95181 0.94260 0.92456 0.90703 0.89000 0.87344 0.85734 0.84168 0.82645 0.81162 0.79719 0.75614 0.94232 0.92860 0.91514 0.88900 0.86384 0.83962 0.81630 0.79383 0.77218 0.75131 0.73119 0.71178 0.65752 0.92385 0.90595 0.88849 0.85480 0.822700.79209 0.76290 0.73503 0.70843 0.68301 0.65873 0.63552 0.57175 0.90573 0.88385 0.86261 0.82193 0.78353 0.74726 0.71299 0.68058 0.64993 0.62092 0.59345 0.56743 0.49718 2 3 4 5 RETURN ON EQUITY (ROE) = Income before Taxes/Total Owners Equity CURRENT RATIO=Current Assets / Current Liabilities 6 7 8 9 10 0.88797 0.86230 0.83748 0.79031 0.74622 0.70496 0.66634 0.63017 0.59627 0.56447 0.53464 0.50663 0.43233 0.87056 0.84127 0.81309 0.75992 0.71068 0.66506 0.62275 0.58349 0.54703 0.51316 0.48166 0.45235 0.37594 0.85349 0.82075 0.78941 0.73069 0.67684 0.62741 0.58201 0.54027 0.50187 0.46651 0.43393 0.40388 0.32690 0.83676 0.80073 0.76642 0.70259 0.64461 0.59190 0.54393 0.50025 0.46043 0.42410 0.39092 0.36061 0.28426 0.82035 0.78120 0.74409 0.67556 0.61391 0.55839 0.50835 0.46319 0.42241 0.38554 0.35218 0.32197 0.24718 QUICK RATIO = (Current assets - inventory/current liabilities ACID TEST RATIO = Cash/current liabilities 11 12 13 14 15 0.80426 0.76214 0.72242 0.64958 0.58468 0.52679 0.47509 0.42888 0.38753 0.35049 0.31728 0.28748 0.21494 0.78849 0.74356 0.70138 0.62460 0.55684 0.49697 0.44401 0.39711 0.35553 0.31863 0.28584 0.25668 0.18691 0.77303 0.72542 0.68095 0.60057 0.53032 0.46884 0.41496 0.36770 0.32618 0.28966 0.25751 0.22917 0.16253 0.75788 0.70773 0.66112 0.57748 0.50507 0.44230 0.38782 0.34046 0.29925 0.26333 0.23199 0.20462 0.14133 0.74301 0.69047 0.64186 0.55526 0.48102 0.41727 0.36245 0.31524 0.27454 0.23939 0.20900 0.18270 0.12289 ACCOUNTS RECEIVABLE TURNOVER=Credit Sales / Accounts Receivable DAY'S RECEIVABLE = 365 Days / Accounts Receivable Tumover ACCOUNTS PAYABLE TURNOVER=Purchases on Credit/ Accounts Payable DAY'S PAYABLE = 365 Days / Accounts Payable Tumover AVERAGE DAY'S SALES=Net Annual Sales/365 Days INVENTORY TURNOVER=Cost of Goods Sold (COGS) / Inventory Level 16 17 18 19 20 0.72845 0.67362 0.62317 0.53391 0.45811 0.39365 0.33873 0.29189 0.25187 0.21763 0.18829 0.16312 0.10686 0.71416 0.65720 0.60502 0.51337 0.43630 0.37136 0.31657 0.27027 0.23107 0.19784 0.16963 0.14564 0.09293 0.70016 0.64117 0.587390.49363 0.41552 0.35034 0.29586 0.25025 0.21199 0.17986 0.15282 0.13004 0.08081 0.68643 0.62553 0.57029 0.47464 0.39573 0.33051 0.27651 0.23171 0.19449 0.16351 0.13768 0.11611 0.07027 0.67297 0.61027 0.55368 0.45639 0.37689 0.31180 0.25842 0.21455 0.17843 0.14864 0.12403 0.10367 0.06110 DAY'S INVENTORY = 365 Days / Inventory Tumover DEBT TO ASSETS RATIO = Total Liabilities/Total Assets DEBT TO EQUITY RATIO = Total Liabilities/Total Equity TIMES INTEREST EARNED RATIO= (Income before taxes + Interest Expenses ) / Interest Expenses TC=CC+OC = (0/2) xPxC+(R/Q)XS Carrying Cost (CC) = 0/2 *p* C Ordering Cost (OC) = R/Q*S EOQ=/2RS/PC ROP=( R/360 days) (number of days to get an order)