Question

1 Approved Answer

Posted on Aug 01, 2024

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

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 5 2440 5 IND 5 2.1 11.54 1:28. (00.131 7. 10.30 1.2.2 1438.254 12 Current Assets Canhand shortest Recettes esed expenses and other current Property Land Bus Futures went Transport . Acumulated depreciation and mortation Total property, net Best of cost over het auteuired Other Total Label and stochodowy Carentes Notes de |currnter apisilienate Current nature of notes and des Maybe Are Series and was Other credere mense Teatte LORE met og tinder Nos and Deberes allongement Aucundam and the abilities |Paal Stadens Como Additional Paid Caps Curmation et Total Storiquity Detalles and holdersity 2004 S. 004 557.500 15. . 2123 2.2.1,72,1 24 11 1 744 1,16 1,1540 4,093, 400 L 1,711, 2, 2, 1,21 225 30.00 36.58 38 6. 66.415 4.513,22 412 Increase of Bere 2012 2018 Pere $ $ 110.45 45.0 40 LIN 24,722 21.31 1,00 IN 2.0 38. 1. 12.30 14 20:43 122, 1., . 255.0 21 110 111 12 116 100 2.74.000 197 101 . 10. 223 1938,994 134.00 11 1. LS2L174.363 BA 162 Safeway Stores, Inc. Comparative statements of income 2019 en De 2018 Al Pena $ $ $ Sales 19,862,201 18.585.217 LO 5. cont of sales 35,00 14.4.14 24.04 Grote 4,637,654 433 200 6.57 Darating and committee 4.214.000 7.45 Creating Profit 4131 414,6 2.0T 351.30 IN 360 12.00 Om os 26, 200 come before provation for income taxes 300 12.11 income 11111 IL 2. Not Income 16.011 11, 1,200 B. Mercome poshte 21 10.30 1) Calculate the following Liqudity Ratios Proto 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? 3% 15% TABLE B-1 PRESENT VALUE OF 1 PV = (n) 0+ in Periods 25 20% 4% 5% 6% 7% 8% 10% 115 12% 1 098039 097561 097187 096154 098238 0.90340 09315 099593 09110 90909 0.90050 0286 09857 2 096117 095181 0.4250 926 090709 0.99.000 0.87344 085734 034158 080515 081192 079719 0.75614 3 0.94232 092860 091514 0.88.00 0.863 0.33862 081530 0.73383 0.77218 0.75131 0.7319 01 06572 4 0.92385 090595 0.8849 0.85480 082270 0.79209 0.75290 073513 07066 0230 055873 063552 057175 5 0.90573 088.385 086281 082193 0.72353 0.426 071299 0.58098 0.54993 652092 05935 056743 0671 6 088797 085230 063748 079031 0.74622 0.70156 090634 053017 05821 056441 053464 05066 0623 7 087056 031127 031309 0.79992 0.71058 056506 052275 05839 054703 051316 0.0156 015235 0.37994 8 085349 092075 0.7841 073069 067684 05231 0.58201 054027 050187 0.851 06.393 040388 0.30890 9 0.83676 073 07662 070099 061461 0.99190056 05105 046143 0.4240 0.33 0.36061 0286 10 0.035 0.78120 0.749 067556 061391 055829 050836 0.18319 0.021 0.33651 035218 032197 02079 11 12 13 14 15 0.8026 0.78244 0.77212 0.54958 058468 0.5679 047509 088 0.38753 035049 031728 0288 02164 0:78849 0.740356 0.70138 062460 055684 0.49897 0.44401 0.99711 035653 0.3186 0.2854 62508 0.1861 0.77303 07256 0.58056 050057 05302 0.16884 01186 0.35770 032518 020966 0.25751 072917 0.15253 0.75788 0.70773 096112 057743 05050 0.40730 0372 0.34346 0295 020 0.23199 020462 0.1433 0.7301 067041 0.51186 0.5556 0.68702 0.0172 0.3826 031524 0.2764 0.23339 0.20900 016270 017289 16 12 19 19 20 0.72515067362 052317 053381 0465811 039355 833873 0218 025187 02172 0.78829 0.16312 0.10676 071416 06572 05052 05133 003530 037136 037657 021027 023707 0.19784 0.13 016564 1525 0.70016 060117 058729 048363 041552 0.35034 0295 0.25035 02719 2.1796 0.1522 073004008081 0.68643 06256 0.57029 047964039573 0.33051 0.27657 023111 019449 016351 0.13/01111 09727 0.57297 067027 05638 015639 0376 031180 02380 021456 01733 01661 0.1203 010367 0910 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 5 2440 5 IND 5 2.1 11.54 1:28. (00.131 7. 10.30 1.2.2 1438.254 12 Current Assets Canhand shortest Recettes esed expenses and other current Property Land Bus Futures went Transport . Acumulated depreciation and mortation Total property, net Best of cost over het auteuired Other Total Label and stochodowy Carentes Notes de |currnter apisilienate Current nature of notes and des Maybe Are Series and was Other credere mense Teatte LORE met og tinder Nos and Deberes allongement Aucundam and the abilities |Paal Stadens Como Additional Paid Caps Curmation et Total Storiquity Detalles and holdersity 2004 S. 004 557.500 15. . 2123 2.2.1,72,1 24 11 1 744 1,16 1,1540 4,093, 400 L 1,711, 2, 2, 1,21 225 30.00 36.58 38 6. 66.415 4.513,22 412 Increase of Bere 2012 2018 Pere $ $ 110.45 45.0 40 LIN 24,722 21.31 1,00 IN 2.0 38. 1. 12.30 14 20:43 122, 1., . 255.0 21 110 111 12 116 100 2.74.000 197 101 . 10. 223 1938,994 134.00 11 1. LS2L174.363 BA 162 Safeway Stores, Inc. Comparative statements of income 2019 en De 2018 Al Pena $ $ $ Sales 19,862,201 18.585.217 LO 5. cont of sales 35,00 14.4.14 24.04 Grote 4,637,654 433 200 6.57 Darating and committee 4.214.000 7.45 Creating Profit 4131 414,6 2.0T 351.30 IN 360 12.00 Om os 26, 200 come before provation for income taxes 300 12.11 income 11111 IL 2. Not Income 16.011 11, 1,200 B. Mercome poshte 21 10.30 1) Calculate the following Liqudity Ratios Proto 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? 3% 15% TABLE B-1 PRESENT VALUE OF 1 PV = (n) 0+ in Periods 25 20% 4% 5% 6% 7% 8% 10% 115 12% 1 098039 097561 097187 096154 098238 0.90340 09315 099593 09110 90909 0.90050 0286 09857 2 096117 095181 0.4250 926 090709 0.99.000 0.87344 085734 034158 080515 081192 079719 0.75614 3 0.94232 092860 091514 0.88.00 0.863 0.33862 081530 0.73383 0.77218 0.75131 0.7319 01 06572 4 0.92385 090595 0.8849 0.85480 082270 0.79209 0.75290 073513 07066 0230 055873 063552 057175 5 0.90573 088.385 086281 082193 0.72353 0.426 071299 0.58098 0.54993 652092 05935 056743 0671 6 088797 085230 063748 079031 0.74622 0.70156 090634 053017 05821 056441 053464 05066 0623 7 087056 031127 031309 0.79992 0.71058 056506 052275 05839 054703 051316 0.0156 015235 0.37994 8 085349 092075 0.7841 073069 067684 05231 0.58201 054027 050187 0.851 06.393 040388 0.30890 9 0.83676 073 07662 070099 061461 0.99190056 05105 046143 0.4240 0.33 0.36061 0286 10 0.035 0.78120 0.749 067556 061391 055829 050836 0.18319 0.021 0.33651 035218 032197 02079 11 12 13 14 15 0.8026 0.78244 0.77212 0.54958 058468 0.5679 047509 088 0.38753 035049 031728 0288 02164 0:78849 0.740356 0.70138 062460 055684 0.49897 0.44401 0.99711 035653 0.3186 0.2854 62508 0.1861 0.77303 07256 0.58056 050057 05302 0.16884 01186 0.35770 032518 020966 0.25751 072917 0.15253 0.75788 0.70773 096112 057743 05050 0.40730 0372 0.34346 0295 020 0.23199 020462 0.1433 0.7301 067041 0.51186 0.5556 0.68702 0.0172 0.3826 031524 0.2764 0.23339 0.20900 016270 017289 16 12 19 19 20 0.72515067362 052317 053381 0465811 039355 833873 0218 025187 02172 0.78829 0.16312 0.10676 071416 06572 05052 05133 003530 037136 037657 021027 023707 0.19784 0.13 016564 1525 0.70016 060117 058729 048363 041552 0.35034 0295 0.25035 02719 2.1796 0.1522 073004008081 0.68643 06256 0.57029 047964039573 0.33051 0.27657 023111 019449 016351 0.13/01111 09727 0.57297 067027 05638 015639 0376 031180 02380 021456 01733 01661 0.1203 010367 0910