Please show all work (in Excel with formulas if possible).

HIT IT FAR GOLF CORPORATION 2020 and 2021 Balance Sheets
Assets			Liabilities and Owners Equity
	2020	2021		2020	2021
Current assets			Current liabilities
Cash	$12,157	$14,105	Accounts payable	$46,382	$49,276
Accounts receivable	$29,382	$32,815	Notes payable	$18,246	$19,784
Inventory	$54,632	$57,204	Total	$64,628	$69,060
Total	$96,171	$104,124	Long-term debt	$49,000	$45,000
			Owners equity
Fixed assets			Common stock & paid-in surplus	$50,000	$50,000
Net plant & equipment	$367,241	$375,830	Accumulated retained earnings	$299,784	$315,894
			Total	$349,784	$365,894
Total assets	$463,412	$479,954	Total liabilities and owners equity	$463,412	$479,954

1. Prepare the 2020 and 2021 common-size balance sheets for Hit it Far Golf.

2. Based on the balance sheets given for Hit it Far Golf, calculate the current ratio, quick ratio, cash ratio, NWC to total assets ratio, debt-equity ratio and equity multiplier, and total debt ratio and long-term debt ratio