Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Compute the following list using information below for both years (2022 & 2021) using Excel, include formulas used. Organize your work in Excel so that
Compute the following list using information below for both years (2022 & 2021) using Excel, include formulas used. Organize your work in Excel so that its easy to read - providing headings, appropriate font sizes, and so forth.
- Return on Assets (Use ending Total Assets)
- Total expenses
- Debt ratio
- Profit Margin
- Current ratio
Year ended 2021 | Year ended 2022 | ||
Total liabilities | 55,164 | 74,467 | |
Total assets | 232,792 | 275,909 | |
Net income | 30,736 | 34,343 | |
Revenue | 136,819 | 161,857 | |
Current assets | 135,676 | 152,578 | |
Current liabilities | 34,620 | 45,221 |
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