For questions #1 and #2, use only the annual, total company figures (as have we have been doing all semester.)
- Complete the attached Corporate Analyzer (Financials). Use the appropriate industry norms. (25 pts)
Benchmarking the Financials (2 decimal places for all)
| FINANCIAL MEASURE | COMPANYS PERFORMANCE Period: ____ | BENCHMARK Companys Past Performance; Period:____ | BENCHMARK Industry Norm |
| Annual Sales Increase or Decrease % | | | |
| Gross Margin % | | | |
| Net Profit % | | | |
| Operating Expense SG & A % | | | |
| Inventory Turnover | | | |
| Current Ratio | | | |
| Quick Ratio | | | |
| Total Debt to Equity Ratio | | | |
- From the information on the Analyzer that you just completed, which are the two highest priority and most immediate financial problems? Why? Set a new, appropriate financial goal for each of these problems, and show what each financial goal is based on. (25 pts)
One World Fashion Favorites- Annual 2019 Financials Income Statement Figures in 000's Annual 2019 Annual 2018 Annual 2017 Net Sales Cost of Goods Sold Gross Profit S, G, & A (Operating Expenses) Other Expenses Net Profit 475. 272. 203. 130. 485. 267. 218. 117. 490. 250. 240. 127. 50. 23. 67. 34. 69. 44. Balance Sheet (Figures in 000's) Assets Cash Accts. Receivable Inventories Other Total Current Assets: Annual 2019 20. 35. 152. 10. 217. Annual 2018 15. 50. 121. 5. 191. 83. 89. Equipment, Lease Rights, other Total Assets 300. 280. Liabilities Accts Payable Wages Payable Other Total Current Liabilities 20. 16. 12. 48. 22 12. 10. 44. Long-term debt Total Liabilities: 112. 160. 96. 140. 140. 140. Stockholders' Equity Total Stockholders' Equity 300. 280. Total Liabilities and Stockholder's Equity Total Liabilities and Stockholder's Equity $ Sales History by Location, in retail dollars Figures in 000's Fiscal 2019 150. 145. 30. 150. Fiscal 2018 155. 155. 55. 120. Fiscal 2017 215. 185. 90. Fiscal 2016 190. 150. 100. Pine Bluff Oakland Centerville Monroe Mall Total Fiscal 2015 165. 135. 100. Not open Not open Not open 475. 485. 490. 440. 400. Sales by Department and Vendor, in retail dollars Figures in 000's Fiscal 2019 40. Fiscal 2018 85. Vendor Name Your Sportswear Connection Blouses and Bows Orbit Slacks The Sweater Source Total Misses Department 45. 45. 25. 20. 10. 95. 20. 195. NYC Urban wear 4U Separates California Red T's That Please Gabriella Total Juniors Department 80. 90. 45. 65. 100. 380. 60. 85. 35. 60. 50. 290. Total Store 475. 485. 20. Average Inventory (stock on the selling floor) by Department and Vendor, in retail dollars Figures in 000's Vendor Name Average stock 2019 Average stock 2018 Your Sportswear 21. Connection Blouses and Bows 14. Orbit Slacks 13. The Sweater Source 6. Total Misses Department 54. 11. 12. 5. 48. NYC Urban wear 4U Separates California Red T's That Please Gabriella Tops Total Juniors Department 20. 25. 10. 17. 26. 98. 17. 22. 9. 15. 10. 73. Total Store 152. 121. Michelle's Comparison Shopping Report Lowest Retail Prices currently on the selling floors H&M Amazon Jane's One World Anderson's Kohl's Zara Apparel Ann Lane Dress Taylor Bryant Barn Plus Loft Sizes (going out of business) 20-50 20-40 36-75 22-55 18-24 12-18 Misses: Sportswear 25-60 Separates Tops 12-22 Bottoms 16-34 Junior Same Plus: as juniors Juniors: Separates 18-50 10-22 15-30 N/A 8-20 15-32 N/A 14-30 17-38 N/A 13-27 9-18 18-65 11-25 limited N/A 6-12 8-18 Same as juniors N/A Same as juniors 16-45 16-40 20-46 10-17 T-Shirts 10-14 12-14 8-13 10-20 6-10 30.90- 70.90 12.90- 25.90 18.90- 58.90 35.90- 65.90 12-20 10-20 12-18 14-28 6-12 Other Tops Bottoms 15-30 13-26 14-28 16-32 9- 38 Annual Industry Norms 2019 Results Industry Segment Annual Sales Var Gross Margin % SG&A % Net Profit % Inventory Tum Current Ratio Quick Ratio Total Debt to Equity Ratio 3.33 -0.3% 31.2% 25.0% 1.3% 4.8 1.66 0.83 Specialty Department Store Mass Market -5.6% 32.7% 35.5% -1.3% 3.7 1.26 0.42 2.44 2.9% 23.1% 20.8% 2.9% 9.0 0.90 0.34 1.18 Off-Price 7.0% 28.5% 17.9% 7.8% 6.3 1.24 0.50 1.93 Ecom 14.1% 28.1% 8.6% 7.0% 12.7 1.39 1.11 0.56 One World Fashion Favorites- Annual 2019 Financials Income Statement Figures in 000's Annual 2019 Annual 2018 Annual 2017 Net Sales Cost of Goods Sold Gross Profit S, G, & A (Operating Expenses) Other Expenses Net Profit 475. 272. 203. 130. 485. 267. 218. 117. 490. 250. 240. 127. 50. 23. 67. 34. 69. 44. Balance Sheet (Figures in 000's) Assets Cash Accts. Receivable Inventories Other Total Current Assets: Annual 2019 20. 35. 152. 10. 217. Annual 2018 15. 50. 121. 5. 191. 83. 89. Equipment, Lease Rights, other Total Assets 300. 280. Liabilities Accts Payable Wages Payable Other Total Current Liabilities 20. 16. 12. 48. 22 12. 10. 44. Long-term debt Total Liabilities: 112. 160. 96. 140. 140. 140. Stockholders' Equity Total Stockholders' Equity 300. 280. Total Liabilities and Stockholder's Equity Total Liabilities and Stockholder's Equity $ Sales History by Location, in retail dollars Figures in 000's Fiscal 2019 150. 145. 30. 150. Fiscal 2018 155. 155. 55. 120. Fiscal 2017 215. 185. 90. Fiscal 2016 190. 150. 100. Pine Bluff Oakland Centerville Monroe Mall Total Fiscal 2015 165. 135. 100. Not open Not open Not open 475. 485. 490. 440. 400. Sales by Department and Vendor, in retail dollars Figures in 000's Fiscal 2019 40. Fiscal 2018 85. Vendor Name Your Sportswear Connection Blouses and Bows Orbit Slacks The Sweater Source Total Misses Department 45. 45. 25. 20. 10. 95. 20. 195. NYC Urban wear 4U Separates California Red T's That Please Gabriella Total Juniors Department 80. 90. 45. 65. 100. 380. 60. 85. 35. 60. 50. 290. Total Store 475. 485. 20. Average Inventory (stock on the selling floor) by Department and Vendor, in retail dollars Figures in 000's Vendor Name Average stock 2019 Average stock 2018 Your Sportswear 21. Connection Blouses and Bows 14. Orbit Slacks 13. The Sweater Source 6. Total Misses Department 54. 11. 12. 5. 48. NYC Urban wear 4U Separates California Red T's That Please Gabriella Tops Total Juniors Department 20. 25. 10. 17. 26. 98. 17. 22. 9. 15. 10. 73. Total Store 152. 121. Michelle's Comparison Shopping Report Lowest Retail Prices currently on the selling floors H&M Amazon Jane's One World Anderson's Kohl's Zara Apparel Ann Lane Dress Taylor Bryant Barn Plus Loft Sizes (going out of business) 20-50 20-40 36-75 22-55 18-24 12-18 Misses: Sportswear 25-60 Separates Tops 12-22 Bottoms 16-34 Junior Same Plus: as juniors Juniors: Separates 18-50 10-22 15-30 N/A 8-20 15-32 N/A 14-30 17-38 N/A 13-27 9-18 18-65 11-25 limited N/A 6-12 8-18 Same as juniors N/A Same as juniors 16-45 16-40 20-46 10-17 T-Shirts 10-14 12-14 8-13 10-20 6-10 30.90- 70.90 12.90- 25.90 18.90- 58.90 35.90- 65.90 12-20 10-20 12-18 14-28 6-12 Other Tops Bottoms 15-30 13-26 14-28 16-32 9- 38 Annual Industry Norms 2019 Results Industry Segment Annual Sales Var Gross Margin % SG&A % Net Profit % Inventory Tum Current Ratio Quick Ratio Total Debt to Equity Ratio 3.33 -0.3% 31.2% 25.0% 1.3% 4.8 1.66 0.83 Specialty Department Store Mass Market -5.6% 32.7% 35.5% -1.3% 3.7 1.26 0.42 2.44 2.9% 23.1% 20.8% 2.9% 9.0 0.90 0.34 1.18 Off-Price 7.0% 28.5% 17.9% 7.8% 6.3 1.24 0.50 1.93 Ecom 14.1% 28.1% 8.6% 7.0% 12.7 1.39 1.11 0.56
