Answered step by step
Verified Expert Solution
Link Copied!

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! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago