Question

In: Finance

You are given the following information: 2018 Sales $23,000 Cost of goods sold $16,000 Depreciation expense...

You are given the following information: 2018

Sales

$23,000

Cost of goods sold

$16,000

Depreciation expense

$4,000

Interest

$1,800

Dividends

$1,300

Tax rate

35%

New debt issuance

$2,000

2017

2018

Current assets

$4,800

$5,900

Current liabilities

$2,700

$3,200

Net fixed assets

$14,000

$17,000

a. Calculate the operating cash flow for 2018. (Hint: Taxes = Earnings before taxes x Tax rate) (show your work)

b. Calculate the cash flow from assets for 2018. (show your work )

c. Calculate the cash flow to creditors and the cash flow to shareholders for 2018. (show your work)

Solutions

Expert Solution

In order to calculate operating cash flow, first we need to calculate net profit in order to calculate taxes..

Net Profit = 23000-16000-4000-1800 = $1,200

Taxes = 1,200 *0.35 = $420.

Now, we will get operating cash flow as :- Revenue- COGS - Taxes- Increase in Current assets + Increase in current liabilities

i.e 23,000-16,000-420-(5,900-.4,800) + (3,200-2,700) = $5,980.

2) Our asset consist of Current assets and fixed asset.

We know current asset increased from 4,800 t0 5,900 which means we invested 1,100 in current assets.

Our opening fixed asset was 14,000 of which 4,000 got depreciated and we had a closing balance of 17,000 which means fixed asset increased by 7,000 i.e. investment in fixed asset.

So, total cash flow from asset is 1,100 + 4,000 = $5,100 cash used in assets.

c) We know current liabilities i.e. creditors increased from 2,700 to 3,200 which means creditors increased by 500 which symbolises we had generated money from creditors which needs to be paid at a later period. So, cash flow from creditors is $500.

To calculate Cash flow to share holder we need to calculate Free cash flow to share holders which is Net profit - taxes + Depreciation - Debt issuance - Investment in Current assets and fixed assets + Increase in Current liabilities

i.e 1,200-480 + 4000 - 2,000 - 1,100 - 7,000 + 500 = (4,820) i.e. negative cash flow of 4,820 for shareholders.


Related Solutions

    income statement Sales 205,000 cost of goods sold -97,000 salaries expense -24,000 depreciation expense -16,000...
    income statement Sales 205,000 cost of goods sold -97,000 salaries expense -24,000 depreciation expense -16,000 interest expense -2,400 loss on equipment disposal -2,500 net income 63,100 Statement of Retained Earnings Beginning Balance - Retained Earnings                   6,000 Plus - Net Income                 63,100 Less - Dividends (41,500) Ending Balance - Retained Earnings 27,600 Balance sheets 2018 2019 change Assets: Cash 13,000 64,600 51,600 Accounts Receivable 25,000 19,000 (6,000) Inventory 19,000 13,000 (6,000) prepaid expenses 0 0 0 Equipment 60,000 41,000 (19,000)...
Assume sales are $7,990, cost of goods sold is $2,120, depreciation expense is $140, interest paid...
Assume sales are $7,990, cost of goods sold is $2,120, depreciation expense is $140, interest paid is $180, selling and general expenses are $360, dividends paid are $1,170, and the tax rate is 21 percent. What is the addition to retained earnings? Group of answer choices $2,005.80 $4,100.10 $2,930.10 $3,175.80
A firm has net sales of $5,500,000, Cost of Goods Sold $3,500,000, Depreciation Expense
of $300,000,...
A firm has net sales of $5,500,000, Cost of Goods Sold $3,500,000, Depreciation Expense
of $300,000, Selling and Administrative Expenses of $500,000, Interest Expense of $200,000, and an average tax rate of 20%. 25. The firm's Net Income is: a. 210,000 b. 400,000 c. 
700,000 d 
800,000 26. The firm's Operating Margin is: a. 14.0% b. 21.8% c. 33.3% 
d. 
67.1% 27. firm's Gross Profit Margin is: a. 21.5% b. 30.0% c. 
36.4% d 
50.0% 28. firm's Pre-taxable Income is:...
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%...
1- You have been given the following information: Net sales = $20,000,000 Cost of goods sold...
1- You have been given the following information: Net sales = $20,000,000 Cost of goods sold = $9,000,000 Addition to retained earnings = $3,600,000 Dividends paid to preferred and common stockholders = $600,000 2- the firm’s 2009 income statement lists the following: EBT = $6,000, Interest expense = $0, and Taxes = $3,000. The firm’s has no preferred stock outstanding and 30,000 shares of common stock outstanding. the 2009 earnings per share is Please Solve As soon as Solve quickly...
A company has sales of $50,000, costs of $23,000, depreciation expense of $2,000, and interest expense...
A company has sales of $50,000, costs of $23,000, depreciation expense of $2,000, and interest expense of $1,500. If the tax rate is 21%, what is the operating cash flow, OCF?
using the information below: Advertising expenses $ 16,000 Depreciation expense - admin. office 107,000 Depreciation expense...
using the information below: Advertising expenses $ 16,000 Depreciation expense - admin. office 107,000 Depreciation expense - plant 197,000 Direct materials inventory, beginning 33,000 Direct materials inventory, ending 28,000 Direct materials purchases 190,000 Direct labor 345,000 Finished goods inventory, beginning 66,000 Finished goods inventory, ending 43,000 Heat and light for plant 23,000 Indirect labor 128,000 Insurance on plant 44,000 Repairs on plant building 34,000 Sales representatives' salaries 258,000 Sales revenue 1,675,000 Supervisor's salary - plant 106,000 Work-in-process inventory, beginning 14,000...
The following information for Vision Company is given: 2016 Sales 9,000 Cost of goods sold 1,500...
The following information for Vision Company is given: 2016 Sales 9,000 Cost of goods sold 1,500 Accounts receivable 1,000 Inventory 250 Calculate the Accounts Receivable Turnover, Inventory Turnover and Day’s Sales in Inventory for 2016. Calculate Day’s Sales in Inventory for 2016. What this ratio attempt to measure? Calculate the Day’s Sales in Receivables for 2016. (1 mark) How long did it take on average for credit customers to pay off their accounts during the past year?
2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801...
2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801 Other expenses 170 140 Interest 137 158 Cash 1,075 1,099 Accounts receivable 1,423 1,603 Short-term notes payable 208 195 Long-term debt 3,600 4,200 Net fixed assets 9,015 9,230 Accounts payable 1,129 1,095 Inventory 2,530 2,600 Dividends 250 ? Common Shares 1,000 Tax rate 40% 40% 2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801 Other expenses 170...
sales=$10,980 cost of goods sold=$8,100 depreciation expense=$1,440 interest expense=$180 dividends paid=$270 Tax rate for the year...
sales=$10,980 cost of goods sold=$8,100 depreciation expense=$1,440 interest expense=$180 dividends paid=$270 Tax rate for the year was 35% what is the operating cash flow for the year
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT