Calculate the current and quick ratios for Toyota (ticker TM) and Honda (ticker HMC) for the fiscal years
2020-2022 (each fiscal year ends on March 31 of the corresponding calendar year). Comment on the
trend in the ratios for each firm, and determine which firm has higher liquidity based on the values for
the current and quick ratios.
Here are some tips:
• You can easily obtain the balance sheets for the past three years from Yahoo Finance.
o Search the ticker
o Click the "Financials" tab
o Then click the balance sheet
o Make sure you're looking at the annual balance sheets
o Copy the balance sheet into a text file
o Then copy it from the text file into excel
o Note: If you try copying directly from the website into an excel file, the format won't
look right. The general advice to first copy into a text file works for a lot of tables on
websites.
o Calculate your ratios in excel
• If you're having trouble copying the whole balance sheet into excel, then you can just type in the
numbers you need instead of copying the whole thing.