Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below find you will find summarized financial statements for Kroger. Using the ratio template discussed in the Mini-lecture; calculate all the ratios and include the
Below find you will find summarized financial statements for Kroger. Using the ratio template discussed in the Mini-lecture; calculate all the ratios and include the trend analysis. Be sure to show all calculations. The Kroger Co. ALL NUMBERS REPORTED IN MILLIONS $ Income Statement 2016 2015 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 109,830 (85,496) 24,334 (20,758) 3,576 (482) 3,094 (1,045) 2,049 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 2017 322 2014 401 2013 238 1,051 Balance Sheet Assets Cash Accounts Receivables Inventories Other Current Assets Total Current Assets Net Fixed Assets Other Assets Total Assets 2016 277 1,734 6,168 1,713 9,892 19,619 4,386 33,897 1,649 6,561 1,808 10,340 21,016 5,149 36,505 2015 268 1,266 5,688 1,689 8,911 17,912 3,733 30,556 5,146 1,524 1,116 5,651 1,662 8,830 16,893 3,558 29,281 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 Formula Yra Yr 3 Yr 5 Trend Trend Current Ratio Current Assets Current Liabilities Debt Ratio Total Liabilities Net Worth Sales Turnover Sales Toral Assets Return on Equity Earnings Refore Taxes Net Worth Retum on Assets Earnings Before Taxes Total Assets . Formula Yr1 Yr 1 Yr 2 r2 Yr 3 Yr 4 Yr 5 Trend Days Receivable Receivables x 365 X 365 X 365 X 365 X 365 X 365 Sales days days days days days Days Inventory Inventory x 365 X 365 x 365 x 365 X 365 X 365 Cost of Goods Sold days days days days days Days Accruals Accrued Expenses X 365 x 365 X 365 X 365 x 365 X 365 Cost of Goods Sold _days days days days days Days Payable Accounts Payable x 365 X 365 x 365 x 365 x 365 X 365 Cost of Goods Sold days days days days days Formula Yr 1 Yr2 Yr 2 Yr 4 Yr 5 Trend Trend Sales Growth Sales Yr 2 - Sales Yr 1 Sales Yr 1 Cost of Goods Sold Cost of Goods Sold Percentage Sales Sales & General SGA Expenses Administrative to Sales Sales Operating profit to Operating Profit Sales Sales Below find you will find summarized financial statements for Kroger. Using the ratio template discussed in the Mini-lecture; calculate all the ratios and include the trend analysis. Be sure to show all calculations. The Kroger Co. ALL NUMBERS REPORTED IN MILLIONS $ Income Statement 2016 2015 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 109,830 (85,496) 24,334 (20,758) 3,576 (482) 3,094 (1,045) 2,049 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 2017 322 2014 401 2013 238 1,051 Balance Sheet Assets Cash Accounts Receivables Inventories Other Current Assets Total Current Assets Net Fixed Assets Other Assets Total Assets 2016 277 1,734 6,168 1,713 9,892 19,619 4,386 33,897 1,649 6,561 1,808 10,340 21,016 5,149 36,505 2015 268 1,266 5,688 1,689 8,911 17,912 3,733 30,556 5,146 1,524 1,116 5,651 1,662 8,830 16,893 3,558 29,281 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 Formula Yra Yr 3 Yr 5 Trend Trend Current Ratio Current Assets Current Liabilities Debt Ratio Total Liabilities Net Worth Sales Turnover Sales Toral Assets Return on Equity Earnings Refore Taxes Net Worth Retum on Assets Earnings Before Taxes Total Assets . Formula Yr1 Yr 1 Yr 2 r2 Yr 3 Yr 4 Yr 5 Trend Days Receivable Receivables x 365 X 365 X 365 X 365 X 365 X 365 Sales days days days days days Days Inventory Inventory x 365 X 365 x 365 x 365 X 365 X 365 Cost of Goods Sold days days days days days Days Accruals Accrued Expenses X 365 x 365 X 365 X 365 x 365 X 365 Cost of Goods Sold _days days days days days Days Payable Accounts Payable x 365 X 365 x 365 x 365 x 365 X 365 Cost of Goods Sold days days days days days Formula Yr 1 Yr2 Yr 2 Yr 4 Yr 5 Trend Trend Sales Growth Sales Yr 2 - Sales Yr 1 Sales Yr 1 Cost of Goods Sold Cost of Goods Sold Percentage Sales Sales & General SGA Expenses Administrative to Sales Sales Operating profit to Operating Profit Sales Sales
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started