Using Excel, please Help Create and estimate (P/E Ratio) Price to earnings ratio and other ratios and show equations for stock price.

AT&T
Ratio Analysis From 2014 to 2018
Ratio	2018	2017	2016	2015	2014	Average (AT&T)	Industry Average
Liquidity Ratios
Current Ratio	80%	97%	76%	75%	90%	84%	94%
Efficient Ratios
A/R turnover	6.45x	9.72x	9.75x	8.01x	n/a	8.48x	7.33x
Average Collection Period	55.81	37.05	36.91	40.54	n/a	42.58	69.05
Fixed Asset Turnover	1.30x	1.28x	1.56x	1.40x	1.90x	1.49x	0.52x
Total Asset Turnover	0.32x	0.36x	0.41x	0.36x	0.45x	0.38x	0.49x
Leverage Ratios
Total Debt Ratio	63.55%	68.02%	69.27%	69.30%	69.59%	67.94%	79.34%
Long Term Debt	31.26%	28.37%	28.15%	29.43%	25.53%	28.55%	39.98%
LTD to Total Capitalizations	95.62%	95.10%	94.60%	94.80%	92.11%	94.44%	99.60%
LTD to Equity	85.75%	88.71%	91.60%	95.85%	83.95%	89.17%	193.52%
Coverage Ratios
Net Profit Margin	11.69%	18.59%	8.14%	9.32%	5.09%	10.57%	11.87%
Return on Total Assets	3.75%	6.72%	3.30%	3.40%	2.27%	3.89%	5.86%
Return on Equity	10.29%	21.02%	10.74%	11.07%	7.46%	12.12%	31%
Return on Common Equity	2.62x	4.60x	2.05x	2.11x	1.04x	2.48x	2.75x
Economic Profit
Tax Rate	21%	35%	35%	35%	35%	32%	32%
Nopat	19649.67	9840.35	12877.8	13449.8	6730.75	12509.674	10,906.52
Total Operating Capital	(11,508)	32,550	(8,556)	(8,719)	(462)	661	5,346
After-Tax cost of Capital	20%	-97%	33%	33%	35%	5%	3%
Dollar Cost of Capital	-2276.34	-31623.32	-2798.02	-2851.32	-161.47	-7942.09	170.32
Economic Profit	21926.01	41463.67	15675.82	16301.12	6892.22	20451.77	10,736.20

Answer rating: 100% (QA)

To calculate the PE ratio we will need the stock price which is not provided in the given data Howev... View the full answer