Consider a firm that reports the reports the following: sales $274,691, cost of goods sold $105,479 and...

Consider a firm that reports the reports the following: sales $274,691, cost of goods sold $105,479 and interest expense of $74,140. The firm has depreciation expense $57,257 and a 15% tax rate. During the last year the firm had an increase in gross fixed assets of $123,964 and a decrease in net operating working capital of $21,169. Calculate the firm's free cash flow. Your answer should be in dollars. So $30 million should be $30,000,000

Expert Solution

A	B	C	D	E	F	G	H	I	J
2
3		Free cash flow can be calculated as follows:
4		Free Cash Flow = Operating Cash Flow - Capital Expenditures - Change in working capital
5		Operating Cash Flow = EBIT - Tax Expense +Depreciation
6
7		Tax Rate	15%
8
9
10		Sales	$274,691
11		Cost of Goods Sold	$105,479
12		Gross Profit	$169,212
13		Depreciation Expense	$57,257
14		EBIT	$111,955	=D12-D13
15		Interest Expense	$74,140
16		Taxable income	$37,815	=D14-D15
17		Tax Expense	$5,672.25	=D16*D7
18		Net Income	$32,142.75	=D16-D17
19
20		Operating Cash Flow	=EBIT - Tax Expense + Depreciation
21			=$111,955 -$5,672.25 + $57,257
22			$163,539.75	=D14-D17+D13
23
24		Capital Expenditure	=Increase in Gross fixed assets
25			$123,964
26
27		Change in working capital	=-Decrease in working capital
28			($21,169)
29
30		Free Cash Flow	= Operating Cash Flow - Capital Expenditures - Change in working capital
31			=$163,539 - $123,964 - (-$21,169)
32			$60,744.75	=D22-D25-D28
33
34		Hence Free Cash Flow	$60,744.75
35

jeff jeffy answered 2 years ago

Ivanhoe Co. reports the following information for 2017: sales revenue $767,200, cost of goods sold $503,000,...

Ivanhoe Co. reports the following information for 2017: sales revenue $767,200, cost of goods sold $503,000, operating expenses $87,800, and an unrealized holding loss on available-for-sale securities for 2017 of $59,600. It declared and paid a cash dividend of $14,450 in 2017. Ivanhoe Co. has January 1, 2017, balances in common stock $362,300; accumulated other comprehensive income $87,600; and retained earnings $91,850. It issued no stock during 2017. Prepare a statement of stockholders’ equity.

The Mohamed & Ahmed Co. reports net sales $ 150,000, cost of goods sold $ 50,000,...

The Mohamed & Ahmed Co. reports net sales $ 150,000, cost of goods sold $ 50,000, selling and administrative expenses $ 37,000. Interest allowances are Mohamed $9,000 and Ahmed $6,000; partner salary allowances are Mohamed $30,000 and Ahmed $25,000 and the remainder is shared 6:4 respectively. Instructions: Indicate the division of net income to each partner and prepare journal entry for net income/net loss division. Solution question 4: Item Mohamed Ahmed Total Journal entry: Date Account title and explanation...

The 2018 income statement of Adrian Express reports sales of $15,015,000, cost of goods sold of...

The 2018 income statement of Adrian Express reports sales of $15,015,000, cost of goods sold of $8,863,500, and net income of $1,570,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2018 and 2017 2018 2017 Assets Current assets: Cash $ 570,000 $ 730,000 Accounts receivable 1,340,000 970,000 Inventory 1,740,000 1,370,000 Long-term assets 4,770,000 4,210,000 Total assets $ 8,420,000 $ 7,280,000 Liabilities and Stockholders' Equity Current liabilities $ 1,990,000 $ 1,630,000...

A company reports sales revenue of $314 million, cost of goods sold of $187 million, selling...

A company reports sales revenue of $314 million, cost of goods sold of $187 million, selling and administrative expenses of $77 million, depreciation of $20 million, and interest expense of $5 million. What is the company's after-tax operating income (to one decimal place) if the corporate tax rate is 30%?

A company reports sales revenue of $313 million, cost of goods sold of $183 million, selling...

A company reports sales revenue of $313 million, cost of goods sold of $183 million, selling and administration expenses of $79 million, depreciation of $20 million and interest expense of $9 million. What is the company's after-tax operating income (to one decimal place) if the corporate tax rate is 30%?

Q4. The 2021 income statement of Adrian Express reports sales of $20,710,000, cost of goods sold...

Q4. The 2021 income statement of Adrian Express reports sales of $20,710,000, cost of goods sold of $12,600,000, and net income of $1,980,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 840,000 $ 930,000 Accounts receivable 1,775,000 1,205,000 Inventory 2,245,000 1,675,000 Long-term assets 5,040,000 4,410,000 Total assets $ 9,900,000 $ 8,220,000 Liabilities and Stockholders' Equity Current liabilities $ 2,074,000 $ 1,844,000 Long-term liabilities...

XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm...

XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm has an accounts receivable balance of $5,685, an accounts payable balance of $18,445 and inventory of $9,946. How many days on average does it take the firm to collect its accounts receivable? That is, what is the average collection period? Assume 365 days.

Stonebroook, INC., has sales of $1,030,000 and cost of goods sold of $811,800. The firm had...

Stonebroook, INC., has sales of $1,030,000 and cost of goods sold of $811,800. The firm had a beginning inventory of $42,000 and an ending inventory of $57,000. What is the length of the inventory period?Assume 365 days per year. a. 18.88 days b. 22.26 days c. 18.63 days d. 17.54 days e. 21.95 days

XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm...

XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm has an accounts receivable balance of $16,047, an accounts payable balance of $15,631 and inventory of $18,963. How many days does it take on average for the firm to pay its suppliers? That is, what is the payable period? Assume 365 days

Dabble, Inc., has sales of $980,000 and cost of goods sold of $640,000. The firm had...

Dabble, Inc., has sales of $980,000 and cost of goods sold of $640,000. The firm had a beginning inventory of $36,000 and an ending inventory of $46,000. What is the length of the days’ sales in inventory? (Use 365 days a year. Round your answer to 2 decimal places. Use ending inventory rather than average inventory.) Days' sales in inventory days

Question