please help me to get done 2.3 for Microsoft company 2014-2018 year 14,15,16,17,18
I also have balance sheet, income statement and cash flow datas if needs to provide. I used yahoo finance 
2017 2016 2015 2014 2018 Name of Ratio 1.5916 1.8329 2.0869 1.4291 Current Ratio 1.4696 2.44 2.31 2.44 2.44 2.85 Liquidity Ratio 24.696 47.599 Times Interest 14.345 11.418 16.889 Earned Ratio 13% 19.6% 25.56% 15% Gross Profit 24.8% % 1648 1052 . 1084 .1095 1515 Basic Earning Power 3 5 1 0.16 0.14 0.15 0.22 0.20 Return on Capital Employed 0.23 0.15 0.24 0.20 0.3 Return on Shareholders Equity I Some of Microsoft's biggest competitors are Lenovo AWS, Google, IBM, Cisco, etc. Comparing the averages for microsoft and Lenovo which is their biggest competitor. In 2014 Lenovo was averaging about 38,707,129 in total revenue. Compared to Microsoft which was around the 86,000,000 in total revenue. In overall averages Microsoft was always leading Lenovo in the years of 2014-2018 2.3 Share Price Analysis Under the current situation, will you recommend to buy, hold, or sell the company's shares and why? You may want to discuss various measures of share price performance (i.e. stock market indicators/ratios). You may also consider other I factors/information that can potentially influence the company's share price. Calculate the intrinsic value using DCFI IN Stock Market Indicators/Ratios Value of Ratio Earnings Per Share P/E ratio Dividend Per Share Dividend Cover Net Assets Per Share 2017 2016 2015 2014 2018 Name of Ratio 1.5916 1.8329 2.0869 1.4291 Current Ratio 1.4696 2.44 2.31 2.44 2.44 2.85 Liquidity Ratio 24.696 47.599 Times Interest 14.345 11.418 16.889 Earned Ratio 13% 19.6% 25.56% 15% Gross Profit 24.8% % 1648 1052 . 1084 .1095 1515 Basic Earning Power 3 5 1 0.16 0.14 0.15 0.22 0.20 Return on Capital Employed 0.23 0.15 0.24 0.20 0.3 Return on Shareholders Equity I Some of Microsoft's biggest competitors are Lenovo AWS, Google, IBM, Cisco, etc. Comparing the averages for microsoft and Lenovo which is their biggest competitor. In 2014 Lenovo was averaging about 38,707,129 in total revenue. Compared to Microsoft which was around the 86,000,000 in total revenue. In overall averages Microsoft was always leading Lenovo in the years of 2014-2018 2.3 Share Price Analysis Under the current situation, will you recommend to buy, hold, or sell the company's shares and why? You may want to discuss various measures of share price performance (i.e. stock market indicators/ratios). You may also consider other I factors/information that can potentially influence the company's share price. Calculate the intrinsic value using DCFI IN Stock Market Indicators/Ratios Value of Ratio Earnings Per Share P/E ratio Dividend Per Share Dividend Cover Net Assets Per Share
