Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me. thank you in advance. begin{tabular}{|c|c|c|c|c|c|} hline EPS (Basic) & & & & & hline EPS(Basic)GrowthEPS(Basic)Growth & & 23.82% & 7.64% &

please help me. thank you in advance. 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
\begin{tabular}{|c|c|c|c|c|c|} \hline EPS (Basic) & & & & & \\ \hline EPS(Basic)GrowthEPS(Basic)Growth & & 23.82% & 7.64% & 23.71% & 4.90% \\ \hline BasicSharesOutstandingBasicSharesOutstanding & 4.13B & 4.14B & 3. 4.14B & 3 4.15B & 4.2B \\ \hline EPS(Diluted)BPS(Diluted) & 3.76 & 4.65 & 4.3 & 5.32 & 5.06 \\ \hline EPS(Diluted)GrowthEPS(Diluted)Growth & & 23.76% & 7.64% & 23.72% & 4,91% \\ \hline DilutedSharesOutstandingDilutedSharesOutstanding & 4.13B & 4.14B & 4.148 & 4.15B & 4.2B \\ \hline EBITDAEBITDA & 47.41B & 47.71B & 46.59B & 48.17B & 47.57B \\ \hline EBITDAGrowthEBITDAGrowth & & 0.63% & 2.36% & 3.40% & 1.26% \\ \hline EBITDAMarginEBITDAMargin & & & & & \\ \hline \end{tabular} Balance Sheet \begin{tabular}{|c|c|c|c|c|c|} \hline NetOtherIntangiblesNetOtherIntangibles & 103.91B & 104.56B & 105.51B & 3 159.3B1 & 161.26B \\ \hline OtherAssetsOtherAssets & 13.02B & 11.09B & 13.1B & 6.76B & 7.01B \\ \hline TotalAssetsTotalAssets & 264.83B & 291.73B & 316.48B & 366.6B3 & 379.68B \\ \hline TotalAssetsGrowthTotalAssetsGrowth & & 10.16% & 8.49% & 15.84% & 3.57% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline ITEMITEM & 2018 & 2019 & 2020 & 2021 & 2022 & 5-YEARTREND \\ \hline STDebt&CurrentPortionLTDebtSTDebt&CurrentPortionLTDebt & 7.19B & 14.04B & 9.37B & 11.3B & 14.1B & \\ \hline ShortTermDebtShortTermDebt & 150M & 3.26B & 3.81B & 3.86B & 4.13B & \\ \hline CurrentPortionofLongTermDebtCurrentPortionofLongTermDebt & 7.04B & 10.78B & 5.57B & 7.44B & 9.96B & \\ \hline AccountsPayableAccountsPayable & 7.23B & 7.73B & 6.67B & 8.04B & 8.75B & \\ \hline AccountsPayableGrowthIAccountsPayableGrowth & & 6.82% & 13.70% & 20.59% & 8.83% & \\ \hline IncomeTaxPayableIncomeTaxPayable & 1.48B & 1.77B & 1.43B & 1.62B & 1.88B & \\ \hline OtherCurrentLiabilitiesOtherCurrentLiabilities & 22.03B & 21.33B & 22.19B & 26.19B & 25.45B & \\ \hline \end{tabular} \begin{tabular}{l|l|} TotalLiabilitiesTotalLiabilitiesNon-EquityReservesNon-EquityReservesTotalLiabilities/TotalAssetsTotalLiabilities/TotalAssets & 210.12B 228.89B247.21B 283.4B287.22B \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline ITEMITEM & 2018 & 2019 & 2020 & 2021 & 2022 & 5-YEARTREND \\ \hline \multicolumn{7}{|l|}{PreferredStock(CarryingValue)PreferredStock(CarryingValue)} \\ \hline \multicolumn{7}{|l|}{RedeemablePreferredStockRedeemablePreferredStock} \\ \hline \multicolumn{7}{|l|}{Non-RedeemablePreferredStockNon-RedeemablePreferredStock} \\ \hline CommonEquity(Total)CommonEquity(Total) & 53.15B & 61.4B & 67.84B & 81.79B & 91.14B & \\ \hline CommonEquity/TotalAssetsCommonEquity/TotalAssets & 20.07% & 21.05% & 21.44% & 22.31% & 24.01% & \\ \hline CommonStockPar/CarryValueCommonStockPar/CarryValue & 429M & 429M & 429M & 429M & 429M & \\ \hline RetainedEarningsRetainedEarnings & 43.54B & 53.15B & 60.46B & 71.99B & 82.38B & \\ \hline ESOPDebtGuaranteeESOPDebtGuarantee & 353M & 222M & 335M & 538M & 793M & \\ \hline CumulativeTranslationAdjustment/UnrealizedFor.Exch. & & & & & & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|l|} \hline BuildingsBuildings & 30.47B & 31.22B & 32.93B & 33.36B & 35.38B \\ \hline Land&ImprovementsLand&Improvements & 807M & 594M & 608M & 673M & 747M \\ ComputerSoftwareandEquipment & & & & & \\ ComputerSoftwareandEquipment & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline ITEM & 2018 & 2019 & 2020 & 2021 & 2022 & 5-YEARTREND \\ \hline OtherProperty,Plant&EquipmentOtherProperty,Plant&Equipment & 18.09B & 19.3B & 20.44B & 19.83B & 21.05B & \\ \hline AccumulatedDepreciationAccumulatedDepreciation & 163.55B & 173.82B & 184.9B & 190.2B2 & 3200.268 & \\ \hline TotalInvestmentsandAdvancesTotalInvestmentsandAdvances & 1.2B & 1.89B & 3.41B & 2.46B & 1.85B & \\ \hline OtherLong-TermInvestmentsOtherLong-TermInvestments & 532M & 1.33B & 2.82B & 1.4B & 775M & \\ \hline Long-TermNoteReceivablesLong-TermNoteReceivables & 246M & 302M & 204M & 7.6B & 12.11B & \\ \hline IntangibleAssetsIntangibleAssets & 128.52B & 128.95B & 130.288 & 187.9B1 & 189.93B & \\ \hline NetGoodwillNetGoodwill & 24.61B & 24.39B & 24.77B & 28.68 & 28.67B & \\ \hline \end{tabular} a.current ratio b.debt ratio c.for all five years given,what kind of change (up and down) can you detect year to year in the total revenues on the income statement? d. for all fige years given, what kind of change (up and down) can you detect year to year in the in net income on the income statement? e. dies the change in total revenues match the changr in net income year to year? yes or no? Income Statement \begin{tabular}{|c|c|c|c|c|c|c|} \hline ITEMITEM & 2018 & 2019 & 2020 & 2021 & 2022 & 5-YEAR TREND \\ \hline Sales/RevenueSales/Revenue & 130.86B1 & 131.87B1 & 128.29B & 133.61B & B136.84B & \\ \hline SalesGrowthSalesGrowth & & 0.77% & 2.71% & 4.15% & 6. 2.41% & \\ \hline CostofGoodsSold(COGS)incl.D&ACostofGoodsSold(COGS)incl.D&A & 72.61B & 71,418 & 67.92B & 72.518 & 76.23B & \\ \hline COGSGrowthcoGSGrowth & & 1.65% & 4.88% & 6.75% & 5.14% & \\ \hline COGSexcludingD&ACOGSexcludingD&A & 55.21B & 54.73B & 51,2B & 56.3B & 59.13B & \\ \hline Depreciation&AmortizationExpenseDepreciation&AmortizationExpense & 17.4B & 16.68B & 16.72B & 16.21B & 17.18 & \\ \hline DepreciationDepreciation & 15.19B & 14.378 & 14.28B & 14.128 & 14.59B & \\ \hline AmortizationofIntangiblesAmortizationofIntangibles & 2228 & 2.318 & 2.45B & 2.098 & 2.518 & \\ \hline GrossIncomeGrossIncome & 58.268 & 60.468 & 60.37B & 61.11B & 60.68 & \\ \hline GrossIncomeGrowthGrossIncomeGrowth & & 3.79% & 0.15% & 1.22% & 0.82% & \\ \hline GrossProfitMarginGrossProfitMargin & & & & & 44.29% & \\ \hline SGRAExpenseSGRAExpense & 28.25B & 29.438 & 3. 30.58 & 29.14B & 30.14B & \\ \hline SGAGrowthSGAGrowth & & 4.19% & 3.65% & 4.47% & 3,41% & \\ \hline Hesearch8DevelopmentResearch&Development & & & & & & \\ \hline OtherSCNAOther50asA & 28.25B & 29,438 & 30.5B & 29.148 & 30.14B & \\ \hline OtherOperatingExpenseOtherOperatingExpenseIInnasalFumense & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline UnusualExpenseUnusualExpense & 6.55B & 4.12B & 1.3B & 3.75B & 1.11B \\ \hline EBITafterUnusualExpenseEBITafterUnusualExpense & 23.45B & 26.91B & 28.57B & 28.21B & 29.36B \\ \hline NonOperatingIncome/ExpenseNonOperatingIncome/Expense & 888M & 448M & (349M) & 4.51B & 2.3B \\ \hline Non-OperatingInterestIncomeNon-OperatingInterestIncome & 94M & 121M & 65M & 48M & 146M \\ \hline EquityinAffiliates(Pretax)EquityinAffiliates(Pretax) & 21M & (15M) & (45M) & 145M & 44M \\ \hline InterestExpenseInterestExpense & 4.83B & 4.73B & 4.27B & 3.5B & 3.58B \\ \hline InterestExpenseGrowthInterestExpenseGrowth & & 2.13% & 9.64%1 & 18.16% & 2.40% \\ \hline Gross Interest Expense & 5.57B & 5.39B & 4.83B & 5.34B & 5.61B \\ \hline \end{tabular} Cumulative Translation Adjustment/Unrealized For. Exch. Gain Cumulative Translation (600M)(584M)(404M)(545M)(698M) Adjustment/Unrealized For. Exch. Gain Unrealized Gain/Loss Marketable Securities Unrealized Gain/Loss Marketable Securities Revaluation Reserves Revaluation Reserves Treasury Stock Treasury Stock (6.99B)(6.82B)(6.72B)(4.1B)(4.01B) Total Shareholders' Equity Total Shareholders' Equity 53.15B 61.4B67.84B81.79B91.14B Total Shareholders' Equity / Total Assets Total Shareholders' Equity / Total Assets Accumulated Minority Intrest Accumulated Minority Interest Total Equity Total Equity 20.07%21.05%21.44%22.31%24.01% Liabilities \& Shareholders' Equity Liabilities \& Shareholders' Equity 264.83B 291.73B 316.48B 366.6 B 379.68B \begin{tabular}{|c|c|c|c|c|c|c|} \hline ITEMITEM & 2018 & 2019 & 2020 & 2021 & 2022 & 5-YEARTREND \\ \hline \multicolumn{7}{|l|}{TotalAccountsReceivableGrowth} \\ \hline AccountsReceivables,NetAccountsReceivables,Net & 25.1B & 26.28B & 24.65B & 24.59B & 25.16B & \\ \hline AccountsReceivables,GrossAccountsReceivables,Gross & 25.87B & 27.01B & 25.9B & 25.48B & 25.99B & \\ \hline BadDebt/DoubtfulAccountsBadDebt/DoubtfulAccounts & (765M) & (733M) & (1.25B) & (896M) & (826M) & \\ \hline OtherReceivableOtherReceivable & 757M & & & & & \\ \hline AccountsReceivableTurnoverAccountsReceivableTurnover & 5.06 & 5.02 & 5.20 & 5.43 & 5.44 & \\ \hline InventoriesInventories & 1.34B & 1.42B & 1.8B & 3.06B & 2.39B & \\ \hline FinishedGoodsFinishedGoods & 1.34B & 1.42B & 1.8B & 3.06B & 2.39B & \\ \hline WorkinProgressWorkinProgress & & & & . & = & \\ \hline \multicolumn{5}{|l|}{ Raw Materials } & = & \\ \hline \multicolumn{7}{|l|}{ProgressPayments&OtherProgressPayments&Other} \\ \hline OtherCurrentAssetsOtherCurrentAssets & 1.57B & B 3.38B & 2.31B & 2.64B & 3.73B & \\ \hline MiscellaneousCurrentAssetsMiscellaneousCurrentAssets & 1.57B & B 943M & 1.11B & 1.55B & 3.56B & \\ \hline TotalCurrentAssetsTotalCurrentAssets & 32.55B & B 34.9B & 52.12B & 34.3B & 35.238 & \\ \hline NetProperty,Plant&EquipmentNetProperty,Plant&Equipment & 89.29B & B 114.61B & 117.36B1 & 127.58B1 & 133.56B & \\ \hline Property,Plant&Equipment-GrossProperty,Plant&Equipment-Gross & 252.84B & B 288.43B & 302.27B3 & 317.7883 & 333.82B & \\ \hline \end{tabular}

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

Information Technology Security Audit Guidebook NIST SP 800-171

Authors: Mark A Russo CISSP-ISSAP CISO

1st Edition

1726674908, 978-1726674904

More Books

Students also viewed these Accounting questions

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago

Question

c. What were the reasons for their move? Did they come voluntarily?

Answered: 1 week ago

Question

5. How do economic situations affect intergroup relations?

Answered: 1 week ago