FINANCIAL STATEMENTS, CASH FLOW, AND TAXES Laiho Industries' 2013 and 2014
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)
- 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_forwardReturn 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_forwardBelow are the 2014 and 2015 year-end balance sheets for Tran Enterprises: Assets: 2015 2014 Cash $ 200,000 $ 170,000 Accounts receivable 864,000 700,000 Inventories 2,000,000 1.400,000 Total current assets $3,064,000 $2,270,000 Net fixed assets 6,000,000 5,600,000 Total assets $9,064,000 $7,870,000 Liabilities and equity: Accounts payable $1,400,000 $1,090,000 Notes payable to bank 1,600,000 1,800,000 Total current liabilities $3.000,000 $2,890,000 Long-term debt 2,400,000 2,400,000 Common stock 3,000,000 2,000,000 Retained earnings 664.000 580,000 Total common equity $3,664,000 $2,580,000 Total liabilities and equity $9,064,000 $7,870,000 The firm has never paid a dividend on its common stock, and issued $2.400.000 of 10-ycar, non-callable, long-term debt in 2014. As of the end of 2015, none of the principal on this debt had been repaid. Assume that the company's sales in 2014 and 2015 were the same. Which of the following statements must be CORRECT? Select one: The firm issued new…arrow_forward
- Limited 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_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
- Use the following data: Barry Computer Company Balance Sheet as of December 31, 2014 In thousands of $ Cash 85,775 Accounts payable 171,550 Receivables 669,045 Other current liabilities 257,325 Inventories 446,030 Notes payable 85,775 Total current assets 1,200,850 Total current liabilities 514,650 Net fixed assets 514,650 Long-term debbt 394,565 Common equity 806,285 Total assets 1,715,500 Total liabilities and equity 1,715,500 Barry Computer Company Income Statement For the year ended December 31, 2014 In thousands of $ Sales 2,350,000 COGS Materials 1,081,000 Labour 517,000 Heat, light and power 164,500 Indirect labour 188,000 Depreciation 94,000 Total COGS 2,044,500 Gross profit 305,500 Selling expenses 164,500 General and administrative expenses 47,000 EBIT 94,000 Interest expense 39,457 EBT 54,543 Federal and state income taxes (40%) 21,817 Net income 32,726 Calculate the following ratio for Barry Company. Round your answer to two decimal places. ROIC:arrow_forwardCurrent Assets Cash A/R Inventory Total Net Plant & Equip Total Assets Tomson Corporation 2013 and 2014 Statement of Financial Position Assets 2013 $ 8,436 21,530 38.760 $ 68,726 $ 226.706 $295,432 2014 $ 10,157 23,406 42.650 $ 76,213 Current Liabilities A/P Notes Payable Total 1. The current ratio for each year 2. The quick ratio for each year Long-term Debt Owner's Equity Common Stock & Paid-in Surplus Retained Earnings $248,306 Total Total Liabilities & $324,519 Owners Equity Liabilities 3. The cash ratio for each year 4. The NWC to total assets ratio for each year 2013 5. The debt-equity ratio and the equity multiplier for each year 6. The total debt ratio and the long-term debt ratio for each year Round all answers to 2 decimal places. $ 43,050 18.384 $61.434 $ 25.000 $ 40,000 168.998 $ 208,998 $ 295,432 2014 1. Prepare: The 2014 combined common-size, common-base year statement of financial position for Tomson. Round your intermediate calculations to 2 decimal places…arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forward
- The following information is taken Aiello Corporation's fiscal 2016 annual report. Selected Balance Sheet Data 2016 2015 Inventories........................ $221,418 $226,893 Accounts Receivable........... $121,333 $122,087 Assume that Aiello Corporation had $1,003,881 sales on credit during fiscal year 2016. What amount did the company collect from credit customers during the year? a. $1,003,881 b. $1,004,635 c. $1,003,127 d. $1,247,301arrow_forwardSelected information from the comparative financial statements of Barcelona Company for the year ended December 31 appears below: 2017 2016 Accounts receivable (net) $200,000 175,000 Inventory 170,000 130,000 Total assets 1,100,000 800,000 Current liabilities 140,000 110,000 Long-term debt 300,000 410,000 Net credit sales 900,000 700,000 Cost of goods sold 530,000 600,000 Interest expense 40,000 25,000 Income tax expense 60,000 29,000 Net income 120,000 85,000 Net cash provided by operating activities 250,000 135,000 Instructions Answer the following questions relating to the year ended December 31, 2017. Show computations. 1. The inventory turnover for 2017 is 2. The number of times interest earned in 2017 is 3. The accounts receivable turnover for 2017 is 4. The return on assets for 2017 isarrow_forwardBruno Inc.'s Financial Statement for years 2014-2015. Compute for the Bruno Inc. Year 2015 Debt to Asset Ratio. (Answer Format: 12.23%, if computed answer is 12.343% answer should be 12.34%, if computed answer is 12.347% answer should be 12.35%) INCOME STATEMENTS 2014 2015 BALANCE SHEETS Assets Cash 2014 2015 Net sales $ 4,760 S 5,000 S 60 50 3,560 3,800 ST Investments 40 . COGS (excl. depr.) Depreciation 170 200 Accounts receivable 380 500 480 500 Inventories 820 1,000 Other operating expenses EBIT S 550 500 Total CA $ 1,300 $ 1,550 Interest expense 100 120 Net PP&E 1,700 2,000 Pre-tax earnings S 450 S 380 Total assets $ 3,000 $ 3,550 . Taxes (40%) 180 152 NI before pref. div. S 270 $ 228 Liabilities and equity Preferred div. 8 8 S 200 Accounts payable Accruals Net income $ 262 $ 220 300 280 Notes payable Total CL Other Data S 780 Common dividends $48 $50 1,000 1,200 Long-term bonds Total liabilities Addition to RE $214 $170 $ 1,600 $ 1,980 Tax rate 40% 40% 100 100 Preferred stock…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