Year (year) 2013 2014 Sales (Sales) $ 740 $ 782 Cost of Goods and Services) 430...

Year (year) 2013 2014
Sales (Sales) $ 740 $ 782
Cost of Goods and
Services)
430 455
Interest Payment (Interest) 33 30
Dividends 16 17
Depreciation 250 215
Cash (Cash) 70 76
Accounts Receivable 563 502
Current Liabilities 390 405
Inventory 662 640
Long-Term Debt 340 410
Net Fixed Assets 1,680 1,425
Common Stock 700 235
Tax Rate 35% 30%
(1) How much net working capital has increased or decreased between 2013 and 2014?
(2) What is the net capital spending in 2014?
(3) What is the operating cash flow in 2014?
(4) What is the total cash flow of the enterprise in 2014?

Expert Solution

a)	2013	2014
Current Assets
Cash	$70.00	$76.00
Accounts Receivable	$563.00	$502.00
Inventory	$662.00	$640.00
Total Current Assets	$1,295.00	$1,218.00
Less: Current Liabilities	$390.00	$405.00
Working Capital	$905.00	$813.00
Decreased Working Capital	$92.00

b)
Net Capital spending = Net fixed assets 2014 – Net fixed assets 2013 + Depreciation Net capital spending
Net Capital spending = 1425 – (1680 + 250)	$505.00

c)
	2013	2014
Sales	$740.00	$782.00
Less: Cost of Goods and Services	$430.00	$455.00
Gross profit	$310.00	$327.00
Less: Depreciation	$250.00	$215.00
EBIT	$60.00	$112.00
Interest Payment	$33.00	$30.00
EBT	$27.00	$82.00
Less Tax	x 35%	30.00%
	$9.45	$24.60
Net Income	$17.55	$57.40

OCF = EBIT + Depreciation – Taxes
OCF =		$302.40

d)
Total cash flow
OCF – Change in NWC – Net capital spending
Total cash flow = $302.40-(-92)-505	-$110.60

ekkarill92 answered 1 year ago

Income Statement Accounts 2014 2013 Net Sales $ 1,720,000 $ 1,450,000 Cost of Goods Sold 1,204,000...

Income Statement Accounts 2014 2013 Net Sales $ 1,720,000 $ 1,450,000 Cost of Goods Sold 1,204,000 1,015,000 Selling and Admin. Expense 220,000 185,385 Non operating revenue 9,192 8,860 Interest Expense 14,620 12,100 Earnings Before Income Tax 290,572 246,375 Provision for Income Taxes 116,473 113,616 Net Income $ 174,099 $ 132,759 Balance Sheet Accounts Current Liabilities $ 190,400 $ 189,000 Long-term debts 120,000 112,000 Preferred Stocks (10%) 100,000 100,000 Common Stocks 850,000 850,000 Retained Earnings 348,198 265,518 Other Information Total Assets...

2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current...

2013 2014 sales 2100 Cost of Goods Sold 1200 Depreciation Expense 225 Interest Expense 175 Current Assets 1000 1300 Total Fixed Assets 3500 4000 Accumulated Depreciation 1250 This can be determined from the information given Current Liabilities 900 975 Long-term Debt 1500 1350 Common Stock 400 This can be determined from the information given Question 1 part one) Use the information above to construct a 2014 income statement and balance sheets for both years. The average tax rate is 35%...

2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225...

2013 2014 Sales $2100 Cost of Goods Sold $1200 Other operating expenses $200 Depreciation Expense $225 Interest Expense $175 Current Assets $1000 $1300 Total Fixed Assets $3500 $4000 Accumulated Depreciation $1250 This can be determined from the information given Current Liabilities $900 $975 Long-term Debt $1500 $1350 Common Stock $400 This can be determined from the information given A company has the financial data above for years 2013 and 2014. The average tax rate is 35% and the dividend payout...

