1. Sweet Candy Corp. has prepared the following financial statements:

Sweet Candy Corp.				Sweet Candy Corp.
Income Statement				Balance Sheet
For the Year Ended Dec. 31 2019				As of Dec. 31 2019
	2019	2018		Assets	2019	2018
Sales	3,074,000	2,567,000		Cash	431,000	339,000
Cost of Goods Sold	2,088,000	1,711,000		Accounts Receivable	503,000	365,000
Gross Profit	986,000	856,000		Inventories	289,000	300,000
Selling and G&A Expenses	294,000	295,000		Total Current Assets	1,223,000	1,004,000
Fixed Expenses	35,000	35,000		Gross Fixed Assets	4,669,000	4,322,000
Depreciation Expense	239,000	223,000		Accumulated Depreciation	2,295,000	2,056,000
EBIT	418,000	303,000		Net Fixed Assets	2,374,000	2,266,000
Interest Expense	93,000	91,000		Total Assets	3,597,000	3,270,000
Earnings Before Taxes	325,000	212,000		Liabilities and Owners' Equity
Taxes	94,000	64,000		Accounts Payable	382,000	270,000
Net Income	231,000	148,000		Short-term Notes Payable	79,000	99,000
				Accrued Expenses	159,000	114,000
				Total Current Liabilities	620,000	483,000
				Long-term Debt	1,023,000	967,000
				Total Liabilities	1,643,000	1,450,000
				Common Stock	819,000	808,000
				Retained Earnings	1,135,000	1,012,000
				Total Shareholder's Equity	1,954,000	1,820,000
				Total Liabilities and Owners' Equity	3,597,000	3,270,000

1. Use the template posted and set up a worksheet, and calculate all the ratios in the template for Sweet Candy Corp.

*Here is the template provided, please show equations if possible as well*

Sweet Candy Corp.
Ratios	2019	2018	Industry 2019	Analysis
	Liquidity Ratios
Current Ratio			2.50x
Quick Ratio			0.60x
	Efficiency Ratios
Inventory Turnover Ratio			6.50x
Accounts Receivable Turnover Ratio			8.00x
Average Collection Period			40.00 days
Fixed Asset Turnover			2.00x
Total Asset Turnover			2.00x
	Leverage Ratios
Total Debt Ratio			50.00%
Long-Term Debt Ratio			20.00%
LTD to Total Capitalization			30.00%
Debt to Equity			0.90x
Long-Term Debt to Equity			40.00%
	Coverage Ratios
Times Interest Earned			2.50x
Cash Coverage Ratio			3.50x
	Profitability Ratios
Gross Profit Margin			20.00%
Operating Proft Margin			7.00%
Net Proft Margin			5.00%
Return on Total Assets			5.00%
Return on Equity			8.00%
Return on Common Equity			10.00%
Du Pont ROE
Market Value of Equity	1,200,000	1,200,000
Z-Score for Public Firms
Sweet Candy Corp.
Economic Profit Calculations
	2019	2018
Tax Rate
NOPAT
Total Operating Capital
After-tax Cost of Capital	12%	12%
Dollar Cost of Capital
Economic Profit