ITS ONLY TWO QUESTIONS PLEASE SOLVE IT QUICKLY !
In the spring of 2020, Mohammed Khalid was an analyst at an investment bank who had recently graduated from the MBA program. As an initial assignment, his supervisor had given him the task of analyzing the financial position of JBC Stores.
Khalid was interested in JBC Stores because it was one of his favorite places to shop. However, recently he had read in the business press that JBCs stock had fallen dramatically, dropping from a high of $20 per share to less than $2, despite the fact that the company was known to pay out relatively constant dividends to its shareholders.
JBC was an established retailer that had been in business for over 15 years. In recent times, management had undertaken a series of new business strategies, one of which was to expand the number of JBCs new supercenter stores, while phasing out the traditional discount stores. The supercenter stores carried a greater selection of durable goods, such as appliances and furniture. In order to entice customers to purchase these more expensive items, JBC had started offering store credit to its customers. Each individual store manager was responsible for authorizing the opening of store credit accounts and ultimately had the final say as to whether credit would be granted to a customer. Store managers were paid an annual bonus, based on net income for their respective store, and were known for being quite lenient in granting credit in order to increase net income for the year and, therefore, the size of their bonus.
Khalid wondered whether these new strategies were responsible for the decline in JBCs share price, which he had read about. To collect the financial statement information that he required to complete his assignment, he went to a business reference library and obtained JBCs balance sheets and statements of income for the fiscal years ending 2012 through 2020 (see Exhibits 1and 2).Armed with these financial statements and the information he had learned in his MBA studies, Khalid calculated the most important financial ratios.
Question 1
- Calculate the 14 ratios done in Exhibit 3 for each year from 2012 to 2020 ITS ALREADY SOLVED AS ATTACHED
- Do you notice any trends?
- What insights do these trends provide into the operations of JBC?
x
A B G 2012 D 2013 E 2014 F 2015 H 2017 1 2018 j 2019 K 2020 2016 Gross income/sales net income after tax/sales net income after tax /total assets net income after tax/shareholders' equity 30.06% 3.42% 7.57% 14.87% 30.00% 3.36% 7.25% 13.71% 29.83% 3.46% 7.42% 13.53% 32.68% 3.44% 5.92% 14.38% 33.03% 3.14% 4.90% 13.10% 32.43% 3.55% 3.73% 10.81% 31.74% 2.29% 3.40% 11.30% 30.79% 0.59% 0.91% 3.34% 26.21% -11.82% -19.29% -183.42% 1 2 Profitability ratios: 3 Gross profit margin 4 Net profit margin 5 Return on assets 6 Return on equity 7 Turnover ratios: 8 Inventory turnover 9 Days Inventory 10 Total asset turnover 11 Receivables turnover 12 Days receivables 13 Liquidity ratios: 14 Current ratio cost of goods sold/inventory 365 / Inventory turnover revenue/total assets 364 / Recievables turnover accounts receivable/(sales/365) 3.70 98.74 2.21 8.37 43.62 3.74 97.53 2.16 7.36 49.57 3.69 99.02 2.14 7.07 51.61 3.68 99.16 1.72 3.30 110.66 3.24 112.76 1.56 3.00 121.67 3.12 117.07 1.46 2.88 126.81 2.82 129.60 1.48 3.03 120.49 2.85 128.21 1.55 3.41 106.99 3.20 114.09 1.63 4.07 89.79 current assets/current liabilities 2.66 2.49 2.28 1.71 1.57 1.75 1.55 1.58 1.24 (cash and cash equivalents + accounts receivable)/current liabilities 1.21 1.14 1.05 1.09 0.99 1.11 0.91 0.89 0.69 Quick ratio 15 16 Solvency ratios: 17 Debt to equity ratio 18 Debt to asset ratio 19 Interest coverage time 1.67 2.32 total liabilities/shareholders' equity total liabilities/total assets Earnings before interest and tax / interest expense 0.96 0.49 6.52 0.89 0.47 5.61 0.82 0.45 1.43 0.59 5.83 0.53 1.90 0.66 4.31 0.70 2.66 0.73 1.27 8.51 0.89 -7.81 5.79 4.43 3.65 . B C D E F G 2017 J 2019 K 2020 1 2011 2012 2014 2015 2016 2018 2013 2,159,867 1,750,724 1,979,167 2,423,227 3,354,450 3,833,003 4,483,403 5,271,373 5,671,409 5,136,439 0 0 0 0 280,550 173,580 454,131 316,454 264,974 581,428 358,091 301,286 659,376 458,479 366,149 824,628 864,399 1,169,510 1,128,319 1,851,102 2,150,399 2,847,600 448,897 496,070 548,218 495,564 497,775 613,235 427,154 512,834 580,550 657,876 489,208 93,496 1,740,449 2,178,414 2,257,087 3,004,542 3,137,382 3,554,331 11 Total assets 12 Liabilities and shareholders' equity 13 Current liabilities 14 Short-term notes payable 15 Accounts payable 16 Corporate income taxes payable 17 18 Long term liabilities 19 Long-term debt 20 Deferred corporate income taxes 21 Other liabilities 22 Shareholders' equity 23 Share capital 24 Retained earnings 25 26 Total liabilities and equity 27 28 29 30 31 332,220 29,753 22,705 332,220 33,384 24,485 297,204 35,837 25,097 205,269 37,688 26,193 168,018 39,330 27,047 153,301 40,426 27,399 609,538 45,865 24,926 601,185 56,601 22,278 896,396 1,031,477 69,524 0 19,914 10,361 265,387 278,177 646,528 729,474 911,915 1,007,651 1,750,724 1,979,167 324,479 817,873 1,142,352 2,159,867 429,575 374,977 339,819 385,551 347,336 357,265 361,470 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 178,801 1,329,448 1,379,605 1,433,463 1,545,986 1,586,768 1,548,193 540,271 2,423,227 3,354,450 3,833,003 4,483,403 5,271,373 5,671,409 5,136,439 0 0 0 0 0 0 0 0 0 0 32 72,268 -72,268 36,567 -36,567 47,598 -47,598 71,523 -71,523 76,600 -76,600 123,007 -123,007 124,588 -124,588 108,322 -108,322 68,020 -68,020 33 A D H I J B 2012 E 2015 F 2016 G 2017 1 2013 2014 2018 2019 2020 2 Sales 4,380,7814,661,730 5,197,264 5,764,8055,975,7646,541,1797,823,7818,798,007 3,063,775 3,263,250 3,647,1783,880,666 4,001,789 4,419,6515,340,489 6,088,857 1,317,006 1,398,480 1,550,0861,884,1381,973,975 2,121,529 2,483,292 2,709,150 8,382,338 6,185,305 2,197,033 3 Cost of goods sold 4 Gross profit 5 Operating expenses 6 Amortization of property, plant and equipment 7 Selling, general, and administrative expenses 8 Interest expense 9 10 Operating income 11 Other income 12 Net income (loss) before taxes 13 Provision for income taxes 14 Net Income (loss) after taxes 15 Dividends 16 Retained earnings for the year 17 Opening retained earnings 18 Closing retained earnings 19 Other Data 20 Earnings per share 21 22 23 NI 24 DEP 25 35,709 38,931 39,810 42,581 45,652 50,198 56,971 62,932 63,521 982,166 1,045,211 1,130,806 1,412,680 1,519,427 1,723,932 2,052,0422,501,000 3,533,387 45,894 56,069 65,505 73,582 92,219 80,540 102,647 114,160 179,261 1,063,769 1,140,2121,236,120 1,528,843 1,657,298 1,854,670 2,211,6602,678,092 3,776,169 253,237 258,268 313,966 355.296 316,677 266,858 271,632 31,058 -1,579,136 14,808 22,757 27,247 23,479 26,825 26,027 29,914 36,293 30,668 268,045 281,025 341,213 378,774 343,501 292,886 301,546 67,350 -1,548,468 118,223 124,440 161,364 180,348 155,669 125,769 122,210 15,609 -557,493 149,822 156,584 179,849 198,426 187,832 167,117 179,336 51,741 -990,975 66,876 68,186 97,848 93,672 98,816 100,325 100,340 100,245 21,153 82,946 88,399 82,001 104,754 89,016 66,791 78,996 -48,504 -1,012,127 646,528 729,474 817,873 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 729,474 817,873 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 178,801 $1.75 $1.90 $2.09 $2.01 $1.85 $1.58 $1.74 $0.53 ($8.92) 156,584 38,931 A B G 2012 D 2013 E 2014 F 2015 H 2017 1 2018 j 2019 K 2020 2016 Gross income/sales net income after tax/sales net income after tax /total assets net income after tax/shareholders' equity 30.06% 3.42% 7.57% 14.87% 30.00% 3.36% 7.25% 13.71% 29.83% 3.46% 7.42% 13.53% 32.68% 3.44% 5.92% 14.38% 33.03% 3.14% 4.90% 13.10% 32.43% 3.55% 3.73% 10.81% 31.74% 2.29% 3.40% 11.30% 30.79% 0.59% 0.91% 3.34% 26.21% -11.82% -19.29% -183.42% 1 2 Profitability ratios: 3 Gross profit margin 4 Net profit margin 5 Return on assets 6 Return on equity 7 Turnover ratios: 8 Inventory turnover 9 Days Inventory 10 Total asset turnover 11 Receivables turnover 12 Days receivables 13 Liquidity ratios: 14 Current ratio cost of goods sold/inventory 365 / Inventory turnover revenue/total assets 364 / Recievables turnover accounts receivable/(sales/365) 3.70 98.74 2.21 8.37 43.62 3.74 97.53 2.16 7.36 49.57 3.69 99.02 2.14 7.07 51.61 3.68 99.16 1.72 3.30 110.66 3.24 112.76 1.56 3.00 121.67 3.12 117.07 1.46 2.88 126.81 2.82 129.60 1.48 3.03 120.49 2.85 128.21 1.55 3.41 106.99 3.20 114.09 1.63 4.07 89.79 current assets/current liabilities 2.66 2.49 2.28 1.71 1.57 1.75 1.55 1.58 1.24 (cash and cash equivalents + accounts receivable)/current liabilities 1.21 1.14 1.05 1.09 0.99 1.11 0.91 0.89 0.69 Quick ratio 15 16 Solvency ratios: 17 Debt to equity ratio 18 Debt to asset ratio 19 Interest coverage time 1.67 2.32 total liabilities/shareholders' equity total liabilities/total assets Earnings before interest and tax / interest expense 0.96 0.49 6.52 0.89 0.47 5.61 0.82 0.45 1.43 0.59 5.83 0.53 1.90 0.66 4.31 0.70 2.66 0.73 1.27 8.51 0.89 -7.81 5.79 4.43 3.65 . B C D E F G 2017 J 2019 K 2020 1 2011 2012 2014 2015 2016 2018 2013 2,159,867 1,750,724 1,979,167 2,423,227 3,354,450 3,833,003 4,483,403 5,271,373 5,671,409 5,136,439 0 0 0 0 280,550 173,580 454,131 316,454 264,974 581,428 358,091 301,286 659,376 458,479 366,149 824,628 864,399 1,169,510 1,128,319 1,851,102 2,150,399 2,847,600 448,897 496,070 548,218 495,564 497,775 613,235 427,154 512,834 580,550 657,876 489,208 93,496 1,740,449 2,178,414 2,257,087 3,004,542 3,137,382 3,554,331 11 Total assets 12 Liabilities and shareholders' equity 13 Current liabilities 14 Short-term notes payable 15 Accounts payable 16 Corporate income taxes payable 17 18 Long term liabilities 19 Long-term debt 20 Deferred corporate income taxes 21 Other liabilities 22 Shareholders' equity 23 Share capital 24 Retained earnings 25 26 Total liabilities and equity 27 28 29 30 31 332,220 29,753 22,705 332,220 33,384 24,485 297,204 35,837 25,097 205,269 37,688 26,193 168,018 39,330 27,047 153,301 40,426 27,399 609,538 45,865 24,926 601,185 56,601 22,278 896,396 1,031,477 69,524 0 19,914 10,361 265,387 278,177 646,528 729,474 911,915 1,007,651 1,750,724 1,979,167 324,479 817,873 1,142,352 2,159,867 429,575 374,977 339,819 385,551 347,336 357,265 361,470 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 178,801 1,329,448 1,379,605 1,433,463 1,545,986 1,586,768 1,548,193 540,271 2,423,227 3,354,450 3,833,003 4,483,403 5,271,373 5,671,409 5,136,439 0 0 0 0 0 0 0 0 0 0 32 72,268 -72,268 36,567 -36,567 47,598 -47,598 71,523 -71,523 76,600 -76,600 123,007 -123,007 124,588 -124,588 108,322 -108,322 68,020 -68,020 33 A D H I J B 2012 E 2015 F 2016 G 2017 1 2013 2014 2018 2019 2020 2 Sales 4,380,7814,661,730 5,197,264 5,764,8055,975,7646,541,1797,823,7818,798,007 3,063,775 3,263,250 3,647,1783,880,666 4,001,789 4,419,6515,340,489 6,088,857 1,317,006 1,398,480 1,550,0861,884,1381,973,975 2,121,529 2,483,292 2,709,150 8,382,338 6,185,305 2,197,033 3 Cost of goods sold 4 Gross profit 5 Operating expenses 6 Amortization of property, plant and equipment 7 Selling, general, and administrative expenses 8 Interest expense 9 10 Operating income 11 Other income 12 Net income (loss) before taxes 13 Provision for income taxes 14 Net Income (loss) after taxes 15 Dividends 16 Retained earnings for the year 17 Opening retained earnings 18 Closing retained earnings 19 Other Data 20 Earnings per share 21 22 23 NI 24 DEP 25 35,709 38,931 39,810 42,581 45,652 50,198 56,971 62,932 63,521 982,166 1,045,211 1,130,806 1,412,680 1,519,427 1,723,932 2,052,0422,501,000 3,533,387 45,894 56,069 65,505 73,582 92,219 80,540 102,647 114,160 179,261 1,063,769 1,140,2121,236,120 1,528,843 1,657,298 1,854,670 2,211,6602,678,092 3,776,169 253,237 258,268 313,966 355.296 316,677 266,858 271,632 31,058 -1,579,136 14,808 22,757 27,247 23,479 26,825 26,027 29,914 36,293 30,668 268,045 281,025 341,213 378,774 343,501 292,886 301,546 67,350 -1,548,468 118,223 124,440 161,364 180,348 155,669 125,769 122,210 15,609 -557,493 149,822 156,584 179,849 198,426 187,832 167,117 179,336 51,741 -990,975 66,876 68,186 97,848 93,672 98,816 100,325 100,340 100,245 21,153 82,946 88,399 82,001 104,754 89,016 66,791 78,996 -48,504 -1,012,127 646,528 729,474 817,873 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 729,474 817,873 899,874 1,004,628 1,093,644 1,160,436 1,239,432 1,190,928 178,801 $1.75 $1.90 $2.09 $2.01 $1.85 $1.58 $1.74 $0.53 ($8.92) 156,584 38,931
