Partial Income Statement Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* Excel Exercise Compute the...

Transcribed Image Text:

Partial Income Statement Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* Excel Exercise Compute the Following 2019 100 EBITDA 40 EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet CF from Operations ? Debt and Loans 150 Total Equity 150 ROE ? Total Assets 300 Asset Turnover ? Inv. Change 10 Net Profit Margin ? A/R Change A/P Change 35 20 Equity Multiplier ? Verify Dupont ROE ? * Assume all taxes paid in current period (no accrued taxes) for rest of course Tt O 23 24 Partial Income Statement Sales COGS SG&A Depreciation Debt Int. Rate Tax Rate* Excel Exercise Compute the Following 2019 100 EBITDA 40 EBIT 25 Interest 10 EBT 0.08 Tax 0.25 Net Income ? ? ? ? ? ? Partial Balance Sheet CF from Operations ? Debt and Loans 150 Total Equity 150 ROE ? Total Assets 300 Asset Turnover ? Inv. Change 10 Net Profit Margin ? A/R Change A/P Change 35 20 Equity Multiplier ? Verify Dupont ROE ? * Assume all taxes paid in current period (no accrued taxes) for rest of course Tt O 23 24