ROIC & WACC
Prob 3-1: ACME General 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. There may be slight (1 or 2 decimal) difference between this spreadsheet and what is in the text due to rounding of the entries in the statements.
Part a. Enter formulas to complete the balance sheet and income statement.
Income Statement (Millions)
Costs of Goods Sold2,312.352,566.712,797.71
Sales, General and Administrative745.92827.97902.49
Earnings Before Taxes
Additions to Retained Earnings
Balance Sheet (Millions)
Total current assets
Total current liabilities
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
Balance as of December 31 of previous year
Dividends on Common Stock
Issuance of Common Stock
Common Stock Repurchases0.000.00
Balance as of December 31
Statement of Cash Flows
Depreciation & Amortization
Change in Inventory
Change in Accounts Receivable
Change in Accounts Payable
Change in Accruals
Net cash from operating activities
Investment in PPE
Net cash from investing activities
Change in short-term debt
Change in long-term debt
Change in common stock
Net cash from financing activities
Net cash flow
Part c. Calclate free cash flow and return on invested capital.
Free Cash Flow Calculation
Tax on operating profit (40%)
Operating current assets
Operating current liabilities
Total net operating capital
Investment in total net operating capital277.20
Return on Invested Capital (ROIC)
Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more