It is the second week of January 2018. The Chief Executive Officer (CEO) of West Point...

  
 
 

Transcribed Image Text:

It is the second week of January 2018. The Chief Executive Officer (CEO) of West Point Supply, Inc. (WPS), Mr. Donnie Glover, is preparing for a meeting with the company's bank, Welles Forgo Bank & Trust (Welles Forgo). To prepare for the meeting, Mr. Glover is reviewing the company's 2017 financial statements. He is working with the knowledge that 2017 was a very good year for WPS both in sales and in profits, and he is hopeful the company's bank will recognize this achievement. Such an outcome is important because in early 2017 WPS had arranged a term loan, for the first time ever, and its initial repayment installment of $40,000 is due in February 1, 2018. Mr. Glover hopes that the company's strong results during 2017 will impress Ms. Carrie Lowe, the bank's loan officer. He is confident that the approaching loan payment is within WPS's financial capacity following its best year ever. He expects to send Ms. Lowe the company's 2017 financial statements soon so that she can review them before the due date of the loan. The Company WPS was organized by Mr. Glover in 2001 as a wholesaler of electrical supplies and equipment to building contractors in and around Pittsburgh, PA. After a contraction during the recession of 2007-2009 its sales had grown through the following 10 years. The company has built a reputation for rapid delivery on a wide array of materials required by builders, many of whom are not well-capitalized and cannot finance an extensive inventory themselves. Mr. Glover believes WPS's competitive advantage depends on this reputation. An implication of this strategy is that WPS must carry substantial inventory. As a result, through time, the company had to rent warehouse space in growing capacity. To stock its inventory WPS purchases supplies from an array of dealers. WPS's suppliers sell to WPS on credit terms of 2/15, net 30 days. All of WPS's purchases are on credit. In turn, the company sells to builders on credit terms of net 30 days and all sales are credit sales. During the latter part of 2016, a decision was made to construct a new warehouse adjacent to the company's main offices and existing storerooms. The new building meant that WPS no longer needed to rent warehouse space -- which represents a saving for the company. The Loan When the financial statements for the year 2016 were completed, Mr. Glover had visited Welles Forgo to secure a loan. Historically, WPS maintained operating cash balances with the bank ranging from $20,000 to $60,000.! Never before, however, had the company sought a loan either for seasonal or longer-term capital requirements. Mr. Glover discussed with Ms. Lowe the possibilities for bank support of WPS's building expansion. He presented to her the 2016 statements, together with a forecast for 2017 which included the anticipated expenditures for construction, and savings on warehouse rental fees (see Exhibits 1 and 2). 1 The numbers in this case may appear to be "too small" to be realistic or worth worrying about. If so, just add three zeroes to all numbers. The concepts employed will be the same regardless of the dollars involved. Based on these financial statements, on her conversations with Mr. Glover, and on her general knowledge of the building and building-supply business, Ms. Lowe and the bank agreed to loan $120,000 to WPS to help finance the proposed new facilities and the customary seasonal increase in sales that occurs during the spring and summer of each year. The loan was structured as a three-year loan, with repayments of principal of $40,000 due on February 1 of 2018, 2019, and 2020. The loan carries an interest rate of 12 percent per year. Mr. Glover visited Ms. Lowe periodically throughout 2017 to update the bank on the company's progress. The new warehouse was completed in May of 2017 and Ms. Lowe participated in the "grand opening" ceremonies. She had been informed in October of 2017 that an especially good sales record was expected for the full year. Exhibit 1 West Point Supply, Inc. Balance Sheets as of December 31 ASSETS Actual Forecast Actual 2016 2017 2017 $ 93,700 $ 52,000 $ 55,000 278,200 Cash Accounts Receivable 198,100 228,000 Inventory Current Assets 300,000 $580,000 265,300 504.600 $557,100 $827,800 117,500 (16,500) 148,500b (17,000) Gross fixed assets 72,500 Less: Accumulated depreciation Net fixed assets (31,500) $ 41,000 $101,000 $131,500 Total Assets $598,100 $681,000 $969,300 LIABILITIES $ 34,600 7,100 S 34,000 Accounts payable Miscellaneous accrued liability Accrued income tax due Current Liabilities $213,500 5,000 47,000 $ 86,000 11,900 49.200° 32,400 $ 74,100 274,600 Capital stock (par $50) Retained earnings 180,000 344,000 180,000 180,000 387,000 394,700 Total Liabilities & Owners Equity (before bank loan) $598,100 $653,000 $849,300 Funds needed (Bank loan) $ 28,000 $120,000 Total Liabilities & Owners Equity $681,000 $969,300 (after bank loan) a Inventory accounted for on a FIFO basis. b. After planned write-off during 2017 of fully depreciated equipment originally costing $20,000. * Payable in March 2018. Exhibit 2 West Point Supply, Inc. Income Statements for Years Ended December 31 Actual Forecast Actual 2016 2017 2017 Sales $1,555,800 $1,873,000 $2,540,600 Cost of goods solda Gross margin (1,012,500) (1,183,000) (1,685,200) 543,300 690,000 855,400 Operating expenses Operating income (432.200) (517,000) (664,900) 111,100 173,000 190,500 Depreciation expense Earnings before tax Interest expense (2,600) (5,000) (5,500) 108,500 168,000 185,000 Federal income tax (52,000) (80,000) (89,300) Earnings after tax 56,500 88,000 95,700 Dividends paid (30,000) (45,000) (45,000) Retained earnings $ 26,500 $ 43,000 $ 50,700 a Actual purchases during 2016 were $1,052,000. Forecast purchases for 2017 were $1,217,700. Actual purchases during 2017 were $1,924,500. Interest expense is negligible (i.e., too small to be of importance) in 2016 and for 2017 forecast and actual. Assignment: Use key financial ratios to determine what events occurred during 2017 to affect the company's financial position. Ratios are presented in the case packet reading "Financial Planning, Financial Ratios and Pro Forma Financial Statements" and in RWJ&J. а. Be prepared to address the following questions: Is the company growing (i.e., calculate the year-to-year growth rate of sales)? Are receivables in control? (Calculate days sales outstanding (DSO) through time.) Is inventory in control? (Calculate days of inventory through time.) Are payables being managed prudently (Note: See footnote a to the income statements)? Is the company's debt usage in control? Is cost of goods sold in control? Are operating and administrative expenses in control? Is the company profitable? profitability improving? (Pay particular attention to the following ratios. These ratios can be used to answer the preceding questions: days sales outstanding (DSO), days of purchases outstanding (DPO), days of inventory, total debt ratio, profit ratios and interest coverage ratio.) In addressing these questions, calculate the ratios for each year's actual financial statements and for the forecast financial statements. In calculating ratios, use end-of-period balances except for profit ratios. (Use the beginning of year balance sheet data in calculating profit ratios.) Is b. What implications do the deviations from plan and the general 2017 operating results have for the company and the bank? What financial strategies seem desirable during 2018? (Be especially aware of the implicit cost of trade credit. See the reading in the case packet.) с. If you were WPS's banker, what would you do? It is the second week of January 2018. The Chief Executive Officer (CEO) of West Point Supply, Inc. (WPS), Mr. Donnie Glover, is preparing for a meeting with the company's bank, Welles Forgo Bank & Trust (Welles Forgo). To prepare for the meeting, Mr. Glover is reviewing the company's 2017 financial statements. He is working with the knowledge that 2017 was a very good year for WPS both in sales and in profits, and he is hopeful the company's bank will recognize this achievement. Such an outcome is important because in early 2017 WPS had arranged a term loan, for the first time ever, and its initial repayment installment of $40,000 is due in February 1, 2018. Mr. Glover hopes that the company's strong results during 2017 will impress Ms. Carrie Lowe, the bank's loan officer. He is confident that the approaching loan payment is within WPS's financial capacity following its best year ever. He expects to send Ms. Lowe the company's 2017 financial statements soon so that she can review them before the due date of the loan. The Company WPS was organized by Mr. Glover in 2001 as a wholesaler of electrical supplies and equipment to building contractors in and around Pittsburgh, PA. After a contraction during the recession of 2007-2009 its sales had grown through the following 10 years. The company has built a reputation for rapid delivery on a wide array of materials required by builders, many of whom are not well-capitalized and cannot finance an extensive inventory themselves. Mr. Glover believes WPS's competitive advantage depends on this reputation. An implication of this strategy is that WPS must carry substantial inventory. As a result, through time, the company had to rent warehouse space in growing capacity. To stock its inventory WPS purchases supplies from an array of dealers. WPS's suppliers sell to WPS on credit terms of 2/15, net 30 days. All of WPS's purchases are on credit. In turn, the company sells to builders on credit terms of net 30 days and all sales are credit sales. During the latter part of 2016, a decision was made to construct a new warehouse adjacent to the company's main offices and existing storerooms. The new building meant that WPS no longer needed to rent warehouse space -- which represents a saving for the company. The Loan When the financial statements for the year 2016 were completed, Mr. Glover had visited Welles Forgo to secure a loan. Historically, WPS maintained operating cash balances with the bank ranging from $20,000 to $60,000.! Never before, however, had the company sought a loan either for seasonal or longer-term capital requirements. Mr. Glover discussed with Ms. Lowe the possibilities for bank support of WPS's building expansion. He presented to her the 2016 statements, together with a forecast for 2017 which included the anticipated expenditures for construction, and savings on warehouse rental fees (see Exhibits 1 and 2). 1 The numbers in this case may appear to be "too small" to be realistic or worth worrying about. If so, just add three zeroes to all numbers. The concepts employed will be the same regardless of the dollars involved. Based on these financial statements, on her conversations with Mr. Glover, and on her general knowledge of the building and building-supply business, Ms. Lowe and the bank agreed to loan $120,000 to WPS to help finance the proposed new facilities and the customary seasonal increase in sales that occurs during the spring and summer of each year. The loan was structured as a three-year loan, with repayments of principal of $40,000 due on February 1 of 2018, 2019, and 2020. The loan carries an interest rate of 12 percent per year. Mr. Glover visited Ms. Lowe periodically throughout 2017 to update the bank on the company's progress. The new warehouse was completed in May of 2017 and Ms. Lowe participated in the "grand opening" ceremonies. She had been informed in October of 2017 that an especially good sales record was expected for the full year. Exhibit 1 West Point Supply, Inc. Balance Sheets as of December 31 ASSETS Actual Forecast Actual 2016 2017 2017 $ 93,700 $ 52,000 $ 55,000 278,200 Cash Accounts Receivable 198,100 228,000 Inventory Current Assets 300,000 $580,000 265,300 504.600 $557,100 $827,800 117,500 (16,500) 148,500b (17,000) Gross fixed assets 72,500 Less: Accumulated depreciation Net fixed assets (31,500) $ 41,000 $101,000 $131,500 Total Assets $598,100 $681,000 $969,300 LIABILITIES $ 34,600 7,100 S 34,000 Accounts payable Miscellaneous accrued liability Accrued income tax due Current Liabilities $213,500 5,000 47,000 $ 86,000 11,900 49.200° 32,400 $ 74,100 274,600 Capital stock (par $50) Retained earnings 180,000 344,000 180,000 180,000 387,000 394,700 Total Liabilities & Owners Equity (before bank loan) $598,100 $653,000 $849,300 Funds needed (Bank loan) $ 28,000 $120,000 Total Liabilities & Owners Equity $681,000 $969,300 (after bank loan) a Inventory accounted for on a FIFO basis. b. After planned write-off during 2017 of fully depreciated equipment originally costing $20,000. * Payable in March 2018. Exhibit 2 West Point Supply, Inc. Income Statements for Years Ended December 31 Actual Forecast Actual 2016 2017 2017 Sales $1,555,800 $1,873,000 $2,540,600 Cost of goods solda Gross margin (1,012,500) (1,183,000) (1,685,200) 543,300 690,000 855,400 Operating expenses Operating income (432.200) (517,000) (664,900) 111,100 173,000 190,500 Depreciation expense Earnings before tax Interest expense (2,600) (5,000) (5,500) 108,500 168,000 185,000 Federal income tax (52,000) (80,000) (89,300) Earnings after tax 56,500 88,000 95,700 Dividends paid (30,000) (45,000) (45,000) Retained earnings $ 26,500 $ 43,000 $ 50,700 a Actual purchases during 2016 were $1,052,000. Forecast purchases for 2017 were $1,217,700. Actual purchases during 2017 were $1,924,500. Interest expense is negligible (i.e., too small to be of importance) in 2016 and for 2017 forecast and actual. Assignment: Use key financial ratios to determine what events occurred during 2017 to affect the company's financial position. Ratios are presented in the case packet reading "Financial Planning, Financial Ratios and Pro Forma Financial Statements" and in RWJ&J. а. Be prepared to address the following questions: Is the company growing (i.e., calculate the year-to-year growth rate of sales)? Are receivables in control? (Calculate days sales outstanding (DSO) through time.) Is inventory in control? (Calculate days of inventory through time.) Are payables being managed prudently (Note: See footnote a to the income statements)? Is the company's debt usage in control? Is cost of goods sold in control? Are operating and administrative expenses in control? Is the company profitable? profitability improving? (Pay particular attention to the following ratios. These ratios can be used to answer the preceding questions: days sales outstanding (DSO), days of purchases outstanding (DPO), days of inventory, total debt ratio, profit ratios and interest coverage ratio.) In addressing these questions, calculate the ratios for each year's actual financial statements and for the forecast financial statements. In calculating ratios, use end-of-period balances except for profit ratios. (Use the beginning of year balance sheet data in calculating profit ratios.) Is b. What implications do the deviations from plan and the general 2017 operating results have for the company and the bank? What financial strategies seem desirable during 2018? (Be especially aware of the implicit cost of trade credit. See the reading in the case packet.) с. If you were WPS's banker, what would you do?

Answer rating: 100% (QA)

a 1 Yes 2 Yes 3 No 4 No 5 Yes 6 No 7 Yes 8 Yes b The constructionsupply industry would have a decent chance of growing This would almost certainly res... View the full answer