Using the below data, please calculate the following 5 ratios for Years 2015, 2016 2017 1 Current Ratio 2 Cash Ratio 3 Debt Ratio 4 Debt to Equity Ratio 5 Payout Ratio Sprouts Balance Sheet (3 Year) Assets Fiscal year is January December All values USD millions 2015 2016 2017 Cash Short Term Investments 136 07M 12 47M 19 48M Cash Only 136 07M 12 47M 19 48M Short Term Investments Total Accounts Receivable 26 28M 27 38M 25 89M Accounts Receivables, Net 11 65M 14 11M 15 36M Accounts Receivables, Gross 11 75M 14 21M 15 46M Bad Debt Doubtful Accounts 100,000 100,000 100,000 Other Receivables 14 63M 13 27M 10 54M Inventories 165 43M 204 46M 229 54M Finished Goods 165 43M 204 46M 229 54M Work in Progress Raw Materials Progress Payments Other Other Current Assets 17 44M 19 72M 24 59M Miscellaneous Current Assets 462,000 462,000 454,000 Total Current Assets 345 22M 264 03M 299 51M 2016 2017 5 year trend Net Property, Plant Equipment 494 07M 604 66M 713 03M Property, Plant Equipment Gross 731 61M 902 54M 1 1B Buildings 115 93M 130 82M 151 31M Land Improvements Computer Software and Equipment Other Property, Plant Equipment 577 05M 722 45M 893 23M Accumulated Depreciation 237 54M 297 88M 383 61M Total Investments and Advances Other Long Term Investments Long Term Note Receivable Intangible Assets 566 68M 565 69M 564 28M Net Goodwill 368 08M 368 08M 368 08M Net Other Intangibles 198 6M 197 61M 196 21M Other Assets 19M 5 52M 4 78M Tangible Other Assets 19M 5 52M 4 78M Total Assets 1 55B 1 58B 1 68B Liabilities Shareholders' Equity ST Debt Current Portion LT Debt 14 97M 12 37M 9 24M Short Term Debt Current Portion of Long Term Debt 14 97M 12 37M 9 24M Accounts Payable 134 48M 157 55M 119 03M Income Tax Payable 7 04M 8 75M 3 39M Other Current Liabilities 73 93M 80 48M 168 05M Dividends Payable Accrued Payroll 30 72M 32 86M 45 62M Miscellaneous Current Liabilities 43 22M 47 62M 122 43M Total Current Liabilities 230 42M 259 16M 299 71M Long Term Debt 275 5M 372 37M 473 49M Long Term Debt excl Capitalized Leases 160M 255M 348M Non Convertible Debt 160M 255M 348M Convertible Debt Capitalized Lease Obligations 115 5M 117 37M 125 49M Provision for Risks Charges 19 83M 26 79M 22 76M Deferred Taxes (1 4M) 19 26M 27 07M Deferred Taxes Credit 123 33M 159 07M 129 55M Deferred Taxes Debit 124 73M 139 8M 102 48M Other Liabilities 77 62M 89 41M 107 88M Other Liabilities (excl Deferred Income) 77 62M 89 41M 107 88M Deferred Income Total Liabilities 726 7M 906 79M 1 03B Non Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non Redeemable Preferred Stock Common Equity (Total) 822 99M 672 91M 650 69M Common Stock Par Carry Value 153,000 140,000 132,000 Retained Earnings 245 45M 75 5M 30 56M ESOP Debt Guarantee Cumulative Translation Adjustment Unrealized For Exch Gain Unrealized Gain Loss Marketable Securities Revaluation Reserves Treasury Stock Total Shareholders' Equity 822 99M 672 91M 650 69M Accumulated Minority Interest Total Equity 822 99M 672 91M 650 69M Liabilities Shareholders' Equity 1 55B 1 58B 1 68B

The Answer is in the image, click to view ...

Question: Using the below data, please calculate the following 5 ratios for Years 2015, 2016 & 2017. 1. Current Ratio 2. Cash Ratio 3. Debt Ratio

Using the below data, please calculate the following 5 ratios for Years 2015, 2016 & 2017.

1. Current Ratio

2. Cash Ratio

3. Debt Ratio

4. Debt to Equity Ratio

5. Payout Ratio

Sprouts Balance Sheet (3-Year)
Assets
Fiscal year is January-December. All values USD millions.	2015	2016	2017
Cash & Short Term Investments	136.07M	12.47M	19.48M
Cash Only	136.07M	12.47M	19.48M
Short-Term Investments	-	-	-
Total Accounts Receivable	26.28M	27.38M	25.89M
Accounts Receivables, Net	11.65M	14.11M	15.36M
Accounts Receivables, Gross	11.75M	14.21M	15.46M
Bad Debt/Doubtful Accounts	-100,000	-100,000	-100,000
Other Receivables	14.63M	13.27M	10.54M
Inventories	165.43M	204.46M	229.54M
Finished Goods	165.43M	204.46M	229.54M
Work in Progress	-	-	-
Raw Materials	-	-	-
Progress Payments & Other	-	-	-
Other Current Assets	17.44M	19.72M	24.59M
Miscellaneous Current Assets	462,000	462,000	454,000
Total Current Assets	345.22M	264.03M	299.51M
	2016	2017	5-year trend
