Question: I need help fill. all blank spaces. ACME Corp. Note: Enter formulas in the cells highlighted yellow. Cells that have a little triangle in the

I need help fill. all blank spaces.

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 view. 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 (Millions)
2018 2019 2020
Sales 3,729.60 4,139.86 4,512.44
Costs of Goods Sold 2,312.35 2,566.71 2,797.71
Sales, General and Administrative 745.92 827.97 902.49
Depreciation 186.48 206.99 225.62
Operating Profit
Interest expense 88.05 96.49 105.73
Earnings Before Taxes
Taxes (40%)
Net Income
Dividends 100.00 160.04 104.89
Additions to Retained Earnings xxxxxxx
Balance Sheet (Millions)
Assets 2018 2019 2020
Cash 37.30 41.40 45.12
Inventory 522.14 579.58 631.74
Accounts receivable 932.40 1034.96 1128.11
Total current assets
Gross PPE 2,619.28 3,031.40 3,443.32
Accumulated depreciation 754.48
Net PPE 1,864.80 2,069.93 2,256.23
Total assets xxxxxxxx 3,725.87 4,061.20
Liabilities
Accounts payable 372.96 413.99 451.24
Accrued expenses 186.48 206.99 225.62
Short-term debt 183.19 285.90 381.71
Total current liabilities
Long-term debt 1,000.00 1,000.00 1,000.00
Total liabilities
Common stock 500.00 600.00 600.00
Retained earnings 1,114.01
Total common equity
Total liabilities and equity
Part b. Enter formulas to complete the statement of shareholders' equity and statement of cash flow.
Statement of Shareholders' Equity
2019 2020
Balance as of December 31 of previous year xxxx
Net Income xxxxxx
Dividends on Common Stock xxxxxx
Issuance of Common Stock xxxxx
Common Stock Repurchases xxxxxx 0.00 0.00
Balance as of December 31 xxxxx
Statement of Cash Flows
2019 2020
Operating Activities
Net Income xxxxxx
Depreciation & Amortization xxxxxxx
Change in Inventory xxxxxx
Change in Accounts Receivable xxxxxx
Change in Accounts Payable xxxxx
Change in Accruals xxxxxx
Net cash from operating activities xxxxxxx
Investing Activities
Investment in PPE xxxxxx
Net cash from investing activities xxxxxxx
Financing Activities
Change in short-term debt xxxxx
Change in long-term debt xxxxxxx
Change in common stock xxxxx
Common dividends xxxxx
Net cash from financing activities xxxxx
Net cash flow
Starting cash xxxxx
Ending cash xxxxxx
Part c. Free Cash Flow
Cash Flow Identity
2019 2020
Operating profit xxxx
- Taxes xxxxxx
NOPAT xxxxx
+ Depreciation xxxxx
Operating Cash Flow (OCF) xxxxxx
Investment in NOWC xxxxxx
CAPEX (Net Capital Spending) xxxxxxx
Total Investment xxxxxx
Free Cash Flow xxxxx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!