I need to find the Price/Earnings (P/E) ratio for Apple and Dell for the years 2016, 2017 and 2018.

As well as the Market/Book (M/B) ratio for the same years and companies.

I need to have the calculations in order to put them in excel if you could provide them, please.

https://finance.yahoo.com/quote/DELL/balance-sheet?p=DELL Heres Dells income statement and balance

https://finance.yahoo.com/quote/AAPL/balance-sheet?p=AAPL Heres apples income statement and balance.

Has to look something like the picture

A B D F F G J K L N C P R S T Years: 2016, 2017, 2018 Analysis 2016 2016 2017 2017 2018 2018 Dell Apple Dell Apple Apple Dell Liquidity 0.93 Apple is better Current Ratio 1.35 1.28 0.81 1.12 0.36 Quick Ratio Apple is better 0.87 1.23 0.74 1.09 0.34 1.33 1 Activity Total Asset Turnover Dell is better 2.02 2.16 1.78 2.003 2.02 2.02 Inventory Turnover 61.62 36.20 29.05 19.18 41.39 15,88 Apple is better 7 Debt Debt ratio 0.97 Apple has a lower debt 0.60 0.64 0.84 0.71 0.88 1 Times interest earned ratio 6.19 7.62 6.73 Apple is better 4.91 6.43 5.39 12 3 Profitabilitv ficure 4 ficure 5. fiquro 1.dobt.ratio ficure 2. fiquro 2 total accot turnovor. Shoat1