Graffiti Advertising, Inc., reported the following financial
statements for the last two years.
| 2016 Income Statement | |||
| Sales | $ | 567,200 | |
| Costs of goods sold | 274,005 | ||
| Selling and administrative | 124,729 | ||
| Depreciation | 54,572 | ||
| EBIT | $ | 113,894 | |
| Interest | 19,384 | ||
| EBT | $ | 94,510 | |
| Taxes | 37,804 | ||
| Net income | $ | 56,706 | |
| Dividends | $ | 10,000 | |
| Addition to retained earnings | $ | 46,706 | |
| GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2015 |
|||||||
| Cash | $ | 13,360 | Accounts payable | $ | 9,500 | ||
| Accounts receivable | 18,990 | Notes payable | 14,504 | ||||
| Inventory | 13,798 | Current liabilities | $ | 24,004 | |||
| Current assets | $ | 46,148 | |||||
| Long-term debt | $ | 136,480 | |||||
| Net fixed assets | $ | 344,546 | Owner's equity | $ | 230,210 | ||
| Total assets | $ | 390,694 | Total liabilities and owners’ equity | $ | 390,694 | ||
| GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2016 |
|||||||
| Cash | $ | 14,346 | Accounts payable | $ | 10,516 | ||
| Accounts receivable | 21,095 | Notes payable | 16,470 | ||||
| Inventory | 22,758 | Current liabilities | $ | 26,986 | |||
| Current assets | $ | 58,199 | |||||
| Long-term debt | $ | 152,400 | |||||
| Net fixed assets | $ | 406,307 | Owner's equity | $ | 285,120 | ||
| Total assets | $ | 464,506 | Total liabilities and owners’ equity | $ | 464,506 | ||
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
$
| Graffiti Advertising Inc. | |||
| Operating Cash Flow: Earnings before interest and tax+depreciation-Income Tax | |||
| a) | Earnings before interest and tax=(A) | $ 1,13,894.00 | |
| Depreciation=(B) | $ 54,572.00 | ||
| Income Tax=(C ) | $ 37,804.00 | ||
| Operating Cash Flow=(A)+(B)-(C ) | $ 1,30,662.00 | ||
| b) | Change in Working Capital=Ending Working Capital-Beginning Working Capital | ||
| Working Capital at the end=(Ending Current Assets-Ending Current Liabilities) | |||
| Working Capital at the beginning=(Beginning Current Assets-Beginning Current Liabilities) | |||
| Ending Current Assets | $ 58,199.00 | ||
| Ending Current Liabilities | $ 26,986.00 | ||
| Working Capital at the end=($58199-$26986)=(A) | $ 31,213.00 | ||
| Beginning Current Assets | $ 46,148.00 | ||
| Beginning Current Liabilities | $ 24,004.00 | ||
| Working Capital at the beginning=($46148-24004)=(B) | $ 22,144.00 | ||
| Change in Net working capital=($31213-$22144)=(A)-(B) | $ 9,069.00 | ||
| c ) | Capital Spending=Ending Net Fixed Assets-Beginning Net Fixed Assets+Depreciation | ||
| Ending Net Fixed Assets=(A) | $ 4,06,307.00 | ||
| Beginning Net Fixed Assets=(B) | $ 3,44,546.00 | ||
| Depreciation=(C ) | $ 54,572.00 | ||
| Capital Spending=(A)-(B)+(C ) | $ 1,16,333.00 | ||
| d ) | Cash Flow from Assets=OCF-Change in Working Capital-Net capital spending | ||
| OCF=(A) | $ 1,30,662.00 | ||
| Change in Working Capital=(B) | $ 9,069.00 | ||
| Net Capital Spending=(C ) | $ 1,16,333.00 | ||
| Cash Flow from Assets=(A)-(B)-(C ) | $ 5,260.00 | ||
| e) | Cash Flow to creditors=Interest Paid-Change in Long term Debt | ||
| Interest Paid=(A) | $ 19,384.00 | ||
| Change in long term debt=(Ending long term debt-Beginning long term debt)=($152400-136480)=(B) | $ 15,920.00 | ||
| Cash Flow to creditors=(A)-(B) | $ 3,464.00 | ||
| f) | Cash flow to stockholders=Dividend Paid-Change in Equity | ||
| Dividend Paid=(A) | $ 10,000.00 | ||
| Change in Equity=Ending Equity-Beginning Equity-Addition to retained earnings=($285120-$230210-$46706)=(B) | $ 8,204.00 | ||
| Cash flow to stockholders=(A)-(B) | $ 1,796.00 |
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 Costs of goods sold Selling and administrative Depreciation EBIT Interest EBT Taxes Net income Dividends Addition to retained earnings $565,700 274,020 124,732 54,575 $112,373 19,318 $ 93,055 37,222 $ 55,833 $ 9,700 $ 46,133 GRAFFITI ADVERTISING, INC Balance Sheet as of December 31, 2015 Cash Accounts receivable Inventory Current assets $ 13,330 Accounts payable $ 9,503 14,507 $ 24,010 18,993 $ 46,118 S344,456...
Can't figure out how to Calculate the Cash Flow to Stockholders
(question F)
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2016 Income Statement Sales Costs of goods sold Selling and administrative Depreciation EBIT Interest EBT Taxes $566,200 274,015 124,731 54,574 $112,880 19,340 $ 93,540 37,416 56,124 $ 9,800 46,324 Net income Dividends Addition to retained earnings GRAFFITI ADVERTISING, INC Balance Sheet as of December 31, 2015 Cash Accounts receivable Inventory Current assets $ 13,340...
Freeman, Inc., reported the following financial statements for the last two years. FREEMAN, INC. 2017 Income Statement Sales $ 565,220 Cost of goods sold 274,015 Selling & administrative 124,731 Depreciation 54,574 EBIT $ 111,900 Interest 19,298 EBT $ 92,602 Taxes 48,153 Net income $ 44,449 Dividends $ 9,800 Addition to retained earnings $ 34,649 FREEMAN, INC. Balance Sheet as of December 31, 2016 Cash $ 13,340 Accounts payable $ 24,008 Accounts receivable 18,992 Inventory 13,796 Current assets $ 46,128 Long-term...
Freeman, Inc., reported the following financial statements for the last two years. FREEMAN, INC. 2017 Income Statement Sales $ 565,320 Cost of goods sold 273,965 Selling & administrative 124,721 Depreciation 54,564 EBIT $ 112,070 Interest 19,308 EBT $ 92,762 Taxes 48,236 Net income $ 44,526 Dividends $ 10,800 Addition to retained earnings $ 33,726 FREEMAN, INC. Balance Sheet as of December 31, 2016 Cash $ 13,440 Accounts payable $ 23,988 Accounts receivable 18,982 Inventory 13,806 Current assets $ 46,228 Long-term...
Incorporation reported the following financial statements for the last two years. 2016 Income Statement Sales $ 567,200 Costs of goods sold 274,005 Selling and administrative 124,729 Depreciation 54,572 EBIT $ 113,894 Interest 19,384 EBT $ 94,510 Taxes 37,804 Net income $ 56,706 Dividends $ 10,000 Addition to retained earnings $ 46,706 INC. Balance Sheet as of December 31, 2015 Cash $ 13,360 Accounts payable $ 9,500 Accounts receivable 18,990 Notes payable 14,504 inventory 13,798 Current liabilities $ 24,004 Current assets...
Consider the following abbreviated financial statements for Cabo Wabo, Inc.: CABO WABO, INC. Partial Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners' Equity Current assets $3,025 $3,213 Current liabilities $ 1,315 $ 1,938 Net fixed assets 13,906 14,497 Long-term debt one 7,209 8,265 CABO WABO, INC. 2019 Income Statement Sales 44,790 22,452 Costs Depreciation 3.801 Interest paid 1,023 b. What is owners' equity for 2018 and 2019? (Do not round intermediate...
Consider the following abbreviated financial statements for Cabo Wabo, Inc.: CABO WABO, INC. Partial Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners' Equity Current assets $ 3,151 $ 3,367 Current liabilities $1,399 $2,078 Net fixed assets 14,060 14,511 Long-term debt 7,377 8,419 $45,000 CABO WABO, INC. 2019 Income Statement Sales 22,522 Costs Depreciation 3,885 Interest paid 995 a. What is owners' equity for 2018 and 2019? (Do not round intermediate calculations...
Consider the following abbreviated financial statements for Cabo Wabo, Inc.: CABO WABO, INC. Partial Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners' Equity 3,367 Current assets $ 3,151 $ Current liabilities $1,399 $2,078 14,060 Net fixed assets 14,511 Long-term debt 7,377 8,419 CABO WABO, INC. 2019 Income Statement $45,000 Sales 22,522 Costs Depreciation Interest paid 3,885 995 What is owners' equity for 2018 and 2019? (Do not round intermediate calculations and...
Consider the following abbreviated financial statements for Cabo Wabo, Inc. CABO WABO, INC. Partial Balance Sheets as of December 31, 2015 and 2016 2015 2015 2016 Assets Current assets Net fxed aasets Liabilities and owners' Equity $ 2,697$ 2,848 Current liabilites 12,411 2,969 Long-term debt S 1,135 S 1,679 6,687 7,846 CABO WABO, INC 2016 Income Slatement Sales Costs $39,950 20,026 3,395 Interest paid a. What is owners'equity for 2015 and 2016? (Do not round intermediate calculations and round your...
Consider the following abbreviated financial statements for Cabo Wabo, Inc.: CABO WABO, INC. Partial Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners’ Equity Current assets $ 3,061 $ 3,257 Current liabilities $ 1,339 $ 1,978 Net fixed assets 13,950 14,501 Long-term debt 7,257 8,309 CABO WABO, INC. 2019 Income Statement Sales $ 44,850 Costs 22,472 Depreciation 3,825 Interest paid 1,015 a. What is owners’ equity for 2018 and 2019? (Do not...