Data Analytics / Financial Ratio Analysis This assignment will focus on the comparison between T Mobile and Verizon. Ide

[answerhappygod]

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.