Question

In: Finance

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 $ 24,012
  Current assets $ 46,108    Long-term debt $ 136,800
  Net fixed assets $ 344,426    Owners' equity $ 229,722
     Total assets $ 390,534       Total liabilities and owners’ equity $ 390,534
GRAFFITI ADVERTISING, INC.
Balance Sheet as of December 31, 2019
  Cash $ 14,306   Accounts payable $ 10,512
  Accounts receivable 21,099   Notes payable 16,466
  Inventory 22,754
  Current liabilities $ 26,978
  Current assets $ 58,159   Long-term debt $ 152,000
  Net fixed assets $ 406,311   Owners' equity $ 285,492
     Total assets $ 464,470      Total liabilities and owners’ equity $ 464,470
a. Calculate the operating cash flow. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
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.)
c. Calculate the net capital spending. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
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.)
e. Calculate the cash flow to creditors. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)
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.)

Solutions

Expert Solution

Solution:
a. Operating Cash Flow          $118,305
Working Notes:
Notes: Operating cash flow is shows the real cash flow generated for the period , and to get Operating cash flow we do is net income and addition of non cash expenses . Depreciation is non cash expenses for the firm. OCF = EBIT + Depreciation - taxes
Operating Cash flow = EBIT + Depreciation - Taxes
= 111,866 + 54,576 - 48,137
= $118,305
b. Change in Net Working Capital $9,085
Working Notes:
we get the addition to NWC , which is also called it change in NWC,
Change in Net Working Capital =Net working capital 2019 - Net working capital 2018
=(current asset 2019 - current liabilities 2019) - (current asset 2018- current liabilities 2018)   
=($58,159 - 26,978) - (46,108 - 24,012)
=$31,181 - $22,096
=$9,085
c. Net capital spending   $116,461
Working Notes:
Net capital spending = Depreciation + Increase in fixed assets
Net capital spending = Depreciation + (net fixed assets 2019 - net fixed assets 2018)
Net capital spending = 54,576 + (406,311 - 344,426)
Net capital spending = 54,576 + 61,885
Net capital spending = $116,461
d. Cash flow from assets       $ -7,241
Working Notes:
Cash flow from assets = Operating cash flow - Change in NWC - Net capital spending
Cash flow from assets = $118,305 - $9,085 - $116,461
Cash flow from assets =    -$7,241
e. Cash flow to creditors              $   4,096
Working Notes:
Cash flow to creditors = Interest paid –New long-term debt
Cash flow to creditors = Interest paid –(Long-term debt 2019 - Long-term debt 2018)
Cash flow to creditors = $19,296 - ($152,000 -$136,800)
Cash flow to creditors = $19,296 - $15,200
Cash flow to creditors = $4,096
f. Cash flow to Stockholders      $ -11,337
Working Notes:
cash flow to stockholders is how much net cash gone to stockholders during the period , which we compute as follows:
Cash flow to Stockholders      = Dividends - Net new equity
Cash flow to Stockholders      = 9,600 - 20,937
Cash flow to Stockholders      = -11,337
New equity = 2019 equity - 2018 equity - Addition to retained earnings 2019
New equity = $285,492 - $229,722 -34,833
New equity = 20,937
Notes: lets check our above calculation are correct.
Cash flow from assets = Cash flow to creditors + Cash flow to stockholders
-$7,241 = $4,096 -11,337
-$7,241 = -$7,241
Please feel free to ask if anything about above solution in comment section of the question.

Related Solutions

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...
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.    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...
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...
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...
Marimarsh Corporation reported the following pretax financial income (loss) for the years 2019 to 2021. 2019...
Marimarsh Corporation reported the following pretax financial income (loss) for the years 2019 to 2021. 2019 $150,000 2020 ($400,000) 2021 $200,000 Pretax financial income (loss) and taxable income (loss) were the same for all years. The applicable tax rates are 30% for 2019, and 20% for 2020 and 2021. Instructions: a) Prepare the journal entry in 2019 to record income tax expense. b) Prepare the journal entries in 2020 for the tax effects of the loss carryforward, assuming that based...
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...
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in...
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales $4,290.00 Operating costs (excluding depreciation) 3,058.00 EBITDA $1,232.00 Depreciation 345.00 EBIT $887.00 Interest 130.00 EBT $757.00 Taxes (40%) 302.80 Net income $454.20 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 5% higher than $4.29 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT