Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i know its a lot but please help! this is all the information i have what do you need? This assignment will focus on the
i know its a lot but please help!
this is all the information i have what do you need?
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 Camas for directions on grading) Calculate the following in this workbook for both T Mobile and Verizon: 1. Vertical Analysis of select items highlighted in yellow on the statements page. 2. Current ratio (current assets / current liabilities) - this examines a company's liquidity 3. Debt to equity ratio (Total Labilites/ Shareholders' Equity) - This examines the capital structure of a company 4. Sales growth 5. Net income growth 6. Return on Equity (Net Income / Stockholder's Equity)- This is also a profitability ratio Complete a vertical analysis of the items highlighted in yellow for both compan Verizon Income Statement Total Current Assets Non-Current Assets PPEE (net) Investments in unconsolidated businesses $91.915 Wireless Licenses $558 Goodwill Other Intangibles Operating Leases Other assets Total non-current Total Assets \begin{tabular}{|} $29,868 \\ \hline$366,596 \\ \hline \end{tabular} $261,887$316,481 Current Liabilities Current portion of debt Accounts payable Current operating lease liabilities Other current liabilities \begin{tabular}{|r|r|r|} \hline$7,443 & $5,889 & $10,777 \\ \hline$24,833 & $20,658 & $21,806 \\ \hline$3,859 & $3,485 & $3,261 \\ \hline$11,025 & $9,628 & $9,024 \\ \hline \end{tabular} Total current liabilities Non-Current Liabilities Total Liabilities $283,396$236,236 $207,549$247,209 \begin{tabular}{|} $184,024 \\ \hline$228,892 \\ \hline \end{tabular} Equity Preferred Stock Common Stock Additional Paid in Capital Retained Earnings \begin{tabular}{rr|} $0 & $0 \\ $429 & $429 \\ 13.404 & $13,419 \\ 60,464 & $53,147 \end{tabular} AOCl or loss Treasury Stock Deferred Compensation Noncontrolling Interest Total Equity Total Liabilities Plus Equity $366,596$316,481 $291.727 Cash from Operating Activities Cash From Investing Activities Cash from Financing Activities Increase in Cash Cash at beginning of period Cash at end of period TMobile Income Statement T Mobile Balance Sheet \begin{tabular}{|lr|r|r|} \hline Current Assets & 2021 & 2020 & 2019 \\ \hline Cash & & & \\ \hline A/R (net) & $6,631 & $10,385 & $1,528 \\ \hline Equipment receivables & $4,167 & $4,254 & $1,888 \\ \hline A/R from affiliates & $4,748 & $3,577 & $2,600 \\ \hline Inventory & $27 & $22 & $20 \\ \hline Prepaid Expenses & $2,567 & $2,527 & $964 \\ \hline Other current assets & $746 & $624 & $333 \\ \hline Total Current Assets & $2,005 & $2,496 & $1,972 \\ \hline \end{tabular} Non-Current Assets Current Liabilities Accounts Payable Payables to Affiliates Short-term Debt Deferred revenue Short-term Operating Lease Short-term financing lease Other current liabilities Totol current Liabilities \begin{tabular}{|rrr|} \hline$11,405 & $10,196 & \\ $103 & $157 & $6,746 \\ \hline$5,623 & $4,579 & $187 \\ \hline$856 & $1,030 & $25 \\ $3,425 & $3,868 & $631 \\ $1,120 & $1,063 & $2,287 \\ $967 & $810 & $957 \\ \hline$23,499 & $21,703 & $1,673 \\ \hline & & $12,506 \\ \hline \end{tabular} Cash Flow Cash from Operating Activities 2021 $13,917 2020 $8,640 2019 $6,824 2018 $3,899 2 Vertical Analysis Verizon TMobile 3. Whose is better for 2022? (choose one) Why? Gross Margin Net Profit Margin Liabilities as a \% Total Liab + Eq. Upon completion of the above, in which company would you invest your $1,000 ? Why? Use your analysis to support your choice. 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 Camas for directions on grading) Calculate the following in this workbook for both T Mobile and Verizon: 1. Vertical Analysis of select items highlighted in yellow on the statements page. 2. Current ratio (current assets / current liabilities) - this examines a company's liquidity 3. Debt to equity ratio (Total Labilites/ Shareholders' Equity) - This examines the capital structure of a company 4. Sales growth 5. Net income growth 6. Return on Equity (Net Income / Stockholder's Equity)- This is also a profitability ratio Complete a vertical analysis of the items highlighted in yellow for both compan Verizon Income Statement Total Current Assets Non-Current Assets PPEE (net) Investments in unconsolidated businesses $91.915 Wireless Licenses $558 Goodwill Other Intangibles Operating Leases Other assets Total non-current Total Assets \begin{tabular}{|} $29,868 \\ \hline$366,596 \\ \hline \end{tabular} $261,887$316,481 Current Liabilities Current portion of debt Accounts payable Current operating lease liabilities Other current liabilities \begin{tabular}{|r|r|r|} \hline$7,443 & $5,889 & $10,777 \\ \hline$24,833 & $20,658 & $21,806 \\ \hline$3,859 & $3,485 & $3,261 \\ \hline$11,025 & $9,628 & $9,024 \\ \hline \end{tabular} Total current liabilities Non-Current Liabilities Total Liabilities $283,396$236,236 $207,549$247,209 \begin{tabular}{|} $184,024 \\ \hline$228,892 \\ \hline \end{tabular} Equity Preferred Stock Common Stock Additional Paid in Capital Retained Earnings \begin{tabular}{rr|} $0 & $0 \\ $429 & $429 \\ 13.404 & $13,419 \\ 60,464 & $53,147 \end{tabular} AOCl or loss Treasury Stock Deferred Compensation Noncontrolling Interest Total Equity Total Liabilities Plus Equity $366,596$316,481 $291.727 Cash from Operating Activities Cash From Investing Activities Cash from Financing Activities Increase in Cash Cash at beginning of period Cash at end of period TMobile Income Statement T Mobile Balance Sheet \begin{tabular}{|lr|r|r|} \hline Current Assets & 2021 & 2020 & 2019 \\ \hline Cash & & & \\ \hline A/R (net) & $6,631 & $10,385 & $1,528 \\ \hline Equipment receivables & $4,167 & $4,254 & $1,888 \\ \hline A/R from affiliates & $4,748 & $3,577 & $2,600 \\ \hline Inventory & $27 & $22 & $20 \\ \hline Prepaid Expenses & $2,567 & $2,527 & $964 \\ \hline Other current assets & $746 & $624 & $333 \\ \hline Total Current Assets & $2,005 & $2,496 & $1,972 \\ \hline \end{tabular} Non-Current Assets Current Liabilities Accounts Payable Payables to Affiliates Short-term Debt Deferred revenue Short-term Operating Lease Short-term financing lease Other current liabilities Totol current Liabilities \begin{tabular}{|rrr|} \hline$11,405 & $10,196 & \\ $103 & $157 & $6,746 \\ \hline$5,623 & $4,579 & $187 \\ \hline$856 & $1,030 & $25 \\ $3,425 & $3,868 & $631 \\ $1,120 & $1,063 & $2,287 \\ $967 & $810 & $957 \\ \hline$23,499 & $21,703 & $1,673 \\ \hline & & $12,506 \\ \hline \end{tabular} Cash Flow Cash from Operating Activities 2021 $13,917 2020 $8,640 2019 $6,824 2018 $3,899 2 Vertical Analysis Verizon TMobile 3. Whose is better for 2022? (choose one) Why? Gross Margin Net Profit Margin Liabilities as a \% Total Liab + Eq. Upon completion of the above, in which company would you invest your $1,000 ? Why? Use your analysis to support your choice Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started