In this assignment you are asked to open the Excel Spreadsheet for YP Enterprises (March 2019) and complete the section entitled Ratios 2019 (highlighted in yellow). This will require you to calculate the specified ratios using the information provided. All information can be found on the income statement and balance sheet included within the spreadsheet. Please see spreadsheet below. In this assignment you are aYP Enterprises 2019 2018 2017 2016 2015 2014 Net sales 3,351 3,314 2,845 2,796 2,493 2,160 EBIT -9 312 256 243 212 156 Interest 37 63 65 58 48 46 Taxes 3 60 46 43 39 34 Net profit -49 189 145 142 125 76 Earnings per share -0.15 0.55 0.44 0.42 0.37 0.25 Current assets 669 469 491 435 392 423 Net fixed assets 923 780 753 680 610 536 Total assets 1,592 1,249 1,244 1,115 1,002 959 Current liabilities 680 365 348 302 276 320 Long-term debt 236 159 297 311 319 315 Shareholders' equity 676 725 599 502 407 324 Number of stores 240 221 211 184 170 157 Employees 13,057 11,835 9,810 9,790 9,075 7,825 Times interest earned -0.243 4.952 3.938 4.190 4.417 3.391 Long-term debt-equity ratio 0.349 0.219 0.496 0.620 0.784