Income Statement For the Year Ended December 31, 2014 Revenue: Sales $ 792,845 Cost of Goods...

Income Statement For the Year Ended December 31, 2014 Revenue: Sales $ 792,845 Cost of Goods Sold $ 275,000 Gross Profit $ 517,845 Operating Expenses: Depreciation Expense $ 35,159 Insurance Expense $ 82,000 Office Expense $ 21,700 Advertising Expense $ 8,400 Utilities Expense $ 31,000 Wage Expense $ 80,350 Bad Debt Expense $ 25,000 Pension Expense $ 40,000 Income from Operations: $ 194,236 Other Revenue: Rent Revenue $ 12,000 Interest Revenue $ 19,561 Other Expenses: Unrealized Holding G/L $ (8,000)...

The computation of operating income for Frisco Company for 2013 follows: Sales $1,800,000 Cost of Goods...

The computation of operating income for Frisco Company for 2013 follows: Sales $1,800,000 Cost of Goods manufactured and sold: Direct mateirals $360,000 Direct Labor 240,000 Variable manufacturing Overhead 120,000 Fixed manufacturing overhead 240,000 960,000 Gross Margin $840,000 Selling Expenses: Variable 132,000 Fixed 168,000 300,000 $540,000 Administrative Exepenses: Variable $156,000 Fixed 192,000 348,000 Net Operating income $192,000 An operating budget is prepared for 2014 with sales forecasted at a 25% increase in volume. Direct materials, direct labor and all costs labeled...

Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs...

Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs $43,000 Selling, general, and administrative expenses $27,800 Depreciation $46,000 Partial Balance Sheet 12/31/2013 ASSETS LIABILITIES Cash $15,800 Notes payable $14,100 Accounts receivable $28,200 Accounts payable $19,200 Inventories $47,900 Long-term debt $189,800 Fixed assets $368,100 OWNERS' EQUITY Accumulated depreciation $140,200 Retained earnings Intangible assets $82,000 Common stock $131,800 Partial Balance Sheet 12/31/2014 ASSETS LIABILITIES Cash $25,900 Notes payable $12,200 Accounts receivable $19,100 Accounts payable $23,900...

Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $141,800 Fixed costs...

Partial Income Statement Year Ending 2014 Sales revenue $350,200 Cost of goods sold $141,800 Fixed costs $43,200 Selling, general, and administrative expenses $28,100 Depreciation $45,900 Partial Balance Sheet 12/31/2013 ASSETS LIABILITIES Cash $15,900 Notes payable $14,100 Accounts receivable $27,900 Accounts payable $18,900 Inventories $48,000 Long-term debt $190,100 Fixed assets $368,000 OWNERS' EQUITY Accumulated depreciation (-) $141,500 Retained earnings Intangible assets $82,000 Common stock $131,800 Partial Balance Sheet 12/31/2014 ASSETS LIABILITIES Cash $26,200 Notes payable $11,800 Accounts receivable $18,900 Accounts payable...

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold...

Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold = $24,600; depreciation expense = $1,700; interest expense = $1,400; dividends paid = $1,000. At the beginning of the year, net fixed assets were $14,300, current assets were $8,700, and current liabilities were $6,600. At the end of the year, net fixed assets were $13,900, current assets were $9,200, and current liabilities were $7,400. The tax rate for 2014 was 34 percent. What is...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods...

Titan Football Manufacturing had the following operating results for 2014: sales = $19,950; cost of goods sold = $13,810; depreciation expense = $2,200; interest expense = $260; dividends paid = $720. At the beginning of the year, net fixed assets were $22,300, current assets were $3,110, and current liabilities were $1,900. At the end of the year, net fixed assets were $26,540, current assets were $3,620, and current liabilities were $1,990. The tax rate for 2014 was 40 percent. (Enter...

Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...

Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015 2016 2017 Sales/Revenue 46.76B 46B 43.7B 41.38B 35.02B Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.

Question