Home Insert Paste 18 UFF Data Analytics_Verizon v. TMobile-3 % Draw Page Layout Formulas Data Review View Tell me A- Conditional Formatting Format as Table Font Alignment Number Cells Editing Cell Styles Analyze Ser Data A B C fx D H K L M Data Analytics/Financial Ratio Analysis This assignment will focus on the comparison between T Mobile and Verizon. Identify each company's weak and/or strong areas of performance. After analysis, if you had $1,000 to purchase stock in either of these companies, which would you choose? (Please see the rubric in Canvas for directions on grading) Calculate the following in this workbook for both T Mobile and Verizon from the most recent 2 years. Complete the vertical analysis in the statements worksheet. Complete the ratio analysis in the analysis worksheet. 1. Vertical Analysis of both the income statement (three years) and balance sheet (two years). Use the yellow highlighted columns for your vertical analysis 2. Current ratio-this examines a company's liquidity 3. Debt ratio (Total Liabilities/Total Assets)-This examines the capital structure of a company 4. Total asset turnover ratio-This examines a company's efficiency 5. Net profit margin (net income/net revenue)-This is a profitability ratio 6. Return on Equity-This is also a profitability ratio Upon completion of the above, in which company would you invest your $1,000? Why? Use your analysis to support your choice Instructions Statements Analysis +