Graffiti Advertising, Inc., reported the following financial statements for the
ID: 1170691 • Letter: G
Question
Graffiti Advertising, Inc., reported the following financial statements for the last two years.
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 $
Explanation / Answer
Explanation:
1: Operating Cash Flow = EBIT + Depreciation –Taxes OCF = $115,922 + $54,568 - $38,580
OCF = $131,910
2:Next, we will calculate the change in net working capital which is:
Change in Net Working Capital = Ending NWC–Beginning NWC
Change in NWC = (Ending Current Assets – Ending Current Liabilities ) –(Beginning Current Assets – Beginning Current Liabilities)
Change in NWC = ($58,239 - $26,994 ) –($46,188 - $23996)
Change in NWC = $9,053
3:Now, we can calculate the capital spending.
The capital spending is: Net capital spending = Ending NFA–BeginningNFA+ Depreciation Net capital spending = $406,303 - $344,666 + $54,568
Net capital spending = $116,205
4:Now, we have the cash flow from assets, which is:
Cash flow from assets = OCF –Change in NWC –Net capital spending Cash flow from assets
= $131,910 –9,053 –116,205
Cash flow from assets = $6,652
The company spent $6,652 on its assets.
The cash flow from operations was $131,910, and the company spent $9,053 on net working capital and $116,205 on fixed assets.
5:The cash flow to creditors is:
Cash flow to creditors = Interest paid –New long-term debt Cash flow to creditors = Interest paid –(Long-term debtend–Long-term debtbeg)
Cash flow to creditors = $19,472 –($152,800 –136,160)
Cash flow to creditors = $2,832
The cash flow to stockholders is a little trickier in this problem. First, we need to calculate the new equity sold. The equity balance increased during the year. The only way to increase the equity balance is to add to retained earnings or sell equity. To calculate the new equity sold, we can use the following equation:
New equity = Ending equity –Beginning equity –Addition to retained earnings
New equity = $284,748 –230,698 –47,470
New equity = $6,580
What happened was the equity account increased by $54,050. Of this increase, $47,470 came from addition to retained earnings, so the remainder must have been the sale of new equity. Now we can calculate the cash flow to stockholders as:
6:Cash flow to stockholders = Dividends paid –Net new equity Cash flow to stockholders
= $10,400 –6,580
Cash flow to stockholders = $3,820
The company paid $2,832 to creditors and raised $3,820 from stockholders. Finally, the cash flow identity is: Cash flow from assets = Cash flow to creditors + Cash flow to stockholders $6,652 = $2,832 + $3,820 The cash flow identity balances, which is what we expect.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.