Concept explainers
Use the following information for Taco Swell, Inc., for Problems 25 and 26 (assume the tax rate is 34 percent):
2014 | 2015 | |
Sales | $12,730 | $ 14,229 |
1,827 | 1,910 | |
Cost of goods sold | 4,377 | 5,178 |
Other expenses | 1,041 | 906 |
Interest | 854 | 1,019 |
Cash | 6,674 | 7,113 |
Accounts receivable | 8,837 | 10,371 |
Short-term notes payable | 1,288 | 1,262 |
Long-term debt | 22,352 | 27,099 |
Net fixed assets | 55,977 | 59,700 |
Accounts payable | 4,822 | 5,108 |
Inventory | 15,711 | 16,817 |
Dividends | 1,522 | 1,780 |
26. Calculating Cash Flow [LO4] For 2015, calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders.
To calculate: The cash flow from assets, the cash flow to creditors, and the cash flow to stockholders for the year 2015.
Introduction:
The cash flow refers to the difference between the money that comes in and goes out of the firm. The cash flow from assets refers to the difference between the revenues from the sale of assets and the money invested in purchasing the assets.
The cash flow to the creditors refers to the interest paid to the creditors minus the net fresh debt borrowed by the company. The cash flow to the stockholders refers to the dividend paid to the shareholders of the company minus the fresh equity raised by the company.
Answer to Problem 26QP
The cash flow from assets for the year 2015 is ($2,080.44). The cash flow to creditors for the year 2015 is ($3,728). The cash flow to stockholders’ for the year 2015 is $1,647.56.
Explanation of Solution
Given information:
Company T | ||
Particulars | 2014 | 2015 |
Sales | $12,730 | $14,229 |
Cost of goods sold | $4,377 | $5,178 |
Other expenses | $1,041 | $906 |
Depreciation | $1,827 | $1,910 |
Interest | $854 | $1,019 |
Dividends | $1,522 | $1,780 |
Cash | $6,674 | $7,113 |
Accounts receivable | $8,837 | $10,371 |
Inventory | $15,711 | $16,817 |
Net fixed assets | $55,977 | $59,700 |
Accounts payable | $4,822 | $5,108 |
Short-term notes payable | $1,288 | $1,262 |
Long-term debt | $22,352 | $27,099 |
Income statement for the year 2014 and 2015 based on the given information:
Company T | ||||
Income statement | ||||
Particulars | 2014 | 2015 | ||
Net sales | $12,730.00 | $14,229.00 | ||
Less: | ||||
Costs | $4,377.00 | $5,178.00 | ||
Other expenses | $1,041.00 | $906.00 | ||
Depreciation | $1,827.00 | $7,245.00 | $1,910.00 | $7,994.00 |
Earnings before interest and taxes | $5,485.00 | $6,235.00 | ||
Less: Interest paid | $854.00 | $1,019.00 | ||
Taxable income | $4,631.00 | $5,216.00 | ||
Less: Taxes ($4,631×34%) | $1,574.54 | $1,773.44 | ||
Net income (A) | $3,056.46 | $3,442.56 | ||
Dividends (B) | $1,522.00 | $1,780.00 | ||
Addition to retained earnings (A)−(B) | $1,534.46 | $1,662.56 |
Balance sheets for the year 2014 and 2015 based on the given information:
Prepare the balance sheet for 2014:
Company T | |||
Balance sheet | |||
For the year 2014 | |||
Assets | Amount | Liabilities | Amount |
Current assets: | Current liabilities: | ||
Cash | $6,674.00 | Accounts payable | $4,822.00 |
Accounts receivable | $8,837.00 | Short-term notes payable | $1,288.00 |
Inventory | $15,711.00 | Total | $6,110.00 |
Total (A) | $31,222.00 | ||
Long-term debt | $22,352.00 | ||
Tangible net fixed assets (B) | $55,977.00 | Shareholders' equity: | |
Common stock (Balance) | $57,202.54 | ||
Retained earnings | $1,534.46 | ||
Total | $58,737.00 | ||
Total assets (A)+(B) | $87,199.00 | Total liabilities and shareholders' equity | $87,199.00 |
Hence, the total assets of Company T is 2014 is $87,199.
Compute the common stock for 2014:
Hence, the common stock of Company T for 2014 is $57,202.54.
Prepare the balance sheet for 2015:
Company T | |||
Balance sheet | |||
For the year 2015 | |||
Assets | Amount | Liabilities | Amount |
Current assets: | Current liabilities: | ||
Cash | $7,113.00 | Accounts payable | $5,108.00 |
Accounts receivable | $10,371.00 | Short-term notes payable | $1,262.00 |
Inventory | $16,817.00 | Total | $6,370.00 |
Total (A) | $34,301.00 | ||
Long-term debt | $27,099.00 | ||
Tangible net fixed assets (B) | $59,700.00 | Shareholders' equity: | |
Common stock (Balance) | $57,334.98 | ||
Retained earnings | $3,197.02 | ||
Total | $60,532.00 | ||
Total assets (A)+(B) | $94,001.00 | Total liabilities and shareholders' equity | $94,001.00 |
Hence, the total assets of Company T is 2015 is $94,001.
Compute the retained earnings for 2015:
Hence, the retained earnings of Company T for 2015 are $3,197.02.
Compute the common stock for 2015:
Hence, the common stock of Company T for 2014 is $57,334.98.
Formulae:
The formula to calculate the net new borrowing and the cash flow to creditors:
The formula to calculate the new equity raised and the cash flow to stockholders:
The formula to calculate the cash flow from assets:
Compute the net new borrowing at the end of 2015:
The long-term debt in the balance sheet of Company T in 2014 was $22,352. The company had long-term debt worth $27,099 in 2015.
Hence, the net new borrowing is $4,747.
Compute the cash flow to creditors in 2015:
The interest expense of Company T in 2015 was $1,019.
Hence, the cash flow to creditors is ($3,728).
Compute the net new equity raised in 2015:
The common equity in 2014 is 57,202.54 (Refer to the balance sheet of 2014 in the solution) and the common equity in 2015 is $57,334.98 (Refer to the balance sheet of 2015 in the solution).
Hence, the net new equity raised is $132.44.
Compute the cash flow to stockholders’ in 2015:
The company paid $1,780 as dividends in the year 2015.
Hence, the cash flow to stockholders’ is $1,647.56.
Compute the cash flow from assets:
Hence, the cash flow from assets is ($2,080.44).
Want to see more full solutions like this?
Chapter 2 Solutions
Fundamentals of Corporate Finance, 2 Semester Access, FIN 3043
- Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?arrow_forwardTalbot Enterprises recently reported an EBITDA of $8 million and net income of $2.4 million. It had $2.0 million of interest expense, and its corporate tax rate was 40%. What was its charge for depreciation and amortization?arrow_forwardBrandt Corporation had sales revenue of 500,000 for the current year. For the year, its cost of goods sold was 240,000, its operating expenses were 50,000, its interest revenue was 2,000, and its interest expense was 12,000. Brandts income tax rate is 30%. Prepare Brandts multiple-step income statement for the current year.arrow_forward
- The Berndt Corporation expects to have sales of 12 million. Costs other than depreciation are expected to be 75% of sales, and depreciation is expected to be 1.5 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Berndts federal-plus-state tax rate is 40%. Berndt has no debt. a. Set up an income statement. What is Berndts expected net income? Its expected net cash flow? b. Suppose Congress changed the tax laws so that Berndts depreciation expenses doubled. No changes in operations occurred. What would happen to reported profit and to net cash flow? c. Now suppose that Congress changed the tax laws such that, instead of doubling Berndts depreciation, it was reduced by 50%. How would profit and net cash flow be affected? d. If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved? Why?arrow_forwardMillennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?arrow_forwardMedium Manufacturers, Inc. (MMI) has the following items on its Income Statement for last year: Sales of $459,500, Cost of Goods Sold of $325,789, Cash Operating Expenses of $45,795, Depreciation Expense of $33,595, Interest Expense of $8,796, and a Marginal Tax Rate of 25%. Medium Manufacturers, Inc. (MMI) has the following items on its Balance Sheet for last year: Cash of $16,495, Accounts Receivable of $49,786, Inventory of $54,997, Short Term Investments of $85,039, Gross Fixed Assets of $429,750, Accumulated Depreciation of $95,847, Accounts Payable of $39,875, Accrued Expenses of $5,496, Short Term Notes Payable of $17,950, Long Term Debt of $105,345, Common Stock of $75,678 with a $1 Par Value, Additional Paid in Capital of $95,876, and Retained Earnings of $200,000. MMI paid Cash Dividends last year of $10,243. 9) What was MMI’s Beginning of Year Retained Earnings Balance last year to the nearest cent?arrow_forward
- Madha Company’s Income Statement for 2015 was as follows:Sales $700,000Cost of goods sold 250,000Gross profit $450,000Operating expenses 380,000Income before income taxes 70,000Additional Information on Madha Company were as follows:1. The tax rate was 40%.2. The sales include 40% cash sales. The remaining 60% was on credit.3. Accounts receivable increased during 2015 by $15,000.4. The allowance for doubtful accounts increased by $10,000 during 2015.5. The company has one depreciable item: an equipment. During 2015 the equipment(net) account increased by $70,000. The company purchased a new equipment for$245,000 cash and sold an equipment with a book value of $42,000 for $80,000 cash.6. Inventories decreased during 2015 by $15,000.7. Operating expenses include depreciation. All other operating expenses are related tosalaries. The salaries payable account decreased during 2015 by $8,000.8. Accounts payable increased during 2015 by 12,000.9. Income tax payable decreased during 2015 by…arrow_forwardUse the following information to answer this question. Windswept, Inc.2017 Income Statement($ in millions) Net sales $ 9,000 Cost of goods sold 7,350 Depreciation 360 Earnings before interest and taxes $ 1,290 Interest paid 87 Taxable income $ 1,203 Taxes 421 Net income $ 782 Windswept, Inc.2016 and 2017 Balance Sheets($ in millions) 2016 2017 2016 2017 Cash $ 160 $ 190 Accounts payable $ 1,150 $ 1,332 Accounts rec. 840 740 Long-term debt 1,000 1,233 Inventory 1,570 1,565 Common stock 3,190 2,910 Total $ 2,570 $ 2,495 Retained earnings 470 720 Net fixed assets 3,240 3,700 Total assets $ 5,810 $ 6,195 Total liab. & equity $ 5,810 $ 6,195 What is the equity multiplier for 2017?arrow_forwardUse the data from the following financial statements in the popup window, LOADING... . The company paid interest expense of $17,800 for 2017 and had an overall tax rate of 40% for 2017. Find the cash flow from assets for 2017, and break it into its three parts: operating cash flow, capital spending, and change in net working capital. Partial Income Statement Year Ending 2017 Sales revenue $349,900 Cost of goods sold $141,900 Fixed costs $43,000 Selling, general, and administrative expenses $28,200 Depreciation $45,900 (Click on the following icon in order to copy its contents into a spreadsheet.) Partial Balance Sheet 12/31/2016 ASSETS LIABILITIES Cash $15,900 Notes payable $13,800 Accounts receivable $28,200 Accounts payable $19,000 Inventories $47,900 Long-term debt $189,800 Fixed assets $368,000 OWNERS' EQUITY Accumulated depreciation $141,900 Retained…arrow_forward
- Use the following information to answer this question. Windswept, Inc.2017 Income Statement($ in millions) Net sales $ 9,750 Cost of goods sold 7,800 Depreciation 355 Earnings before interest and taxes $ 1,595 Interest paid 94 Taxable income $ 1,501 Taxes 450 Net income $ 1,051 Windswept, Inc.2016 and 2017 Balance Sheets($ in millions) 2016 2017 2016 2017 Cash $ 250 $ 270 Accounts payable $ 1,480 $ 1,732 Accounts rec. 1,050 950 Long-term debt 1,040 1,228 Inventory 1,720 1,630 Common stock 3,300 3,000 Total $ 3,020 $ 2,850 Retained earnings 620 870 Net fixed assets 3,420 3,980 Total assets $ 6,440 $ 6,830 Total liab. & equity $ 6,440 $ 6,830 Windswept, Inc., has 520 million shares of stock outstanding. Its price–earnings ratio for 2017 is 20. What is the market price per share of stock?arrow_forwardGiven the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College