Question

In: Finance

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
Inventories	$52,800	Long-term debt	$162,200
Fixed assets	$447,800	OWNERS' EQUITY
Accumulated depreciation		Retained earnings
Intangible assets	$82,000	Common stock	$181,800

The company paid interest expense of

$17,200

for 2014 and had an overall tax rate of

40%

for 2014. Find the cash flow from assets for 2014, and break it into its three parts: operating cash flow, capital spending, and change in net working capital.

The operating cash flow is

$?

(Round to the nearest dollar.)

Expert Solution

Cash flow from assets = operating cash flow - capital spending - chnage in net working capital

Operating cash flow = EBIT + depreciation - tax

Sales revenue	$3,50,200
COGS	$1,42,000
Fixed costs(excluding interest)	$25,800
selling and general and admin costs	$27,800
Depreciation	$46,000
EBIT	$1,08,600
Interest	$17,200
EBT	$91,400
Tax @40%	$36,560

Operating cash flow = 108600 + 46000 - 36560

= $1,18,040

Capital sepnding = Ending net fixed assets - beginning net fixed assets + depreciation

Enfding net fixed assets = 447800 - (140200+46000)

= $2,61,600

Beginning net fixed assets = 368100 - 140200

= $2,27,900

Capital spending = $2,61,600 - $2,27,900 + $46000

= $79,700

Chnage in net working capital = Ending NWC - beginning NWC

Ending NWC = Ending CA - Ending CL

= (25900+19100+52800) - (12200 + 23900)

= $61,700

Beginnigng NWC = (15800 + 28200+47900) - (14100+19200)

= $58600

Change in NWC = 61700 - 58600

= $3100

Therefore Cash flow from assets = $1,18,040 - $79,700 - $3100

= $35,240

jeff jeffy answered 2 years ago

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...

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)...

Income Statement For Year Ended December 31, 2018 Sales revenue $97,200 Expenses Cost of goods sold...

Income Statement For Year Ended December 31, 2018 Sales revenue $97,200 Expenses Cost of goods sold 42,000 Depreciation expense 12,000 Salaries expense 18,000 Rent expense 9,000 Insurance expense 3,800 Interest expense 3,600 Utilities expense 2,800 Net income $6,000 LANSING COMPANY Selected Balance Sheet Accounts At December 31 2018 2017 Accounts receivable $ 5,600 $ 5,800 Inventory 1,980 1,540 Accounts payable 4,400 4,600 Salaries payable 880 700 Utilities payable 220 160 Prepaid insurance 260 280 Prepaid rent 220 180 Prepare the...

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...

Income Statement Year Ended July 31, 2018 Net Sales Revenue $28,000 Cost of Goods Sold 10,800...

Income Statement Year Ended July 31, 2018 Net Sales Revenue $28,000 Cost of Goods Sold 10,800 Gross Profit 17,200 Operating Expenses: Selling Expenses $690 Administrative Expenses 1,550 Total Operating Expenses 2,240 Operating Income 14,960 Other Income and (Expenses): Interest Expense ? Total Other Income and (Expenses) ? Net Income before Income Tax Expense ? Income Tax Expense 2,810 Net Income $ ? The income statement for UtahUtah Communications follows. Assume UtahUtah Communications signed a 3-month, 9 %9%, $ 60 comma...

Income Statement Accounts for the Year Ending 2017 Account Balance Cost of goods sold $1,415,000 Interest...

Income Statement Accounts for the Year Ending 2017 Account Balance Cost of goods sold $1,415,000 Interest expense $293,000 Taxes $227,600 Revenue $2,985,000 Selling, general, and administrative expenses $453,000 Depreciation $255,000 Income statement. From the following income statement accounts in the popup window, (popup window info above) a. produce the income statement for the year. b. produce the operating cash flow for the year. a. produce the income statement for the year. Complete the income statement below. (Round to the nearest...

Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3)During the year, TRC Corporation has the following inventory transactions.DateTransactionNumber of UnitsUnit CostTotal CostJan.1Beginning inventory52$44$2,288Apr.7Purchase132466,072Jul.16Purchase202499,898Oct.6Purchase112505,600498$23,858For the entire year, the company sells 432 units of inventory for $62 each.Exercise 6-4A Part 22. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

Joyner Company’s income statement for Year 2 follows: Sales $ 714,000 Cost of goods sold ...

Joyner Company’s income statement for Year 2 follows: Sales $ 714,000 Cost of goods sold 207,000 Gross margin 507,000 Selling and administrative expenses 217,000 Net operating income 290,000 Nonoperating items: Gain on sale of equipment 7,000 Income before taxes 297,000 Income taxes 89,100 Net income $ 207,900 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets ...

1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 60 $ 52 $ 3,120 Apr. 7 Purchase 140 54 7,560 Jul. 16 Purchase 210 57 11,970 Oct. 6 Purchase 120 58 6,960 530 $ 29,610 For the entire year, the company sells 450 units of inventory for $70 each. 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using...

Joyner Company’s income statement for Year 2 follows: Sales $ 708,000 Cost of goods sold 387,000...

Joyner Company’s income statement for Year 2 follows: Sales $ 708,000 Cost of goods sold 387,000 Gross margin 321,000 Selling and administrative expenses 151,100 Net operating income 169,900 Nonoperating items: Gain on sale of equipment 8,000 Income before taxes 177,900 Income taxes 53,370 Net income $ 124,530 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 97,030 $ 80,700 Accounts receivable 228,000 132,000 Inventory...