Question

In: Finance

Graffiti Advertising, Inc., reported the following financial statements for the last two years.    2016 Income...

Graffiti Advertising, Inc., reported the following financial statements for the last two years.
  

2016 Income Statement
Sales $ 571,200
Costs of goods sold 273,965
Selling and administrative 124,721
Depreciation 54,564
EBIT $ 117,950
Interest 19,560
EBT $ 98,390
Taxes 39,356
Net income $ 59,034
Dividends $ 10,800
Addition to retained earnings $ 48,234
GRAFFITI ADVERTISING, INC.
Balance Sheet as of December 31, 2015
Cash $ 13,440 Accounts payable $ 9,492
Accounts receivable 18,982 Notes payable 14,496
Inventory 13,806 Current liabilities $ 23,988
Current assets $ 46,228
Long-term debt $ 135,840
Net fixed assets $ 344,786 Owner's equity $ 231,186
Total assets $ 391,014 Total liabilities and owners’ equity $ 391,014
GRAFFITI ADVERTISING, INC.
Balance Sheet as of December 31, 2016
Cash $ 14,426 Accounts payable $ 10,524
Accounts receivable 21,087 Notes payable 16,478
Inventory 22,766 Current liabilities $ 27,002
Current assets $ 58,279
Long-term debt $ 153,200
Net fixed assets $ 406,299 Owner's equity $ 284,376
Total assets $ 464,578 Total liabilities and owners’ equity $ 464,578

a. Calculate the operating cash flow. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Operating cash flow            $
  
b. Calculate the change in net working capital. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Change in net working capital            $
  
c. Calculate the net capital spending. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Net capital spending            $
  
d. Calculate the cash flow from assets. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Cash flow from assets            $

e. Calculate the cash flow to creditors. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Cash flow to creditors            $

f. Calculate the cash flow to stockholders. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
  
Cash flow to stockholders            $

Solutions

Expert Solution

Answer a.

Operating Cash Flow = EBIT + Depreciation - Taxes
Operating Cash Flow = $117,950 + $54,564 - $39,356
Operating Cash Flow = $133,158

Answer b.

Change in Net Working Capital = Ending Net Working Capital - Beginning Net Working Capital
Change in Net Working Capital = (Ending Current Assets - Ending Current Liabilities) - (Beginning Current Assets - Beginning Current Liabilities)
Change in Net Working Capital = ($58,279 - $27,002) - ($46,228 - $23,988)
Change in Net Working Capital = $9,037

Answer c.

Net Capital Spending = Ending Net Fixed Assets + Depreciation - Beginning Net Fixed Assets
Net Capital Spending = $406,299 + $54,564 - $344,786
Net Capital Spending = $116,077

Answer d.

Cash Flow from Assets = Operating Cash Flow - Net Capital Spending - Change in Net Working Capital
Cash Flow from Assets = $133,158 - $116,077 - $9,037
Cash Flow from Assets = $8,044

Answer e.

Net New Long-term Debt = Ending Long-term Debt - Beginning Long-term Debt
Net New Long-term Debt = $153,200 - $135,840
Net New Long-term Debt = $17,360

Cash Flow to Creditors = Interest Paid - Net New Long-term Debt
Cash Flow to Creditors = $19,560 - $17,360
Cash Flow to Creditors = $2,200

Answer f.

Cash Flow from Assets = Cash Flow to Creditors + Cash Flow to Stockholders
$8,044 = $2,200 + Cash Flow to Stockholders
Cash Flow to Stockholders = $5,844


Related Solutions

Graffiti Advertising, Inc., reported the following financial statements for the last two years.    2016 Income...
Graffiti Advertising, Inc., reported the following financial statements for the last two years.    2016 Income Statement Sales $ 567,700 Costs of goods sold 274,000 Selling and administrative 124,728 Depreciation 54,571 EBIT $ 114,401 Interest 19,406 EBT $ 94,995 Taxes 37,998 Net income $ 56,997 Dividends $ 10,100 Addition to retained earnings $ 46,897 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2015 Cash $ 13,370 Accounts payable $ 9,499 Accounts receivable 18,989 Notes payable 14,503 Inventory 13,799 Current...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2016 Income Statement...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2016 Income Statement Sales $ 568,700 Costs of goods sold 273,990 Selling and administrative 124,726 Depreciation 54,569 EBIT $ 115,415 Interest 19,450 EBT $ 95,965 Taxes 38,386 Net income $ 57,579 Dividends $ 10,300 Addition to retained earnings $ 47,279 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2015 Cash $ 13,390 Accounts payable $ 9,497 Accounts receivable 18,987 Notes payable 14,501 Inventory 13,801 Current liabilities...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement   Sales $ 565,200   Costs of goods sold 274,025   Selling & administrative 124,733     Depreciation 54,576   EBIT $ 111,866   Interest 19,296     EBT $ 92,570   Taxes 48,137   Net income $   44,433     Dividends $ 9,600   Addition to retained earnings $ 34,833 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2018   Cash $ 13,320    Accounts payable $ 9,504   Accounts receivable 18,994    Notes payable 14,508   Inventory 13,794    Current liabilities...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement   Sales $ 573,200   Costs of goods sold 273,945   Selling & administrative 124,717     Depreciation 54,560   EBIT $ 119,978   Interest 19,648     EBT $ 100,330   Taxes 40,132   Net income $   60,198     Dividends $ 11,200   Addition to retained earnings $ 48,998 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2018   Cash $ 13,480    Accounts payable $ 9,488   Accounts receivable 18,978    Notes payable 14,492   Inventory 13,810    Current liabilities...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2019 Income Statement   Sales $ 573,200   Costs of goods sold 273,945   Selling & administrative 124,717     Depreciation 54,560   EBIT $ 119,978   Interest 19,648     EBT $ 100,330   Taxes 40,132   Net income $   60,198     Dividends $ 11,200   Addition to retained earnings $ 48,998 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2018   Cash $ 13,480    Accounts payable $ 9,488   Accounts receivable 18,978    Notes payable 14,492   Inventory 13,810    Current liabilities...
Fizer, Inc., reported the following financial statements for the last two years. FIZER, INC. 2020 Income...
Fizer, Inc., reported the following financial statements for the last two years. FIZER, INC. 2020 Income Statement   Sales $ 565,330   Cost of goods sold 273,960   Selling & administrative 124,720     Depreciation 54,563   EBIT $ 112,087   Interest 19,309     EBT $ 92,778   Taxes 48,245   Net income $   44,533     Dividends $ 10,900   Addition to retained earnings $ 33,633 FIZER, INC. Balance Sheet as of December 31, 2019   Cash $ 13,450    Accounts payable $ 23,986   Accounts receivable 18,981       Inventory 13,807   Current assets $ 46,238...
The January 28, 2017 (fiscal year 2016) financial statements of Caleres, Inc. reported the following information...
The January 28, 2017 (fiscal year 2016) financial statements of Caleres, Inc. reported the following information (in thousands): Caleres, Inc. 2016 2015 Cost of sales $1,517,397 $1,529,527 Inventories, net     585,764     546,745 LIFO reserve         4,345         4,094 The footnotes to the 2016 financial statements of Skechers U.S.A., Inc. reported that the company uses the FIFO method of accounting for inventories. Financial statements reported the following (in thousands): Skechers U.S.A., Inc. 2016 2015 Cost of sales $1,928,715 $1,723,315 Inventories,...
Ambrose Inc. published the following financial statements in its 2016 annual report Income statement For the...
Ambrose Inc. published the following financial statements in its 2016 annual report Income statement For the year ending December 31, 2016 sales $500,000 Cost of goods sold 350000    Gross profit 150,000 Operating expenses $75,000 Depreciation 20,000 95,000 EBIT   55,000 ? Interest expense 20,000 EBT 35,000 ? Tax Expense 12,250 EAT   22,750 Dividends 10,000 Addition to retained earnings$ 12,750 Sales in 2017 are estimated to be $650,000. Forecast the 2017 income statement, balance sheet, and statement of cash flow assuming:...
Orland Restaurants Inc. reports the following comprehensive income in its 2016 consolidated financial statements ($ in...
Orland Restaurants Inc. reports the following comprehensive income in its 2016 consolidated financial statements ($ in millions): Comprehensive income: Net earnings $576.7 Other comprehensive income (loss): Foreign currency adjustment (0.3) Change in fair value of marketable securities net of tax (8.4) Change in fair value of derivatives, net of tax (6.6) Net unamortized gain (loss) arising during period, including amortization of unrecognized net actuarial loss, net of taxes 25.6 Other comprehensive income (loss) 10.3 Total comprehensive income $587.0    In...
Cast Exercise? Equipment, Inc. reported the following financial statements for 2018?: Cast Exercise Equipment, INC. Income...
Cast Exercise? Equipment, Inc. reported the following financial statements for 2018?: Cast Exercise Equipment, INC. Income Statement Year Ended December 31,2018 Net Sales Revenue $709000 Cost of Goods Sold $344000 Gross Profit $365000 Operating Expenses: Depreciation Expense $50000 Other Operating Expense $195000 Total Operating Expenses $245000 Net Income $120000 Cast Exercise Equipment, INC. Comparative Balance Sheet December 31, 2018 and 2017 Assets 2018 2017 Current assests $20000 $19000 Accounts Receivable 55000 49000 Merchandise Inventory 87000 92000 Long-Term Assets: Plant Assets...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT