Calculate following ratios (make all the calculations in your Excel file using reference cells calculations) and measures for the company you selected and its competitor, compare them to the industry ratios. Here are the ratios that you will need to calculate for the last two years:

Please provide the following for Lowe's and Home Depot for the year 2020.

Short-Term Solvency or Liquidity Measures

Net-Working-Capital to-Total-Assets Ratio

Current Ratio

Quick Ratio

Cash Ratio

Enterprise Value

Enterprise Value Multiples