Hello tutor,

This is a white paper -finical analysis report. I am for Pepsi versus Coca-cola. I need an 800-100 paper. The questions that needed to be answered are in the document unit 5 and the Excel document helps with the financial report. Thank you

qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 LIQUIDITY RATIO Longterm debt paying Profitability Asset utilization/ Management efficiency Page 1 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 Market Measures Page 2 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 current ratio = CA/CL cash ratio cash + cash equiv CL quick ratio = (Current Assets - Inventory)/CL Total debt to assets ratio = Total debt/ Total assets Total debt to equity ratio = Total debt/ Equity Times Interest Earned = EBIT/interest profit margin = Net income/sales Return on Assets = Net income/T.Assets Return on Equity= Net Income/ Share Equity Total asset Turnover = Sales/ Total Assets Page 3 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 Inventory turnover = CoGs/ Inventory Accounts Receivable turnover = Sales on credit/AR Price-earnings ratio = Market price per share/EPS Earnings per share = NI/Outstanding shares Dividend payout ratio = dividends/ Earnings Page 4 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 Year PEPSI Inc. 2015 22.99 17.58 1.307736064 9.1 2.91 17.58 0.683162685 CocaCola. 33.4 26.93 1.240252506 7.31 12.59 26.93 0.738952841 22.99 2.72 17.58 1.15301479 33.4 2.9 26.93 1.132565912 57.64 69.67 0.827328836 64.33 90.09 0.714063714 57.64 11.92 4.83557047 64.33 25.55 2.517808219 EBIT Interest T.I.E 8.37 0.779 10.74454429 7.95 0.522 15.22988506 Net income Sales Profit Margin 5.45 63.05 0.086439334 7.35 43.7 0.16819222 Net income T.Assets ROA 5.45 69.67 0.078225922 7.35 90.09 0.081585082 Net income Common Equity ROE 5.45 11.92 0.457214765 7.35 25.55 0.287671233 Sales Total Assets 63.05 69.67 0.904980623 43.7 90.09 0.485070485 Current assets Current liabilities Cash Cash Equiv CL CA Inventory CL Total Debt Total Assets Total Debt shareholders equity Page 5 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 COGS Inventory 28.53 2.72 10.48897059 17.4 2.9 6 Sales AR 63.05 6.44 9.790372671 43.7 3.94 11.09137056 MPS EPS 106.34 3.71 28.66307278 42.74 1.69 25.28994083 NI O.S 5.45 1.47 3.707482993 7.35 4.35 1.689655172 Dividends Earnings 0.006 50.47 Page 6 - qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 Year Page 7 qattachments_5b4883d447139eb91a1cad5cdf7044b06174b366 Page 8 Due in Unit 5: 9. Financial Analysis Summary: Section 9 should be a minimum of 800-1000 words, not counting titles, abstract and references. In this unit all files for the financial analysis report from Units 1, 3, and 5 should be submitted. Based on your research, ratio analyses, and calculations regarding the most current full year's annualized financial data, comment on the following questions: How well has management added value? Is the company's financial performance improving? What are the key strengths and risks for this company? Would you invest your financial capital in the selected firm as a shareholder? Why or why not? Would you invest your human and intellectual capital in the firm as an employee? Why or why not? Submit Section 9 in APA format and citation style per the most recent APA edition together with all your previous work from Units 1 and 3 should be submitted to the U