In: Finance
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
$
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 | ||||