Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Income Statements 2018 2019 2020 2021 2022 Sales $ 699,005,000 $ 891,945,500 $ 506,443,300 $ 487,421,800 $ 783,601,000 Cost of Goods Sold 426,250,000 550,357,100 323,504,700

Income Statements
2018 2019 2020 2021 2022
Sales $ 699,005,000 $ 891,945,500 $ 506,443,300 $ 487,421,800 $ 783,601,000
Cost of Goods Sold 426,250,000 550,357,100 323,504,700 306,867,800 499,025,500
Gross Profit 272,755,000 341,588,400 182,938,600 180,554,000 284,575,500
Operating Costs
Selling and Distribution 73,233,100 91,395,900 80,423,200 60,294,100 89,722,300
Research & Development 67,663,700 87,589,000 87,564,000 51,228,000 74,363,700
Administration 23,936,100 34,108,900 39,502,600 22,908,800 34,478,400
Depreciation & Amortization 48,556,200 60,758,400 62,517,400 61,530,300 64,200,800
Operating Profit 59,365,900 67,736,200 -87,068,600 -15,407,200 21,810,300
Interest 9,693,500 10,131,200 9,541,500 13,421,200 14,919,500
Earnings Before Taxes 49,672,400 57,605,000 -96,610,100 -28,828,400 6,890,800
Taxes 14,901,720 17,281,500 -28,983,030 -8,648,520 2,067,240
Net Income $ 34,770,680 $ 40,323,500 ($ 67,627,070) ($ 20,179,880) $ 4,823,560
Balance Sheets
2018 2019 2020 2021 2022
Cash $ 25,340,000 $ 26,800,300 $ 5,630,000 $ 15,320,100 $ 23,430,300
Accounts receivable 32,364,900 41,298,300 23,449,000 22,568,300 36,281,800
Parts Inventory 95,760,300 122,134,000 326,163,600 174,872,600 128,516,200
WIP Inventory 43,427,500 54,281,800 76,223,000 51,516,400 57,422,100
Finished Goods Inventory 79,411,000 93,485,300 163,968,100 130,163,000 117,578,600
Total Current Assets $ 276,303,700 $ 337,999,700 $ 595,433,700 $ 394,440,400 $ 363,229,000
Land, plant, and equipment, net 445,230,840 595,750,840 600,601,740 592,134,240 616,526,140
Intangibles 50,340,030 79,343,030 94,035,830 91,535,430 96,816,530
Total Non-Current Assets $ 495,570,870 $ 675,093,870 $ 694,637,570 $ 683,669,670 $ 713,342,670
Total Assets $ 771,874,570 $ 1,013,093,570 $ 1,290,071,270 $ 1,078,110,070 $ 1,076,571,670
Accounts payable $ 68,700,400 $ 95,620,000 $ 167,500,300 $ 85,259,400 $ 98,361,100
Line of credit 460,000 $ 506,000 $ 557,000 $ 613,000 $ 674,000
Current portion of long-term debt 25,743,300 25,743,300 44,875,600 72,765,100 57,641,700
Total current liabilities $ 94,903,700 $ 121,869,300 $ 212,932,900 $ 158,637,500 $ 156,676,800
Long-term debt 234,030,000 407,959,900 661,501,070 524,015,150 519,613,890
Total Liabilities 328,933,700 529,829,200 874,433,970 682,652,650 676,290,690
Shareholders' equity 442,940,870 483,264,370 415,637,300 395,457,420 400,280,980
Total Liabilities and Equity $ 771,874,570 $ 1,013,093,570 $ 1,290,071,270 $ 1,078,110,070 $ 1,076,571,670

Operations

In order to expand sales, PGI has kept its prices constant over the last five years for water turbines. Wind turbine prices were decreased in 2020 only in order to incentivize customer business during covid; this was reversed in 2021. Only solar turbines had annual price increases. By comparison, competitors have increased prices annually.

PGI also offers its distributors terms of 2/10, net 30, which vary from the industry standard of net 30. Most distributors took advantage of these terms over the past five years.

PGI designs and assembles its products in Canada but sources its components globally. As a precautionary measure, to guard against supply interruptions caused by strikes, material shortages, and transportation delays, it stockpiles many of its key parts. Its accounts payable relate primarily to inventory purchases. Industry standard credit terms are 3/15, net 60 and most suppliers charge interest of 10 percent per annum on any overdue accounts.

In order to remain competitive with low-wage countries, PGI invested heavily in factory automation, but has had difficulties with many of the complex systems. Breakdowns and software "bugs" are common place as most of the equipment was bought from a low-cost supplier, which has since gone bankrupt. Low educational standards also made training difficult and lowered production efficiency. It was thought automation would allow the company to reduce finished goods inventory though just-in-time production, but the frequent breakdowns made it necessary to carry more stock.

To accommodate company growth, PGI built a new corporate headquarters, R&D facility and distribution centre in 2019. A number of existing buildings were considered, but a new facility in an expensive area of Toronto was constructed to increase the profile of the company.

PGI has not paid any dividends to date. Debt had already increased significantly due to growth and the new facilities, and was then compounded due to the collapse of revenues. Since 2020, management had to bear down and managed to improve the levels of debt. Terms loans and mortgages were negotiated with five different banks to diversify its funding sources. PGI is listed on the Toronto and New York Stock Exchanges and is considering going to the market to raise more equity through a secondary offering. To avoid losing control, the three founding shareholders have agreed to issue only non-voting common shares, but is appears the market has lost its appetite for this type of security. PGI maintains a $1,500,000 line of credit with Western Canadian Bank to finance seasonal variations in net working capital. The loan must be 200 percent secured by inventory and accounts receivable. Also, to comply with the different loan agreements, the following ratios must be maintained:

  • The current ratio must be kept above 2.5;
  • the long-term debt to total capitalization, measured as long-term debt / (long-term debt + equity), must remain below 50 percent; and
  • the cash flow coverage ratio, measured as EBITDA / (Interest + Current Portion of LT Debt) above 2.0.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools for business decision making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

6th Edition

978-0470477144, 1118096894, 9781118214657, 470477148, 111821465X, 978-1118096895

More Books

Students also viewed these Accounting questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago