Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the 18 formulas showering all work and what numbers you used for each formula for American towers year 2020. 1 American Tovers Corporation and
Calculate the 18 formulas showering all work and what numbers you used for each formula for American towers year 2020.
1 American Tovers Corporation and Subsidiaries 2 Consolidated Income Statements As of December 31, 2020. December 31, 2019, and December 31, 2018 4 In Millions. Except Share and Per Share Data 5 6 Decmber 31, 2020 7 Revenues: Property 7,953.6 Services 87.9 10 Total Operating Revenues 8,041.5 11 12 Operating Expenses: 13 Costs of Operations (Exclusive of Items Shown Separately Below): 14 Property 2189.6 15 Services 37.6 16 Depreciation, Amortization and Accretion 1882.3 17 Selling, General, Administrative and Development Expense 778.7 18 Other Operating Expenses 265.8 19 Total Operating Expenses 5,154.0 20 21 Operating Income $ 2,887.5 22 Other Income (Expense): 23 Interest Expense, TV Azteca 24 Interest Income 39.7 (793.5) (71.8) 25 Interest Expense 26 Loss on Retirement of Long-Term Obligations Other (Expense) Income (Including Foreign Currency 27 (Losses) Gains Of $(216.4). $6.1, and $(4.5). Respectively) 28 Total Other Expense 29 30 Income from Continuing Operations Before Incon 31 Income Tax (Provision) Benefit (240.8) (1,066.4) 1,821.1 (129.6) 1691.5 (0.9) 1690.6 1,690.6 32 Net Income $ 33 Net Income Attributable to Nonoontrolling Interests Net Income Attributable to American Tover 34 Corporation Stockholders 35 Dividends on Preferred Stock Net Income Attributable to American Tover 36 Corporation Common Stockholders 37 38 Net Income Per Common Share Amounts: Basic Net Income Attributable to American Tower 39 Corporation Common Stockholders $ Diluted Net Income Attributable to American Tower 40 Corporation Common Stockholders 41 Veighted Average Common Shares Outstanding (In Thousands): 42 Basic 43 Diluted 44 Treasure Stock 3.81 3.79 443,640 446,104 2,464 1 American Tovers Corporation and Subsidiaries 2 Consolidated Balance Sheets As of December 31, 2020. December 31, 2019, and December 31, 2018 4 In Millions, Except Share Count and Per Share Data 5 6 Decmber 31, 2020 7 Assets Current Assets: 9 Cash and Cash Equivalents $ 1,746.3 10 Restricted Cash 115.1 11 Accounts Receivable, Net 511.6 12 Prepaid and Other Current Assets 532.6 13 Total Current Assets 2,905.6 14 Property and Equipment, Net 12,808.7 15 Goodwill 7.282.7 16 Other Intangible Assets, Net 13,839.8 17 Deferred Tax Asset 123.1 18 Deferred Rent Asset 2,084.3 19 Right-of-Use Asset 7.789.2 20 Notes Receivable and Other Non-Current Assets 400.1 21 Total $ 47,233.5 22 23 Liabilities 24 Current Liabilities: 25 Accounts Payable $ 139.1 26 Accrued Expenses 1,043.7 27 Distributions Payable 544.6 28 Accrued Interest 207.8 29 Current Portion of Operating Lease Liability 539.9 30 Current Portion of Long-Term Obligations 789.8 31 Unearned Revenue 390.6 32 Total Current Liabilities $ 3,655.5 33 Long-Term Obligations 28,497.7 34 Operating Lease Liability 6,884.4 35 Asset Retirement Obligations 1,571.3 36 Deferred Tax Liability 859.5 37 Other Non-Current Liabilities 984.6 38 Total Liabilities $ 42,453.0 39 40 Commitments and Contingencies 41 Redeemable Noncontrolling Interests 212.1 42 43 Equity (Shares in Thousands): Common Stock: $.01 Par Value: 1,000,000 Shares Authorized: 455,245 Shares 44 Issued; and 444,330 Shares 45 Common Stock: 9.01 Par Value: 1,000,000 Shares 4.6 46 Additional Paid-In Capital 10,473.7 47 Distributions in Excess of Earnings (1,343.0) 48 Accumulated Other Comprehensive Loss (3.759.4) Treasury Stock: 10,915 49 Shares at Cost 50 Treasury Stock (1,282.4) 51 Total American Tover Corporation Equity 4,093.5 52 Noncontrolling Interests 474.9 53 Total Equity $ 4,568.4 54 Total $ 47,233.5 1,882.3 120.8 299.6 239.5 71.8 32.9 (22.5) (175.5) 84.4 (322.0) (10.9) (69.2) (1.8) 60.7 (0.2) 3,881.4 (1.031.7) (3.799.1) 19.6 1 American Tovers Corporation and Subsidiaries 2 Consolidated Statement of Cash Flows 3 As of December 31, 2020. December 31, 2019, and December 31, 2018 4 In Millions 5 6 Decmber 31, 2020 7 Cash Flows from Operating Activities 8 Net Income $ 1,691.5 Adjustments to Reconcile Net Income to Cash Provided 9 by Operating Activities: 10 Depreciation, Amortization and Accretion 1,882.3 11 Stock-Based Compensation Expense 120.8 Loss on Investments, Unrealized Foreign Currency Loss 12 and Other Non-Cash Expense 299.6 Impairments, Net Loss on Sale of Long-Lived Assets, 13 Non-Cash Restructuring and Merger Related Expenses 239.5 14 Loss on Early Retirement of Long-Term Obligations 71.8 Amortization of Deferred Financing Costs, Debt 45 Discounts and Premiums and Other Non-Cash Interest 32.9 16 Deferred Income Taxes (22.5) 17 Changes in Assets and Liabilities, Net of Acquisitions: 18 Accounts Receivable (175.5) ( 19 Prepaid and Other Assets 84.4 20 Deferred Rent Asset (322.0) 21 Right-of-Use Asset and Operating Lease Liability, Net (10.9) 22 Accounts Payable and Accrued Expenses (69.2) Accrued Interest (1.8) 24 Unearned Revenue 60.7 25 Deferred Rent Liability 26 Other Non-Current Liabilities (0.2) 27 Cash Provided by Operating Activities $ 3,881.4 28 29 Cash Flows from Investing Activities Payments for Purchase of Property and Equipment and 30 Construction Activities (1.031.7) 61 Payments for Acquisitions, Net of Cash Acquired (3.799.1) Proceeds From Sales of Short-Term Investments and 32 Other Non-Current Assets 19.6 33 Payments for Short-Term Investments 34 Deposits and Other 26.6 35 Cash Used for Investing Activities $ (4.784.6) 36 37 Cash Flows from Financing Activities -38 Borrowings Under Credit Facilities 8.230.4 39 Proceeds from Issuance of Senior Notes, Net 7.925.1 40 Proceeds from Term Loans 1.940.0 41 Proceeds from Issuance of Securities in Securitization Trai Repayments of Notes Payable, Credit Facilities, Term 42 Loans, Senior Notes, Secured Debt, Finance Leases and (13,875.4) 43 Distributions to Noncontrolling Interest Holders, Net (12.3) 44 Purchases of Common Stock (56.0) 45 Proceeds from Stock Options and Employee Stock Purch 98.1 46 Distributions Paid on Common Stock (1.928.2) 47 Distributions Paid on Preferred Stock Payment for Early Retirement of Long-Term Obligations (68.2) 49 Deferred Financing Costs and Other Financing Activities (176.5) 50 Purchases of Redeemable Noncontrolling Interests (861.7) 51 Purchase of Noncontrolling Interest Cash Provided by (Used For) Financing Activitis $ 1.215.3 10 Depreciation, Amortization and Accretion 11 Stock-Based Compensation Expense Loss on Investments, Unrealized Foreign Currency Loss 12 and Other Non-Cash Expense Impairments, Net Loss on Sale of Long-Lived Assets, 13 Non-Cash Restructuring and Merger Related Expenses 14 Loss on Early Retirement of Long-Term Obligations Amortization of Deferred Financing Costs, Debt 15 Discounts and Premiums and Other Non-Cash Interest 16 Deferred Income Taxes 17 Changes in Assets and Liabilities, Net of Acquisitions: 18 Accounts Receivable 19 Prepaid and Other Assets 20 Deferred Rent Asset 21 Right-of-Use Asset and Operating Lease Liability, Net 22 Accounts Payable and Accrued Expenses 23 Accrued Interest 24 Unearned Revenue 25 Deferred Rent Liability 26 Other Non-Current Liabilities 27 Cash Provided by Operating Activities $ 28 29 Cash Flows from Investing Activities Payments for Purchase of Property and Equipment and 30 Construction Activities 31 Payments for Acquisitions, Net of Cash Acquired Proceeds From Sales of Short-Term Investments and 32 Other Non-Current Assets 33 Payments for Short-Term Investments 34 Deposits and Other 35 Cash Used for Investing Activities $ 36 37 Cash Floys from Financing Activities 38 Borrowings Under Credit Facilities 39 Proceeds from Issuance of Senior Notes, Net 40 Proceeds from Term Loans 41 Proceeds from Issuance of Securities in Securitization Trai Repayments of Notes Payable. Credit Facilities, Term 42 Loans, Senior Notes, Secured Debt, Finance Leases and 43 Distributions to Noncontrolling Interest Holders, Net 44 Purchases of Common Stock 45 Proceeds from Stock Options and Employee Stock Purch 46 Distributions Paid on Common Stock 47 Distributions Paid on Preferred Stock 48 Payment for Early Retirement of Long-Term Obligations Deferred Financing Costs and Other Financing Activities 50 Purchases of Redeemable Noncontrolling Interests 51 Purchase of Noncontrolling Interest 52 Cash Provided by (Used For) Financing Activitit $ Net Effect of Changes in Foreign Currency Exchange 53 Rates on Cash and Cash Equivalents, and Restricted 54 Net Increase in Cash and Cash Equivalents, and I $ Cash and Cash Equivalents, and Restricted 55 Cash, Beginning of Year 56 Cash and Cash Equivalents, and Restricted Cash $ 57 58 Ending Cash Balance $ 26.6 (4.784.6) 8.230.4 7,925.1 1.940.0 (13,875.4) (12.3) (56.0) 98.1 (1.928.2) (68.2) (176.5) (861.7) 1.215.3 (28.7) 283.4 48 1,578.0 1,861.4 47.233.5 52 7 2 Competitor Ratio Analysis 3 4 As of December 31, 2020 Extra Space Storage Inc., 2020 American Tower Corp., 2020 Industy Average 5 6 PO 7 8 Liquidity Ratios 9 Current Ratio 10 Quick Ratio 11 12 Leverage Ratios 13 Debt to Total Assets Ratio 14 Debt Equity Ratio 15 Long-Term Debt to Equity 16 Times Interest Earned Ratio 17 18 Activity Ratios 19 Inventory Turnover 20 Fixed Assets Turnover 21 Total Assets Turnover 22 Accounts Receivable Turnover 23 Average Collection Period 24 25 Profitability Ratios 26 Gross Profit Margin 27 Operating Profit Margin 28 Net Profit Margin 29 Return on Total Assets (ROA) 30 Return on Stockholders' equity (ROE) 31 Earnings Per Share (EPS) 32 Price Earnings RatioStep 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