Concept explainers
Balance Sheets as of December 31
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
Mindtap Finance, 1 Term (6 Months) Printed Access Card For Brigham/houston's Fundamentals Of Financial Management, 15th
- 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_forwardThe Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2018 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents $ 15 Accounts payable $ 100 Accounts receivable 515 Accruals 220 Inventories 830 Notes payable 230 Total current assets $ 1,360 Total current liabilities $ 550 Net plant and equipment 2,550 Long-term bonds 1,500 Total liabilities $ 2,050 Common stock (100 million shares) 260 Retained earnings $ 1,600 Common equity $ 1,860 Total assets $ 3,910 Total liabilities and equity $ 3,910 Davidson Corporation: Income Statement for Year Ending December 31, 2018 (Millions of Dollars) Sales $ 6,000 Operating costs excluding depreciation and amortization 3,780 EBITDA $ 2,220 Depreciation and amortization 420 EBIT $ 1,800 Interest 164 EBT $ 1,636 Taxes…arrow_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_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_forwardConsider the following financial data for Nguyen Industries: Statement of Financial Position as of December 31, 2018 Cash $ 232,500 Accounts payable $ 86,500 Accts. receivable 357,500 Short-term bank note 254,000 Inventories 150,500 Accrued wages & taxes 80,000 Total current assets $ 740,500 Total current liabilities $ 420,500 Long-term debt 566,000 Net fixed assets 774,500 Common equity 528,500 Total assets $ 1,515,000 Total liab. & equity $ 1,515,000 Profit & Loss Statement for 2018 Industry Average Ratios Net sales $ 1,894,000 Current ratio 1.4× Cost of goods sold 1,382,500 Quick ratio 1.0× Gross profit $ 511,500 Days sales outstanding 63 days Operating expenses 373,000 Inventory turnover 9.5× EBIT $ 138,500 Total asset turnover 1.5× Interest expense 64,000 Net…arrow_forwardArlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Shoats as of December 31 2018 2017 Assets Cash and equivalonts $ 15,000 $ 14,000 Accounts recalvable 35,000 30,000 Inventories 33,320 27,000 Total current assots $ 83320 $ 71,000 Nat plant and equipment 48,000 46,000 Total assets $131,320 $117,000 Liabilities and Equity Accounts payable $ 10,100 $ 9,000 Accruals R000 6,000 Notes payable 7,000 5,050 Total current labilities $ 25,100 $ 20,050 Long term bonds 20,000 20,000 Total labilnies $ 45,100 $ 40,050 Common stock (4,000 shares) 40,000 40,000 Retained earnings 46,220 36,950 Common oquity $ 86,220 $ 76,950 Total labilites and equity $131,320 $117,000 Income Statement for Year Ending Decomber 31, 2018 Sales $210,000 Operating costs excluding depredation andamortzation 160,000 EBITDA $ 50,000 Depraciation and amortization 6,000 $ 44,000 5,350 $ 38,650 EBIT Interast EBT Taxes (40%) 15,460 Not income $ 23,190 Dividends paid $…arrow_forward
- Davidson Corporation: Balance Sheet as of December 31, 2021 (millions of dollars) Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets EBIT Interest Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities Long-term bonds Total liabilities Common stock (100 million shares) Retained earnings Common equity $ 3,730 Total liabilities and equity EBT Taxes (25%) Net income 20 585 840 Davidson Corporation: Income Statement for Year Ending December 31, 2021 (millions of dollars) Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Common dividends paid Earnings per share $ 1,445 2,285 130 220 230 580 1,500 $ 2,080 250 $ 1,400 $1,650 $ 3,730 $ $ 9,500 7,570 $ 1,930 480 $ 1,450 150 $ $ 1,300 325 975 335 9.75arrow_forwardFree Cash Flows Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $7,800.0 $6,000.0 Operating costs excluding depreciation 5,850.0 5,100.0 Depreciation and amortization 216.0 180.0 Earnings before interest and taxes $1,734.0 $720.0 Less Interest 168.0 129.0 Pre-tax income $1,566.0 $591.0 Taxes (40%) 626.4 236.4 Net income available to common stockholders $939.6 $354.6 Common dividends $846.0 $284.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2018 2017 Assets Cash $90.0 $72.0 Short-term investments 39.0 30.0 Accounts receivable 975.0 780.0 Inventories 1,512.0 1,260.0 Total current assets $2,616.0 $2,142.0 Net plant and equipment 2,160.0 1,800.0 Total assets $4,776.0 $3,942.0 Liabilities and Equity Accounts payable $468.0 $360.0 Accruals 345.0 300.0 Notes payable 156.0 120.0 Total current…arrow_forwardPreparing the Cash Flow from Financing Activities Section Gomez Corp. reported the following items for the year ended December 31, 2020. Item Dec 31, 2020 Purchased an investment in debt securities (long-term) for cash $ 42,000 Sold equipment for cash, previously used in operations 35,000 Paid cash for dividends 14,000 Issued common stock for cash 140,000 Retired a 10-year bond payable by repaying the face value at maturity 112,000 Sold investment in equity securities (held for one-year) 15,400 Borrowed cash by signing a nine-month note payable 21,000 Extended a loan to a customer for a building expansion 11,200 Use a negative sign with your answer to indicate a cash outflow, if applicable. Calculate net cash from financing activities for the year ended December 31, 2020. Answerarrow_forward
- The Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2021 (millions of dollars) Assets Cash and equivalents Accounts receivable Inventories Total current assets. Net plant and equipment Total assets EBIT Interest EBT Taxes (25%) Net Income Common dividends paid Earnings per share Liabilities and Equity $ 20 Accounts payable 470 Accruals Balances, 12/31/20 2021 Net Income Cash dividends Addition to RE 890 Notes payable $ 1,380 2,520 Davidson Corporation: Income Statement for Year Ending December 31, 2021 (millions of dollars) Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Total current liabilities Long-term bonds Total liabilities Common stock (100 million shares) Retained earnings Common equity $ 3,900 Total llabilities and equity $ Shares $ $ $ $ 140 250 220 610 1,510 $ 2,120 280 $ 1,500 $ 1,780 $ 3,900 $5,500 4,470 $ 1,030 $ $ a. Construct the…arrow_forwardCash Accounts receivable (net) Other current assets Investments Property, plant, and equipment (net) Current liabilities Long-term debt Common stock, $10 par Retained earnings Blue Corporation Balance Sheets December 31 Net income 2025 $31,000 $21,000 51,000 95,000 60,000 500,000 $86,000 150,000 370,000 $737,000 $612,000 $81,000 325,000 176,000 $737,000 Blue Corporation Income Statements For the Years Ended December 31 Sales revenue Less: Sales returns and allowances Net sales Cost of goods sold Gross profit Operating expenses (including income taxes) 2024 46,000 100.000 2025 75,000 90,000 315,000 $745,000 41,000 704,000 430,000 2023 $19,000 49,000 126,000 114,000 $612,000 $545,000 69,000 2024 50,000 358,000 $545,000 $71,000 55,000 305,000 $605,000 31,000 574,000 355,000 219,000 151,000 274,000 181,000 $93,000 $68,000arrow_forwardSeminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning