Data Analytics / Financial Ratio Analysis This assignment will focus on the comparison between T Mobile and
Question:
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? 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.
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris