Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
a.current ratio
\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 & 200.268 & \\ \hline TotalInvestmentsandAdvancesTotalInvestmentsandAdvances & 1.2B & 1.89B & 3.41B & 2.46B & 1.85B & \\ \hline OtherLong-TermInvestmentsOtherLong-TermInvestments & 532M & 1.33B & 2.828 & 1,4B & 775M & \\ \hline Long-TermNoteReceivablesLong-TermNoteReceivables & 246M & 302M & 204M & 7.6B & 12.11B & \\ \hline IntangibleAssetsIntangibleAssets & 128.52B & 128.95B & 130.28B & 187.9B1 & 189.93B & \\ \hline NetGoodwillNetGoodwill & 24.61B & 24.39B & 24.77B & 28.6B & 28.67B & \\ \hline \end{tabular} \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 & 79.68B \\ \hline TotalAssetsGrowthTotalAssetsGrowth & & 10.16% & 8.49% & 15.84% & 3.57% \\ \hline \end{tabular} Balance Sheet \begin{tabular}{|c|c|c|c|c|c|} \hline EPS (Basic) & & & & & \\ \hline EPS(Basic)GrowthEPS(Basic)Growth & & 23.82% & 7.64% & 23.71% & 64.90% \\ \hline BasicSharesOutstandingBasicSharesOutstanding & 4.13B & 3. 4.14B & 4.14B & 4.15B & 4.2B \\ \hline EPS(Diluted)EPS(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 EBITDAMarginEBIrDAMargin & & & & & \\ \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|}{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 RawMaterialsRawMaterials & & & & & = & \\ \hline \multicolumn{7}{|l|}{ProgressPayments&OtherProgressPayments&Other} \\ \hline OtherCurrentAssetsOtherCurrentAssets & 1.57B & 3.38B & 2.31B & 2.64B & 3.73B & \\ \hline MiscellaneousCurrentAssetsMiscellaneousCurrentAssets & 1.57B & 943M & 1.11B & 1.55B & 3.56B & \\ \hline TotalCurrentAssetsTotalCurrentAssets & 32.55B & 34,9B & 52.12B & 34.3B & 35.23B & \\ \hline NetProperty,Plant&EquipmentNetProperty,Plant&Equipment & 89.29B & 3114.61B & 117.36B & 127.58B1 & 3133.56B & \\ \hline Property,Plant&Equipment-GrossProperty,Plant&Equipment-Gross & 252.848 & B 288.43B & 3302.27B & 317.7883 & 333.82B & \\ \hline \end{tabular} 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.848 & \\ \hline SalesGrowthSalesGrowth & . & 0.77% & 2.71% & 4.15% & 2.41% & \\ \hline CostofGoodsSold(COGS)incl.D&ACostofGoodsSold(COGS)incl.D&A & 72.61B & 71.41B & 67.92B & 72.51B & 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.37B & 14.28B & 14.128 & 14.59B & \\ \hline AmortizationofIntangiblesAmortizationofIntangibles & 2228 & 2.318 & 2.45B & 2.09B & 2.51B & \\ \hline GrossIncomeGrossIncome & 58.268 & 60.468 & 60.37B & 61.11B & 60.68 & \\ \hline GrossIncomeGrowthGrossIncomeGrowth & 2 & 3.79% & .0.15% & 1.22% & 0.82% & \\ \hline GrossProfitMarginGrossProfitMargin & & & & & 44.29% & \\ \hline SGlaAExpenseSGRAExpense & 28.25B & 29.43B & 30.58 & 29.14B & 30.148 & \\ \hline SGAGrowthSGAGrowth & & 4.19% & 3.65% & 4.47% & 3.41% & \\ \hline Research8DevelopmentResearch&Development. & & & & & & \\ \hline OtherSCNAOtherSGSA & 28.25B & 29.43B & 3. 30.5B & 29.148 & 30.148 & \\ \hline OtherOperatingExpenseOtherOperatingExpenseIInusaalFomense & & & & & & \\ \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} \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(CarryingWalue)PreferredStock(CarryingValue)} \\ \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} 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?
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