Please asnwer all the questions and use the excel
The price per share for the company is 26.75, there are 43.22 MM shares outstanding, and the market cap is 1120,32MM.
Prepare a common size income statement and a common size balance sheet for the three years and answer to the following questions:
1.- How is the development of the sales of the company in the period?
2.- What is the development of the margin?
3.- What is the development of the fixed costs?
4.- Make your comments and explain numerically the development of the following items:
a) Total Assets
b) Total Liabilities
c) Stockholders Equity
d) Retained earnings
e) Explain what the situation of the company in terms of liquidity is.
f) What is the working capital of the company, is it adequate for the business of the company?
g) Comment on the leverage of the company and give an explanation based on calculations.
h) Comment on days of accounts receivable, days of inventory and days of accounts payable.
i) What is the Return on sales, return on Equity and Return on Assets, comment on the profitability development of the company.
j) What is the EPS for the three periods.
k) What is the PE ratio of the company for the three periods.
Total Assets Total Current Assets Cash, Cash Equivalents and Short Term Investments Cash and Cash Equivalents Cash Restricted or Pledged, Current Inventories Raw Materials, Consumables and Supplies Work-in-Process Finished Goods and Merchandise Inventory Allowance/Adjustments Trade and Other Receivables, Current Trade/Accounts Receivable, Current Gross Trade/Accounts Receivable, Current Allowance/Adjustments for Trade/Accounts Receivable, Current Other Current Assets Deferred Tax Assets, Current Assets Held for Sale/Discontinued Operations, Current Total Non-Current Assets Net Property, Plant and Equipment Gross Property, Plant and Equipment Properties Land and Improvements Buildings and Improvements Machinery, Furniture and Equipment Plant and Machinery Furniture, Fixtures and Office Equipment Flight, Fleet, Vehicle and Related Equipment Construction in Progress and Advance Payments Leased Property, Plant and Equipment Accumulated Depreciation and Impairment Accumulated Depreciation Net Intangible Assets Gross Goodwill and Other Intangible Assets Goodwill Intangibles other than Goodwill Trademarks and Patents Licenses and Rights Other Intangible Assets Deferred Tax Assets, Non-Current Other Non-Current Assets Total Current Liabilities Payables and Accrued Expenses, Current Trade and Other Payables, Current Trade/Accounts Payable, Current Accrued Expenses, Current Financial Liabilities, Current Current Debt and Capital Lease Obligation Current Debt Bank/Credit Facilities, Current Debt Current Portion of Long Term Debt and Capital Lease Capital Lease Obligations, Current Current Portion of Long Term Debt Deferred Liabilities, Current Deferred Income/Customer Advances/Billings in Excess of Cost, Current Other Current Liabilities Liabilities Held for Sale/Discontinued Operations, Current Total Non-Current Liabilities Financial Liabilities, Non-Current Long Term Debt and Capital Lease Obligation Capital Lease Obligations, Non-Current Long Term Debt Other Non-Current Liabilities Total Equity Equity Attributable to Parent Stockholders Paid in Capital Capital Stock Common Stock Preferred Stock Additional Paid in Capital/Share Premium Retained Earnings/Accumulated Deficit Reserves/Accumulated Comprehensive Income/Losses Non-Controlling/Minority Interests Total Liabilities 2019 2020 2021 1,059,790,000 1,434,889,000 1,786,322,000 541,118,000 626,326,000 926,160,000 129,819,000 261,553,000 391,213,000 129,819,000 261,553,000 391,213,000 1,968,000 1,975,000 3,490,000 196,899,000 181,643,000 226,137,000 90,359,000 92,174,000 112,371,000 13,728,000 14,064,000 24,791,000 114,478,000 96,850,000 121,182,000 -21,666,000 -21,445,000 -32,207,000 143,288,000 99,351,000 139,341,000 143,288,000 99,351,000 139,341,000 145,468,000 106,892,000 143,352,000 -4,011,000 -2,180,000 -7,541,000 69,144,000 81,804,000 165,979,000 518,672,000 808,563,000 860,162,000 200,523,000 533,414,000 562,994,000 547,588,000 897,070,000 938,847,000 255,282,000 264,726,000 270,635,000 31,777,000 31,663,000 36,260,000 223,505,000 233,063,000 234,375,000 271,584,000 285,463,000 299,564,000 148,760,000 155,776,000 167,577,000 109,226,000 114,595,000 116,615,000 13,598,000 15,092,000 15,372,000 20,722,000 28,234,000 24,848,000 318,647,000 343,800,000 -347,065,000 -363,656,000 -375,853,000 -347,065,000 -363,656,000 -375,853,000 215,774,000 189,670,000 206,245,000 215,774,000 189,670,000 206,245,000 185,867,000 161,017,000 175,814,000 29,907,000 28,653,000 30,431,000 6,956,000 5,360,000 20,117,000 19,996,000 22,507,000 6,158,000 2,834,000 2,499,000 2,564,000 20,670,000 20,839,000 11,915,000 81,705,000 64,640,000 79,008,000 362,814,000 718,583,000 1,004, 176,000 238,636,000 350,169,000 611,670,000 171,145,000 132,631,000 104,755,000 65,365,000 55,511,000 94,152,000 65,365,000 55,511,000 94,152,000 67,266,000 49,244,000 76,993,000 180,000 139,376,000 67,614,000 180,000 139,376,000 67,614,000 75,000,000 0 75,000,000 0 180,000 64,376,000 67,614,000 180,000 64,376,000 67,614,000 0 59,825,000 57,807,000 289,226,000 59,825,000 57,807,000 289,226,000 46,000,000 48,231,000 83,685,000 124,178,000 368,414,000 392,506,000 19,000 270,162,000 295,023,000 270,162,000 295,023,000 19,000 19,000 270,162,000 295,023,000 0 124,159,000 98,252,000 97,483,000 696,976,000 716,306,000 782,146,000 682,508,000 700,753,000 773,498,000 360,123,000 364,072,000 376,009,000 360,123,000 364,072,000 376,009,000 46,955,000 45,857,000 45,361,000 0 0 0 313,168,000 318,215,000 330,648,000 325,847,000 343,633,000 399,010,000 -3,462,000 -6,952,000 -1,521,000 14,468,000 15,553,000 8,648,000 Gross Profit Total Revenue Business Revenue Cost of Goods and Services Other Cost of Revenue Operating Income/Expenses Selling, General and Administrative Expenses Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Interest Income Irregular Income/Expenses Goodwill Impairment/Write Off Other Irregular Income/Expenses Restructuring and Reorganization Income/Expense Impairment/Write Off/Write Down of Capital Assets Other Income/Expense, Non-Operating Pretax Income Provision for Income Tax Net Income from Continuing Operations Net Income after Extraordinary Items and Discontinued O Non-Controlling/Minority Interests Net Income after Non-Controlling/Minority Interests Preferred/Other Stock Distribution Other Distributions Net Income Available to Common Stockholders Diluted Net Income Available to Common Stockholders Cost of Revenue 2019 2020 2021 702,570,000 721,445,000 740,260,000 1,745,401,000 1,703,982,000 1,734,244,000 1,745,401,000 1,703,982,000 1,734,244,000 -1,042,831,000 -982,537,000 -993,984,000 -1,042,831,000 -982,537,000 -993,984,000 -572,896,000 -575,821,000 -603,524,000 -572,896,000 -575,821,000 -603,524,000 129,674,000 145,624,000 136,736,000 -34,347,000 -30,451,000 9,177,000 561,000 1,494,000 -289,000 561,000 1,494,000 -289,000 -1,542,000 -1,291,000 -1,390,000 2,103,000 2,785,000 1,101,000 -32,671,000 -24,962,000 0 -26,862,000 0 -32,671,000 1,900,000 0 -2,237,000 -6,983,000 9,466,000 95,327,000 115,173,000 145,913,000 -25,186,000 -36,189,000 -38,384,000 70,141,000 78,984,000 107,529,000 70,141,000 78,984,000 107,529,000 -1,567,000 -1,515,000 -1,068,000 68,574,000 77,469,000 106,461,000 -225,000 -117,000 -46,000 -225,000 -117,000 -46,000 68,349,000 77,352,000 106,415,000 68,349,000 77,352,000 106,415,000 Total Assets Total Current Assets Cash, Cash Equivalents and Short Term Investments Cash and Cash Equivalents Cash Restricted or Pledged, Current Inventories Raw Materials, Consumables and Supplies Work-in-Process Finished Goods and Merchandise Inventory Allowance/Adjustments Trade and Other Receivables, Current Trade/Accounts Receivable, Current Gross Trade/Accounts Receivable, Current Allowance/Adjustments for Trade/Accounts Receivable, Current Other Current Assets Deferred Tax Assets, Current Assets Held for Sale/Discontinued Operations, Current Total Non-Current Assets Net Property, Plant and Equipment Gross Property, Plant and Equipment Properties Land and Improvements Buildings and Improvements Machinery, Furniture and Equipment Plant and Machinery Furniture, Fixtures and Office Equipment Flight, Fleet, Vehicle and Related Equipment Construction in Progress and Advance Payments Leased Property, Plant and Equipment Accumulated Depreciation and Impairment Accumulated Depreciation Net Intangible Assets Gross Goodwill and Other Intangible Assets Goodwill Intangibles other than Goodwill Trademarks and Patents Licenses and Rights Other Intangible Assets Deferred Tax Assets, Non-Current Other Non-Current Assets Total Current Liabilities Payables and Accrued Expenses, Current Trade and Other Payables, Current Trade/Accounts Payable, Current Accrued Expenses, Current Financial Liabilities, Current Current Debt and Capital Lease Obligation Current Debt Bank/Credit Facilities, Current Debt Current Portion of Long Term Debt and Capital Lease Capital Lease Obligations, Current Current Portion of Long Term Debt Deferred Liabilities, Current Deferred Income/Customer Advances/Billings in Excess of Cost, Current Other Current Liabilities Liabilities Held for Sale/Discontinued Operations, Current Total Non-Current Liabilities Financial Liabilities, Non-Current Long Term Debt and Capital Lease Obligation Capital Lease Obligations, Non-Current Long Term Debt Other Non-Current Liabilities Total Equity Equity Attributable to Parent Stockholders Paid in Capital Capital Stock Common Stock Preferred Stock Additional Paid in Capital/Share Premium Retained Earnings/Accumulated Deficit Reserves/Accumulated Comprehensive Income/Losses Non-Controlling/Minority Interests Total Liabilities 2019 2020 2021 1,059,790,000 1,434,889,000 1,786,322,000 541,118,000 626,326,000 926,160,000 129,819,000 261,553,000 391,213,000 129,819,000 261,553,000 391,213,000 1,968,000 1,975,000 3,490,000 196,899,000 181,643,000 226,137,000 90,359,000 92,174,000 112,371,000 13,728,000 14,064,000 24,791,000 114,478,000 96,850,000 121,182,000 -21,666,000 -21,445,000 -32,207,000 143,288,000 99,351,000 139,341,000 143,288,000 99,351,000 139,341,000 145,468,000 106,892,000 143,352,000 -4,011,000 -2,180,000 -7,541,000 69,144,000 81,804,000 165,979,000 518,672,000 808,563,000 860,162,000 200,523,000 533,414,000 562,994,000 547,588,000 897,070,000 938,847,000 255,282,000 264,726,000 270,635,000 31,777,000 31,663,000 36,260,000 223,505,000 233,063,000 234,375,000 271,584,000 285,463,000 299,564,000 148,760,000 155,776,000 167,577,000 109,226,000 114,595,000 116,615,000 13,598,000 15,092,000 15,372,000 20,722,000 28,234,000 24,848,000 318,647,000 343,800,000 -347,065,000 -363,656,000 -375,853,000 -347,065,000 -363,656,000 -375,853,000 215,774,000 189,670,000 206,245,000 215,774,000 189,670,000 206,245,000 185,867,000 161,017,000 175,814,000 29,907,000 28,653,000 30,431,000 6,956,000 5,360,000 20,117,000 19,996,000 22,507,000 6,158,000 2,834,000 2,499,000 2,564,000 20,670,000 20,839,000 11,915,000 81,705,000 64,640,000 79,008,000 362,814,000 718,583,000 1,004, 176,000 238,636,000 350,169,000 611,670,000 171,145,000 132,631,000 104,755,000 65,365,000 55,511,000 94,152,000 65,365,000 55,511,000 94,152,000 67,266,000 49,244,000 76,993,000 180,000 139,376,000 67,614,000 180,000 139,376,000 67,614,000 75,000,000 0 75,000,000 0 180,000 64,376,000 67,614,000 180,000 64,376,000 67,614,000 0 59,825,000 57,807,000 289,226,000 59,825,000 57,807,000 289,226,000 46,000,000 48,231,000 83,685,000 124,178,000 368,414,000 392,506,000 19,000 270,162,000 295,023,000 270,162,000 295,023,000 19,000 19,000 270,162,000 295,023,000 0 124,159,000 98,252,000 97,483,000 696,976,000 716,306,000 782,146,000 682,508,000 700,753,000 773,498,000 360,123,000 364,072,000 376,009,000 360,123,000 364,072,000 376,009,000 46,955,000 45,857,000 45,361,000 0 0 0 313,168,000 318,215,000 330,648,000 325,847,000 343,633,000 399,010,000 -3,462,000 -6,952,000 -1,521,000 14,468,000 15,553,000 8,648,000 Gross Profit Total Revenue Business Revenue Cost of Goods and Services Other Cost of Revenue Operating Income/Expenses Selling, General and Administrative Expenses Total Operating Profit/Loss Non-Operating Income/Expenses, Total Total Net Finance Income/Expense Net Interest Income/Expense Interest Expense Net of Capitalized Interest Interest Income Irregular Income/Expenses Goodwill Impairment/Write Off Other Irregular Income/Expenses Restructuring and Reorganization Income/Expense Impairment/Write Off/Write Down of Capital Assets Other Income/Expense, Non-Operating Pretax Income Provision for Income Tax Net Income from Continuing Operations Net Income after Extraordinary Items and Discontinued O Non-Controlling/Minority Interests Net Income after Non-Controlling/Minority Interests Preferred/Other Stock Distribution Other Distributions Net Income Available to Common Stockholders Diluted Net Income Available to Common Stockholders Cost of Revenue 2019 2020 2021 702,570,000 721,445,000 740,260,000 1,745,401,000 1,703,982,000 1,734,244,000 1,745,401,000 1,703,982,000 1,734,244,000 -1,042,831,000 -982,537,000 -993,984,000 -1,042,831,000 -982,537,000 -993,984,000 -572,896,000 -575,821,000 -603,524,000 -572,896,000 -575,821,000 -603,524,000 129,674,000 145,624,000 136,736,000 -34,347,000 -30,451,000 9,177,000 561,000 1,494,000 -289,000 561,000 1,494,000 -289,000 -1,542,000 -1,291,000 -1,390,000 2,103,000 2,785,000 1,101,000 -32,671,000 -24,962,000 0 -26,862,000 0 -32,671,000 1,900,000 0 -2,237,000 -6,983,000 9,466,000 95,327,000 115,173,000 145,913,000 -25,186,000 -36,189,000 -38,384,000 70,141,000 78,984,000 107,529,000 70,141,000 78,984,000 107,529,000 -1,567,000 -1,515,000 -1,068,000 68,574,000 77,469,000 106,461,000 -225,000 -117,000 -46,000 -225,000 -117,000 -46,000 68,349,000 77,352,000 106,415,000 68,349,000 77,352,000 106,415,000
