Description
Using the balance sheet and income statement for Archer-Daniels-Midland company for 2019 and 2020 sourced from Yahoo Finance, calculate your ratios with the spreadsheet template provided below (I've attached the excel template) (i.e., I used Darden Restaurants Inc. as an example). Discuss liquidity, solvency, activity, and profitability for your company.
Please post your answer in approximately 200 words. Also, attach your Excel spreadsheet for your company (ADM)
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.Please see attached file for the answer and explanation.
Archer-Daniels-Midland Company (ADM)
Liquidity
Current Ratio
December 31, 2020
CA
CL
$
$
27,286,000,000
18,182,000,000
1.50
(CA-INV)
CL
$
$
15,573,000,000
18,182,000,000
0.86
Debt Asset Ratio
TL
TA
$
$
29,623,000,000
49,719,000,000
0.60
Equity Asset Ratio
OE
TA
$
$
20,022,000,000
49,719,000,000
0.40
Debt Equity Ratio
TL
OE
$
$
29,623,000,000
20,022,000,000
1.48
Total Asset Turnover Ratio
Sales
TA
$
$
64,355,000,000
49,719,000,000
1.29
Fixed Asset Turnover Rati...
