Using the information given, complete the Balance Sheet and Income Statement for Columbia Enterprises, Inc.

Then, do the Common Size calculations. There is adequate information to complete all statements. (Using excel please show all the formulas in their corresponding cells) Thanks

165,000 Columbia Enterprises, Inc. Working Capital Accounts Payable Accounts Receivable Accumulated Depreciation 80,000 145,600 65,000 Cash Common Stock Cost of Goods sold Current Assets Current Liabilities Depreciation EBIT 352,400 EBITDA General & Administrative Expenses 183,640 865,000 Gross Fixed Assets Gross Profit 581,955 Interest Paid 12,400 245,700 Inventory Long-Term Debt 177,010 800,000 Net Fixed Assets Net Income 206,300 Notes Payable Retained Earnings 287,990 Sales 830,655 Taxable Income Taxes @ 35% Total Assets Total Equity Total Liabilities NAME: Date: Columbia Enterprises, Inc. Balance Sheet (000) 12/31/20 Common Size CURRENT ASSETS TOTAL ASSETS TOTAL DEBT TOTAL EQUITY TOTAL LIABILITIES & EQUITY Working Capital: 165,000 NAME: Date: Columbia Enterprises, Inc. Income Statement (000) 12/31/2020 Common Size COST OF GOODS SOLD EBITDA EBIT TAXES (21%) Dividends