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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
