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
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
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.3C
Related questions
Question
Transcribed Image Text: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
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you