Mindtap Finance, 1 Term (6 Months) Printed Access Card For Brigham/houston's Fundamentals Of Financial Management, 15th
Mindtap Finance, 1 Term (6 Months) Printed Access Card For Brigham/houston's Fundamentals Of Financial Management, 15th
15th Edition
ISBN: 9781337710268
Author: Eugene F. Brigham, Joel F. Houston
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
100%
Book Icon
Chapter 3, Problem 14P

FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here.

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
Retained earnings 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 depreciation and amortization 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
  1. 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.
  2. b. What was .Arlington’s 2018 free cash flow?
  3. c. Construct Arlington’s 2018 statement of stockholders’ equity.
  4. d. What was Arlington’s 2018 EVA? Assume that its after tax cost of capital is 10%.
  5. e. What was Arlington’s MVA at year-end 2018? Assume that its stock price at December 31, 2018? Was $25.

a.

Expert Solution
Check Mark
Summary Introduction

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:

operating current assets=Total current assetsCash and equivalents

Compute operating current assets is as follows:

operating current assets=Total current assetsCash and equivalents=$71,000$14,000=$57,000

Hence, the operating current asset is $57,000.

Formula to compute operating current liabilities is as follows:

operating current liabilities=Total current libilitiesNotes payable

Compute operating current liabilities is as follows:

operating current liabilities=Total current libilitiesNotes payable=$20,050$5,050=$15,000

Hence, the operating current liabilities is $15,000.

Formula to compute net operating working capital is as follows:

Net operating working capital(2017)=Operating current assetsOperting current liabilities

Compute net operating working capital is as follows:

Net operating working capital(2017)=Operating current assetsOperting current liabilities=$57,000$15,000=$42,000

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:

operating current assets=Total current assetsCash and equivalents

Compute operating current assets:

operating current assets=Total current assetsCash and equivalents=$83,320$15,000=$68,320

Hence, the operating current asset is $68,320.

Formula to compute operating current liabilities:

operating current liabilities=Total current libilitiesNotes payable

Compute operating current liabilities:

operating current liabilities=Total current libilitiesNotes payable=$25,100$7,000=$18,100

Hence, the operating current liabilities is $18,100.

Formula to compute net operating working capital is as follows:

Net operating working capital(2018)=Operating current assetsOperting current liabilities

Compute net operating working capital is as follows:

Net operating working capital(2018)=Operating current assetsOperting current liabilities=$68,320$18,100=$50,220

Hence, the net operating working capital for 2018 is $50,220.

Conclusion

Therefore, Company A has net operating working capital of $42,000 and $50,220 in 2017 and 2018, respectively.

b.

Expert Solution
Check Mark
Summary Introduction

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($42,000$50,220).

Formula to compute free cash flow is as follows:

Free cash flow=[EBIT(1Tax)+Depreciation][(Capital expenditure+Change in net operating working capital)]

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.

Free cash flow=[$44,000(10.40)+$6,000]($8,000+$8,220)=$26,400+$6,000$16,220=$16,180

Hence, the free cash flow is $16,180.

Conclusion

Therefore, Company A’s free cash flow for 2016 is $16,180.

c.

Expert Solution
Check Mark
Summary Introduction

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:

 SharesAmountRetained EarningsTotal Stockholders’ Equity
Balances, December 31, 20174,00040,00036,95076,950
2018 Net income  23,190 
Cash dividends  (13,920) 
Additional to retained earnings   9,270
Balances, December 31, 20184,00040,00046,22086,220
Conclusion

Therefore, Company A has stockholders’ equity of $86,220 at the end of year 2018.

d.

Expert Solution
Check Mark
Summary Introduction

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:

Economic value added=[EBIT(1Tax Rate)Invested Capital×After Tax Percentage Cost of Capital]

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:

Economic value added=[$44,000(10.40)$113,220×0.10]=$26,400$11,322=$15,078

Hence, the economic value added is $15,078.

Working note:

Calculation of total invested capital is as follows:

Total invested capital=Note payable+Long term debt+Common equity=$7,000+$20,000+$86,2200=$113,220

Hence, the total invested capital is $113,220.

Conclusion

Therefore, the economic value added of Company A for the year 2018 is $15,078.

e.

Expert Solution
Check Mark
Summary Introduction

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:

Market value added=[(Number of outstanding shares×Stock price)Book value of equity]

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:

Market Value Added=(4,000×$25)$86,220=$13,780

Hence, the market value is $13,780.

Conclusion

Therefore, the market value added for Company A for the year 2018 is $13,780.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Consider the following financial data for Terry Enterprises:     Balance Sheet as of December 31, 2018               Cash $ 86,000   Accounts payable $ 15,500 Accts. receivable   91,500   Notes payable   93,500 Inventories   65,500   Accruals   19,500   Total current assets $ 243,000     Total current liabilities $ 128,500         Long-term debt   162,500 Net plant & equip.   419,500   Common equity   371,500 Total assets $ 662,500   Total liab. & equity $ 662,500               Statement of Earnings for 2018   Industry Average Ratios               Net sales $ 642,500   Current ratio 2.2× Cost of goods sold   482,000   Quick ratio 1.7× Gross profit $ 160,500   Days sales outstanding 44 days Operating expenses   119,500   Inventory turnover 6.7×   EBIT $ 41,000   Total asset turnover 0.6× Interest expense   14,500   Net profit margin 7.2%   Pre-tax earnings $ 26,500…
Presented below are data taken from the records of Sheffield Company.     December 31,2020   December 31,2019 Cash   $15,100   $7,900 Current assets other than cash   85,800   59,800 Long-term investments   10,100   53,000 Plant assets   335,200   214,500     $446,200   $335,200           Accumulated depreciation   $20,200   $40,200 Current liabilities   39,600   22,000 Bonds payable   75,800   –0– Common stock   252,800   252,800 Retained earnings   57,800   20,200     $446,200   $335,200 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 $49,600 and were 80% depreciated were sold during 2020 for $7,900. The loss was incorrectly charged directly to Retained Earnings. 3.   Net income as reported on the…
Presented below are data taken from the records of Sheffield Company.     December 31,2020   December 31,2019 Cash   $15,100   $7,900 Current assets other than cash   85,800   59,800 Long-term investments   10,100   53,000 Plant assets   335,200   214,500     $446,200   $335,200           Accumulated depreciation   $20,200   $40,200 Current liabilities   39,600   22,000 Bonds payable   75,800   –0– Common stock   252,800   252,800 Retained earnings   57,800   20,200     $446,200   $335,200 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 $49,600 and were 80% depreciated were sold during 2020 for $7,900. The loss was incorrectly charged directly to Retained Earnings. 3.   Net income as reported on the…

Chapter 3 Solutions

Mindtap Finance, 1 Term (6 Months) Printed Access Card For Brigham/houston's Fundamentals Of Financial Management, 15th

Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License