Jim Harrod knew that service, above all, was important to his customers. Jim and Becky Harrod...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Jim Harrod knew that service, above all, was important to his customers. Jim and Becky Harrod had opened their first store in Omaha, Nebraska in 1997, Harrod's carried a full line of sporting goods including everything from baseball bats and uniforms to fishing gear and hunting equipment. By the year 2015, there were twelve Harrod stores producing $5 million in total sales and generating a profit of over $200,000 per series cach year in June and this generates a lot of interest in baseball (and softball as well). Jim, who had been a walk-on third string offensive tackle at the University of Nebraska (the Cornhuskers in Lincoln, Nebraska), took great pride in his stores as well as his prior university affiliation. He and Becky (also a University of Nebraska graduate in the early 1990s) contributed S2,000 annually to the University of Nebraska athletic program. The growth in the stores was the good news for Jim and Becky. The less than good news was the intense competition that they faced. Not only were they forced to compete with nationally established sporting good stores such as Oshman's and the year. On the positive side, there was an increasing demand for sporting goods as leisure time activities continued to grow. Also, the state of Nebraska, where all twelve located, experiencing moderate growth. Finally, there had been a sharp upturn in the last decade for women's sporting goods equipment. This was particularly true of softball uniforms for high school, college, and city league women's teams. Jim's wife Becky was one of the top softball players in the city of Omaha, and her extensive contacts throughout the state help to bring in new business. While Nebraska is primarily known as a football state, Omaha actually hosts the college baseball world stores were was Academy, but represented intense competition for the sporting goods dollar. The national stores were extremely competitive in terms of pricing However, Jim, Becky and their employees offered great personal service, and they hoped this would allow them to continue with their specialty niche. Walmart also In January of 2016, Becky, who served as the company's chief financial officer, walked into Jim's office and said, "I've had it with the First National Bank of Omaha. charge us 2% percentage points over prime. The prime rate is the rate at which banks make loans to their most creditworthy customers. It was 4.75 percent at the time Becky had visited the bank, so that the total rate on the loan would be 7.25 percent. It was not so much the total rate that Becky objected to, as the fact that Harrod's was being asked to pay 2% percent over prime. She felt that Harrod's was a strong enough company that one percent over prime should be all that the bank required. Her banker told her he would review the firm's financial statements with her next week and reconsider the premium Harrod's was being asked to pay over prime. While Becky knew the bank "crunched all the numbers," she decided to do some additional financial analysis on her own. She had a bachelor's degree in finance with a 3.3 GPA. She began by examining Figures 1, 2, and 3. is willing to renew our loan and line of credit, but the bank wants to 1. Compute the profitability ratios, including the a and b components (DuPont Methods) of ratios 2 and 3 as shown in the textbook. The profitability ratios should be shown for all three years. 2. Write a brief one-paragraph description of any trends that appear to have taken place over the three-year time period. 3. In examining the income statement in Figure 1, note that there was an extraordinary loss of S170,000 in 2015. This might have represented uninsured losses from a fire, a lawsuit settlement, etc. It probably does not represent a recurring event or affect the earnings capability of the fim. For that reason, the astute financial analyst might add back in the extraordinary loss to gauge the true operating carnings of the firm. Since it was a tax-deductible item, we must first multiply by (1-tax rate) before adding it back in. The tax rate was 35 percent for the year." Required S170,000 .65 S110,500 Extraordinary loss (1-tax rate) Aftertax addition to profits from eliminating the extraordinary loss from net income The more representative net income number for 2015 would now be: Initially reported (Figure 1) Adjustment for extraordinary loss being eliminated Adjusted net income $200,318 +110,500 S310,818 This adjustment was made because the $170.000 deduction saved 35 percent of this amount in taxes If we eliminate the S170,000, the tax benefit would also be climinated. Thus, the firm would only benefit by 65 percent of SI70,000, based on a 35 percent tax rate. The aflertax benefit of the tax adjustment for the extraoridinary loss is S110.500. Harrnd's Sporting Goods Based on the adjusted net income figure of $310,818, recompute the profitability ratios for 2015 (include parts a and b for ratios 2 and 3). 4. Now with the adjusted net income numbers as part of the ratios for 2015, write a brief one-paragraph description of trends that appear to have taken place over the three-year time period (refer back to the data in Question 1 for 2013 and 2014). 5. Once again, using the revised profitability ratios for 2015 that you developed in Question 3, write a complete one paragraph analysis of the company's profitability ratios compared to the industry ratios (figure 3). Make sure to include asset turnover and debt to total assets as supplemental material in your analysis. 6. Harrod's has a superior sales to total assets ratio compared to the industry. For 2015, compute ratios 4, 6 and 7 as described in the text and compare them to industry data to see why this is so. Write a brief one-paragraph description of the results. Note: for ratio 4, only half the sales are on credit terms. 7. Conclusion: Based on your analysis in answering Questions 4 and 5, do you think that Becky Harrod has a legitimate complaint about being charged 2% percent over prime instead of one percent over prime? There is no absolute right answer to this question, but use your best judgment. Required Figure 1 Harrod's Sporting Goods Income Statement (2013-2015) 2013 2014 2015 Sales $4,269,871 $4,483,360 $5,021,643 2,991,821 2,981,434 3,242,120 Cost of goods sold Gross $1,278,050 $1,501,926 $1,779,523 Profit Selling and administrative expense 865,450 1,004,846 1,175,100 S412,600 $497,080 $604,423 Operating profit Interest 115,300 122,680 126,241 expense Extraordinary 170,000 loss Net income before 297,300 374,400 308,182 taxes Taxes 104,100 31,300 107,864 Net $ 193,200 $ 243,100 $ 200,318 income Figure 2 Harrod's Sporting Goods Balance Sheet (2013-2015) 2013 2014 2015 Cash S 121,328 S 125,789 99,670 Marketable 56,142 66,231 144,090 securities wwww. Accounts 341,525 216,240 398,200 reçeivable Inventory 972,456 1,250,110 1,057,008 Total current $1,491,451 S1,658,370 S1,698,968 assets 1.678,749 702.280 1,811,142 Net plant and equipment Total $3,170,200 $3,360,650 S3,510.110 assets enoon Xunuodeenm Liabilities and Stockholders' Equity $ 539,788 $ 576,910 S 601,000 Accounts payable Notes 160,540 180,090 203,070 payable Total current S700,328 $757,000 S804,070 liabilities Long-term liabilities 1,292,995 1,372,240 1,265,272 Total S1,965,600 $2,049,995 $2,176,310 liabilities Common 367,400 368,000 368,000 stock Retained 837,200 942,665 965,800 earnings Total Stockholders" 1,204,600 1,310,655 1,333,800 equity Total liabilities and stockholders" $3,170,200 $3,360,650 S3,510,110 equity Figure 3 Harrod's Sporting Goods Selected Industry Ratios for 2015 1. Net income/Sales Net income/Total Assets Sales Total Assets Net income/Stockholder's Equity Debt/Total Assets Sales/Receivables 4.51% 5.10% 1.33 x 9.80% 2a. 2b. 3a. 3b. 0.48 5.75 x 4. Withdrawal of funds in the form of dividends or gther means makes the incrcase in retained carnings less than net income. Cupyreht Case 1 S. Sales/Inventory 6. 3.01 x Sales/Fixed Assets 3.20 x Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) A. Av Wrap Text Percentage 11 Copy A Merge & Center % > Con Form Paste Format B11 : x v fx A B 2 Mini-case #1- Chapter 3 3 Spring 2018 51. Profitabillty Ratios: 2013 2014 2015 Industry 7 la. Profit marginnet income/sales 4.50% 5.40% 4.00% 916. Retun on investment (assets)net income / total assets 6.10N 7.40% 5.80% 10 11 E DuPont = (net income / sales) x sales / total assets) 12 13 ld. Return on equity net income/ stockholders equity 14 15 le. Return on equity = retum on investment / (1- debt / assets) 16 17 3 Profitability Ratios: (2015 recalculated) 2013 2014 2015 18 19 la. Profit margin net income / sales 0.00% 20 21 ib Returm on investment (assets)net income/total assets 0.00% 23 1e. DuPont (net incame /sales x (sales / total ussets) 0.cON 24 25 1d. Return on equity net incone / tockholden equity 26 27 1e. Return on equityreturn on investment/(1 dett /assets) 0.00N 0.00% 29 6.Selected Asset Utilisation Ration 2015 Industry 31 Ga Recevables turnoereredt valen/average receivales 31 33 mentory turnover sales/avere investory 34 35 . Fed usset urnoversales/averge fieed aets Jim Harrod knew that service, above all, was important to his customers. Jim and Becky Harrod had opened their first store in Omaha, Nebraska in 1997, Harrod's carried a full line of sporting goods including everything from baseball bats and uniforms to fishing gear and hunting equipment. By the year 2015, there were twelve Harrod stores producing $5 million in total sales and generating a profit of over $200,000 per series cach year in June and this generates a lot of interest in baseball (and softball as well). Jim, who had been a walk-on third string offensive tackle at the University of Nebraska (the Cornhuskers in Lincoln, Nebraska), took great pride in his stores as well as his prior university affiliation. He and Becky (also a University of Nebraska graduate in the early 1990s) contributed S2,000 annually to the University of Nebraska athletic program. The growth in the stores was the good news for Jim and Becky. The less than good news was the intense competition that they faced. Not only were they forced to compete with nationally established sporting good stores such as Oshman's and the year. On the positive side, there was an increasing demand for sporting goods as leisure time activities continued to grow. Also, the state of Nebraska, where all twelve located, experiencing moderate growth. Finally, there had been a sharp upturn in the last decade for women's sporting goods equipment. This was particularly true of softball uniforms for high school, college, and city league women's teams. Jim's wife Becky was one of the top softball players in the city of Omaha, and her extensive contacts throughout the state help to bring in new business. While Nebraska is primarily known as a football state, Omaha actually hosts the college baseball world stores were was Academy, but represented intense competition for the sporting goods dollar. The national stores were extremely competitive in terms of pricing However, Jim, Becky and their employees offered great personal service, and they hoped this would allow them to continue with their specialty niche. Walmart also In January of 2016, Becky, who served as the company's chief financial officer, walked into Jim's office and said, "I've had it with the First National Bank of Omaha. charge us 2% percentage points over prime. The prime rate is the rate at which banks make loans to their most creditworthy customers. It was 4.75 percent at the time Becky had visited the bank, so that the total rate on the loan would be 7.25 percent. It was not so much the total rate that Becky objected to, as the fact that Harrod's was being asked to pay 2% percent over prime. She felt that Harrod's was a strong enough company that one percent over prime should be all that the bank required. Her banker told her he would review the firm's financial statements with her next week and reconsider the premium Harrod's was being asked to pay over prime. While Becky knew the bank "crunched all the numbers," she decided to do some additional financial analysis on her own. She had a bachelor's degree in finance with a 3.3 GPA. She began by examining Figures 1, 2, and 3. is willing to renew our loan and line of credit, but the bank wants to 1. Compute the profitability ratios, including the a and b components (DuPont Methods) of ratios 2 and 3 as shown in the textbook. The profitability ratios should be shown for all three years. 2. Write a brief one-paragraph description of any trends that appear to have taken place over the three-year time period. 3. In examining the income statement in Figure 1, note that there was an extraordinary loss of S170,000 in 2015. This might have represented uninsured losses from a fire, a lawsuit settlement, etc. It probably does not represent a recurring event or affect the earnings capability of the fim. For that reason, the astute financial analyst might add back in the extraordinary loss to gauge the true operating carnings of the firm. Since it was a tax-deductible item, we must first multiply by (1-tax rate) before adding it back in. The tax rate was 35 percent for the year." Required S170,000 .65 S110,500 Extraordinary loss (1-tax rate) Aftertax addition to profits from eliminating the extraordinary loss from net income The more representative net income number for 2015 would now be: Initially reported (Figure 1) Adjustment for extraordinary loss being eliminated Adjusted net income $200,318 +110,500 S310,818 This adjustment was made because the $170.000 deduction saved 35 percent of this amount in taxes If we eliminate the S170,000, the tax benefit would also be climinated. Thus, the firm would only benefit by 65 percent of SI70,000, based on a 35 percent tax rate. The aflertax benefit of the tax adjustment for the extraoridinary loss is S110.500. Harrnd's Sporting Goods Based on the adjusted net income figure of $310,818, recompute the profitability ratios for 2015 (include parts a and b for ratios 2 and 3). 4. Now with the adjusted net income numbers as part of the ratios for 2015, write a brief one-paragraph description of trends that appear to have taken place over the three-year time period (refer back to the data in Question 1 for 2013 and 2014). 5. Once again, using the revised profitability ratios for 2015 that you developed in Question 3, write a complete one paragraph analysis of the company's profitability ratios compared to the industry ratios (figure 3). Make sure to include asset turnover and debt to total assets as supplemental material in your analysis. 6. Harrod's has a superior sales to total assets ratio compared to the industry. For 2015, compute ratios 4, 6 and 7 as described in the text and compare them to industry data to see why this is so. Write a brief one-paragraph description of the results. Note: for ratio 4, only half the sales are on credit terms. 7. Conclusion: Based on your analysis in answering Questions 4 and 5, do you think that Becky Harrod has a legitimate complaint about being charged 2% percent over prime instead of one percent over prime? There is no absolute right answer to this question, but use your best judgment. Required Figure 1 Harrod's Sporting Goods Income Statement (2013-2015) 2013 2014 2015 Sales $4,269,871 $4,483,360 $5,021,643 2,991,821 2,981,434 3,242,120 Cost of goods sold Gross $1,278,050 $1,501,926 $1,779,523 Profit Selling and administrative expense 865,450 1,004,846 1,175,100 S412,600 $497,080 $604,423 Operating profit Interest 115,300 122,680 126,241 expense Extraordinary 170,000 loss Net income before 297,300 374,400 308,182 taxes Taxes 104,100 31,300 107,864 Net $ 193,200 $ 243,100 $ 200,318 income Figure 2 Harrod's Sporting Goods Balance Sheet (2013-2015) 2013 2014 2015 Cash S 121,328 S 125,789 99,670 Marketable 56,142 66,231 144,090 securities wwww. Accounts 341,525 216,240 398,200 reçeivable Inventory 972,456 1,250,110 1,057,008 Total current $1,491,451 S1,658,370 S1,698,968 assets 1.678,749 702.280 1,811,142 Net plant and equipment Total $3,170,200 $3,360,650 S3,510.110 assets enoon Xunuodeenm Liabilities and Stockholders' Equity $ 539,788 $ 576,910 S 601,000 Accounts payable Notes 160,540 180,090 203,070 payable Total current S700,328 $757,000 S804,070 liabilities Long-term liabilities 1,292,995 1,372,240 1,265,272 Total S1,965,600 $2,049,995 $2,176,310 liabilities Common 367,400 368,000 368,000 stock Retained 837,200 942,665 965,800 earnings Total Stockholders" 1,204,600 1,310,655 1,333,800 equity Total liabilities and stockholders" $3,170,200 $3,360,650 S3,510,110 equity Figure 3 Harrod's Sporting Goods Selected Industry Ratios for 2015 1. Net income/Sales Net income/Total Assets Sales Total Assets Net income/Stockholder's Equity Debt/Total Assets Sales/Receivables 4.51% 5.10% 1.33 x 9.80% 2a. 2b. 3a. 3b. 0.48 5.75 x 4. Withdrawal of funds in the form of dividends or gther means makes the incrcase in retained carnings less than net income. Cupyreht Case 1 S. Sales/Inventory 6. 3.01 x Sales/Fixed Assets 3.20 x Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) A. Av Wrap Text Percentage 11 Copy A Merge & Center % > Con Form Paste Format B11 : x v fx A B 2 Mini-case #1- Chapter 3 3 Spring 2018 51. Profitabillty Ratios: 2013 2014 2015 Industry 7 la. Profit marginnet income/sales 4.50% 5.40% 4.00% 916. Retun on investment (assets)net income / total assets 6.10N 7.40% 5.80% 10 11 E DuPont = (net income / sales) x sales / total assets) 12 13 ld. Return on equity net income/ stockholders equity 14 15 le. Return on equity = retum on investment / (1- debt / assets) 16 17 3 Profitability Ratios: (2015 recalculated) 2013 2014 2015 18 19 la. Profit margin net income / sales 0.00% 20 21 ib Returm on investment (assets)net income/total assets 0.00% 23 1e. DuPont (net incame /sales x (sales / total ussets) 0.cON 24 25 1d. Return on equity net incone / tockholden equity 26 27 1e. Return on equityreturn on investment/(1 dett /assets) 0.00N 0.00% 29 6.Selected Asset Utilisation Ration 2015 Industry 31 Ga Recevables turnoereredt valen/average receivales 31 33 mentory turnover sales/avere investory 34 35 . Fed usset urnoversales/averge fieed aets
Expert Answer:
Answer rating: 100% (QA)
First four parts have been answered Answer 1 All ratios are in Year 2013 2014 2015 Gross profit rati... View the full answer
Related Book For
Fundamental Statistics for the Behavioral Sciences
ISBN: 978-1285076911
8th Edition
Authors: David C. Howell
Posted Date:
Students also viewed these accounting questions
-
To ensure a full line of outdoor clothing and accessories, the marketing department at Teddy Bower insists that they also sell waterproof hunting boots. Unfortunately, neither Teddy Bower nor Teddy...
-
US Copiers manufactures a full line of copiers including desktop models. The Small Copier Division (SCD) manufactures desktop copiers and sells them in the United States. A typical model has a retail...
-
Aspen View produces a full line of sunglasses. This year it began producing a new model of sun-glasses, the Peak 32. It produced 5,300 pairs and sold 4,900 pairs. The following table summarizes the...
-
In what circumstances have courts opted to use the substantial-factor test rather than the but-for test?
-
In the diagram, regions A and C extend far to the left and right, respectively. The electric field due to the two point charges is zero at some point in which region or regions? Explain. -B- -4 C +2...
-
Electrons in a cathode ray tube start from rest and are accelerated through a potential difference of 12.0 kV. They are moving in the + x -direction when they enter the space between the plates of a...
-
How have changes in society, laws and technology affected the UK labour market?
-
A manager of Varden Sporting Goods Company is considering accepting an order from an overseas customer. This customer has requested an order for 20,000 dozen golf balls at a price of $ 22 per dozen....
-
Based on the corporate valuation model, Gray Entertainment's total corporate value is $1,475 million. The company's balance sheet shows $160 million of notes payable, $320 million of long-term debt,...
-
Two light waves E x = E 0 cos (kz - t) and E y = -E 0 cos (kz - t) overlap in space. Show that the resultant is linear light and determine its amplitude and tilt angle .
-
QUESTION TWO Solve the following pde's by the operator method. (i) Uxxx - 2Uxxy = 2ex + 3xy (ii) Uxx + Uxy - 6Uyy = y cos x [8 Marks] [7 Marks] QUESTION THREE (a) Given the pde Uxx = U,U(x,0)=x...
-
What is the nominal appreciation/depreciation rate of USD? (2 points) (2) What is the real appreciation/depreciation rate of USD? (4 points) (3) Do you expect the exports of the US to Argentina would...
-
A project is expected to have the following cash flows: Year Cash flow ($000) 0 (1,900) 1 300 2 500 3 600 4 800 5 500 What is the expected payback period?
-
Suppose you take out a 20-year mortgage for a house that costs $470,987. Assume the following: The annual interest rate on the mortgage is 5%. The bank requires a minimum down payment of 11% at the...
-
Three boilers have capacities of 200kr and 250kr. If 150, 000kg of coal are supplied to three boilers for 10 days. What is the capacity of the third boiler? A. 200kr C. 175k r B. 250k 9 D. 150k r
-
Compute the monthly payments on a 2-year lease for a $29,273 car if the annual rate of depreciation is 18% and the lease's annual interest rate is 3.3%. Round your answer to the nearest dollar.
-
A car consumes 1 3 . 2 5 gallons of fuel when driving a distance of 4 0 0 . 0 miles. How many liters of gasoline will it consume when driving 7 7 5 . 0 kilometers?
-
A genetically engineered strain of Escherichia coli (E. coli) is used to synthesize human insulin for people suffering from type I diabetes mellitus. In the following simplified reaction scheme,...
-
What can we conclude from the data on infant mortality?
-
In examples like the Guber study on the funding of education, we frequently speak of variables like PctSAT as nuisance variables. In what sense is that usage reasonable here, and in what sense is it...
-
Several times in this chapter I have drawn a parallel between hypothesis testing and our judicial system. How would you describe the workings of our judicial system in terms of Type I and Type II...
-
a. The equation of the Phillips curve from 1970 to 1995 is: \[\pi_{t}-\pi_{t-1}=7.4 \%-1.2 u_{t}\] Calculate and define the natural rate of unemployment using this curve. b. The equation of the...
-
Suppose that the mark-up of goods prices over marginal cost is \(5 \%\), and that the wage-setting equation is: \[W=P(1-u)\] where \(u\) is the unemployment rate. a. What is the real wage, as...
-
How can a lockdown result in stagflation? A lockdown can have three different effects: a. The first happens when demand during the lockdown decreases so that actual output, \(Y_{t}\), falls exactly...
Study smarter with the SolutionInn App