Corporation: December 31 Balance Sheets
(Thousands of Dollars)
Assets		2020	2019
Cash and cash equivalents		$18,700	$17,100
Short-term investments		2,944	2,260
Accounts Receivable		60,200	40,100
Inventories		80,000	52,000
Total current assets		?	?
Net fixed assets		219,055	196,000
Total assets
Liabilities and equity
Accounts payable		$30,360	$28,650
Accruals		11,500	11,000
Notes payable		19,929	6,480
Total current liabilities		?	?
Long-term debt		67,662	58,320
Total liabilities		?	?
Common stock		178,440	178,440
Retained Earnings		?	40,000
Total common equity
Total liabilities and equity
December 31 Income Statements
(Thousands of Dollars)
		2020	2019
Sales		$380,000	$365,000
COGS except excluding depr. and amort.		290,000	287,500
Depreciation and Amortization		17,650	16,000
Other operating expenses		24,390	18,900
EBIT		?	?
Interest Expense		5,210	3,910
EBT
Taxes (25%)
Net Income		?	?
Tax rate	25%
Common dividends		$18,125	$17,262
Addition to retained earnings		?	?
		2020	2019
Net Operating Working Capital (NOWC)		?	?
Total Net Operating Capital (TNOC)		?	?
Investment in TNOC		?	?
Net Operating Profit After Taxes (NOPAT)		?	?
Free Cash Flow (FCF)		?	?
Return on Investment Capital (ROIC)		?	?
Other Data		2020	2019
Year-end Stock Price		$84.00	$89.00
# of shares (Thousands)		3,571	3,500
Ratio Analysis		2020	2019
Liquidity Ratios		?	?
Current Ratio		?	?
Quick Ratio		?	?
Asset Management Ratios
Inventory Turnover (Total COGS/Inventories)		?	?
Total Assets Turnover		?	?
Debt Management Ratios
Debt Ratio (Total debt-to-assets)		?	?
Profitability Ratios
Profit Margin		?	?
Return on Assets		?	?
Return on Equity		?	?
Market Value Ratios
Earnings per share		?	?

please show how to input into excel sheet. Thanks!