FSA template with competitiors 8.7.23-1

xlsx

School

Maryville University *

*We aren’t endorsed by this school

Course

210

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

3

Uploaded by MateWalrus2441

Report
Your company name HERE Profit Ratios Date 1 Date 2 Profit Margin Return on Assets Return on Equity Asset Utilization Ratios Date 1 Date 2 Receivable Turnover Average Collection Days Inventory Turnover Fixed Asset Turnover Total Asset Turnover Liquidity Ratios Date 1 Date 2 Current Ratio Quick Ratio Debt Utilization Ratios Date 1 Date 2 Debt to Total Assets Times Interest Earned Debt to Equity Dupont Analysis Date 1 Date 2 Profit Margin x Asset Turnover = Return on Assets x Leverage = Return on Equity
Microsoft Dupont Analysis 6/30/2023 6/30/2022 Profit Margin 34.14% 36.7% x Asset Turnover 0.5 0.5 = Return on Assets 17.6% 19.7% x Leverage 2.00 2.19 = Return on Equity 35.1% 43.2% Target Dupont Analysis 1/31/2023 1/31/2022 Profit Margin 2.5% 6.6% x Asset Turnover 2.0 2.0 = Return on Assets 5.1% 12.9% x Leverage 4.75 4.20 = Return on Equity 24.2% 54.2% Walmart Dupont Analysis 1/31/2023 1/31/2022 Profit Margin 1.9% 2.4% x Asset Turnover 2.5 2.3 = Return on Assets 4.8% 5.6% x Leverage 2.90 2.66 = Return on Equity 13.9% 14.9% Under Armour Dupont Analysis 12/31/2022 12/31/2021 Profit Margin 6.55% 6.34% x Asset Turnover 1.2 1.1 = Return on Assets 7.96% 7.21% x Leverage 2.43 2.39
= Return on Equity 19.35% 17.24% Proctor & Gamble Dupont Analysis 6/30/2023 6/30/2022 Profit Margin 17.5% 18.0% x Asset Turnover 0.7 0.7 = Return on Assets 11.9% 12.3% x Leverage 2.57 2.50 = Return on Equity 30.5% 30.9%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help