Question 4 You are given the following information for ABC Limited: Sales Cost of goods sold Other operating expenses Depreciation expense Interest Dividends Cash Accounts receivable Inventory Net fixed assets Current liabilities Long-term debt Tax rate 2022 $50,000 $30,000 $20,000 $150,000 $40,000 $70,000 30% 2023 $120,000 $70,000 $14,000 $6,000 $3,500 $4,500 2023 $60,000 $35,000 $25,000 $160,000 $60,000 $80,000 30% Current assets consist of cash, accounts receivable, and inventory. a. Calculate the earnings before interest and taxes (EBIT) for 2023. Show your calculation. b. Calculate the amount of income taxes for 2023. Show your calculation. c. What was the cash flow from assets for 2023? Show your calculation. d. What was the cash flow to creditors for 2023? Show your calculation. e. What was the cash flow to shareholders for 2023? Show your calculation.

Question 4 You are given the following information for ABC Limited: Sales Cost of goods sold Other operating expenses Depreciation expense Interest Dividends Cash Accounts receivable Inventory Net fixed assets Current liabilities Long-term debt Tax rate 2022 $50,000 $30,000 $20,000 $150,000 $40,000 $70,000 30% 2023 $120,000 $70,000 $14,000 $6,000 $3,500 $4,500 2023 $60,000 $35,000 $25,000 $160,000 $60,000 $80,000 30% Current assets consist of cash, accounts receivable, and inventory. a. Calculate the earnings before interest and taxes (EBIT) for 2023. Show your calculation. b. Calculate the amount of income taxes for 2023. Show your calculation. c. What was the cash flow from assets for 2023? Show your calculation. d. What was the cash flow to creditors for 2023? Show your calculation. e. What was the cash flow to shareholders for 2023? Show your calculation.

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Similar questions

Partial Income Statement Excel Exercise Compute the Following ՀԱՐ Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* 2019 100 40 EBITDA EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet Debt and Loans 150 Total Equity 150 Total Assets 300 Inv. Change 10 A/R Change A/P Change 35 20 Net Profit Margin Equity Multiplier Verify Dupont ROE ? סיי ? ? ? ? ? * Assume all taxes paid in current period (no accrued taxes) for rest of course CF from Operations ROE Asset Turnover CED Tt O 24
Sales Depreciation COGS Interest Cash Accts Receivables Notes Payable L ong-term debt Net fixed assets Accounts Payable Inventory Dividend payout Tax rate 2020 21. What is the ROE for 2021? $5,300 $5,900 750 850 2400 180 200 200 800 1500 3000 250 700 2021 2900 196 500 22. What is the Inventory period in 2021? 400 550 1950 3500 400 900 30% 35% 30% 20. What is the cash flow from operating activities?
Consider 2021 consolidated balance sheet and income statement for Pfizer Corporation (PFE). The company projects that its revenue for 2022 will grow at the annual rate of 50%. > All assets are assumed to grow at the same rate as sales. > All current liabilities are assumed to grow at the same rate as sales. All operating expenses are assumed to grow at the same annual growth rate as sales. All non-operating income/expenses as well as depreciation and amortization are assumed to remain at the same level as they were in 2021. For the time being, the company wants to keep its long-term debt at 2021 level. Company plans to keep the same dividend payout ratio as it did in 2021. Balance Sheet as of December 31, 2021 Assets Liabilities and Owner's Equity Current Assets Current Liabilities Cash & Short Term 31,069 Current Portion of Long Term Debt 1,636 Investments 11,479 Accounts Payable 9,059 | Income Tax Payable 8,086 Other Current Liabilities Dividends Payable Accrued Payroll Notes Payable…
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Income Statement for the years ending 31 August: 2020 2019 £ £Revenue 950,000 975,000Cost of sales 455,000 460,000Gross profit 495,000 515,000Total expenses 320,000 310,000Net profit 175,000 205,000 Statement of financial position as at 31 August: 2020 2019£ £Non-current assets 70,000 65,000Current assetsCash at bank…
Module pute Net Operating Profit after Tax Refer to the balance sheet information below for Home Depot. Feb. 3, 2019 Jan. 28, 2018 $35,891 $34,794 1,511 3,056 $37,402 $37,850 $14,177 $13,640 24,822 22,974 $38,999 $36,614 Operating assets Nonoperating assets Total assets $ millions Operating liabilities Nonoperating liabilities Total liabilities Net sales Operating expense before tax Net operating profit before tax (NOPBT) Other expense Income before tax Tax expense Net income Assume a statutory tax rate of 22%. a. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = Net income + NNE Net income NNE NOPAT $ 9,453 $ $ $91,973 78,772 13,201 828 12,373 2,920 $9,453 7,361 * $ 16814 b. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = NOPBT - Tax on operating profit NOPBT Tax on operating profit 7,361 * $ 10,296.78 x $ NOPAT -2936
XYZ Co its selected financial statements items are given as following. Total net sales equals to 550.000 TL, COGS equals to 300.000 TL, operating expenses equals to 100.000 TL, interest expenses equals to 50.000 TL, 4 - tax expenses 20.000 TL, total depreciation & amortization expenses equals to 40.000 TL. Calculate the EBITDA of the company for the year 2020. a) O 80.000 TL 01383 b) O 150.000 TL c) O 190.000 TL d) O 110.000 TL
Total Net Fixed Assets Total Assets O 14.97 siven, O 16.05 O 9.63 Cash Accounts Receivable Inventory Click to open: O 12.59 Net Sales Less: Cost of Goods Sold Less: Depriciation Earnings before Interest and Taxes O 10.12 Less: Interest Paid Taxable income Less: Taxes Net Income Precision Tools 2012 Income Statement ($ in Millions) What is the times interest earned ratio for 2012? 2011 2060 3411 18776 24247 14160 38407 LE 36408 28225 1760 6423 510 5913 2070 3843 Precision Tools 2011 and 2012 Balance Sheets ($ in Millions) 2012 1003 Accounts Payable 4218 Long Term Debt 21908 Common Stock 27129 Retained Earnings 14080 41209 Total Liabilities and Equity 2011 7250 9800 15000 6357 38407 2012 8384 11500 17500 3825 41209 97
BHP Group Ltd.- 2019 and 2020 Partial Balance Sheet Assets Liabilities & Owner’s Equity 2019 2020 2019 2020 Current assets $4665 $7279 Current liabilities $2076 $4256 Net Fixed assets $7033 $11378 Long-term debt $3712 $1980 Total Equity (Total assets – total liabilities) (Total assets – total liabilities) BHP Group Ltd.- 2020 Income Statement Sales $10073 Cost of goods sold $5815 Depreciation $2227 Interest paid $1284 Taxes $1202 Calculate the Profit margin ratio of BHP Group Ltd. for the financial year 2020
6 T&T Company's selected financial statements items are given as following. Total net sales equals to 100.000 TL, COGS equals to 50.000 TL, operating expenses equals to 20.000 TL, interest expenses equals to 10.000 TL, tax expenses 5.000 TL, total depreciation & amortization expenses equals to 15.000 TL. Calculate the EBITDA/Interest Expense ratio of the company for the year 2020. a) O 4,50 01383 b) O 3,00 c) O 2,50 d) O 5,00
Question 1 Consider the following financial information and answer the questionsthat follow:Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC Question 2 The following financial information is available for Hero Sports Ltd.:Sales : $45,000Costs : $25,000Addition to retained earnings : $5,500Dividends paid : $900Interest expense : $1,450Tax rate : 40%Compute the depreciation expense. Question 3 Use the following information to answer the question that follow:Net Income : $205,000Profit margin : 7.80%A/R : $151,642Credit sales :…
PLASMA SCREENS CORPORATION Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 155,100 74,800 87,000 2,400 171,800 88,000 72,800 1,200 Accounts receivable Inventory Prepaid rent Long-term assets: Land 440,000 732,00ө (406, ө00) $1,085,300 440, ө0ө 630,000 252,000) $1,151,800 Equipment Accumulated depreciation Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payable Income tax payable Long-term liabilities: Notes payable Stockholders' equity: 91,000 6,900 6,400 $ 77,800 13,800 4, 200 115,000 230,000 Common stock 660,000 206,000 $1,085,300 660,000 166,000 $1,151,800 Retained earnings Total liabilities and stockholders' equity Additional Information for 2021: 1. Net income is $61,000. 2. The company purchases $102,000 in equipment. 3. Depreciation expense is $154,000. 4. The company repays $115,000 in notes payable. 5. The company declares and pays a cash dividend of $21,000. %24 %24 %24