Question

In: Finance

2017 2018 Sales $ 2,900   3,300 COGS 2,030 2,310 Interest 410 420 Dividends 56 79 Depreciation...

2017 2018

Sales $ 2,900   3,300

COGS 2,030 2,310

Interest 410 420

Dividends 56 79

Depreciation 290 330

Cash 250 150

Receivables 242 412

Current liabilities 900 1,100

Inventory 1,015 900

Long-term debt 3,200 3,100

Net fixed assets 6,000 5,700

Retained earnings 1,050 ?

Tax rate 34% 34%

Given the above information, what is the operating cash flow and retained earnings balance for 2018?

Solutions

Expert Solution

Income Statement for 2018
Sales        3,300.00
Less: Cost of goods sold        2,310.00
Less: Depreciation           330.00
Earnings before Interest & Tax (EBIT)           660.00
Less: Interest Expenses           420.00
Earnings before tax (EBT)           240.00
Less: Tax at 34% [$240 x 34%]            81.60
Net Income           158.40
Operating Cash Flow
Earnings before Interest & Tax (EBIT)           660.00
Add: Depreciation Expenses           330.00
Less: Taxes            81.60
Operating Cash Flow           908.40
Retained earnings balance for 2018
Retained earnings balance at the beginning        1,050.00
Add: Net Income for the Year           158.40
Less: Dividends paid            79.00
Retained earnings balance for 2018        1,129.40

Related Solutions

2017 2018 Sales $2,900 $3,300 COGS 2,030 2,310 Interest 410 420 Dividends 56 79 Depreciation 290...
2017 2018 Sales $2,900 $3,300 COGS 2,030 2,310 Interest 410 420 Dividends 56 79 Depreciation 290 330 Cash 250 150 Receivables 242 412 Current liabilities 900 1,100 Inventory 1,015 900 Long-term debt 3,200 3,100 Net fixed assets 6,000 5,700 Tax rate 34% 34% What is cash flow to stockholders for 2018? A. $79 B. $189 C. $445 D. $524 E. $603 Why is the answer E? please explain.
2017 2018 Sales $ 785 COGS 460 Interest 35 Dividends 17 Depreciation 210 Cash 70 75...
2017 2018 Sales $ 785 COGS 460 Interest 35 Dividends 17 Depreciation 210 Cash 70 75 Accounts receivables 563 502 Accounts Payable 390 405 Inventory 662 640 Long-term debt 340 410 Net fixed assets 1,680 1,413 Common stock 700 235 Tax rate 35% 35% Calculate the EBIT 426 90 535 115 Calculate the net income 49 60 52 46 Calculate the cash flow from operation -226 194 238 360 Calculate the cash flow from investment 57 485 -43 98 Calculate...
ABC Inc. has sales of $44,500, costs of $19,400, depreciation expense of $2,900, and interest expense...
ABC Inc. has sales of $44,500, costs of $19,400, depreciation expense of $2,900, and interest expense of $2,400. If the tax rate is 35%, what is the operating cash flow, or OCF? (Omit $ sign in your response.)
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are 20% in the month of sale and 80% the following month. Accounts receivable as of December 31, 2018 is $15,000 and this amount is expected to be collected in January 2019. 2. End of month inventory must equal 60% of next month’s sales. The inventory at the end...
sales revenue 300,000 COGS 180,000 Selling and Admin 30,000 Interest rev 6,000 Dividends declared and paid...
sales revenue 300,000 COGS 180,000 Selling and Admin 30,000 Interest rev 6,000 Dividends declared and paid 9,000 Loss from discontinued 15,000 Dividend rev 8,000 Interest ex 8,000 What is the net amount of non-operating revenue and expenses? -81,000 -6,000 -(9,000) -(3,000)
2018 2017 Sales revenue 9,245,000 Interest revenue 850,000 Royalties revenue 1,450,000 Dividend revenue 150,000 Depreciation-building 147,500...
2018 2017 Sales revenue 9,245,000 Interest revenue 850,000 Royalties revenue 1,450,000 Dividend revenue 150,000 Depreciation-building 147,500 Depreciation-plant 262,500 Depreciation-equipment 75,000 Research and development expenditure 1,650,000 Cost of goods sold 4,005,000 Warranty expense 195,000 Wages and salaries expense 3,475,000 Long service leave expense 235,000 Interest expense 305,000 Rates and taxes on property 145,500 Doubtful debts expense 142,500 Accounts receivable 675,000 375,000 Estimated uncollectible debts 182,000 95,000 Interest receivable 300,000 275,000 Royalties receivable 920,000 745,000 Land (at cost) 2,500,000 2,500,000 Buildings 3,200,000...
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...
XYZ has Sale s= 4,000, COGS = 2,000, Depreciation = 400, Interest = 600. The tax...
XYZ has Sale s= 4,000, COGS = 2,000, Depreciation = 400, Interest = 600. The tax rates are:10% for taxable income up to 500, 15% for the next 500, and 20% for any taxable income above 1,000 1. What is XYZ’s Interest Tax Shield (ITS)? A. 90 B.   120 C. 85 D. none of the above 2. What would be the ITS if depreciation is increased to 1,000? A. 90 B.   120 C. 85 D. none of the above
In 2018, ABC Corp. had sales/revenue of $26,500,000, Costs of Goods Sold (COGS) of $14,500,000, Sales,...
In 2018, ABC Corp. had sales/revenue of $26,500,000, Costs of Goods Sold (COGS) of $14,500,000, Sales, General, and Administrative (SG&A) expense of $5,600,000, Depreciation expense of $1,000,000, and Interest expense of $400,000. Also assume that its average tax rate was 19%. What was ABC Corp.'s Earnings Before Interests and Taxes (or Operating Income) as of 2018?
Salim, a self-employed plumber, received the following income in 2017/2018: Building society interest £ 4,200 Dividends...
Salim, a self-employed plumber, received the following income in 2017/2018: Building society interest £ 4,200 Dividends from a UK company ​£ 3,800 Trading Income ​​​​ ​£ 80,000 He paid allowable interest of £3,000 on 15 August 2017/2018. The following tax rates are applicable during the fiscal year. BAND CATEGORY TAX RATE OTHER INCOME Basic rate 0 - £37,400 20% Higher rate 37401-150,000 40% SAVING INCOME Starting rate 0 - £2,440 10% Basic rate 2441-37400 20% Higher rate 37401-150,000 40% DIVIDEND...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT