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 $ 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 liabilities $ 24,002
Current assets $ 46,158
Long-term debt $ 136,400
Net fixed assets $ 344,576 Owner's equity $ 230,332
Total assets $ 390,734 Total liabilities and owners’ equity $ 390,734
GRAFFITI ADVERTISING, INC.
Balance Sheet as of December 31, 2016
Cash $ 14,356 Accounts payable $ 10,517
Accounts receivable 21,094 Notes payable 16,471
Inventory 22,759 Current liabilities $ 26,988
Current assets $ 58,209
Long-term debt $ 152,500
Net fixed assets $ 406,306 Owner's equity $ 285,027
Total assets $ 464,515 Total liabilities and owners’ equity $ 464,515

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

Req a:
Operating cashflows:
Net income 56997
Add; Interest expense 19406
Add: Depreciation expenses 54571
Operating cashflows: 130974
Req b:
Change in Net Working capital:
Increase in cash (14356-13370) 986
Increase in AR (21094-18989) 2105
Increase in Invntory (22759-13799) 8960
Increase in AP (10517-9499) -1018
Increase in Notes payable (16471-14503) -1968
Net Increase in Working capital 9065
Reqc:
Beginning balance of FA 344576
Less: Depreciation -54571
Required balance of FA 290005
Ending Balance of FA 406306
Net capital spending on FA 116301
Req d:
Cash flows from Assets:
Operating cashflows 130974
Net Increase in WC -9065
Net capital spending on FA -116301
Cashflows from Assets 5608
Req e.
Cashflows to Creditors:
Interest paid 19406
Borrowing from LTD -16100
(152500-136400)
Cashflows to Creditors: 3306
Req f:
Cashflows to Stockkholders:
Dividend paid 10100
Increase in Equity -7798
(230332+46897-285027)
Cashflows to Stockkholders: 2302

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 $ 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...
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