ZuoTi.Pro
Question
Here the handout along with the template of what we need to complete. Thank you!
Harrods Sporting Goods 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. Harrods 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 year. series each 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 $2,000 annually to the University of Nebraska athletic program. 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 stores were located, was experiencing moderate growth. Finally there had been a sharp upturn in the last decade for womens sporting goods equipment. This was particularly true of softball uniforms for high school, college, and city league womens teams. Jims wife Becky was one of the top softball players in the city of Omaha, and her extensive 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 Oshmans and the Academy, but Walmart also 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. in new business. While Nebraska is primarily known as a football state, Omaha actually hosts the college baseball world
In January of 2016, Becky, who served as the companys chief financial officer, walked into Jims office and said, Ive had it with the First National Bank of Omaha. It is willing to renew our loan and line of credit, but the bank wants to 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 Harrods was being asked to pay 2% percent over prime. She felt that Harrods 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 firms financial statements with her next week and reconsider the premium Harrods 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 bachelors degree in finance with a 3.3 GPA. She began by examining Figures 1, 2, and 3. Required 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 earmings 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 up adding it back in. The tax rate was 35 percent for the year S170,000Extraordinary loss 65 (1-tax rate) S1T0,500Attertas addition to profits from eliminating the extraordinary loss from net income trhe more representative net income number for 2015 would now be $200,318 Adjustment for extraordinary loss being eliminated110.500 Initially reported (Figure 1) Adjusted net income $310,818 This adjustment was made because the S170,000 deduction saved 35 percent of this amount in taxes. If we eliminate the $170,000, the tax benefit would also be climinated. Thus, the firm wouid only benefit by 65 percent of s170,000, based on a 35 percent tax rate. The atterax benefit of the tax adjustment for the extraordinary loss is $110,500
Harrods Sporting Goods Required 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). 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). 4. 5. Once again, using the revised profitability ratios for 2015 that you developed in Question 3, write a complete one paragraph analysis of the companys 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. Harrods 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. 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 7.
Figure 1 Harrods Sporting Goods Income Statement (2013-2015) 2014 $4,269,871 $4,483,360 $5,021,643 2013 2015 Sales Cost of goods sold 2,991,821 2,981434 3,242,120 Gross Profit $1,278,050 $1,501,926 $1,779,52:3 Selling and administrative expense 865,450 1,004,846 1.175,100
Operating profit $412,600 $497,080 $604,423 Interest 115,300122,680126,241 expense 170,000 loss Net income before taxes 297,300374,400 308,182 Taxes 104,100 131300 107864 S 193,200 243,100 $ 200,318 Net income Figure 2 Harrods Sporting Goods Balance Sheet (2013-2015) 2014 2015 99,670 2013 Cash S 121,328 S 125,789 56,14266,231 144,090 Marketable securities 341,525 216,240 398,200 Accounts reçeivable Inventory 972.456 1,230,110 1,057,008 Total current $1,491,451 $1,658,370 $1,698,968 assets 1.678,749 4.702.280 1.811.142 Net plant and equipment Total assets $3,170,200 $3,360,650 S3,510,110
Liabilitiles and Stockholders Equity S 539,788 $ 576,910 S 601,000 160,540 180,090 203,070 $700,328$757,000 $804,070 1265,272 1292,995 1372,240 S1,965,600 $2,049,995 $2,176,310 367,400 368000 368,000 837.200 942,665 965,800 1204.600 1310,655 1333.800 Accounts payable Notes payable Total current liabilities Long-term liabilities Total liabilities Commor stock Retained earnings Total Stockholders equity Total liabilities and stockholders equity $3,170,200 S3,360,650 S3,510,110 Figure 3 Harrods Sporting Goods Selected Industry Ratios for 2015 Net income/Sales 2a.Net income/Total Assets 2b 3a. Net income/Stockholders Equity 3b.Debt/Total Assets 4.51% 5.10% 1.33 x 9.80% 0.48 5.75 x Sales Total Assets Sales Receivables W ithdrawal of funds in the form of dividends or other mcans makes the sncrease in retainod earnings less than net income,
Case 1 3.01 x Sales/Inventory 6. 5. Sales/Fixed Assets 3.20 x
Home Insert Page Layout Formulas Data Review View .xCut Copy = =圓秒· cut . Calibri (Body) Calit ritBody) -111 11 A4 A, A- A▼ ! 印wrap Text wrap Text Percentage . Paste B I U Forn Format Mini-case #1-Chapter 3 Spring 2018 2 3 5 1. Profitability Ratios: 2014 2015 7 la. Profit margin net income/sales 9 lb. Return on investment (assets) net income / total assets 10 11 3c DuPont(net income / sales) x(sales/total assets) 12 13 Ld. Return on equity net income / stockholders equity le. Return on equity-return on investment , (1-debt , assets) 16 17 3 Profitability Ratios: (2015 recalculated) 18 19 1a. Profit margin net income , sales 20 2013 2014 2015 0.00% tb. Return on investment (assets) - net income /total assets 21c DuPont (net income / sales) x (sales/ total assets) 25 id. Return on equity- income , stockholders equity 0.00% 0.00% e Return on equity retur on investment / debe/assets) &Selected Asset Utilieation Ratios Industry th inventory turnover sales/average inventory c. Fixed asset turnover e sales / average fixed assets
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1
Profitability ratios as 2013 2014 2015 industry
Profit margin = (net income /sales) 4.50% 5.40% 4.00% 4.51%
Return on investment = (net income/total assets) 6.10% 7.40% 5.80% 5.10%
DuPont = (net income/sales)x(sales/total assets) 6.06% (0.045x4269871/3170200) 7.20% (0.054x4483360/3360650 5.72% (0.040x5021643/3510110) 6% (1.33x4.51)
Return on equity = (net income/stockholder equity) 16.04% {(193200/1204600)x100} 18.55% {(243100/1310655)x100} 15.02% {(200318/1333800)x100} 9.80%
Return on equity = (return on investment / (1- debt/asset))

16.05%

6.10/{1-(1965600/3170200)}

18.97%

7.40 / {1-(2049995/3360650)}

15.26%

5.80 / {1-(2176310/3510110)}

2 . We can clearly see that profitability margin , return on investment , DuPont, return on equity all these profitability ratio rose at a very high rate from 2013 to 2014 however in the year 2015 there was a sharp decline in all these profitability ratios that it not even fell below the ratios mentioned in 2014 but even fall below the level of year 2013. Reasons may be attributed to various causes like stuff competition faced from competitors emerged in the industry another reason may re the extraordinary losses put by the accountant to offset the extraordinary gain. Also the after effects of the event thst gave ride to extraordinary income may have hampered the earning capacity of the business

3. Profitability ratios calculated after adjustment :-

Profitability ratios 2013 2014 2015 industry
Profit margin = (net income /sales) 4.50% 5.40% 6.19% (310818/5021643) 4.51%
Return on investment (net income / total assets ) 6.10% 7.40% 8.85% (310818/3510110) 5.10%
DuPont (net income/sales)x(sales/total asset)

6.06%

(0.045x4269871/3170200)

7.20%

(0.054x4483360/3360650)

 8.86% (0.0619x5021643/3510110) 6% (1.33x4.51)
Return on equity = (net income/stockholder equity)

16.04%

{(193200/1204600)x100}

18.55%

(243100/1310655x100)

23.30%

{(310818/1333800)x100}

 9.80%
Return on equity = (return on investment / (1-debt/asset)

16.05%

6.10/{1-(1965600/3170200)}

18.97%

7.40/(1-{2049995/3360650}

23.29%

8.85/(1-{2176310/3510110})

4. Now after adjustment we can clearly seen that growth observed from year 2013 to 2014 is further extended to the year 2015. And we can see all profitability ratios further riding in year 2015.

5. Profitability margin of the company is 6.19% whereas profitability margin of industry is around 4.51% which shows we are able to gain more profitability and thus incurring lesser expense as compared to industry as a whole.

As far as Return on investment is concerned company has a return on investment of around 8.85% whereas industry average is around 5.10% which shows we are utilising out asset more effectively then industry as a whole also DuPont of the company is better than industrial average which again shows we are using our asset well.

Return on equity of the company is around 23.30% whereas industrial average is around 9.80% this company is generating double return for it's investor as compared to industry which also goes to show that company is better on trading in equity compared to industry.

Note : due to shortage of time on question answer board I am able to solve this much please upload the remaining portion of the question, I will definitely complete it then.

I am extremely sorry for inconvenience caused to you.

Inconvenience caused to you is highly regretted.

2 0
Add a comment
Know the answer?
Add Answer to:
Here the handout along with the template of what we need to complete. Thank you! Harrod's...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Taking it to the Net  P3   BTN 17-5  Access the February 26, 2016, filing of the December 31,...

    Taking it to the Net  P3   BTN 17-5  Access the February 26, 2016, filing of the December 31, 2015, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2015, and December 31, 2014. Interpret its profitability using the results obtained for these two years. Profit margin ratio (round the percent to one decimal). Gross profit ratio (round the percent to...

  • Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement...

    Part 1: Ratio Analysis calculate the following ratios Part 2: Perform a vertical analysis of statement of financial position & Income statement Part 3: Perform a Horizontal Analysis of statement of Financial Position for 2015 and 2014 & Income statement for 2015 Instructions: 1. On pages three and four, you will find condensed statement of financial position and income statement data for Waterloo Corporation. 2. Use the same information to answer all the three parts. 3. Part 1: a. In...

  • Problem 13-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies...

    Problem 13-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2015, 2014, and 2013 2015 2014 Sales $ 554,143 $ 424,519 Cost of goods sold 333,594 266,173 2013 $ 294,600 188,544 Gross profit Selling expenses Administrative expenses 220,549 78,688 49,873 158,346 58,584 37,358 106,056 38,887 24,452 Total expenses 128,561 95,942 63,339...

  • just need help filling in the blanks! thank you OUTPUT Income Statement INPUT 2014 250,000 300,000...

    just need help filling in the blanks! thank you OUTPUT Income Statement INPUT 2014 250,000 300,000 120,000 150,000 2013 Cash Flow 2014 Sales Cost of Good Sold Cash Depreciation Interest Expense Tax Rate SG&A Long Tem Debt Initial Equity Investment Accounts Receivable Inventory Gross Fixed Assets Accumulated Depreciation Accounts Payable Retained Eamings 2013 2014 Sales COGS NI Plus Depreciation Cash Income 20,000 36,000 8,000 40.0% 50,000 40,000 9,000 40.0% 55,000 240,000 230,000 150,000 150,000 42,000 14,500 800,000 820,000 Gross margin...

  • 5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put...

    5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...

  • i answer most this budget but please complete it with explain the slove .. and analyse...

    i answer most this budget but please complete it with explain the slove .. and analyse it the last photo is a clear slove Analyzing a Company for its Investment Potential In its annual report, WRS Athletic Supply, Inc., includes the following five-year financial summary. WRS ATHLETIC SUPPLY, INC. Five-Year Financial Summary (Partial adapted) 2010 2011 $137,634 17% 2014 2013 2012 5344,524 5217599 $191,129 $165,013 16% 20% 5% 6% 1,873 1,78 1,615 191,838 171,562 150,235 129,664 96 5% 2,001 1,391...

  • [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company...

    [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2015, 2014, and 2013 2015 2014 Sales $ 490,941 $ 376,101 Cost of goods sold 295,546 236,944 2013 $ 261,000 167,040 Gross profit Selling expenses Administrative expenses 195,395 69,714 44,185 139,157 51,902 33,097 93,960 34,452 21,663 Total expenses 113,899 84,999 56,115 Income before taxes Income taxes 81,496 15,158 54,158 11,102 37,845 7,683 Net...

  • Some recent financial statements for Smolira Golf Corp follow 2014 and 2015 Balance Sheets Assets Liabilities...

    Some recent financial statements for Smolira Golf Corp follow 2014 and 2015 Balance Sheets Assets Liabilities and Owners' Equity 2014 2015 2015 Current assets Current liabilities $ 24.126 5 24ltes 23,984 2790 11,600 Accounts payable counts receivable 13 248 26,542 16,000 27,900 18 000 12,371 Inventory Othes 16,500 Total $ 63,916 68,800 Total $ 54,355 3 56,000 77,000 87,000 50,000 50,000 Long-term debt Owners equity Common stock and paid-in sumplus Accumulated retained earnings 215.256 238,000 Fxed assets Net plant and...

  • Hello, Help me please to solve it, thank you. Financial Statement Analysis Case 2: Profitability Analysis...

    Hello, Help me please to solve it, thank you. Financial Statement Analysis Case 2: Profitability Analysis of Johnson & Johnson and Pfizer Inc. Pfizer Inc. is a U.S. products that are similar to those sold b Johnson's profitability ratios computed in Example 5B.1 in the chapter appendix. Use these an of Pfizer's income statements to answer the following questions: are similar to those sold by Johnson& Johnson. In the following, we present Johnson & d the excerpts company that manufactures...

  • P10-7A You have been presented with the following selected information from the financial statements of one...

    P10-7A You have been presented with the following selected information from the financial statements of one of Canada's largest dairy producers, Saputo Inc. (in millions): 2015 2014 2013 Statement of financial position Accounts receivable S 785 S 807 $ 625 Inventory Total current assets 1,006 1.962 933 1,896 770 1,513 Total assets 6.800 6,357 5,194 Current liabilities 1,179 1,725 1,227 Total liabilities 3,172 3,518 2,888 Income statement Net sales $10,658 $9,223 $7,298 Cost of goods sold 7,688 6,518 5,136 Interest...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT