I need help with the highlighted portion of this problem. Formulas written out would be great thanks! ACME Corp.

Note: Enter formulas in the cells highlighted yellow. Cells that have a little triangle in the upper right hand corner have comments you can vlew. Let the cursor hover over the cell and the comment will appear. These comments have hints or Instructions.

Part a$,$ Enter formulas to complete the balance sheet and income statement.

Income Statement$($Milllons$)$

Sales

Costs of Goods Sold

Sales, General and Administrative

Depreciation

Interest expense

Taxes $(40\%)$

Net Income

Dividends

Additions to Retained Eamings

Balance Sheet$($Millions$)$

Assets

Cash

Inventory

Accounts receivable

$31$ Total current assets

$32$ Gross PPE

Accumulated depreciation

Labllities

Accounts payable

Accrued expenses

Short$-$term debt

$40$

$1$ Long$-$term debt

Total current liabilities

$42$

$43$ Common stock

$44$ Retained eamings

Total liabilities

$45$

$46$

$47$ Part b$.$ Enter formulas to complete the statement of shareholders' equity and

statement of cash flow.

Statement of Shareholders' Equity

Balance as of December $31$ of previous

year

Net Income

Dividends on Common Stock

Issuance of Common Stock

Common Stock Repurchases

Balance as of December $31$

Statement of Cash Flows

Operating Activities

Net Income

Depreciation & Amortization

Change in Inventory

Change in Accounts Receivable

Change in Accounts Payable

Change in Accruals

$69$ Net cash from operating activities

Investing Activities

Investment in PPE

Net cash from investing activities

Financing Activities

Change in short$-$term debt

Change in long$-$term debt

Change in common stock

Common dividends

Net cash from financing activities

Net cash flow

Starting cash

Ending cash Part c$.$ Free Cash Flow

Cash Flow Identity

$91$ Operating profit

Taxes

NOPAT

Depreciation

Operating Cash Flow $($OCF$)$

$97$ Investment in NOWC

$98$ CAPEX $($Net Capital Spending$)$

$99$ Total Investment

$100$

$101$ Free Cash Flow