subject: corporate finance (3200)

please help me with this homework i put the questions to answer at the end.

1. Prepare the following Financial Exhibits for 2006, 2007, 2008. . Ratio Table with Industry averages (liquidity, asset management, long term

debt ability, profitability)

Common Size Income Statement and Balance Sheet

Dupont Analysis of ROE Cash Flow Statements (for 2007 and 2008)

2. Prepare a two-page memo as requested by Mr. Johnstone. The memo should be

divided into sections describing liquidity, asset management, long term debt ability, profitability and recommendations.

In early January 2009, David Johnstone received the draft 2008 financial statements for Strong Tie and began to question the company's performance when compared to previous years. How were profits holding up, given the intense price competition in the industry? Were attempts to lower costs through more automation paying off? Were the current problems in the U.S. housing market going to continue to reduce demand for connectors? How would lenders react to this poor performance? Was the company's financing in danger? After discussing the matter with company accountant Audrey Johnstone, it was decided that an outside consultant should be hired to provide an independent analysis of the company's recent performance and to provide suggestions for future action. COMPANY BACKGROUND Strong Tie Ltd., located in Winnipeg, Manitoba, designed and manufactured the standardized and customized structural connectors used to reinforce wood joints in the construction of decks, fences, houses and other structures. Strong Tie was a family-owned corporation founded in 1946 by Bill Johnstone to capitalize on the high demand for housing as returning World War II veterans married and began families. Bill Johnstone died in 1975 but passed the business on to his son David, who continued to operate the business along with his three daughters, Ellen, Elizabeth and Audrey. David served as CEO, while Ellen Johnstone, P.Eng, was responsible for product design and production; Elizabeth Johnstone, CSP, managed marketing, sales and distribution; and Audrey Johnstone, CA, managed the company's finances. The Johnstone family was a pillar of the Winnipeg business community, making sizeable donations to local charities and sport teams. The standardized connectors were designed in Winnipeg based on input from architects, draftsmen and builders. The production process was highly automated with metal cutting, stamping and drilling machines completing most of the tasks. Human intervention was required to transfer work-in-process between stations, to feed machines and to pack, store and distribute the end products. This automation had allowed production to remain in Canada to date despite fierce competition from low-wage countries, particularly China. Customized connectors were produced based on specifications provided by the customer. Production of these units was more labour-intensive, but margins were still significantly higher as contractors were prepared to pay a premium to have their special needs met. Strong Tie prided itself on its product design capabilities. Designers in Winnipeg consistently generated an array of new standardized connectors that improved on existing products or addressed newly identified industry needs. These products were described in detail in terms of dimension, strength (load-bearing weights and steel gauge) and installation on the company's website or in a paper catalogue located in stores - both were of very high quality. Strong Tie also had a reputation among construction professionals as providing innovative solutions to unique design requests and being able to produce customized products in a timely manner at a reasonable price. Standardized products were distributed through all national home improvement chains in North America including Home Depot, Lowe's, Rona, Home Hardware, Eagle and Sears. Most local chains catering to contractors also carried the standardized products and accepted requests for customized connectors, which they then forwarded to Strong Tie. Strong Tie was estimated to have a 60 per cent market share, which had fallen from 70 per cent in recent years. Universal Connector, a U.S. firm based in Ohio, was estimated to have a 30 per cent and growing share; it offered a similar array of standardized products and customized design services. The remainder of the market was served by five Chinese producers whose market share had grown considerably in the last five years, although they had yet to enter the customized product segment. Universal Connector had closed a number of its U.S. manufacturing facilities in recent years and replaced them with new facilities in China, which put considerable downward pressure on industry prices. Currently, Strong Tie priced its products at a premium to its competitors because of its industry leadership. All sales were on terms Net 60. Large accounts such as Home Depot had a reputation of stretching their payments past the due date because of their buying power, while contractors frequently delayed payments due to cash flow problems. All purchases, which were primarily steel, were on terms 2/10, Net 60. Metal prices varied considerably, and the trend over 2006 to 2008 was for these prices to rise due to increasing demand from emerging market countries, particularly Brazil, Russia, India and China. Strong Tie had attempted to adopt just-in-time inventory practices to help reduce its raw material, work-in-process and finished goods inventory levels The Johnstone family maintained excellent relations with its unionized workforce, which was represented by the United Steel Workers of America. They prided themselves on paying generous wages and providing their workers with excellent health care, disability and pension benefits. The company had never had a strike and was currently negotiating a new collective agreement to take effect in three months on April 1, 2009. In recent years, Strong Tie had been investing heavily in factory automation to improve its competitiveness. Automatic feeders and packaging equipment had been purchased to further reduce labour costs, and new computers and software had helped to speed up the design of high-margin customized connectors. A new, more automated warehouse had also been constructed. FINANCIAL STATEMENTS Exhibits 1 and 2 contain the income statements and balance sheets for Strong Tie for the last three years, FINANCIAL BENCHMARKS Reliable industry average information was not available for Strong Tie's Chinese competitors, but comparable ratios were available for Universal Connector, a public company, in 2008. These ratios are contained in Exhibit 3. FINANCING Strong Tie had a $2,000,000, five-year, revolving credit agreement with the Bank of Nova Scotia, which was used to finance the company's working capital requirements as well as a number of individual term loans to finance fixed assets. The revolving credit agreement was committed, so as long as the loan conditions were met, financing was guaranteed. The loan had to be secured 100 per cent by accounts receivable and inventory. The receivables were primarily with large retail chains that were in good financial health, so the Bank of Nova Scotia was prepared to lend 90 per cent of their value. They were also willing to lend 60 per cent of the value of the finished goods and work-in-process inventory because of a strong re-sale market and the short production process. The bank would only lend 40 per cent of the value of raw materials inventory due to general instability in the commodities market. The revolving credit agreement had to be paid down to zero at least once per year. All loans required that the company maintain a Current Ratio of 1.5 or higher, a Cash Flow Coverage Ratio of 1.0 or higher and a Long-term Debt to Total Capitalization Ratio of 40 per cent or less. Audited quarterly and annual financial statements also had to be provided to the bank each quarter. As the sole owner of the corporation, David Johnstone did not take a salary, but his three daughters received over $1,000,000 in salary and bonuses each year. Preferred dividends of $500,000 were paid out to Mr. Johnstone's sister Katherine, who chose not to participate in the management of the business but was promised a regular income by her late father in lieu of receiving a share of the business. These dividends had to be paid unless the company entered bankruptcy. Exhibit 1 INCOME STATEMENTS 2006 2007 2008 $16,200 $17.450 $16.500 10.445 11.956 11.950 $5,755 $5,494 $4.550 3,054 3.130 3,379 396 720 756 $2,305 $1,644 $415 Nel Sales Cost of Goods Sold Gross Profit Selling and Administration Depreciation Operating Income Other Income Interest Income Other Expense Interest Expense Income Before Taxes Income Taxes Net income 21 10 2 246 $2,080 624 $1,456 291 $1,363 409 $954 407 $10 3 $7 Exhibit 2 BALANCE SHEETS 2006 2007 2008 $61 $234 1,034 3,250 1,025 200 2.030 182 $7.955 $122 488 3,450 1,350 138 1.700 143 $7,391 99 2.854 1,395 42 1.200 188 $5.839 Current Assets Cash Temporary Investment Accounts Receivable, Net Raw Materials Inventory WIP Inventory Finished Goods Inventory Prepaid Expenses Total Current Assets Fixed Assets Land. Plant, and Equipment Less: Accumulative Depreciation Net Land, Plant, Equipment Total Assets Current Liabilities Accounts Payable Income Taxes Payable Current Portion of Long-term Debt Total Current Liabilities Long-term Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity $4,893 $7,076 9.590 1.380 2.100 2.856 3,513 4,976 6,734 $11,468 $12,367 $12,573 $534 54 1.000 $1,588 3,190 $543 35 1,145 $1.723 3.500 500 23 1,340 $1,863 4.059 1,350 5,340 $6,690 $11,468 1,350 5,794 $7.144 $12,367 1,350 5,301 $6,651 $12.573 Exhibit 3 BENCHMARK RATIOS Ratio Current Ratio Cash Ratio Raw Materials Turnover in Days WIP Turnover in Days Finished Goods Turnover in Days A/R Turnover in Days A/P Turnover in Days Cash Conversion Cycle Fixed Asset Turnover Total Asset Turnover Long-term Debt to Total Capitalization Cash Flow Coverage Gross Profit Margin Operating Profit Margin Net Profit Margin ROA ROE Industry Average 4 .5 31 days 3 days 51 days 63 days 11 days 137 days 4.1 1.7 35% 2 32% 16% 10% 17% 28% . Questions to Answer: 1. Prepare the following Financial Exhibits for 2006, 2007, 2008. Ratio Table with Industry averages (liquidity, asset management, long term debt ability, profitability) (2 points) Common Size Income Statement and Balance Sheet (1 point) Dupont Analysis of ROE (0.5 point) Cash Flow Statements (for 2007 and 2008) (1point) . 2. Prepare a two-page memorandum as requested by Mr. Johnstone. The memo should be divided into sections describing liquidity, asset management, long term debt ability, profitability and recommendations. (Times New Roman font, 12 points, 1.5 line spacing) (5 points) 3. Grammar/ Writing Style/ Presentation (0.5 point) Total: (10 points) In early January 2009, David Johnstone received the draft 2008 financial statements for Strong Tie and began to question the company's performance when compared to previous years. How were profits holding up, given the intense price competition in the industry? Were attempts to lower costs through more automation paying off? Were the current problems in the U.S. housing market going to continue to reduce demand for connectors? How would lenders react to this poor performance? Was the company's financing in danger? After discussing the matter with company accountant Audrey Johnstone, it was decided that an outside consultant should be hired to provide an independent analysis of the company's recent performance and to provide suggestions for future action. COMPANY BACKGROUND Strong Tie Ltd., located in Winnipeg, Manitoba, designed and manufactured the standardized and customized structural connectors used to reinforce wood joints in the construction of decks, fences, houses and other structures. Strong Tie was a family-owned corporation founded in 1946 by Bill Johnstone to capitalize on the high demand for housing as returning World War II veterans married and began families. Bill Johnstone died in 1975 but passed the business on to his son David, who continued to operate the business along with his three daughters, Ellen, Elizabeth and Audrey. David served as CEO, while Ellen Johnstone, P.Eng, was responsible for product design and production; Elizabeth Johnstone, CSP, managed marketing, sales and distribution; and Audrey Johnstone, CA, managed the company's finances. The Johnstone family was a pillar of the Winnipeg business community, making sizeable donations to local charities and sport teams. The standardized connectors were designed in Winnipeg based on input from architects, draftsmen and builders. The production process was highly automated with metal cutting, stamping and drilling machines completing most of the tasks. Human intervention was required to transfer work-in-process between stations, to feed machines and to pack, store and distribute the end products. This automation had allowed production to remain in Canada to date despite fierce competition from low-wage countries, particularly China. Customized connectors were produced based on specifications provided by the customer. Production of these units was more labour-intensive, but margins were still significantly higher as contractors were prepared to pay a premium to have their special needs met. Strong Tie prided itself on its product design capabilities. Designers in Winnipeg consistently generated an array of new standardized connectors that improved on existing products or addressed newly identified industry needs. These products were described in detail in terms of dimension, strength (load-bearing weights and steel gauge) and installation on the company's website or in a paper catalogue located in stores - both were of very high quality. Strong Tie also had a reputation among construction professionals as providing innovative solutions to unique design requests and being able to produce customized products in a timely manner at a reasonable price. Standardized products were distributed through all national home improvement chains in North America including Home Depot, Lowe's, Rona, Home Hardware, Eagle and Sears. Most local chains catering to contractors also carried the standardized products and accepted requests for customized connectors, which they then forwarded to Strong Tie. Strong Tie was estimated to have a 60 per cent market share, which had fallen from 70 per cent in recent years. Universal Connector, a U.S. firm based in Ohio, was estimated to have a 30 per cent and growing share; it offered a similar array of standardized products and customized design services. The remainder of the market was served by five Chinese producers whose market share had grown considerably in the last five years, although they had yet to enter the customized product segment. Universal Connector had closed a number of its U.S. manufacturing facilities in recent years and replaced them with new facilities in China, which put considerable downward pressure on industry prices. Currently, Strong Tie priced its products at a premium to its competitors because of its industry leadership. All sales were on terms Net 60. Large accounts such as Home Depot had a reputation of stretching their payments past the due date because of their buying power, while contractors frequently delayed payments due to cash flow problems. All purchases, which were primarily steel, were on terms 2/10, Net 60. Metal prices varied considerably, and the trend over 2006 to 2008 was for these prices to rise due to increasing demand from emerging market countries, particularly Brazil, Russia, India and China. Strong Tie had attempted to adopt just-in-time inventory practices to help reduce its raw material, work-in-process and finished goods inventory levels The Johnstone family maintained excellent relations with its unionized workforce, which was represented by the United Steel Workers of America. They prided themselves on paying generous wages and providing their workers with excellent health care, disability and pension benefits. The company had never had a strike and was currently negotiating a new collective agreement to take effect in three months on April 1, 2009. In recent years, Strong Tie had been investing heavily in factory automation to improve its competitiveness. Automatic feeders and packaging equipment had been purchased to further reduce labour costs, and new computers and software had helped to speed up the design of high-margin customized connectors. A new, more automated warehouse had also been constructed. FINANCIAL STATEMENTS Exhibits 1 and 2 contain the income statements and balance sheets for Strong Tie for the last three years, FINANCIAL BENCHMARKS Reliable industry average information was not available for Strong Tie's Chinese competitors, but comparable ratios were available for Universal Connector, a public company, in 2008. These ratios are contained in Exhibit 3. FINANCING Strong Tie had a $2,000,000, five-year, revolving credit agreement with the Bank of Nova Scotia, which was used to finance the company's working capital requirements as well as a number of individual term loans to finance fixed assets. The revolving credit agreement was committed, so as long as the loan conditions were met, financing was guaranteed. The loan had to be secured 100 per cent by accounts receivable and inventory. The receivables were primarily with large retail chains that were in good financial health, so the Bank of Nova Scotia was prepared to lend 90 per cent of their value. They were also willing to lend 60 per cent of the value of the finished goods and work-in-process inventory because of a strong re-sale market and the short production process. The bank would only lend 40 per cent of the value of raw materials inventory due to general instability in the commodities market. The revolving credit agreement had to be paid down to zero at least once per year. All loans required that the company maintain a Current Ratio of 1.5 or higher, a Cash Flow Coverage Ratio of 1.0 or higher and a Long-term Debt to Total Capitalization Ratio of 40 per cent or less. Audited quarterly and annual financial statements also had to be provided to the bank each quarter. As the sole owner of the corporation, David Johnstone did not take a salary, but his three daughters received over $1,000,000 in salary and bonuses each year. Preferred dividends of $500,000 were paid out to Mr. Johnstone's sister Katherine, who chose not to participate in the management of the business but was promised a regular income by her late father in lieu of receiving a share of the business. These dividends had to be paid unless the company entered bankruptcy. Exhibit 1 INCOME STATEMENTS 2006 2007 2008 $16,200 $17.450 $16.500 10.445 11.956 11.950 $5,755 $5,494 $4.550 3,054 3.130 3,379 396 720 756 $2,305 $1,644 $415 Nel Sales Cost of Goods Sold Gross Profit Selling and Administration Depreciation Operating Income Other Income Interest Income Other Expense Interest Expense Income Before Taxes Income Taxes Net income 21 10 2 246 $2,080 624 $1,456 291 $1,363 409 $954 407 $10 3 $7 Exhibit 2 BALANCE SHEETS 2006 2007 2008 $61 $234 1,034 3,250 1,025 200 2.030 182 $7.955 $122 488 3,450 1,350 138 1.700 143 $7,391 99 2.854 1,395 42 1.200 188 $5.839 Current Assets Cash Temporary Investment Accounts Receivable, Net Raw Materials Inventory WIP Inventory Finished Goods Inventory Prepaid Expenses Total Current Assets Fixed Assets Land. Plant, and Equipment Less: Accumulative Depreciation Net Land, Plant, Equipment Total Assets Current Liabilities Accounts Payable Income Taxes Payable Current Portion of Long-term Debt Total Current Liabilities Long-term Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity $4,893 $7,076 9.590 1.380 2.100 2.856 3,513 4,976 6,734 $11,468 $12,367 $12,573 $534 54 1.000 $1,588 3,190 $543 35 1,145 $1.723 3.500 500 23 1,340 $1,863 4.059 1,350 5,340 $6,690 $11,468 1,350 5,794 $7.144 $12,367 1,350 5,301 $6,651 $12.573 Exhibit 3 BENCHMARK RATIOS Ratio Current Ratio Cash Ratio Raw Materials Turnover in Days WIP Turnover in Days Finished Goods Turnover in Days A/R Turnover in Days A/P Turnover in Days Cash Conversion Cycle Fixed Asset Turnover Total Asset Turnover Long-term Debt to Total Capitalization Cash Flow Coverage Gross Profit Margin Operating Profit Margin Net Profit Margin ROA ROE Industry Average 4 .5 31 days 3 days 51 days 63 days 11 days 137 days 4.1 1.7 35% 2 32% 16% 10% 17% 28% . Questions to Answer: 1. Prepare the following Financial Exhibits for 2006, 2007, 2008. Ratio Table with Industry averages (liquidity, asset management, long term debt ability, profitability) (2 points) Common Size Income Statement and Balance Sheet (1 point) Dupont Analysis of ROE (0.5 point) Cash Flow Statements (for 2007 and 2008) (1point) . 2. Prepare a two-page memorandum as requested by Mr. Johnstone. The memo should be divided into sections describing liquidity, asset management, long term debt ability, profitability and recommendations. (Times New Roman font, 12 points, 1.5 line spacing) (5 points) 3. Grammar/ Writing Style/ Presentation (0.5 point) Total: (10 points)