Calculate all the ratios and include the trend analysis and exclude the Days Accruals. Be sure to show all calculations.

Days Payable, Days Receivable, Days Inventory, Sales Growth, COGS Percentage, Operating Profit to Sales, Sales and General Asministrative to Sales, Current Ratio, Debt Ratio, Sales Turnover, Return on Equity, and Return on Assets. The picture gives an example

The Kroger Co. ALL NUMBERS REPORTED IN MILLIONS $ Income Statement Revenue Less: Cost of Goods Sold Gross Profit Less: SG&A Expense Operating Income +/- Other Revenue Other Expenses Income Before Taxes Less: Income Taxes Net Income After Taxes 2017 115,337 (89,502) 25,835 (22,399) 3,436 (522) 2,914 (939) 1,975 2016 109,830 (85,496) 24,334 (20,758) 3,576 (482) 3,094 (1,045) 2,049 2015 108,465 (85,512) 22,953 (19,816) 3,137 (488) 2,649 (902) 1,747 2014 98,375 (78,138) 20,237 (17,512) 2,725 (443) 2,282 (751) 1,531 2013 96,751 (76,858) 19,893 (17,129) 2,764 (462) 2,302 (794) 1,508 Balance Sheet Assets Cash Accounts Receivables Inventories Other Current Assets Total Current Assets Net Fixed Assets Other Assets Total Assets 2017 322 1,649 6,561 1,808 10,340 21,016 5,149 36,505 2016 277 1,734 6,168 1,713 9,892 19,619 4,386 33,897 2015 268 1,266 5,688 1,689 8,911 17,912 3,733 30,556 2014 401 1,116 5,651 1,662 8,830 16,893 3,558 29,281 2013 238 1,051 5,146 1,524 7,959 14,875 1,818 24,652 Liabilities Accounts Payable Short Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Noncurrent Liabilities Total Liabilities 5,818 2,252 4,790 12,860 11,825 5,122 29,807 5,728 2,370 4,873 12,971 9,709 4,397 27,077 5,052 1,885 4,466 11,403 9,771 3,970 25,144 4,881 1,657 4,167 10,705 9,653 3,539 23,897 4,524 2,734 4,249 11,507 6,145 2,793 20,445 Stockholder's Equity 6,698 6,820 5,412 5,384 4,207 Total Liabilities & Stockholder's Equity 36,505 33,897 30,556 29,281 24,652 Financial Ratio Worksheet Formula Yr 2 Y 3 Yr 5 Trend Days Receivable 365 365 x 365 x 365 x 365 365 Sales days days days Days Inventory 365 365 x 365 x 365 x 365 365 Cost of Goods Sold days days days days days Days Accue x365 365 x 35 Accrued Expenses Cost of Goods Sold x 365 x 365 365 days days days days days Days Payable Accounts Payable Cost of Goods Sold 365 x x 365 days days days days