Concept explainers
2018 | 2017 | |
Assets | ||
Cash and equivalents | $ 15,000 | $ 14,000 |
Accounts receivable | 35,000 | 30,000 |
Inventories | 33,320 | 27,000 |
Total current assets | $83,320 | $71,000 |
Net plant and equipment | 48,000 | 46,000 |
Total assets | $131,320 | $117,000 |
Liabilities and Equity | ||
Accounts payable | $ 10,100 | $ 9,000 |
Accruals | 8,000 | 6,000 |
Notes payable | 7,000 | 5,050 |
Total current liabilities | $ 25,100 | $ 20,050 |
Long term bonds | 20,000 | $20,000 |
Total liabilities | $45,100 | $ 40,050 |
Common stock(4,000 shares) | 40,000 | 40,000 |
46,220 | 36,950 | |
Common equity | $ 86,220 | $ 76,950 |
Total liabilities and equity | $ 131,320 | $ 117,000 |
Income Statement for Year Ending December 31, 2018
Sales | $ 210,000 |
Operating cost excluding |
160,00 |
EBITDA | $ 50,000 |
Depreciation and amortization | 6000 |
EBIT | $ 44,000 |
interest | 5,350 |
EBT | 5,38,650 |
Taxes (40%) | 15,460 |
Net income | $ 23,190 |
Dividends paid | $13,920 |
- a. What was net operating working capital for 2017 and 2018? Assume that all cash is excess cash; i.e., this cash is not needed for operating purposes.
- b. What was .Arlington’s 2018 free cash flow?
- c. Construct Arlington’s 2018 statement of stockholders’ equity.
- d. What was Arlington’s 2018 EVA? Assume that its after tax cost of capital is 10%.
- e. What was Arlington’s MVA at year-end 2018? Assume that its stock price at December 31, 2018? Was $25.
a.
To compute: The net operating working capital of Company A.
Financial Statements:
A part of annual report that is attributed to the financials aspects of the company for an accounting period is called financial statements. These include balance sheet, statement of retained earnings, income statement, and cash flow statement.
Net Operating Working Capital:
The difference of current assets and current liabilities is called as the working capital. When only accounts payable and accruals are considered instead of total current liabilities, the difference is called as the net operating working capital.
Explanation of Solution
Given information (for 2017)
Cash and equivalents is $14,000.
Note payable is $5,050.
Current assets are $71,000.
Current liabilities is $20,050.
Formula to compute operating current assets is as follows:
Compute operating current assets is as follows:
Hence, the operating current asset is $57,000.
Formula to compute operating current liabilities is as follows:
Compute operating current liabilities is as follows:
Hence, the operating current liabilities is $15,000.
Formula to compute net operating working capital is as follows:
Compute net operating working capital is as follows:
Hence, the net operating working capital for 2017 is $42,000.
Given information (for 2018)
Cash and equivalents is $15,000.
Note payable is $7,000.
Current liabilities is $25,100.
Current assets are $83,320.
Formula to compute operating current assets:
Compute operating current assets:
Hence, the operating current asset is $68,320.
Formula to compute operating current liabilities:
Compute operating current liabilities:
Hence, the operating current liabilities is $18,100.
Formula to compute net operating working capital is as follows:
Compute net operating working capital is as follows:
Hence, the net operating working capital for 2018 is $50,220.
Therefore, Company A has net operating working capital of $42,000 and $50,220 in 2017 and 2018, respectively.
b.
To compute: The free cash flow in 2018 for Company A.
Free Cash Flow: The cash generated over and above required by the business operations and capital expenditure known as free cash flow. Statement of cash flow reports the cash flow generated or consumed by the business.
Explanation of Solution
Given information:
EBIT is $44,000.
Depreciation is $6,000.
Capital expenditure is $8,000.
Tax rate is 40%.
Change in net operating working capital is $8,220
Formula to compute free cash flow is as follows:
Compute free cash flow is as follows:
Substitute $44,000 for EBIT, 40% for tax rate, $6,000 for depreciation, $8,000 for capital expenditure and $9,220 for change in net operating working capital.
Hence, the free cash flow is $16,180.
Therefore, Company A’s free cash flow for 2016 is $16,180.
c.
To prepare: The statement of stockholders’ equity of Company A for 2018.
Statement of Stockholders’ Equity: Statement of stockholders’ equity shows the opening and closing balance of stockholder’s equity with the changes occurred during the accounting period.
Explanation of Solution
Statement of stockholders’ equity:
Shares | Amount | Retained Earnings | Total Stockholders’ Equity | |
Balances, December 31, 2017 | 4,000 | 40,000 | 36,950 | 76,950 |
2018 Net income | 23,190 | |||
Cash dividends | (13,920) | |||
Additional to retained earnings | 9,270 | |||
Balances, December 31, 2018 | 4,000 | 40,000 | 46,220 | 86,220 |
Therefore, Company A has stockholders’ equity of $86,220 at the end of year 2018.
d.
To compute: The economic value added for Company A for 2018.
Economic Value Added (EVA): It is a measure along with market value added to evaluate the management’s performance. It considers the opportunity costs of capital invested in the business and the net operating profit generated by the business.
Explanation of Solution
Given information:
EBIT is $44,000.
Tax rate is 40%.
Total invested capital $113,220 (working note).
After tax percentage cost of capital is 10%.
Formula to compute economic value added is as follows:
Substitute $44,000 for EBIT, 40% for tax rate, $113,220 for invested capital and 10% for after tax percentage cost of capital.
Compute economic value added is as follows:
Hence, the economic value added is $15,078.
Working note:
Calculation of total invested capital is as follows:
Hence, the total invested capital is $113,220.
Therefore, the economic value added of Company A for the year 2018 is $15,078.
e.
To compute: The market value added for Company A for the year 2018.
Market Value Added: The measure to evaluate management’s performance in a company’s operations and growth, market value added considers the market value of company’s outstanding shares. It reports the market value over and above the book value of those outstanding shares.
Explanation of Solution
Given information:
Book value of common equity is $86,220.
Stock price is $25 per share.
Number of shares outstanding are 4,000.
Formula to compute market value added is as follows:
Substitute $86,220 for book value of common equity, $25 for stock price and 4,000 for number of shares outstanding.
Compute market value added is as follows:
Hence, the market value is $13,780.
Therefore, the market value added for Company A for the year 2018 is $13,780.
Want to see more full solutions like this?
Chapter 3 Solutions
Bundle: Fundamentals of Financial Management, 15th + MindTap Finance, 1 term (6 months) Printed Access Card
- Comprehensive: Balance Sheet from Statement of Cash Flows Mills Company prepared the following balance sheet at the beginning of 2019: Additional information related to the statement of cash flows: 1. The long-term bonds have a face value of 6,000 and were issued on December 31, 2019. 2. The building was purchased on December 30, 2019. 3. The land was sold at its original cost. 4. The common stock which was sold totaled 300 shares and had a par value of 10 per share. Required: Next Level Prepare a classified balance sheet for Mills as of December 31, 2019. (Hint. Review the information on the statement of cash flows and the balances in the beginning balance sheet accounts to determine the impact on the ending balance sheet accounts.)arrow_forwardBalance Sheet (Millions of $) Assets 2018 Cash and securities $3,000 Accounts receivable 15,000 Inventories 18,000 Total current assets $36,000 Net plant and equipment $24,000 Total assets $60,000 Liabilities and Equity Accounts payable $18,630 Accruals 8,370 Notes payable 6,000 Total current liabilities $33,000 Long-term bonds $9,000 Total liabilities $42,000 Common stock $5,040 Retained earnings 12,960 Total common equity $18,000 Total liabilities and equity $60,000 Income Statement (Millions of $) 2018 Net sales $84,000 Operating costs except depreciation 78,120 Depreciation 1,680 Earnings before interest and taxes (EBIT) $4,200 Less interest 900 Earnings before taxes (EBT) $3,300…arrow_forwardPresented below are data taken from the records of Crane Company. December 31, 2020 December 31, 2019 Cash $15,000 $7,900 Current assets other than cash 85,700 60,300 Long-term investments 10,000 52,700 Plant assets 334,400 216,700 $445,100 $337,600 Accumulated depreciation $20,100 $39,800 Current liabilities 39,700 22,100 Bonds payable 74,600 –0– Common stock 252,600 252,600 Retained earnings 58,100 23,100 $445,100 $337,600 Additional information: 1. Held-to-maturity debt securities carried at a cost of $42,700 on December 31, 2019, were sold in 2020 for $34,000. The loss (not unusual) was incorrectly charged directly to Retained Earnings. 2. Plant assets that cost $49,600 and were 80% depreciated were sold during 2020 for $8,000. The loss was incorrectly charged directly to Retained Earnings. 3. Net income as reported on the…arrow_forward
- Please show calculationarrow_forward...///// Acme Company Balance Sheet As of January 5, 2023 (amounts in thousands) Cash 8,400 Accounts Payable 2,800 Accounts Receivable 4,700 Debt 3,400 Inventory 4,200 Other Liabilities 900 Property Plant & Equipment 17,200 Total Liabilities 7,100 Other Assets 2,800 Paid-In Capital 6,700 Retained Earnings 23,500 Total Equity 30,200 Total Assets 37,300 Total Liabilities & Equity 37,300 Update the balance sheet above to reflect the transactions below, which occur on January 6, 2023 1. Sell product for $25,000 with historical cost of $20,000 2. Sell product for $30,000 with historical cost of $24,000 3. Sell product for $20,000 with historical cost of $16,000 What is the final amount in Retained Earnings? help plz thank u smarrow_forwardOriole Company Balance Sheets December 31 Assets Cash Receivables (net) Other current assets 2022 2021 $28,400 $20,800 77,000 61,500 67,100 53,700 Long-term investments 62,200 61,000 Property, plant, and equipment (net) 610,000 488,000 Total assets $844,700 685,000 Liabilities and Stockholders' Equity. Current liabilities $75,000 $68,000 Long-term liabilities 84,500 96,000 Common stock 333,000 298,500 Retained earnings 352,200 222,500 Total liabilities and stockholders' equity $844,700 $685,000 Oriole Company Income Statements For the Years Ended December 31 2022 2021 Sales revenue $775,940 $674,200 Cost of goods sold 448,000 401,000 Operating expenses (including income taxes) 256,000 218,000 Net income $71,940 $55,200 Additional information: Net cash provided by operating activities $88,400 $60,000 Cash used for capital expenditures $39,500 $41,000 Dividends paid $30,000 $13,000 Weighted-average common shares outstanding 33,000 30,000 Compute these values and ratios for 2021 and 2022…arrow_forward
- Cash Accounts Receivable Inventory Property Plant & Equipment, Gross Accumulated Depreciation Property Plant & Equipment, Net Other Assets Total Assets Dansko Integrated Balance Sheet As of December 31, 2022 (amounts in thousands) 99,000 Accounts Payable 45,000 Debt 38,000 Other Liabilities 235,000 Total Liabilities 67,000 Paid-In Capital 168,000 Retained Earnings 16,000 Total Equity 366,000 Total Liabilities & Equity Dansko Integrated Statement of Cash Flows January 1 to March 31, 2023 (amounts in thousands) Net Income Depreciation Decrease (Increase) in Accounts Receivable Decrease (Increase) in Inventory Increase (Decrease) in Accounts Payable Other Adjustments Net Cash Flow from Operating Activities Purchase of Property, Plant, & Equipment Other Adjustments Net Cash Flow from Investing Activities Increase (Decrease) in Debt Dividends Other Adjustments Net Cash Flow from Financing Activities Net Cash Flow 27,000 35,000 10,000 72,000 214,000 294,000 366,000 9,500 1,800 400 (800) 900…arrow_forwardSuppose the following financial data were reported by 3M Company for 2021 and 2022 (dollars in millions). Current assets 3M Company Balance Sheets (partial) Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Current liabilities Screenshot Current ratio Working capital 2022 $ $3,180 3,600 2,738 1,932 $11,450 $4,830 2021 $1,836 3,180 3,019 1,590 Suppose that at the end of 2022, 3M management used $183 million cash to pay off $183 million of accounts payable. How would its current ratio and working capital have changed? (Round current ratio to 2 decimal places, e.g. 1.25: 1. Enter working capital answer to million.) $9,625 $5,887 :1 million Donearrow_forwardcorrect answer asaparrow_forward
- Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: 2018 2017 Cash and equivalents $120 $105 Accounts receivable 275 300 Inventories 375 350 Total current assets $770 $755 Net plant and equipment 2,000 1,490 Total assets $2,770 $2,245 Accounts payable $150 $85 Accruals 75 50 Notes payable 170 195 Total current liabilities $395 $330 Long-term debt 450 290 Common stock 1,225 1,225 Retained earnings 700 400 Total liabilities and equity $2,770 $2,245 Income Statements: 2018 2017 Sales $2,000 $1,500 Operating costs excluding depreciation 1,250 1,000 EBITDA $750 $500 Depreciation and amortization 100 75 EBIT $650 $425 Interest 62 45 EBT $588 $380 Taxes (40%) 235 152 Net income $353 $228 Dividends paid $53 $48 Addition to retained earnings $300 $180…arrow_forwardPresented below are data taken from the records of Wildhorse Company. December 31,2020 December 31,2019 Cash $15,200 $8,100 Current assets other than cash 84,700 60,600 Long-term investments 10,000 52,900 Plant assets 332,400 215,200 $442,300 $336,800 Accumulated depreciation $20,100 $40,100 Current liabilities 39,600 22,100 Bonds payable 74,800 –0– Common stock 254,500 254,500 Retained earnings 53,300 20,100 $442,300 $336,800 Additional information: 1. Held-to-maturity debt securities carried at a cost of $42,900 on December 31, 2019, were sold in 2020 for $33,600. The loss (not unusual) was incorrectly charged directly to Retained Earnings. 2. Plant assets that cost $50,500 and were 80% depreciated were sold during 2020 for $8,000. The loss was incorrectly charged directly to Retained Earnings. 3. Net income as reported on the…arrow_forwardVaiarrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning