Average Assets = (14555+12469)/2 = 13512
Average Equity = (5450+5527)/2 = 5488.5
Average Asset Turnover = Revenue / Average Assets = 19974 / 13512 = 1.478242
Interest Burden = Earning before Tax / Earning Before Interest and Tax = 901 / (901+207) = 0.8013177
Tax Burden = Net Income / Earning before Tax = 691 / 901 = 0.766926
EBIT Margin = EBIT / Revenue = (901+207) / 19974 = 0.082001
Equity Multiplier = Average Assets / Average Equity = 13512 / 5488.5 = 2.461875
Return on Average Equity = Net Income / Average Equity = 691 / 5488.5 = 12.59%
Return on Average Equity = Average Asset Turnover X Interest Burden X Tax Burden X EBIT Margin X Equity Multiplier = 12.59%
11 pts INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A...
what is the dupont EBT using avg assets equity what is the tax burden? INCOME STATEMENT Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Gross Income EBIT SG&A Expense Unusual Expense Interest Expense Pretax Income Income Tax - Current Domestic Consolidated Net Income 2020 19,974 11,990 1,067 6,917 5,705 104 207 901 159 691 2019 20,229 12,199 964 7,066 5,601 167 256 1,042 272 801 BALANCE SHEET Cash & Short Term Investments Total Accounts Receivable Inventories Other Current Assets Miscellaneous...
6 ANNUAL FINANCIAL REPORT All values USD Millions. Fiscal year is February-January. All values USD Millions. BALANCE SHEET Assets Cash & Short Term Investments Total Accounts Receivable Inventories Other Current Assets Total Current Assets 2020 723 15 3,537 374 4,649 2019 934 29 3,475 397 4,835 9,743 145 14,555 7,428 182 12,469 3 Net Property, Plant & Equipment 4 Other Assets 5 Total Assets -6 17 Liabilities & Shareholders' Equity 18 ST Debt & Current Portion LT Debt 19 Accounts...
Income Statement Sales/Revenue Total revenue 76,480,000,000 Cost of Revenue 25,110,000,000 Gross Profit 51,370,000,000 Operating Exp 31,810,000,000 Selling General & Admin - Other Operating Expense 3,390,000,000 Unusual Expense 16,180,000,000 EBIT after Unusual Expense 2,130,000,000 Non Operating Income/Expense 385,000,000 Equity in Affiliates (Pretax) 1,020,000,000 Interest Expense 17,670,000,000 Pretax Income 16,370,000,000 Other After Tax Income (Expense) 1,300,000,000 Consolidated Net Income - Minority Interest Expense 1,300,000,000 Net Income - Discontinued Operations 1,300,000,000 Net Income After Extraordinaries - Preferred Dividends 1,300,000,000 Net Income Available to...
Income Statement Year 2019 2020 Net Revenue 140,000 - Cost of Goods Sold 70,000 - Depreciation Expense 9,000 EBIT 61,000 - Interest Expense 10,500 Income Before Taxes 50,500 Tax Expense 10,605 Net Income 2019 Dividend 39,895 9,974 Balance Sheet Year (end of) 2019 2020 2019 2020 Assets Liabilities Current Assets Current Liabilities Cash and Equivalents 10,000 Accounts Payable 21,000 Accounts Receivable 25,000 Long-term Debt 95,000 Inventory 12,000 Total Liabilities 116,000 Fixed Assets, Net 165,000 Stockholders' Equity Total Assets 212,000 Common...
Complete the excel. INCOME STATEMENT 1 Sales 2 COGS 3 Depreciation expense 4 Total operating costs 5 EBIT 6 Less interest 7 Earnings before taxes (EBT) 8 Taxes (40%) 11 Net Income 12 Shares of common equity 13 Dividends per share 14 Dividends to common 15 Additions to retained earnings Actual 2016 $ 7,500.00 $ 5,625.00 375.00 6,000.00 1,500.00 63.00 1,437.00 574.80 862.20 62.50 $ 2.50 $ 156.25 $ 705.95 Actual 2016 30.00 543.75 787.50 1,361.25 1,350.00 2,711.25 BALANCE SHEET...
Income Statement Revenue Total revenue $470,100 Cost of Revenue $149,700 Gross Profit $320,100 Operating Exp Selling General & Admin $57,800 other $17,400 Total Operating Exp $269,900 Operating Income or Loss $200,200 Income from Continuing Operations Expenses Net/Total other Income $114,400 Earnings before Int & Tax $200,200 Interest Exp -$32,200 Income before Tax $314,600 Income Tax Exp $100 Minority Interest $23,300 Net Income from Continuing Ops $314,500 Net Income $295,300 Net Income applicable to common shares $230,700 Balance Sheet Current Assets...
Income Statement Sales 900 COGS 550 Gross Margin 350 S&G 200 EBIT 150 Interest Exp 20 Taxes 15 Net Income 115 # Shares 400 Balance Sheet Cash 400 Account Receivable 200 Inventory 100 Total Current Assets 700 Long Term Investments 500 Property Plant and Equipment 800 Goodwill 100 Total Assets 2100 Accounts Payable 220 Total Current Liabilities 300 Total Liabilities 1720 Stockholders' Equity Total Stockholders' Equity 380 Net Tangible Assets 280 Cash Flow Net Income 115 Depreciation 250 Total Cash...
Income Statement Sales $198,520 Costs Except Depreciation (99,010) EBITDA $99,510 Depreciation (6,080) EBIT $93,430 Interest Expense (net) (440) Pretax Income $92,990 Income Tax (23,248) Net Income $69,742 Balance Sheet Assets Cash and Equivalents $15,020 Accounts Receivable 1,940 Inventories 4,090 Total Current Assets $21,050 Property, Plant and Equipment 10,000 Total Assets $31,050 Liabilities and Equity Accounts Payable $1,410 Debt 4,080 Total Liabilities $5,490 Stockholders' Equity 25,560 Total Liabilities and Equity $31,050 Jim's Espresso expects sales to grow by 10.1% next...
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. April 26, 2019 $30,557 9,155 2,330 10,418 1,764 Consolidated Statement of Income, 12 Months Ended ($ millions) Net Sales Costs and expenses Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax...
Refine Assumptions for Dividend and Retained Earnings Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income $ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income,...