Power Green Industries

Student Instructions

1. 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

2. Assuming the role of William Wyler, CPA, prepare a 2-page memorandum that analyzes the financial condition of PGI and makes recommendations relating to the companys financial performance and proposed new product introduction. The memo should be divided into sections describing liquidity, asset management, long-term debt paying ability, profitability, and recommendations. The memo should be single spaced and use the 12-point Calibri font with 0.7-inchfi margins.

Submit one Word file through the Moodle site using the drop box provided. No Excel spreadsheet should be submitted but you should build one to calculate the ratios. Exhibits should be included at the end of the memorandum.

Power Green Industries In early January 2017, William Wyler, CPA, a senior manager at Myers Norris Penny LLP in Regina, Saskatchewan, was assigned the task of reviewing the financial performance of Power Green Industries (PGI) Ltd., a Canadian-based manufacturer of alternative electrical generating equipment. Before proceeding with the introduction of a revolutionary new product, PGI's board of director thought it prudent to retain an independent consultant to review the company's performance. Despite its rapid sales growth, the board was worried about PGI's financial ability to execute this expansion. Having taken two years of engineering before changing to accounting at university, Wyler feels he has the technical knowledge to understand the company's products, which will aid him in analyzing its financial performance. If this review goes smoothly, Wyler believes he will finally make partner after 10 years at the firm. Company Formation PGI was formed in 2005 by Dr. Maggi McGruder, P.Eng. who had taken a buyout from Natural Resources Canada, a department of the federal government of Canada, after becoming frustrated with the slow rate of implementation of her many ideas. McGruder completed her PhD in electrical engineering in 1997 at the University of Manitoba where her dissertation dealt with home and farm-based energy alternatives such as wind turbines, water turbines, solar panels, geothermal, and biogas. In the new start-up, she decided to focus on wind and water turbines and solar panels because of her background in electrical engineering. Also, in her opinion, the geothermal and biogas segments of the alternative energy industry were not cost effective in the long term. McGruder's knowledge of manufacturing and marketing was limited so she recruited two partners, Matthew Wiggins, P.Eng. and Nancy Cranston, CSP, Wiggins had over 30 years of experience supervising manufacturing facilities for companies such as Caterpillar, General Electric, and Nortel while Cranston had been a vice-president of marketing and sales for several equipment producers with her most recent position being with Stanley Tools. Each contributed CAR.200.000 for a 25.0% share of the company and the remainder of the seed capital was provided by Wilson Mclvor, a retired Fortune 500 CEO, who had been an "angel" to several other tech start-ups in Canada. After three rounds of funding from CanDo Venture Capital, each of the three founders' holdings had been reduced to 15.0%. In 2007, the angel and venture capitalists took PGI public in an initial public offering in order to exit the investment. The partners bought enough of the shares to maintain control. Company Expansion The period from 2005 to 2007 was a troublesome one for PGI. Products took much longer than planned to develop and production processes where difficult to master. Venture capital financing was also difficult to acquire, and the owners had to relinquish a much larger portion of the business than hoped to secure the needed funding. By 2008, the products and manufacturing facilities were in place. Despite initial hesitancy, several key distributors were recruited. In Canada, both Canadian Tire and Home Hardware agreed to carry PGI's products. Canadian Tire also featured them in one of their advertising campaigns where they stressed Page 1 their new focus on environmentally friendly products. The Co-op, a farmer cooperative organization and major agricultural supply chain, agreed to sell the products and allowed PGI to promote them at all their membership meetings. In the U.S., Eagle Hardware and several regional farmer cooperatives also signed distribution agreements. Sales of PGI's products increased dramatically from 2008 to 2016. Farmers welcomed them to reduce costs in a competitive industry and to avoid frequent power outages that can be problematic especially for dairy and poultry producers. People living in remote areas found them to be a cheaper alternative to burning fossil fuels, while environmentally conscious consumers felt they greatly reduced their ecological footprint. New Product Introduction To expand its product line further, PGI is currently developing an advanced power management system. This includes high-capacity batteries that store electricity to balance differences in generation and consumption as well as a monitoring system that automatically resells power to the local grid when user's needs are met, and prices offered by the local public utility are at their highest. The monitoring system also detects faulty storage batteries so they can be quickly replaced. PGI will produce its own batteries using technology licensed from a well-known research firm, but the remainder of this new system is being developed in-house and is considered "leading-edge" by the industry. Financial Data PGI provided Wyler with financial statements for the last five years, which are contained in Exhibit 1 and 2. A detailed breakdown of unit prices and costs and sales quantities for the last five years was also provided in Exhibit 3. Exhibit 1 Income Statements (CAD) 2012 2013 2014 2015 711,100,000 850,762,000 1,625,324,200 2,211,360,600 421,650,000 516,212,000 1,021,419 200 1,468,340,150 289,450,000 334,550,000 603,905,000 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 Exhibit 2 Balance Sheets (CAD) 2012 2013 2014 2015 75,340,000 76,800,300 95,630,000 55,320,100 31,650,000 45,320,000 65,340,000 75,800,300 96,670,000 150,320,000 245,320,600 339,760,200 46,789, 180 65,354,460 86,650,675 124,532,030 145,300,530 210,360,300 271,530,200 314,580,400 395,749,710 548,155,060 764,471, 475 909,993,030 445,230,840 489,300,500 1,317,388,220 1,318,350,000 50,340,030 79,003,000 97,300,200 110,850,000 891,320,580 1,116,458,560 2,179, 159,895 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 320580 95,620,000 26,790,000 122,410,000 267,900,000 726, 148,560 1,116,458,560 167,500,300 240,650,430 69,575,000 73,453,020 237,075,300 314,103,450 695,750,000 734,530,200 1 246,334,595 1,290,559,380 2,179,159 895 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 (CAD) 2012 2013 2014 2015 2016 Wind turbines Unit price 9,500 9,500 9,500 9,50 0 5,75 0 15,000 9,50 0 6,50 0 85,600 5,932 21,000 6,010 55,560 6,230 62,500 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 Financial Ratios Current ratio Cash ratio Parts inventory turnover in days WIP inventory turnover in days Industry Averages 2016 4.90x 11x 33.71 days 15.93 days Page 3 FG inventory turnover in days Accounts receivable turnover in days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total assets turnover Debt ratio Long-term debt total capitalization Times interest eamed Cash flow coverage Gross profit margin Operating profit margin Net profit margin Return on assets Return on equity 51.98 days 30.44 days 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% Paragraph 14.51% Return on equity Vertical Analysis (%) Income Statement 2016 Sales 100.00 Cost of sales 59.34 Gross profit 40.66 Operating costs Selling and distribution 9.32 Research and development 7.02 Administration 4.83 Depreciation 5.45 Operating profit 14.04 Interest 1.48 Earnings before taxes 12.56 Taxes 4.40 Net income 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.2 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 Operations Power Green Industries In early January 2017, William Wyler, CPA, a senior manager at Myers Norris Penny LLP in Regina, Saskatchewan, was assigned the task of reviewing the financial performance of Power Green Industries (PGI) Ltd., a Canadian-based manufacturer of alternative electrical generating equipment. Before proceeding with the introduction of a revolutionary new product, PGI's board of director thought it prudent to retain an independent consultant to review the company's performance. Despite its rapid sales growth, the board was worried about PGI's financial ability to execute this expansion. Having taken two years of engineering before changing to accounting at university, Wyler feels he has the technical knowledge to understand the company's products, which will aid him in analyzing its financial performance. If this review goes smoothly, Wyler believes he will finally make partner after 10 years at the firm. Company Formation PGI was formed in 2005 by Dr. Maggi McGruder, P.Eng. who had taken a buyout from Natural Resources Canada, a department of the federal government of Canada, after becoming frustrated with the slow rate of implementation of her many ideas. McGruder completed her PhD in electrical engineering in 1997 at the University of Manitoba where her dissertation dealt with home and farm-based energy alternatives such as wind turbines, water turbines, solar panels, geothermal, and biogas. In the new start-up, she decided to focus on wind and water turbines and solar panels because of her background in electrical engineering. Also, in her opinion, the geothermal and biogas segments of the alternative energy industry were not cost effective in the long term. McGruder's knowledge of manufacturing and marketing was limited so she recruited two partners, Matthew Wiggins, P.Eng. and Nancy Cranston, CSP, Wiggins had over 30 years of experience supervising manufacturing facilities for companies such as Caterpillar, General Electric, and Nortel while Cranston had been a vice-president of marketing and sales for several equipment producers with her most recent position being with Stanley Tools. Each contributed CAR.200.000 for a 25.0% share of the company and the remainder of the seed capital was provided by Wilson Mclvor, a retired Fortune 500 CEO, who had been an "angel" to several other tech start-ups in Canada. After three rounds of funding from CanDo Venture Capital, each of the three founders' holdings had been reduced to 15.0%. In 2007, the angel and venture capitalists took PGI public in an initial public offering in order to exit the investment. The partners bought enough of the shares to maintain control. Company Expansion The period from 2005 to 2007 was a troublesome one for PGI. Products took much longer than planned to develop and production processes where difficult to master. Venture capital financing was also difficult to acquire, and the owners had to relinquish a much larger portion of the business than hoped to secure the needed funding. By 2008, the products and manufacturing facilities were in place. Despite initial hesitancy, several key distributors were recruited. In Canada, both Canadian Tire and Home Hardware agreed to carry PGI's products. Canadian Tire also featured them in one of their advertising campaigns where they stressed Page 1 their new focus on environmentally friendly products. The Co-op, a farmer cooperative organization and major agricultural supply chain, agreed to sell the products and allowed PGI to promote them at all their membership meetings. In the U.S., Eagle Hardware and several regional farmer cooperatives also signed distribution agreements. Sales of PGI's products increased dramatically from 2008 to 2016. Farmers welcomed them to reduce costs in a competitive industry and to avoid frequent power outages that can be problematic especially for dairy and poultry producers. People living in remote areas found them to be a cheaper alternative to burning fossil fuels, while environmentally conscious consumers felt they greatly reduced their ecological footprint. New Product Introduction To expand its product line further, PGI is currently developing an advanced power management system. This includes high-capacity batteries that store electricity to balance differences in generation and consumption as well as a monitoring system that automatically resells power to the local grid when user's needs are met, and prices offered by the local public utility are at their highest. The monitoring system also detects faulty storage batteries so they can be quickly replaced. PGI will produce its own batteries using technology licensed from a well-known research firm, but the remainder of this new system is being developed in-house and is considered "leading-edge" by the industry. Financial Data PGI provided Wyler with financial statements for the last five years, which are contained in Exhibit 1 and 2. A detailed breakdown of unit prices and costs and sales quantities for the last five years was also provided in Exhibit 3. Exhibit 1 Income Statements (CAD) 2012 2013 2014 2015 711,100,000 850,762,000 1,625,324,200 2,211,360,600 421,650,000 516,212,000 1,021,419 200 1,468,340,150 289,450,000 334,550,000 603,905,000 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 Exhibit 2 Balance Sheets (CAD) 2012 2013 2014 2015 75,340,000 76,800,300 95,630,000 55,320,100 31,650,000 45,320,000 65,340,000 75,800,300 96,670,000 150,320,000 245,320,600 339,760,200 46,789, 180 65,354,460 86,650,675 124,532,030 145,300,530 210,360,300 271,530,200 314,580,400 395,749,710 548,155,060 764,471, 475 909,993,030 445,230,840 489,300,500 1,317,388,220 1,318,350,000 50,340,030 79,003,000 97,300,200 110,850,000 891,320,580 1,116,458,560 2,179, 159,895 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 320580 95,620,000 26,790,000 122,410,000 267,900,000 726, 148,560 1,116,458,560 167,500,300 240,650,430 69,575,000 73,453,020 237,075,300 314,103,450 695,750,000 734,530,200 1 246,334,595 1,290,559,380 2,179,159 895 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 (CAD) 2012 2013 2014 2015 2016 Wind turbines Unit price 9,500 9,500 9,500 9,50 0 5,75 0 15,000 9,50 0 6,50 0 85,600 5,932 21,000 6,010 55,560 6,230 62,500 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 Financial Ratios Current ratio Cash ratio Parts inventory turnover in days WIP inventory turnover in days Industry Averages 2016 4.90x 11x 33.71 days 15.93 days Page 3 FG inventory turnover in days Accounts receivable turnover in days Accounts payable turnover in days Cash conversion cycle Fixed assets turnover Total assets turnover Debt ratio Long-term debt total capitalization Times interest eamed Cash flow coverage Gross profit margin Operating profit margin Net profit margin Return on assets Return on equity 51.98 days 30.44 days 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% Paragraph 14.51% Return on equity Vertical Analysis (%) Income Statement 2016 Sales 100.00 Cost of sales 59.34 Gross profit 40.66 Operating costs Selling and distribution 9.32 Research and development 7.02 Administration 4.83 Depreciation 5.45 Operating profit 14.04 Interest 1.48 Earnings before taxes 12.56 Taxes 4.40 Net income 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.2 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 Operations