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...
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...
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:...
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...
Meyer reported the following pretax financial income (loss) for the years 2012-2016 2012 $240,000 2013 200,000...
Meyer reported the following pretax financial income (loss) for the years 2012-2016 2012 $240,000 2013 200,000 2014 150,000 2015 (500,000) 2016 180,000 pretax financial income (loss) and taxable income (loss) were the same for all the years involved. The enacted tax rate was 34% for 2012 and 2013 and 38% for 2014-2016. Assume the carryback provision is used first for net operating losses. In 2015, based on the weight of available evidence, it is more likely than not that one-fifth...
Two firms, Green and Red, from the same industry reported the following income statements. Green, Inc....
Two firms, Green and Red, from the same industry reported the following income statements. Green, Inc. 2018 2019 Sales $110,000 $150,000 –COGS and Other Variable Operating Costs - 77,000 - 105,000 –Fixed Operating Costs - 15,000 - 15,000 EBIT 18,000 30,000 –Interest -      0 -      0 EBT 18,000 30,000 –Taxes - 5,400 - 9,000 Net Income $ 12,600 $ 21,000 Red, Inc. 2018 2019 Sales $110,000 $150,000 –COGS and Other Variable Operating Costs - 66,000 - 90,000 -Fixed Operating Costs...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 5% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
At the end of last year, Edwin Inc. reported the following income statement (in millions of...
At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales $4,190.00 Operating costs (excluding depreciation) 3,048.00 EBITDA $1,142.00 Depreciation 325.00 EBIT $817.00 Interest 150.00 EBT $667.00 Taxes (25%) 166.75 Net income $500.25 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 6% higher than $4.19 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT