Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate accurate financial ratios to assess the businesss current financial health. ( The professor did not give further instructions but I need help filling out
Calculate accurate financial ratios to assess the businesss current financial health. ( The professor did not give further instructions but I need help filling out the charts based on using the information provided from mergent online).
I need calculated the Future Value of Lump Sum, the Present Value of Lump Sum, the Future Value Annuity, and the Present Value Annuity, using the mergent online information. No further instructions was included and that is where I am stuck.
Time Value of Money - Future Value of Lump Sum Rate Years $0.00 Initial Investment Time Value of Money - Present Value of Lump Sum Rate Years $0.00 Initial Investment Time Value of Money - Future Value Annuity Number of Years Rate of Return $0.00 Payment Time Value of Money - Present Value Annuity Number of Years Rate of Return $0.00 Payment Standardized Annual Cash Flows Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated Yes 7.545,200,000 > Net Income Adjustments from Inc to Cash 1,142,100,000 Change in Working Capital 454,200,000 > 9,141,500,000 > (2.040,000,000)> Cash Flow from Operations Purchase of Pty Plant & Equip Proceeds from Pty Plant & Equip Change in Business Activities 106,200,000 > (178,000,000)> Other Investing Cash Flows (53,900,000) Cash Flow from Investing (2,165,700,000) Change in ST Debt 15,100,000 Change in LT Debt (1,085,600,000) Change in Equity (559,800,000) Payment of Dividends (3.918,000,000) Other Financing Cash Flows (46.700,000) Cash Flow from Financing (5.595,600,000) Effect of Exchange Rate (120,100,000) Change in Cash 1,260,100,000 > Opening Cash 3,440,100,000 > Closing Cash 4,700,200,000 Depo & Amorth (CF) 1.868,100,000 Net Purch of Pty Plant & Equip (1.933,000,000) 12/31/2020 USD Not Qualified 0 Yes 4,730,500,000 > 1,746,800,000 > (212,100,000) 6,255,200,000 > (1,640,800,000) 27,400,000 > 10,200,000 57,400,000 > 12/31/2019 USD Not Qualified O Yes 6,025,400,000 > 1,798,200,000 > 298,500,000 > 8,122,100,000 > (2,393,700,000)> 151,200,000 > (200,100.000)> (628,500,000)> (3,071,100.000) (1,545,600.000) (893,100,000)> 3,131,300,000 > 2.437,100,000 (612,300,000) (4,625,700,000)> (3,752,900,000)> (3.581.900.000)> (122,000,000)> (23,500,000) (2.249,000,000) (4,994,800.000) 80,200,000 2,550,600,000 808,500,000 3,449,100,000 1,751,400,000 (1,613.400.000) 799,200,000 > (23,700,000)> 32,500,000 > 806,000,000 > 898,500,000 1,617,900,000 (2,242,500,000) 12/31/2018 USD Not Qualified O Yes 5,924,300,000 > 1,515,100,000 > (472,700.000) 6.966,700,000 > (2,741,700,000)> 160,400,000 > 429,100,000 > (302,900,000)> (2.455.100.000)> 95,900,000 > 2,034,900,000 > (4,804,500,000)> (3,255,900,000)> (20,000,000)> (5,949,600,000) (159.800.000) (1,597,800,000)> 2,463,800,000 > 866,000,000 > 1,482,000,000 > (2.581.300.000)> 12/31/2017 USD Not Qualified O Yes 5,192,300,000 >> 1,339,400,000 > (980,500,000)> 5.551,200,000 > (1,853,700,000)> 166,800,000 > 2,494,800,000 > (245,900,000)> 562,000,000 > (1.050,300,000)> 3,075,100,000 > (4.228.900,000)> (3.089.200,000) (20,500,000)> (5.310,000,000)> 264,000,000 > 1,066,400,000 > 1,223,400,000 > 1,363,400,000 (1,686,900,000) As Reported Currency No Scale Exchange rate used is that of the Year End reported date Standardized Annual Income Statement Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated Yes 9,787,400,000 > 13,435,500,000 > 23,222,900,000 > 8,307,700,000 > 14,915,200,000 > 4,712,800,000 > 329,700,000 > (285,400,000)> 75,400,000 > 4,832,500,000 > 10.082,700,000 > (1.185.800.000)> 96,600,000 > (42,300,000)> (1.131,500,000)> 8,951,200,000 > 1,582,700,000 > 176,700,000 > 0> 7,545,200,000 > 0> 7,545,200,000 > 746,300,000 > 10.11 > 10.11 >> 751,800,000 > 10.04 > 10.04 >> 744,800,000 > Sales Revenue Other Revenue Total Revenue Direct Costs Gross Profit Selling General & Admin Depreciation & Amortization Restruct Remediation & Impair Other Operating Expense Total Indirect Operating Costs Operating Income Interest Income Gains on Sale of Assets Other Non-Operating Income Total Non-Operating Income Earnings Before Tax Taxation Equity Earnings Extraordinary Items Accounting Changes Net Income Preference Dividends & Similar Net Income to Common Average Shares Basic EPS Net Basic EPS Continuing Basic Average Shares Diluted EPS Net Diluted EPS Continuing Diluted Shares Outstanding Refresh 12/31/2020 USD Not Qualified Yes 8,139,200,000 > 11.068,600,000 > 19,207,800,000 > 7,248,200,000 > 11,959,600,000 > 4,452,500,000 > 300,600,000 > (267,500,000)> 290,700,000 > 4,776,300,000 > 7.183,300,000 > (1.218,100.000)> 23,300,000 > 34,800,000 > (1,160,000,000)> 6,023,300,000 > 1,410,200,000 > 117,400,000 > 0> 4,730,500,000 > 0> 4,730,500,000 > 744,600,000 > 6.35 > 6.35 750,100,000 > 6.31 6.31 745,400,000 > 12/31/2019 USD Not Qualified Yos 9,420,800,000 > 11,655,700,000 > 21,076,500,000 > 7,760,600,000 > 13,315,900,000 > 4,430,000,000 > 74,300,000 > 23,100,000 > 4,527,400,000 > 8.788,500,000 > (1.121,900,000)> 127,500,000 > 70,200,000 > (924,200,000)> 7,864,300,000 > 1,992,700,000 > 153,800,000 > 0> 6,025,400,000 > 0> 6,025,400,000 > 758,100,000 > 7.95 >> 7.95 >> 764,900,000 > 7.88 >> 7.88 >> 746,300,000 > 12/31/2018 USD Not Qualified Yes 10,012,700,000 > 11,012,500,000 > 21,025,200,000 > 8,265,900,000 > 12,759,300,000 > 4,173,500,000 > 231,700,000 > (12.900.000)> 4.392,300,000 > 8.367,000,000 > (981,200.000)> 304,100,000 > (25,300,000)> (702,400,000)> 7,664,600,000 > 1,891,800,000 > 151,500,000 > 0> 5,924,300,000 > 5,924,300,000 > 778,200,000 > 7.61 >> 7.61 > 785,600,000 > 7.54> 7.54> 767,100,000 > 12/31/2017 USD Not Qualified Yes 12,718,900,000 > 10.101,500,000 > 22.820,400,000 > 10.409,600,000 > 12,410,800,000 > 4,021,300,000 > (702,800,000)> 18,700,000 > 3,337,200,000 > 9.073,600,000 > (921,300,000)> 295,400,000 > (57,900,000)> (683,800,000)> 8,389,800,000 > 3,381,200,000 > 183,700,000 > 5,192,300,000 > 5,192,300,000 > 807,400,000 > 6.43 >> 6.43 >> 815,500,000 > 6.37 >> 6.37> 794,100,000 > Exchange rate used is that of the Year End reported date Standardized Annual Balance Sheet Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated You Cash & Equivalents 4,709,200,000 > Cash & Equivs & ST Investments 4,709,200.000 >> Receivables (ST) 1,872,400,000 > Inventories Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Long Term Investments 55,600,000 > 511,300,000 > 7.148,500,000 > 41,916,600,000 > 17,196,000,000 > 24,720,600,000 > 1,201,200,000 > 2,782,500,000 > 18,001,500,000 > Intangible Assets Other Assets Total Assets 53,854,300.000 Accounts Payable & Accrued Exps 1,606,800,000 > Accounts Payable 1,000,000,000 > Accrued Expenses 600,000,000 > Current Debt Other Current Liabilities 2,413,200,000 > Total Current Liabilities 4,020,000,000 > LT Debt & Leases 35,622,700,000 > Deferred LT Liabilities 2,813,900,000 > Minority Interests 0x Other Liabilities 15,998,700,000 > Total Liabilities 58,455,300.000 Common Share Capital 16,600,000 > Additional Paid-In Capital 8.231,600,000 > Retained Earnings 57,534,700.000 > Accum Other Comprehensive Income (2,573,700,000)> Treasury Stock 67,810.200.000 > Other Equity Total Equity (4,601,000,000)> Total Liabilities & Equity 53,854,300,000 > 12/31/2020 USD Not Qualified O Yos 3,449,100,000 > 3,449,100,000 > 2,110,300,000 > 51,100,000 > 632,700,000 > 6,243,200,000 > 41,476,500,000 > 16,518,300,000 > 24,958,200,000 > 1,297,200,000 > 2,773,100,000 > 17,355,100,000 > 52.626,800,000 > 1,356,700,000 > 741,300,000 > 615,400,000 > 2.243,600,000 > 2,580,900,000 > 6,181,200,000 > 35,196,800,000 > 2.727,600,000 > 16,346,100,000 > 60.451,700,000 > 16,600,000 > 7,903,600,000 > 53.908,100,000 > (2,586,800,000)> 67,066,400,000 > (7.824,900.000) 52.626,600,000 > 12/31/2019 USD Not Qualified O Yes 898,500,000 > 898,500,000 > 2.224,200,000 > 50,200,000 > 385,000,000 > 3.557,900,000 > 39,050,900,000 > 14,890,900,000 > 24,160,000,000 > 1,270,300,000 > 2.677,400,000 > 15.845,200,000 > 47.510,800,000 > 1,573,500,000 > 988,200,000 > 585,300,000 > 59,100,000 > 1,988,400,000 > 3,621,000,000 > 34,118,100,000 > 1,978,700,000 > 16,003,300,000 > 55.721,100,000 > 16,600,000 > 7,653,900,000 > 52.930,500,000 > (2.482,700,000)> 66,328,600,000 > (8.210,300,000)> 47.510,800,000 > 12/31/2018 USD Not Qualified Yes 866,000,000 > 866,000,000 > 2,441,500,000 > 51,100,000 > 694,600,000 > 4,053,200,000 >> 37.193,600,000 > 14.350,900,000 > 22.842,700,000 > 1,202,800,000 > 2,331,500,000 > 2,381,000,000 > 32,811,200,000 > 1,758,600,000 > 1,207,900,000 > 550,700,000 > 1,214,900,000 > 2.973,500,000 > 31,075,300,000 > 1,843,300,000 > 0> 3,177,500,000 > 39,069,600,000 16,600,000 > 7,376,000,000 > 50,487,000,000 > (2.609,500,000)> 61,528,500,000 > (6.258,400.000)> 32,811,200,000 > 12/31/2017 USD Not Qualified O Yes 2,463,800,000 > 2.463.800,000 > 1,976,200,000 > 58,800,000 > 828,400,000 > 5,327,200,000 > 36,626,400,000 > 14,178,100,000 > 22,448,300,000 > 1,085,700,000 > 2,379,700,000 > 2.562.800,000 > 33,803,700,000 > 1,478,600,000 > 924,800.000> 553,800,000 > 1,412,000,000 > 2.890,600,000 > 29,536,400,000 > 1,119,400,000 > 3.525,300,000 > 37,071,700,000 16,600,000 > 7,072,400,000 > 48,325,800,000 > (2,178,400,000)> 56,504,400,000 > (3,268,000,000)> 33.803,700,000 > Time Value of Money - Future Value of Lump Sum Rate Years $0.00 Initial Investment Time Value of Money - Present Value of Lump Sum Rate Years $0.00 Initial Investment Time Value of Money - Future Value Annuity Number of Years Rate of Return $0.00 Payment Time Value of Money - Present Value Annuity Number of Years Rate of Return $0.00 Payment Standardized Annual Cash Flows Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated Yes 7.545,200,000 > Net Income Adjustments from Inc to Cash 1,142,100,000 Change in Working Capital 454,200,000 > 9,141,500,000 > (2.040,000,000)> Cash Flow from Operations Purchase of Pty Plant & Equip Proceeds from Pty Plant & Equip Change in Business Activities 106,200,000 > (178,000,000)> Other Investing Cash Flows (53,900,000) Cash Flow from Investing (2,165,700,000) Change in ST Debt 15,100,000 Change in LT Debt (1,085,600,000) Change in Equity (559,800,000) Payment of Dividends (3.918,000,000) Other Financing Cash Flows (46.700,000) Cash Flow from Financing (5.595,600,000) Effect of Exchange Rate (120,100,000) Change in Cash 1,260,100,000 > Opening Cash 3,440,100,000 > Closing Cash 4,700,200,000 Depo & Amorth (CF) 1.868,100,000 Net Purch of Pty Plant & Equip (1.933,000,000) 12/31/2020 USD Not Qualified 0 Yes 4,730,500,000 > 1,746,800,000 > (212,100,000) 6,255,200,000 > (1,640,800,000) 27,400,000 > 10,200,000 57,400,000 > 12/31/2019 USD Not Qualified O Yes 6,025,400,000 > 1,798,200,000 > 298,500,000 > 8,122,100,000 > (2,393,700,000)> 151,200,000 > (200,100.000)> (628,500,000)> (3,071,100.000) (1,545,600.000) (893,100,000)> 3,131,300,000 > 2.437,100,000 (612,300,000) (4,625,700,000)> (3,752,900,000)> (3.581.900.000)> (122,000,000)> (23,500,000) (2.249,000,000) (4,994,800.000) 80,200,000 2,550,600,000 808,500,000 3,449,100,000 1,751,400,000 (1,613.400.000) 799,200,000 > (23,700,000)> 32,500,000 > 806,000,000 > 898,500,000 1,617,900,000 (2,242,500,000) 12/31/2018 USD Not Qualified O Yes 5,924,300,000 > 1,515,100,000 > (472,700.000) 6.966,700,000 > (2,741,700,000)> 160,400,000 > 429,100,000 > (302,900,000)> (2.455.100.000)> 95,900,000 > 2,034,900,000 > (4,804,500,000)> (3,255,900,000)> (20,000,000)> (5,949,600,000) (159.800.000) (1,597,800,000)> 2,463,800,000 > 866,000,000 > 1,482,000,000 > (2.581.300.000)> 12/31/2017 USD Not Qualified O Yes 5,192,300,000 >> 1,339,400,000 > (980,500,000)> 5.551,200,000 > (1,853,700,000)> 166,800,000 > 2,494,800,000 > (245,900,000)> 562,000,000 > (1.050,300,000)> 3,075,100,000 > (4.228.900,000)> (3.089.200,000) (20,500,000)> (5.310,000,000)> 264,000,000 > 1,066,400,000 > 1,223,400,000 > 1,363,400,000 (1,686,900,000) As Reported Currency No Scale Exchange rate used is that of the Year End reported date Standardized Annual Income Statement Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated Yes 9,787,400,000 > 13,435,500,000 > 23,222,900,000 > 8,307,700,000 > 14,915,200,000 > 4,712,800,000 > 329,700,000 > (285,400,000)> 75,400,000 > 4,832,500,000 > 10.082,700,000 > (1.185.800.000)> 96,600,000 > (42,300,000)> (1.131,500,000)> 8,951,200,000 > 1,582,700,000 > 176,700,000 > 0> 7,545,200,000 > 0> 7,545,200,000 > 746,300,000 > 10.11 > 10.11 >> 751,800,000 > 10.04 > 10.04 >> 744,800,000 > Sales Revenue Other Revenue Total Revenue Direct Costs Gross Profit Selling General & Admin Depreciation & Amortization Restruct Remediation & Impair Other Operating Expense Total Indirect Operating Costs Operating Income Interest Income Gains on Sale of Assets Other Non-Operating Income Total Non-Operating Income Earnings Before Tax Taxation Equity Earnings Extraordinary Items Accounting Changes Net Income Preference Dividends & Similar Net Income to Common Average Shares Basic EPS Net Basic EPS Continuing Basic Average Shares Diluted EPS Net Diluted EPS Continuing Diluted Shares Outstanding Refresh 12/31/2020 USD Not Qualified Yes 8,139,200,000 > 11.068,600,000 > 19,207,800,000 > 7,248,200,000 > 11,959,600,000 > 4,452,500,000 > 300,600,000 > (267,500,000)> 290,700,000 > 4,776,300,000 > 7.183,300,000 > (1.218,100.000)> 23,300,000 > 34,800,000 > (1,160,000,000)> 6,023,300,000 > 1,410,200,000 > 117,400,000 > 0> 4,730,500,000 > 0> 4,730,500,000 > 744,600,000 > 6.35 > 6.35 750,100,000 > 6.31 6.31 745,400,000 > 12/31/2019 USD Not Qualified Yos 9,420,800,000 > 11,655,700,000 > 21,076,500,000 > 7,760,600,000 > 13,315,900,000 > 4,430,000,000 > 74,300,000 > 23,100,000 > 4,527,400,000 > 8.788,500,000 > (1.121,900,000)> 127,500,000 > 70,200,000 > (924,200,000)> 7,864,300,000 > 1,992,700,000 > 153,800,000 > 0> 6,025,400,000 > 0> 6,025,400,000 > 758,100,000 > 7.95 >> 7.95 >> 764,900,000 > 7.88 >> 7.88 >> 746,300,000 > 12/31/2018 USD Not Qualified Yes 10,012,700,000 > 11,012,500,000 > 21,025,200,000 > 8,265,900,000 > 12,759,300,000 > 4,173,500,000 > 231,700,000 > (12.900.000)> 4.392,300,000 > 8.367,000,000 > (981,200.000)> 304,100,000 > (25,300,000)> (702,400,000)> 7,664,600,000 > 1,891,800,000 > 151,500,000 > 0> 5,924,300,000 > 5,924,300,000 > 778,200,000 > 7.61 >> 7.61 > 785,600,000 > 7.54> 7.54> 767,100,000 > 12/31/2017 USD Not Qualified Yes 12,718,900,000 > 10.101,500,000 > 22.820,400,000 > 10.409,600,000 > 12,410,800,000 > 4,021,300,000 > (702,800,000)> 18,700,000 > 3,337,200,000 > 9.073,600,000 > (921,300,000)> 295,400,000 > (57,900,000)> (683,800,000)> 8,389,800,000 > 3,381,200,000 > 183,700,000 > 5,192,300,000 > 5,192,300,000 > 807,400,000 > 6.43 >> 6.43 >> 815,500,000 > 6.37 >> 6.37> 794,100,000 > Exchange rate used is that of the Year End reported date Standardized Annual Balance Sheet Report Date 12/31/2021 Currency USD Audit Status Not Qualified O Consolidated You Cash & Equivalents 4,709,200,000 > Cash & Equivs & ST Investments 4,709,200.000 >> Receivables (ST) 1,872,400,000 > Inventories Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Long Term Investments 55,600,000 > 511,300,000 > 7.148,500,000 > 41,916,600,000 > 17,196,000,000 > 24,720,600,000 > 1,201,200,000 > 2,782,500,000 > 18,001,500,000 > Intangible Assets Other Assets Total Assets 53,854,300.000 Accounts Payable & Accrued Exps 1,606,800,000 > Accounts Payable 1,000,000,000 > Accrued Expenses 600,000,000 > Current Debt Other Current Liabilities 2,413,200,000 > Total Current Liabilities 4,020,000,000 > LT Debt & Leases 35,622,700,000 > Deferred LT Liabilities 2,813,900,000 > Minority Interests 0x Other Liabilities 15,998,700,000 > Total Liabilities 58,455,300.000 Common Share Capital 16,600,000 > Additional Paid-In Capital 8.231,600,000 > Retained Earnings 57,534,700.000 > Accum Other Comprehensive Income (2,573,700,000)> Treasury Stock 67,810.200.000 > Other Equity Total Equity (4,601,000,000)> Total Liabilities & Equity 53,854,300,000 > 12/31/2020 USD Not Qualified O Yos 3,449,100,000 > 3,449,100,000 > 2,110,300,000 > 51,100,000 > 632,700,000 > 6,243,200,000 > 41,476,500,000 > 16,518,300,000 > 24,958,200,000 > 1,297,200,000 > 2,773,100,000 > 17,355,100,000 > 52.626,800,000 > 1,356,700,000 > 741,300,000 > 615,400,000 > 2.243,600,000 > 2,580,900,000 > 6,181,200,000 > 35,196,800,000 > 2.727,600,000 > 16,346,100,000 > 60.451,700,000 > 16,600,000 > 7,903,600,000 > 53.908,100,000 > (2,586,800,000)> 67,066,400,000 > (7.824,900.000) 52.626,600,000 > 12/31/2019 USD Not Qualified O Yes 898,500,000 > 898,500,000 > 2.224,200,000 > 50,200,000 > 385,000,000 > 3.557,900,000 > 39,050,900,000 > 14,890,900,000 > 24,160,000,000 > 1,270,300,000 > 2.677,400,000 > 15.845,200,000 > 47.510,800,000 > 1,573,500,000 > 988,200,000 > 585,300,000 > 59,100,000 > 1,988,400,000 > 3,621,000,000 > 34,118,100,000 > 1,978,700,000 > 16,003,300,000 > 55.721,100,000 > 16,600,000 > 7,653,900,000 > 52.930,500,000 > (2.482,700,000)> 66,328,600,000 > (8.210,300,000)> 47.510,800,000 > 12/31/2018 USD Not Qualified Yes 866,000,000 > 866,000,000 > 2,441,500,000 > 51,100,000 > 694,600,000 > 4,053,200,000 >> 37.193,600,000 > 14.350,900,000 > 22.842,700,000 > 1,202,800,000 > 2,331,500,000 > 2,381,000,000 > 32,811,200,000 > 1,758,600,000 > 1,207,900,000 > 550,700,000 > 1,214,900,000 > 2.973,500,000 > 31,075,300,000 > 1,843,300,000 > 0> 3,177,500,000 > 39,069,600,000 16,600,000 > 7,376,000,000 > 50,487,000,000 > (2.609,500,000)> 61,528,500,000 > (6.258,400.000)> 32,811,200,000 > 12/31/2017 USD Not Qualified O Yes 2,463,800,000 > 2.463.800,000 > 1,976,200,000 > 58,800,000 > 828,400,000 > 5,327,200,000 > 36,626,400,000 > 14,178,100,000 > 22,448,300,000 > 1,085,700,000 > 2,379,700,000 > 2.562.800,000 > 33,803,700,000 > 1,478,600,000 > 924,800.000> 553,800,000 > 1,412,000,000 > 2.890,600,000 > 29,536,400,000 > 1,119,400,000 > 3.525,300,000 > 37,071,700,000 16,600,000 > 7,072,400,000 > 48,325,800,000 > (2,178,400,000)> 56,504,400,000 > (3,268,000,000)> 33.803,700,000 > 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