Net Property, Plant & Equipment	494.07M	604.66M	713.03M
Property, Plant & Equipment - Gross	731.61M	902.54M	1.1B
Buildings	115.93M	130.82M	151.31M
Land & Improvements	-	-	-
Computer Software and Equipment	-	-	-
Other Property, Plant & Equipment	577.05M	722.45M	893.23M
Accumulated Depreciation	237.54M	297.88M	383.61M
Total Investments and Advances	-	-	-
Other Long-Term Investments	-	-	-
Long-Term Note Receivable	-	-	-
Intangible Assets	566.68M	565.69M	564.28M
Net Goodwill	368.08M	368.08M	368.08M
Net Other Intangibles	198.6M	197.61M	196.21M
Other Assets	19M	5.52M	4.78M
Tangible Other Assets	19M	5.52M	4.78M
Total Assets	1.55B	1.58B	1.68B

Liabilities & Shareholders' Equity

ST Debt & Current Portion LT Debt	14.97M	12.37M	9.24M
Short Term Debt	-	-	-
Current Portion of Long Term Debt	14.97M	12.37M	9.24M
Accounts Payable	134.48M	157.55M	119.03M
Income Tax Payable	7.04M	8.75M	3.39M
Other Current Liabilities	73.93M	80.48M	168.05M
Dividends Payable	-	-	-
Accrued Payroll	30.72M	32.86M	45.62M
Miscellaneous Current Liabilities	43.22M	47.62M	122.43M
Total Current Liabilities	230.42M	259.16M	299.71M
Long-Term Debt	275.5M	372.37M	473.49M
Long-Term Debt excl. Capitalized Leases	160M	255M	348M
Non-Convertible Debt	160M	255M	348M
Convertible Debt	-	-	-
Capitalized Lease Obligations	115.5M	117.37M	125.49M
Provision for Risks & Charges	19.83M	26.79M	22.76M
Deferred Taxes	(1.4M)	19.26M	27.07M
Deferred Taxes - Credit	123.33M	159.07M	129.55M
Deferred Taxes - Debit	124.73M	139.8M	102.48M
Other Liabilities	77.62M	89.41M	107.88M
Other Liabilities (excl. Deferred Income)	77.62M	89.41M	107.88M
Deferred Income	-	-	-
Total Liabilities	726.7M	906.79M	1.03B
Non-Equity Reserves	-	-	-
Preferred Stock (Carrying Value)	-	-	-
Redeemable Preferred Stock	-	-	-
Non-Redeemable Preferred Stock	-	-	-
Common Equity (Total)	822.99M	672.91M	650.69M
Common Stock Par/Carry Value	153,000	140,000	132,000
Retained Earnings	245.45M	75.5M	30.56M
ESOP Debt Guarantee	-	-	-
Cumulative Translation Adjustment/Unrealized For. Exch. Gain	-	-	-
Unrealized Gain/Loss Marketable Securities	-	-	-
Revaluation Reserves	-	-	-
Treasury Stock	-	-	-
Total Shareholders' Equity	822.99M	672.91M	650.69M
Accumulated Minority Interest	-	-	-
Total Equity	822.99M	672.91M	650.69M
Liabilities & Shareholders' Equity	1.55B	1.58B	1.68B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

b. Quick ratio c. Cash ratio d. NWC to total assets ratio e. Debt-equity ratio and equity multiplier Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. Based...

i need Cost of Capital and Capital Structure: Managerial Finance Term Project American Airlines Section 1: Background Information American Airlines, founded in 1926 by Charles Lindbergh, began as a...

Balance Sheet All figures in millions of U.S. Dollar except per share items. FY2015 FY2016 FY2017 Assets Cash \& Short-Term Investments Short-Term Receivables Inventories Other Current Assets Total...

Balance Sheet All figures in millions of U . S . Dollar except per share items. FY 2 0 1 5 FY 2 0 1 6 FY 2 0 1 7 Assets Cash & Short - Term Investments 2 , 2 1 6 2 , 5 3 8 3 , 5 9 5 Short - Term...

Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017...

Prepare the following ratios for Mikes Manufacturing for 2014, 2015, 2016, & 2017: Current Ratio Quick Ratio Inventory Turnover Debt to Equity Gross Profit Margin Return on Assets Return on Equity...

Picasso Company is a wholesale distributor of packaging equipment and supplies. The companys sales have averaged about $900,000 annually for the 3-year period 20152017. The firms total assets at the...

Income statement and balance sheet data for The Sports Shack are provided below. Required: 1. Calculate the following risk ratios for 2015 and 2016. Receivables turnover ratio ....Current ratio...

please answer ONLY B Required: 1. Please calculate the following ratios and amounts: a) working capital, b) current ratio, c) acid-test ratio, d) cash to current liabilities ratio, e) days' sales in...

answer all pleaseeeee Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. UD JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners'...

How might charitable giving impact the income, gift, or estate tax outcome for your client? Is there an optimal strategy? Recommend a charitable donation for income, gift, or estate tax planning...

The following data represent the numbers of tornadoes that touched down during 1950 to 1994 in the 12 states that had the most tornadoes during this period. The data for these states are given in the...

1 8 Multiple Choice 3 points Which of the following are commonly used as collaterals when consumers borrow policy loans from their insurance companies? Consumers' own policies Consumers' expected...

Organizational culture guides a companies _ _ _ _ _ _ _ _ _ _ _ . Group of answer choices Mission and Vision Vision and Values Mission and Objectives Visions and Objectives

Be able to provide a brief history of the development of state and local civil service systems

Understand the purpose of the civil service system job classification

Explain why position classification and compensation are very important and controversial parts of public administration organizations governed by civil service