Watson Leisure Time Sporting Goods Scenario: Al Thomas has recently been approached by his brother-in-law, Robert Watson, with a proposal to buy a 20 percent interest in Watson Leisure Time Sporting Goods. The company manufactures golf clubs, baseball bats, basketball goals, and other similar items. Mr. Watson is quick to point out the increase in sales over the last three years as indicated in the income statement, Exhibit 1. The annual growth rate is 20 percent. A balance sheet for a similar time period is shown in Exhibit 2, and selected industry ratios are presented in Exhibit 3. Note the industry growth rate in sales is only approximately 10 percent per year. There was a steady real growth of 2 to 3 percent in gross domestic product during the period under study. The rate of inflation was in the 3 to 4 percent range. The stock in the corporation has become available due to the ill health of a current stockholder, who needs cash. The issue here is not to determine the exact price for the stock, but rather whether Watson Leisure Time Sporting Goods represents an attractive investment situation. Although Mr. Thomas has a primary interest in the profitability ratios, he will take a close look at all the ratios. He has no fast and firm rules about required return on investment, but rather wishes to analyze the overall condition of the firm. The firm does not currently pay a cash dividend, and return to the investor must come from selling the stock in the future. After doing a thorough analysis (including ratios for each year and comparisons to the industry), what comments and recommendations do you offer to Mr. Thomas?

I have all of this completed but am having issues with one part. In which I need someone to help me figure out what I am doing wrong. The file is in Excel. Please Help.