Use the following information to create an income statement and balance sheet for 2018 and 2019;
assume the tax rate is 34%. Then, using those statements, calculate for 2019:
Cash flow from assets, Cash flow to creditors, Cash flow to stockholders
2016 2017
Sales 50,920 56,916
Depreciation expense 7,308 7,640
Cost of goods sold 17,508 20,712
Other expense 4,164 3,624
Interest expenses 3,416 4,076
Cash 26,696 28,452
Accounts receivables 33,348 41,484
short term notes payables 5,152 5,048
long term debt 89,408 108,396
Net fixed assets 223,908 238,800
Accounts payable 19,288 20,432
Inventory 62,844 67,268
Dividends 6,088 7,120
INCOME STATEMENT | ||||
2018 | 2019 | |||
Sales | 50920 | 56916 | ||
Cost of goods sold | 17508 | 20712 | ||
Gross Profit | 33412 | 36204 | ||
Other Expenses | 4164 | 3624 | ||
Earning Before Interest & Taxes& Depreciation | 29248 | 32580 | ||
Depreciation Expense | 7308 | 7640 | ||
Earning Before Interest & Taxes | 21940 | 24940 | ||
Interest expense | 3416 | 4076 | ||
Before Tax Income | 18524 | 20864 | ||
Taxes(34%) | 6298 | 7094 | ||
Net Income | 12226 | 13770 | ||
BALANCE SHEET | ||||
2018 | 2019 | |||
Assets: | ||||
Cash | 26696 | 28452 | ||
Accounts Receivable | 33348 | 41484 | ||
Inventory | 62844 | 67268 | ||
Total Current assets | 122888 | 137204 | ||
Net Fixed assets | 223908 | 238800 | ||
Total Assets | 346796 | 376004 | ||
Liabilities: | ||||
Accounts Payable | 19288 | 20432 | ||
Short term notes payable | 5152 | 5048 | ||
Total Current Liabilities | 24440 | 25480 | ||
Long Term Debt | 89408 | 108396 | ||
Total Liabilities | 113848 | 133876 | ||
Common Equity | 232948 | 242128 | ||
Total Liabilities and Equity | 346796 | 376004 | ||
CASH FLOW TO STOCKHOLDERS: | ||||
Common Equity in the beginning 2019 | 232948 | |||
Add: Net Income 2019 | 13770 | |||
Less : Dividend 2019 | -7120 | |||
Common Equity at end of 2019 | 239598 | |||
Additional Equity Issued in 2019 | 2530 | |||
Common Equity at end of 2019 | 242128 | |||
Dividend Payment | 7120 | |||
Additional Equity Issued | -2530 | |||
CASH FLOW TO EQUITY HOLDERS | 4590 | |||
CASH FLOW TO CREDITORS: | ||||
Decrease Change in Short term Notes Payable | 104 | (5152-5048) | ||
Increase in Long Term Debt | -18988 | (108396-89408) | ||
CASH FLOW TO CREDITORS: | -18884 | |||
CASH FLOW FROM ASSET | ||||
Increase in Net Fixed assets | -14892 | (238800-223908) | ||
Depreciation Expenses | -7640 | |||
CASH FLOW FROM ASSET | -22532 | |||
Use the following information to create an income statement and balance sheet for 2018 and 2019;...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2019. INCOME STATEMENT OF QUICK BURGER CORP., 2019 (Figures in $ millions) Net sales $ 27,580 Costs 17,582 Depreciation 1,415 Earnings before interest and taxes (EBIT) $ 8,583 Interest expense 530 Pretax income 8,053 Federal plus other taxes 2,819 Net income $ 5,234 201 2019 2018 $ $ - 3,416 3,416 $ 406 3,156 $ 3,562 Assets Current assets Cash and marketable securities Receivables...
2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016. 2016 Categor Current Assets 2015 S50 Categor Sales Cost of Goods Sold Interest Expense $80 S50 250 30 420 60 $24 $5 Net Fixed Assets Accounts Pavable Accrued Expenses Long-term Debt Owner's Equit 25 150 95 40 250 150 Depreciation Tax Rate S6 30% a)Calculate the Operating Cash Flow for 2016. b)Calculate the Free Cash Flow for 2016. c)What is the...
2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 Categor Crrent Assets 2015 S50 2016 $80 2016 $50 Categor Sales Cost of Goods Sold Interest Expense 420 60 $24 S5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owner's Equity 250 30 25 150 95 40 250 150 Depreciation Tax Rate S6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c)What is...
2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 2016 $80 Catego 2015 $50 Cate 2016 $50 Sales Cost of Goods Sold Interest Expense Current Assets 420 60 $24 $5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owner's Equit 250 30 25 150 95 40 250 150 Depreciation Tax Rate $6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c) What...
2) You've obtained the following balance sheet information for 2015 & 2016 along with income statement information for 2016 2016 $80 Catego 2015 $50 Cate 2016 $50 Sales Cost of Goods Sold Interest Expense Current Assets 420 60 $24 $5 Net Fixed Assets Accounts Payable Accrued Expenses Long-term Debt Owner's Equit 250 30 25 150 95 40 250 150 Depreciation Tax Rate $6 30% a)Calculate the Operating Cash Flow for 2016 b)Calculate the Free Cash Flow for 2016 c) What...
Use the information in the provided Income Statement and Balance
Sheet to create the 2017 Statement of Cash Flows and ratio
calculations for 2017.
Income Statement For the Years Ended December 31, 2017 and 2016 $ in millions 2016 2017 Revenue Net sales Cost of merchandise sold $27,528 37,043 20,807 16,236 16,099 11,429 Gross Profit Operating Expenses Selling, general and administrative Depreciation Amortization 5,757 1,223 124 4,449 5,985 2,499 124 7,752 Operating income Interest expense, net Gain/(Loss) on sale of...
Weiland Co. shows the following information on its 2019 income statement sales = $156,000, costs = $81,300; other expenses = $4,600. depreciation expense = $10,300; interest expense = $7,800, taxes = $18,200, dividends = $7,500. In addition, you're told that the firm issued $3,200 in new equity during 2019 and redeemed $5,100 in outstanding long-term debt a. What is the 2019 operating cash flow? b. What is the 2019 cash flow to creditors? c. What is the 2019 cash flow...
Weiland Co. shows the following information on its 2019 income statement: sales = $155,000; costs = $81,500; other expenses = $4,800; depreciation expense = $10,500; interest expense = $8,000; taxes = $17,570; dividends = $7,400. In addition, you're told that the firm issued $3,000 in new equity during 2019 and redeemed $4,700 in outstanding long-term debt. a. What is the 2019 operating cash flow? b. What is the 2019 cash flow to creditors? c. What is the 2019 cash flow...
Weiland Co. shows the following information on its 2019 income statement sales $156,000, costs = $81,300, other expenses = $4,600, depreciation expense = $10.300 interest expense = $7,800; taxes = $18,200; dividends = $7,500. In addition, you're told that the firm issued $3,200 in new equity during 2019 and redeemed $5,100 in outstanding long-term debt. a. What is the 2019 operating cash flow? b. What is the 2019 cash flow to creditors? c. What is the 2019 cash flow to...
Weiland Co. shows the following information on its 2019 income statement: sales = $155,000; costs = $81,500; other expenses = $4,800; depreciation expense = $10,500; interest expense = $8,000; taxes = $17,570; dividends = $7,400. In addition, you're told that the firm issued $3,000 in new equity during 2019 and redeemed $4,700 in outstanding long-term debt. a. What is the 2019 operating cash flow? b. What is the 2019 cash flow to creditors? c. What is the 2019 cash flow...