Question

In: Finance

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

Solutions

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

Related Solutions

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   
Dabble, Inc. has sales of $977,000 and cost of goods sold of $514,000. The firm had...
Dabble, Inc. has sales of $977,000 and cost of goods sold of $514,000. The firm had a beginning inventory of $34,500 and an ending inventory of $44,500. What is the length of the days’ sales in inventory?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT