Prepare the following financial exhibits for 2013 through 2016:
Ratio table
Vertical analysis of income statements and balance sheets
Horizontal analysis (index numbers) of income statements and balance sheets
Cash flow statements
5-way analysis of ROE
2012 711,100,000 421,650,000 289,450,000 Exhibit 1 Income Statements 2013 2014 850,762,000 1,625,324,200 516,212,000 1,021,419,200 334,550,000 603,905,000 2015 2,211,360,600 1,468,340,150 743,020,450 2016 2,651,882,800 1,791,102.960 860,779,840 Sales Cost of sales Gross profit Operating costs Selling and distribution Research and development Administration Amortization Operating profit Interest Earnings before taxes Taxes Net income 74,500,300 45,890,340 24,350,300 49,557,087 95,151,973 14,189,065 80,962,908 28,337,018 52,625,890 85,984,000 55,689,500 32,534,000 56,830,350 103,512,150 17,386,710 86,125,440 30,143,904 55,981,536 200,450,300 101,230,000 95,608,890 141,468,842 65,146,968 46,684,825 18,462,143 6,461,750 12,000,393 231,530,000 185,640,000 124,890,000 142,920,000 58,040,450 51,226,136 6,814,314 2,385,010 4,429,304 267,300,200 239,560,000 137,450,300 152,885,800 63,583,540 56,015, 189 7,568,351 2,648,923 4,919,428 Cash Accounts receivable Parts inventory WIP inventory Finished goods inventory Total current assets Land, plant, and equipment, net Intangibles Total assets 2012 75,340,000 31,650,000 96,670,000 46,789,180 145,300,530 395,749.710 445,230,840 50,340,030 891,320,580 Exhibit 2 Balance Sheets 2013 76,800,300 45,320,000 150,320,000 65,354,460 210,360,300 548,155,060 489,300,500 79,003,000 1,116,458,560 2014 95,630,000 65,340,000 245,320,600 86,650,675 271,530,200 764,471,475 1,317,388,220 97,300,200 2,179,159,895 2015 55,320,100 75,800,300 339,760,200 124,532,030 314,580,400 909,993,030 1,318,350,000 110,850,000 2,339,193,030 2016 15,430,300 95,300,000 423,340,000 145,673,800 389,640,200 1,069,384,300 1,402,870,000 125,988,000 2,598,242,300 Accounts payable Current portion of long-term debt Total current liabilities Long-term debt Shareholders' equity Total liabilities and equities 68,700,400 23,453,000 92,153,400 234,530,000 564,637,180 891,320,580 95,620,000 26,790,000 122,410,000 267,900,000 726,148,560 1,116,458,560 167,500,300 69,575,000 237,075,300 695,750,000 1,246,334,595 2,179,159,895 240,650,430 73,453,020 314,103,450 734,530,200 1,290,559,380 2,339,193,030 320,640,430 79,567,030 400,207,460 795,670,300 1,402,364,540 2,598,242,300 Exhibit 3 Sales Analysis 2013 2014 2012 2015 2016 9,500 9,500 9,500 5,750 15,000 9,500 5,932 21,000 9,500 6,010 55,560 6,230 62,500 6,500 85,600 Wind turbines Unit price Unit cost Quantity Water turbines Unit price Unit cost Quantity Solar panels Unit price Unit cost Quantity 5,400 3,900 2,500 5,400 4,100 3,100 5,400 4,200 4,560 5,400 4,350 6,509 5,400 4.450 7,848 8,540 5,010 65,000 8,540 5,100 74,300 8,540 5,320 125,630 8,540 5,670 185,300 8,540 5,704 210,340 Financial Benchmarks Exhibit 4 contains industry average information secured from Statistics Canada. Exhibit 4 Industry Averages Industry Financial Ratios Averages 2016 Current ratio 4.90x Cash ratio .11% Parts inventory turnover in days 33.71 days WIP inventory turnover in days 15.93 days FG inventory turnover in days 51.98 days Accounts receivable turnover in days 30.44 days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total assets turnover Debt ratio Long-term debt total capitalization Times interest earned Cash flow coverage Gross profit margin Operating profit margin Net profit margin Return on assets Return on equity 19.13 days 112.93 days 2.42x 1.22x 32% 29% 9.47x 2.66x 40.66% 14.04% 8.16% 6.46% 14.51% 100.00 59.34 40.66 Vertical Analysis (%) Income Statement 2016 Sales Cost of sales Gross profit Operating costs Selling and distribution Research and development Administration Depreciation Operating profit Interest Earnings before taxes Taxes Net income 9.32 7.02 4.83 5.45 14.04 1.48 12.56 4.40 8.16 Vertical Analysis (%) Balance Sheet 2016 Cash Accounts receivable Parts inventory WIP inventory Finished goods inventory Total current assets Land, plant, and equipment, net Other assets Total assets 10.95 10.15 6.67 3.15 10.28 41.21 50.31 8.48 100.00 Accounts payable Current portion of long-term debt Total current liabilities Long-term debt Shareholders' equity Total liabilities and equities 3.78 4.62 8.41 23.12 68.47 100.00 Ratio Tables 2013 2014 2015 2016 Industry Average Liquidity Current ratio Cash ratio Asset Management Parts inventory turnover in days Work-in-progress turnover in days Finished goods turnover in days Accounts receivable turnover in days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total asset turnover Long-term Debt Paying Ability Debt ratio Long-term debt to total capitalization Times interest earned Cash flow coverage Profitability Gross margin Operating profit margin Net profit margin ROA ROE Analysis of ROE - 5-Part EBIT/Sales EBT/EBIT NI/EBT Total Asset Turnover Debt Ratio ROE 2013 2014 2015 2016 2012 711,100,000 421,650,000 289,450,000 Exhibit 1 Income Statements 2013 2014 850,762,000 1,625,324,200 516,212,000 1,021,419,200 334,550,000 603,905,000 2015 2,211,360,600 1,468,340,150 743,020,450 2016 2,651,882,800 1,791,102.960 860,779,840 Sales Cost of sales Gross profit Operating costs Selling and distribution Research and development Administration Amortization Operating profit Interest Earnings before taxes Taxes Net income 74,500,300 45,890,340 24,350,300 49,557,087 95,151,973 14,189,065 80,962,908 28,337,018 52,625,890 85,984,000 55,689,500 32,534,000 56,830,350 103,512,150 17,386,710 86,125,440 30,143,904 55,981,536 200,450,300 101,230,000 95,608,890 141,468,842 65,146,968 46,684,825 18,462,143 6,461,750 12,000,393 231,530,000 185,640,000 124,890,000 142,920,000 58,040,450 51,226,136 6,814,314 2,385,010 4,429,304 267,300,200 239,560,000 137,450,300 152,885,800 63,583,540 56,015, 189 7,568,351 2,648,923 4,919,428 Cash Accounts receivable Parts inventory WIP inventory Finished goods inventory Total current assets Land, plant, and equipment, net Intangibles Total assets 2012 75,340,000 31,650,000 96,670,000 46,789,180 145,300,530 395,749.710 445,230,840 50,340,030 891,320,580 Exhibit 2 Balance Sheets 2013 76,800,300 45,320,000 150,320,000 65,354,460 210,360,300 548,155,060 489,300,500 79,003,000 1,116,458,560 2014 95,630,000 65,340,000 245,320,600 86,650,675 271,530,200 764,471,475 1,317,388,220 97,300,200 2,179,159,895 2015 55,320,100 75,800,300 339,760,200 124,532,030 314,580,400 909,993,030 1,318,350,000 110,850,000 2,339,193,030 2016 15,430,300 95,300,000 423,340,000 145,673,800 389,640,200 1,069,384,300 1,402,870,000 125,988,000 2,598,242,300 Accounts payable Current portion of long-term debt Total current liabilities Long-term debt Shareholders' equity Total liabilities and equities 68,700,400 23,453,000 92,153,400 234,530,000 564,637,180 891,320,580 95,620,000 26,790,000 122,410,000 267,900,000 726,148,560 1,116,458,560 167,500,300 69,575,000 237,075,300 695,750,000 1,246,334,595 2,179,159,895 240,650,430 73,453,020 314,103,450 734,530,200 1,290,559,380 2,339,193,030 320,640,430 79,567,030 400,207,460 795,670,300 1,402,364,540 2,598,242,300 Exhibit 3 Sales Analysis 2013 2014 2012 2015 2016 9,500 9,500 9,500 5,750 15,000 9,500 5,932 21,000 9,500 6,010 55,560 6,230 62,500 6,500 85,600 Wind turbines Unit price Unit cost Quantity Water turbines Unit price Unit cost Quantity Solar panels Unit price Unit cost Quantity 5,400 3,900 2,500 5,400 4,100 3,100 5,400 4,200 4,560 5,400 4,350 6,509 5,400 4.450 7,848 8,540 5,010 65,000 8,540 5,100 74,300 8,540 5,320 125,630 8,540 5,670 185,300 8,540 5,704 210,340 Financial Benchmarks Exhibit 4 contains industry average information secured from Statistics Canada. Exhibit 4 Industry Averages Industry Financial Ratios Averages 2016 Current ratio 4.90x Cash ratio .11% Parts inventory turnover in days 33.71 days WIP inventory turnover in days 15.93 days FG inventory turnover in days 51.98 days Accounts receivable turnover in days 30.44 days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total assets turnover Debt ratio Long-term debt total capitalization Times interest earned Cash flow coverage Gross profit margin Operating profit margin Net profit margin Return on assets Return on equity 19.13 days 112.93 days 2.42x 1.22x 32% 29% 9.47x 2.66x 40.66% 14.04% 8.16% 6.46% 14.51% 100.00 59.34 40.66 Vertical Analysis (%) Income Statement 2016 Sales Cost of sales Gross profit Operating costs Selling and distribution Research and development Administration Depreciation Operating profit Interest Earnings before taxes Taxes Net income 9.32 7.02 4.83 5.45 14.04 1.48 12.56 4.40 8.16 Vertical Analysis (%) Balance Sheet 2016 Cash Accounts receivable Parts inventory WIP inventory Finished goods inventory Total current assets Land, plant, and equipment, net Other assets Total assets 10.95 10.15 6.67 3.15 10.28 41.21 50.31 8.48 100.00 Accounts payable Current portion of long-term debt Total current liabilities Long-term debt Shareholders' equity Total liabilities and equities 3.78 4.62 8.41 23.12 68.47 100.00 Ratio Tables 2013 2014 2015 2016 Industry Average Liquidity Current ratio Cash ratio Asset Management Parts inventory turnover in days Work-in-progress turnover in days Finished goods turnover in days Accounts receivable turnover in days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total asset turnover Long-term Debt Paying Ability Debt ratio Long-term debt to total capitalization Times interest earned Cash flow coverage Profitability Gross margin Operating profit margin Net profit margin ROA ROE Analysis of ROE - 5-Part EBIT/Sales EBT/EBIT NI/EBT Total Asset Turnover Debt Ratio ROE 2013 2014 2015 2016
