5. Undertake a DuPont decomposition analysis of ROE for 2020.
6. Say the stock price of the company is $86.50 and there are 5.5 mnillion shares outstanding, find out the following ratiosumbers for 2020: a. Market capitalizations b. Market to book ratio C. P/E ratio.
All numbers are in USD. Income statement Total Revenue Cost of Revenue Gross Profit Selling General and Administrative Operating Income Depreciation and Amortization Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Net Income 2020 65,299,000 32,909,000 32,390,000 18,949,000 13,441,000 507,000 12,934,000 579,000 12,355,000 3,342,000 9,013,000 2019 70,749,000 37,056,000 33,693,000 22,644,000 11,049,000 589,000 10,460,000 626,000 9,834,000 2,725,000 7,109,000 2018 74,401,000 39,030,000 35,371,000 21,461,000 13,910,000 308,000 13,602,000 709,000 12,893,000 2,851,000 10,042,000 Assets Cash and Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets 2020 7,102,000 6,246,000 5,880,000 4,716,000 9,838,000 33,782,000 0 19,385,000 44,350,000 24,527,000 0 5,092,000 0 127,136,000 2019 6,836,000 4,767,000 5,924,000 4,979,000 7,140,000 29,646,000 0 24,859.000 44,622,000 25,010,000 0 5,358,000 2018 8,558,000 2,128,000 7,478,000 6,759,000 6,694,000 31,617,000 0 22,304,000 53,704,000 30,843,000 0 5,798,000 0 144,266,000 129,495,000 2019 2018 Liabilities Accommts Payable Short/Current Long-Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities 2020 16,774,000 11,653,000 2,343,000 30,770,000 18,945,000 10,325,000 9,113,000 642,000 0 69,795,000 16,229,000 12,018,000 1,543,000 29,790,000 18,327,000 9,149,000 9,179,000 631,000 0 67,076,000 17,460,000 15,606,000 660,000 33,726,000 19,811,000 10,535,000 10,218,000 762,000 0 75,052,000 All numbers are in USD. Income statement Total Revenue Cost of Revenue Gross Profit Selling General and Administrative Operating Income Depreciation and Amortization Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Net Income 2020 65,299,000 32,909,000 32,390,000 18,949,000 13,441,000 507,000 12,934,000 579,000 12,355,000 3,342,000 9,013,000 2019 70,749,000 37,056,000 33,693,000 22,644,000 11,049,000 589,000 10,460,000 626,000 9,834,000 2,725,000 7,109,000 2018 74,401,000 39,030,000 35,371,000 21,461,000 13,910,000 308,000 13,602,000 709,000 12,893,000 2,851,000 10,042,000 Assets Cash and Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets 2020 7,102,000 6,246,000 5,880,000 4,716,000 9,838,000 33,782,000 0 19,385,000 44,350,000 24,527,000 0 5,092,000 0 127,136,000 2019 6,836,000 4,767,000 5,924,000 4,979,000 7,140,000 29,646,000 0 24,859.000 44,622,000 25,010,000 0 5,358,000 2018 8,558,000 2,128,000 7,478,000 6,759,000 6,694,000 31,617,000 0 22,304,000 53,704,000 30,843,000 0 5,798,000 0 144,266,000 129,495,000 2019 2018 Liabilities Accommts Payable Short/Current Long-Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities 2020 16,774,000 11,653,000 2,343,000 30,770,000 18,945,000 10,325,000 9,113,000 642,000 0 69,795,000 16,229,000 12,018,000 1,543,000 29,790,000 18,327,000 9,149,000 9,179,000 631,000 0 67,076,000 17,460,000 15,606,000 660,000 33,726,000 19,811,000 10,535,000 10,218,000 762,000 0 75,052,000
