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)
- Ch 26: Assignment - Mergers and Corporate Control Widget Corp., which is considering the acquisition of Exteter Enterprise Inc., estimates that acquiring Exteter will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company: Data Collected (in millions of dollars) Year 1 Year 2 Year 3 EBIT $13.0 $15.6 $19.5 Interest expense 5.0 5.5 6.0 Debt 35.2 41.6 44.8 Total net operating capital 107.1 109.2 111.3 Exteter Enterprise Inc. is a publicly traded company, and its market-determined pre-merger beta is 1.00. You also have the following information about the company and the projected statements: •Exteter currently has a $38.00 million market value of equity and $24.70 million in debt. The risk-free rate is 3.5%, there is a 5.60% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity ISL of 9.10%. •Exteter's cost…arrow_forward3. Problem 30-03 (Plan Funding) Plan Funding eBook Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,480,000 2,980,000 26-30 31-35 2,480,000 1,980,000 1,480,000 The current value of the firm's pension fund is $5.6 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 11%, and it uses 11% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio= which means the assets are select than the PV of benefits and the plan is select Less or greater Select underfunded overfundedarrow_forwardPlan Funding Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,500,000 3,000,000 2,500,000 26-30 31-35 2,000,000 1,500,000 The current value of the firm's pension fund is $6.1 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 12%, and it uses 12% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio = which means the assets are -Select- than the PV of benefits and the plan is -Select- ☑. Less or Greater Overfunded or Underfundedarrow_forward
- Benefits and Contributions The Certainty Company (CC) operates in a world of certainty. It has just hired Mr. Jones, age 27, who will retire at age 65, draw retirement benefits for 14 years, and die at age 79. Mr. Jones' salary is $21,000 per year, but wages are expected to increase at the 6% annual rate of inflation. CC has a defined benefit plan in which workers receive 1% of the final year's wage for each year employed. The retirement benefit, once started, does not have a cost-of-living adjustment. CC earns 12% annually on its pension fund assets and uses a 10% rate to discount its expected future benefit payments. Assume that pension contribution and benefit cash flows occur at year-end. Do not round intermediate calculations. Round your answers to the nearest dollar. a. How much will Mr. Jones receive in annual retirement benefits? $ b. What is CC's required annual contribution to fully fund Mr. Jones' retirement benefits? $ c. Assume now that CC hires Mr. Smith at the same…arrow_forwardlab.infoseclearning.com/console/5061763/3047 310-win10 Project Three Milestone - GNS3 File Edit View Control Node Annotate Tools Help e 41 Sales_PC1 0000 Sales_PC2 Sales_PC3 Enforce US Keyboard Layout View Fullscreen Send Ctrl+Alt+Delete Reboot To exit full screen, press and hold esc ■C00/6@ Q Sales_Switch Human Resources_Switch Office_Router Sales PC4 Customer_Service_Switch X: -299.0 Y: -136.0 Z: 1.0 H Type here to search CS_FTP_Server HR_PC2 HR_PC1 7:19 PM 12/14/2024 Barrow_forwardAGG is a US multinational that manufactures specialist high tech parts in the airline engine industry. AGG is an established company with steady growth in turnover and dividends over the last 10 years. The company is undertaking a projected titled Project Big as a strategic response to the changing market scene. AGG will develop a new state of the art highly automated plant located in Cambodia which is expected to result in cost advantages if it is implemented. The details about the project are below • Initital investment has been estimated at $500m • • The annual pre tax savings in operating costs at current exchange rates has been calculated at $150m for the first four years (starting in the first year) The residual value of the project at the end of the four years is estimated to be $250m The initial investment, net of residual value, qualifies for capital allowance and can be claimed back on a straight line basis over the four years of the project. Current AGG's cost of capital is…arrow_forward
- You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or provide how to do the calculations in Excel. Explain why there is a difference between the present value of the Strayer lottery jackpot and the future value of the twenty-six annual payments based on your calculations and the information provided.arrow_forwardYou have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or in an attached spreadsheet file.arrow_forwardThe approach uses a weighted average cost of capital that is unique to a particular project while determining the appropriate discount rate.arrow_forward
- An all-equity firm faces a risk-free rate of 4%, a beta of 2, and a market risk premium of 6%. What is its cost of capital? Multiple choice question. 18% 12% 14% 16%arrow_forwardcreated or destroyed. uses the weighted average cost of capital to determine if value is beingarrow_forwardUnder the subjective approach for project evaluation, all proposed projects are placed into several Blank______ categories. Multiple choice question. risk cost revenue returnarrow_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