Creative Design, Inc., a kitchen appliance and supplies wholesale company, has engaged your CPA firm to prepare their financial statements for the end of their fiscal year, December 31, 2020. The following adjusted account balances have been provided to you. Your staff accountant has already verified the amounts. The amounts are expressed in millions. ($13,200 = $13,200,000)

Accounts payable	$	13,200
Accounts receivable		3,300
Accumulated depreciation: Demo appliances		12,900
Additional paid-in capital (Common Stock)		7,900
Bonds payable (due December 31, 2031)		23,000
Cash		15,100
Common stock (2,400 shares, $10 par value)		24,000
Cost of goods sold		103,015
Deferred income taxes		5,900
Depreciation expense: office equipment		2,400
Dividends declared		4,700
Income tax expense		8,040
Insurance expense		840
Land		39,800
Product inventory		20,200
Notes payable (due December 31, 2021)		2,700
Demo Appliances		42,100
Office supplies		860
Office supplies expense		510
Preferred stock (260 shares, $20 par value)		5,200
Premium on bonds payable		2,050
Prepaid rent		1,200
Rent expense		5,300
Retained earnings (January 2020)		21,850
Salaries expense		87,995
Sales		226,300
Sales returns and allowances		2,200
Sales taxes payable		3,400
Treasury stock (600 shares @ cost)		6,750
Utilities expense		4,090

You must use Excel to complete items 1 and 2

Create an Income Statement, Statement of Retained Earnings and Balance Sheet. Express amounts as above, no cents. ($13,200) The statements must be presented in standard GAAP format, and accounts must be in GAAP order.

Calculate the following: Gross Margin, Gross Profit Margin, Current Ratio, Return on Total Assets, Return on Common Shareholders Equity, and Earnings Per Share. You must show your work.

You may use either a well formatted block in Excel or a separate Word document for items 3 and 4.

Given only the statements and the ratios you have calculated: would you buy shares in this company?

Explain your answer to #3.