Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do in excel and show how you got the answer in excel See below for selected information from the recent financials of ABC Corp.
please do in excel and show how you got the answer in excel
See below for selected information from the recent financials of ABC Corp. 1) What was the cash coverage ratio for the year? 2) Compute the equity multiplier. 3) Compute the profit margin. 4) Compute the quick ratio. 5) What was the firm's ROE? SHOW YOUR WORK $ Cash Inventory PP&E Total Assets 2020 185,000 66,000 644,000 '$ 895,000 Revenue COGS Gross profit SG&A Depreciation EBIT Interest EBT Tax @21% Net Income 2020 435,000 348,000 87,000 12,000 5,000 70,000 50,000 20,000 4,200 15,800 Accounts Payable Long-term Debt Total Liabilities 82,000 343,000 $ 425,000 $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started