FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho Industries' 2013 and 2014 balance sheets (in thousands of dollars) are shown.
2014 | 2013 | |
Cash | $102,850 | $ 89,725 |
Accounts receivable | 103,365 | 85,527 |
Inventories | 38,444 | 34,982 |
Total current assets | $244,659 | $210,234 |
Net fixed assets | 67,165 | 42,436 |
Total assets | $311,824 | $252,670 |
Accounts payable | $ 30,761 | $ 23,109 |
Accruals | 30,477 | 22.656 |
Notes payable | 16,717 | 14,217 |
Total current liabilities | $ 77,955 | $ 59,982 |
long term debt | 76,264 | 63,914 |
Total liabilities | $154,219 | $123,896 |
Common stock | 100,000 | 90,000 |
57,605 | 38,774 | |
Total common equity | $157,605 | $128,774 |
Total liabilities and equity | $311,824 | $252,670 |
- a. Sales for 2014 were $455,150,000, and EBITDA was 15% of sales. Furthermore,
depreciation and amortization were 11% of net fixed assets, interest was $8,575,000, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends. Given this information, construct the firm's 2014 income statement. - b. Construct the statement of stockholders' equity for the year ending December 31,2014, and the 2014 statement of cash flows.
- c. Calculate 2013 and 2014 net operating working capital (NOWC) and 2014
free cash flow (FCF). - d. If Laiho increased its dividend payout ratio, what effect would this have on corporate taxes paid? What effect would this have on taxes paid by the company's shareholders?
- e. Assume that the firm's after-tax cost of capital is 105%. What is the firm's 2014 EVA?
- f. Assume that the firm's stock price is $22 per share and that at year-end 2014 the firm has 10 million shares outstanding. What is the firm's MVA at year-end 2014?
a.
To prepare: The income statement of L Industries.
Income statement:
This is a financial statement that shows the net income earned or net loss suffered by a company through reporting all the revenues earned and expenses incurred by the company over a specific period of time.
Retained earnings statement:
This is a financial statement that shows the amount of net income retained by a company at a particular point of time for reinvestment and to pay its debts and obligations. It shows the amount of retained earnings that is not paid as dividends to the shareholders.
Balance sheet:
This is a financial statement that shows the available assets (owner’s equity and outsider’s equity) and owed liabilities from investing and financial activities of a company. This statement reveals the financial health of company.
Statement of cash flows:
This is a financial statement that shows the cash and cash equivalents of a company for a particular period of time. It determines the net changes in cash through reporting the sources and uses of cash due to operating, investing, and financial activities of a company.
Explanation of Solution
Prepare the income statement as shown below.
L Industries Income Statement For the year ended 2014 | |
Particulars | Amounts ($) |
Sales | 455,150,000 |
Less: Operating cost | 386,877,500 |
EBITDA | 68,272,500 |
Less: Depreciation and amortization | 7,388,150 |
EBIT | 60,884,350 |
Less: Interests | 8,575,000 |
EBT | 52,309,350 |
Less: Tax | 20,923,740 |
Net income | 31,385,610 |
Table 1
Hence, the net income of L Industries is $31,385,610.
b.
To prepare: The stockholders’ equity and the cash flow statement of L Industries.
Explanation of Solution
Prepare the stockholders’ equity statement as shown below.
L Industries Stockholders’ equity statement For the year ended 2015 | ||
Particulars | Amounts ($) | Amounts ($) |
Common stock | $1,000,000,000 | |
Retained earnings, 2014 | 38,774,000 | |
Add: Net income | 31,385,610 | |
$70,159,610 | ||
Less: Dividends | $12,554,244 | |
Retained earnings, 2015 | $57,605,366 | |
Total stockholders’ equity | $1, 057,605,366 |
Table 2
Prepare the statement of the cash flow as shown below.
L Industries Cash flow statement For the year ended 2015 | ||
Particulars | Amount ($) | Amount ($) |
Cash flow from operating activities | ||
Net income | 31,385,244 | |
Adjustments | ||
Depreciation and amortization | 7,3 88,150 | |
Increase in receivables | -17,838,000 | |
Increase in inventory | -3,462,000 | |
Increase in payables | 7,652,000 | |
Increase in accruals | 7,821,000 | |
Increase in notes payable | 2,500,000 |
4,061,150 |
Net cash flow from operating activities (a) | 35,446,394 | |
Cash flow from investing activities | ||
Purchase of net fixed assets |
-32,117,150 | |
Net cash flow from investing activities (b) |
-32,117,150 | |
Cash flow from financing activities | ||
Proceeds from long term debt | 12,350,000 | |
Issue of common stock | 10,000,000 | |
Dividend paid | -12,554,244 | |
Net cash flow from financing activities (c) | 9,795,756 | |
Net increase in cash and cash equivalents (a + b + c) | 13,125,000 | |
Add: Cash and cash equivalents at the beginning of the period | 89,725,000 | |
Cash and cash equivalents at the end of the period | 102,850,000 |
Table 3
Hence, the stockholders’ equity and the cash flow statement are prepared as above.
c.
To determine: The net operating working capital for the year 2014 and 2015 and the free cash flow of L industries.
Explanation of Solution
Compute the net operating working capital as shown below.
Particulars | 2015 | 2014 |
Cash | 102,850,000 | 89,725,000 |
Accounts receivable | 103,365,000 | 85,527,000 |
Inventories | 38,444,000 | 34,982,000 |
Total current operating assets (a) | 244,659,000 | 210,234,000 |
Accounts payable | 30,761,000 | 23,109,000 |
Accrued expense | 30,477,000 | 22,656,000 |
Total current operating liabilities (b) | 61,238,000 | 45,765,000 |
Net operating working capital (a) - (b) | 183,421,000 | 164,469,000 |
Table 4
Compute the free cash flow as shown below.
Particulars | Amounts ($) | Amounts ($) |
EBIT after tax | 36,530,610 | |
Add: Depreciation and amortization | 7,388,150 | |
Less: Change in working capital | ||
Increase in receivables | -17,838,000 | |
Increase in inventory | -3,462,000 | |
Increase in payables | 7,652,000 | |
Increase in accruals | 7,821,000 | |
Increase in notes payable | 2,500,000 | 3,327,000 |
Less: Capital expense | 32,117,150 | |
Free cash flow | 8,474,610 |
Table 5
Hence, the net operating working capital for the year 2014 and 2015 and the free cash flow of L Industries is calculated as above.
d.
To determine: The effect on corporate taxes and the taxes paid by shareholders of the company, on increasing the dividend payout ratio.
Explanation of Solution
On increasing the dividend payout ratio, the corporate taxes would not be affected. It is so because the company did not pay any tax on the dividend distributed to the shareholders. It can be concluded from the income statement that tax is computed on the net income before deducting the dividend paid. Therefore, there is no impact on the corporate tax.
Yes, there would be an impact on the tax paid by the shareholders. The increase in payout ratio will increase the earnings of the shareholder. Therefore, the shareholders’ taxes will increase with the increase in payout ratio.
Hence, there is no impact on the corporate tax and the shareholder taxes will increase with the increase in payout ratio.
e.
To determine: The EVA of the L Industries.
Explanation of Solution
Calculate the EVA as shown below:
Hence, the EVA is $11,974.
f.
To determine: The MVA of the L Industries.
Explanation of Solution
Calculate the MVA as shown below:
Hence, the MVA is $219,842,395.
Want to see more full solutions like this?
Chapter 3 Solutions
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
- Consider 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_forwardMaligalig Company Comparative Statement of Financial Position December 31 (in Thousand Dollars) 2017 2016 2015 ASSETS Current Assets Cash and Cash Equivalents 91,100 12,628 11,254 Short term Investments 193,230 12,000 12,000 Trade Receivables, net of $30,000 allowance 485,000 529,949 510,435 Note Receivable – related party 12,325 18,941 21,543 Other Receivables 80,532 Inventory 212,515 252,567 252,567 Prepaid Insurance 7,500 7,500 7,500 Total Current Assets 1,001,670 914,117 815,299 Non-Current Asset Property, Plant and Equipment 209,330 209,330 209,330 Less Accumulated Depreciation 87,260 75,332 64,034…arrow_forwardCondensed financial statements for Robeson Company appear below: Comparative Balance Sheets 2014 2013 Cash $ 128,000 $ 201,000 Accounts receivable 472,000 438,000 Inventories 797,000 673,000 Prepaid expenses 81,000 92,000 Plant and equipment (net) 2,655,000 2,428,000 Total assets $4,133,000 $3,832,000 Accounts payable $ 198,000 $ 280,600 Long-term bonds payable 1,000,000 1,000,000 Preferred stock, 10%, $100 par 450,000 450,000 Common stock, no par 1,800,000 1,800,000 Retained earnings 685,000 301,400 Total liabilities and equities $4,133,000 $3,832,000 Income Statement December 31, 2014 Sales, net $5,400,000 Less cost of goods sold 3,240,000 Gross margin 2,160,000 Less operating expenses 1,010,000 Net operating income 1,150,000 Interest expense 80,000 Net income before taxes…arrow_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_forwardCondensed financial statements for Robeson Company appear below: Comparative Balance Sheets 2014 2013 Cash $ 128,000 $ 201,000 Accounts receivable 472,000 438,000 Inventories 797,000 673,000 Prepaid expenses 81,000 92,000 Plant and equipment (net) 2,655,000 2,428,000 Total assets $4,133,000 $3,832,000 Accounts payable $ 198,000 $ 280,600 Long-term bonds payable 1,000,000 1,000,000 Preferred stock, 10%, $100 par 450,000 450,000 Common stock, no par 1,800,000 1,800,000 Retained earnings 685,000 301,400 Total liabilities and equities $4,133,000 $3,832,000 Income Statement December 31, 2014 Sales, net $5,400,000 Less cost of goods sold 3,240,000 Gross margin 2,160,000 Less operating expenses 1,010,000 Net operating income 1,150,000 Interest expense 80,000 Net income before taxes…arrow_forwardCondensed financial statements for Robeson Company appear below: Comparative Balance Sheets 2014 2013 Cash $ 128,000 $ 201,000 Accounts receivable 472,000 438,000 Inventories 797,000 673,000 Prepaid expenses 81,000 92,000 Plant and equipment (net) 2,655,000 2,428,000 Total assets $4,133,000 $3,832,000 Accounts payable $ 198,000 $ 280,600 Long-term bonds payable 1,000,000 1,000,000 Preferred stock, 10%, $100 par 450,000 450,000 Common stock, no par 1,800,000 1,800,000 Retained earnings 685,000 301,400 Total liabilities and equities $4,133,000 $3,832,000 D. Gross Profit Percentage E. Accounts Receivable Turnover F. Debt Ratio Income Statement December 31, 2014 Sales, net $5,400,000 Less cost of goods sold 3,240,000 Gross margin 2,160,000 Less operating expenses 1,010,000 Net…arrow_forward
- Return on AssetsThe following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars, except earnings per share.) 2016 Sales revenue $210,000 Cost of goods sold 125,000 Net income 8,800 Dividends 3,100 Earnings per share 4.40 Hi-Tech Instruments, Inc.Balance Sheet (Thousands of Dollars) Dec. 31, 2016 Dec. 31, 2015 Assets Cash $19,300 $18,000 Accounts receivable (net) 46,000 41,000 Inventory 39,500 43,700 Total current assets 104,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 Total assets 173,000 $167,000 Liabilities and Stockholders' Equity Notes payable-banks $6,000 $6,000 Accounts payable 22,500 18,700 Accrued liabilities 16,500 21,000 Total current liabilities 45,000 45,700 9% Bonds payable 41,000 40,000 Total liabilities 86,000 85,700 Common stock, $25 par value (2,000,000 shares) 50,000 50,000 Retained earnings 37,000 31,300 Total stockholders'…arrow_forwardLimited Review of the Akins Income Statement shows 100,000 of Net Sales for the Year 2017 and Net Income of 12,000. The terms for Sales and Purchases are 2/10, n/30. Partial Comparative Balance Sheets for the Akins Corporation appear below: (In Thousands) (In Thousands) 2017 2016 $ 3,000 $15,000 5,000 Cash Marketable Securities 9,000 Accounts Receivable 25,000 15,000 23,000 17,000 Inventory Equipment (At Book Value) 60,000 55,000 Land 20,000 15,000 Patents 50.000 50,000 Total Assets $190,000 $172,000 Current Liabilities 10,000 30,000 Long Term Liabilities Total Liabilities 70.000 100,000 75,000 85,000 a) Compute the current ratio for 2017 b) Compute the accounts receivable turnover ratio for 2017 c) Compute the average days uncollected for 2017 and provide observation.arrow_forwardConsider 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…arrow_forward
- Ratio Analysis Presented below are summary financial data from Pompeo’s annual report: Amounts in millions Balance sheet Cash and cash equivalents $2,712 Marketable securities 27,128 Accounts receivable (net) 14,051 Total current assets 58,632 Total assets 184,617 Current liabilities 66,017 Long-term debt 12,738 Shareholders’ equity 119,487 Income Statement Interest expense 539 Net income before taxes 24,512 Calculate the following ratios: (round to two decimal places) a. Times-interest-earned ratio b. Quick ratio c. Current ratioarrow_forwardFollowing is the balance sheet for 3M Company. At December 31 2015 2014 Cash and cash equivalents $ 1,798 $ 1,897 Marketable securities-current 118 1,439 Accounts receivable, net 4,154 4,238 Inventories 3,518 3,706 Other current assets 1,398 1,023 Total current assets 10,986 12,303 Marketable securities-noncurrent 126 117 Property, plant and equipment--net 8,515 8,489 Goodwill 9,249 7,050 Intangible assets-net 2,601 1,435 Prepaid pension benefits 188 46 1,053 $32,718 1,769 $31,209 Other assets Total assets $ $ Short-term debt & current portion of LT debt Accounts payable 2,044 106 1,694 1,807 Accrued payroll 644 732 Accrued income taxes 332 435 Other current liabilities 2,404 2,884 Total current liabilities 7,118 5,964 Long-term debt 8,753 6,705 Pension and postretirement benefits 3,520 3,843 Other liabilities 1,580 1,555 Total liabilities 20,971 18,067 3M Company shareholders' equity: Common stock 9. Additional paid-in capital Retained earnings 4,791 4,379 36,575 34,317 Treasury stock…arrow_forwardQuantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: 2018 2017 Cash and equivalents $70 $55 Accounts receivable 275 300 Inventories 375 350 Total current assets $720 $705 Net plant and equipment 2,000 1,490 Total assets $2,720 $2,195 Accounts payable $150 $85 Accruals 75 50 Notes payable 120 145 Total current liabilities $345 $280 Long-term debt 450 290 Common stock 1,225 1,225 Retained earnings 700 400 Total liabilities and equity $2,720 $2,195 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…arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning