Image transcription text A B C D E F 1 JB Hi Fi Limited (JBH) All figures in millions of Australian Dollar W N Income statement data un 2019 2020 2021 2022 2023 Sales 7,095 3 7,918 9 8,916 1 9,232 0 9,626 4 Cost of sales (5,568 2) (6,224 8) (6,938 9) (7,151 6) (7 443 9 8 Gross profit 1,527 1 1,694 1 1,977 2 2,080 4 2, 182 5 9 Other income 2 4 3 6 2 9 3 0 7 6 10 Finance costs (14 3) (36 4) (24 7) (20 1) (26 3 11 Sales and marketing expenses (731 0) (809 8) (845 8) (881 1) (978 3 12 Occupancy expenses (306 4) (313 1) (293 6) (302 8) (321 8 13 Administration expenses (44 5) (41 7) (41 3) (41 8) (46 0 14 Other expenses (74 0) (48 7) (54 7) (62 3) (70 6) 15 Profit before tax 359 3 448 0 720 0 775 3 747 1 16 Tax expense (109 5) (145 7) (213 9) (230 4) (222 5 17 Net profit after tax 249 8 302 3 506 1 544 9 524 6 18 19 Balance sheet data 20 2019 2020 2021 2022 2023 21 Current assets 22 Cash and cash equivalent 119 2 251 5 263 2 125 6 177 3 23 Trade and other receivables 254 4 220 3 102 8 132 6 146 5 24 Inventories 886 7 739 3 938 8 1,135 3 1,040 9 25 Other current assets 34 6 34 7 35 7 31 2 34 6 26 Total current assets 1,294 9 1,245 8 1,340 5 1,424 7 1,399 3 27 Non current assets 28 Plant and equipment 191 5 172 3 169 0 169 0 182 8 29 Deferred tax assets 2 7 22 2 30 3 30 6 41 1 30 Other non current assets 40 8 38 4 39 0 44 1 50 2 31 Intangibles goodwill 1,037 3 1,031 4 1,031 4 1,031 4 1,031 4 32 Right of use assets 642 2 536 3 461 6 530 1 33 Totalnon current assets 1,272 3 1,906 5 1,806 0 1,736 7 1, 835 6 34 Totalassets 2,567 2 3,152 3 3,146 5 3,161 4 3,234 9 35 Current Liabilities 36 Trade and other payables 672 7 854 1 668 6 721 6 660 5 37 Deferred revenue 165 8 196 6 212 9 253 5 231 0 38 Provisions 93 9 98 9 105 5 109 4 115 0 39 Lease liabilities 164 0 167 3 167 0 174 1 40 Current tax liabilities 5 1 32 3 92 2 54 8 4 3 41 Other current liabilities 8 0 42 Total current liabilities 945 5 1,345 9 1,246 5 1,306 3 1, 184 9 43 Non current liabilities 44 Borrowings 439 1 59 4 49 8 45 Deferred revenue 90 1 81 6 85 0 94 7 106 9 46 Provisions 15 2 41 5 42 6 42 7 42 5 47 Other non current liabilities 33 2 48 Lease liabilities 577 6 464 0 378 0 431 2 49 Total non current liabilities 577 6 700 7 591 6 574 8 630 4 50 Total liabilities 1,523 1 2,046 6 1, 838 1 1, 881 1 1,815 3 51 Equity 52 Contributed equity 434 8 403 2 393 0 346 8 329 3 53 Reserves 53 7 66 8 83 8 22 8 25 4 54 Retained earnings 555 6 635 7 831 6 910 7 1,064 9 55 Totalequity 1, 044 1 1, 105 7 1,308 4 1,280 3 1, 419 6 56 Total liabilities and equity 2,567 2 3,152 3 3,146 5 3,161 4 3,234 9 57 Show less Image transcription text Part A Calculations You are required to calaculate the ratios outlined below Industry average Ratios 2019 2020 2021 2022 2023 (2023) Profitability ratios Return on assets Return on equity Net profit margin Activity ratios Asset turnover Inventory turnover Receivable turnover Days inventory Daysreceivable Days payable Liquidity ratios Current ratio 1 37 Quick ratio Solvency ratios Debt to asset ratio Debt to equity ratio Leverage ratio ROE (DuPont) 1 JB Hi Fi Limited (JBH) 2 All figures in millions of Australian Dollar 3 4 Income statement data B C D E F 5 6 Sales 7 Cost of sales 2019 2020 2021 2022 2023 7,095 3 7,918 9 8,916 1 9,232 0 9,626 4 (5,568 2) (6,224 8) (6,938 9) (7,151 6) (7,443 9) 8 Gross profit 1,527 1 1,694 1 1,977 2 2,080 4 2,182 5 9 Other income 2 4 3 6 2 9 3 0 7 6 10 Finance costs (14 3) (36 4) (24 7) (20 1) (26 3) 11 Sales and marketing expenses (731 0) (809 8) (845 8) (881 1) (978 3) 12 Occupancy expenses (306 4) (313 1) (293 6) (302 8) (321 8) 13 Administration expenses (44 5) (41 7) (41 3) (41 8) (46 0) 14 Other expenses (74 0) (48 7) (54 7) (62 3) (70 6) 15 Profit before tax 359 3 448 0 720 0 775 3 747 1 16 Tax expense (109 5) (145 7) (213 9) (230 4) (222 5) 17 Net profit after tax 249 8 302 3 506 1 544 9 524 6 18 19 Balance sheet data 20 2019 2020 2021 2022 2023 21 Current assets 22 Cash and cash equivalent 119 2 251 5 263 2 125 6 177 3 23 Trade and other receivables 254 4 220 3 102 8 132 6 146 5 24 Inventories 886 7 739 3 938 8 1,135 3 1,040 9 25 Other current assets 34 6 34 7 35 7 26 Total current assets 1,294 9 1,245 8 1,340 5 31 2 1,424 7 34 6 1,399 3 27 Non current assets 28 Plant and equipment 191 5 172 3 169 0 169 0 182 8 29 Deferred tax assets 2 7 22 2 30 3 30 6 41 1 30 Other non current assets 40 8 38 4 39 0 44 1 50 2 31 Intangibles goodwill 1,037 3 1,031 4 1,031 4 1,031 4 1,031 4 32 Right of use assets 642 2 536 3 461 6 33 Total non current assets 1,272 3 1,906 5 1,806 0 1,736 7 530 1 1,835 6 34 Total assets 2,567 2 3,152 3 3,146 5 3,161 4 3,234 9 35 Current Liabilities 36 Trade and other payables 672 7 854 1 668 6 721 6 660 5 37 Deferred revenue 165 8 196 6 212 9 253 5 231 0 38 Provisions 93 9 98 9 105 5 109 4 115 0 39 Lease liabilities 164 0 167 3 167 0 174 1 40 Current tax liabilities 5 1 32 3 92 2 54 8 4 3 41 Other current liabilities 8 0 42 Total current liabilities 945 5 1,345 9 1,246 5 1,306 3 1,184 9 43 Non current liabilities 44 Borrowings 439 1 59 4 49 8 45 Deferred revenue 90 1 81 6 85 0 94 7 106 9 46 Provisions 15 2 41 5 42 6 42 7 42 5 47 Other non current liabilities 33 2 48 Lease liabilities 577 6 464 0 378 0 431 2 49 Total non current liabilities 577 6 700 7 591 6 574 8 630 4 50 Total liabilities 1,523 1 2,046 6 1,838 1 1,881 1 1,815 3 51 Equity 52 Contributed equity 434 8 403 2 393 0 53 Reserves 53 7 66 8 54 Retained earnings 555 6 55 Total equity 1,044 1 56 Total liabilities and equity 2,567 2 635 7 1,105 7 3,152 3 3,146 5 83 8 831 6 346 8 22 8 329 3 25 4 1,308 4 910 7 1,280 3 1,064 9 1,419 6 3,161 4 3,234 9 57

The Answer is in the image, click to view ...

Question: Image transcription text A B C D E F 1 JB Hi-Fi Limited (JBH) All figures in millions of Australian Dollar. & W N Income

Screenshot 2024-03-06 at 12.13.02 pm.png

Screenshot 2024-03-06 at 12.13.08 pm.png

1 JB Hi-Fi Limited (JBH) 2 All figures in millions of Australian Dollar. 3 4 Income statement data B C D E F 5 6 Sales 7 Cost of sales 2019 2020 2021 2022 2023 7,095.3 7,918.9 8,916.1 9,232.0 9,626.4 (5,568.2) (6,224.8) (6,938.9) (7,151.6) (7,443.9) 8 Gross profit 1,527.1 1,694.1 1,977.2 2,080.4 2,182.5 9 Other income 2.4 3.6 2.9 3.0 7.6 10 Finance costs (14.3) (36.4) (24.7) (20.1) (26.3) 11 Sales and marketing expenses (731.0) (809.8) (845.8) (881.1) (978.3) 12 Occupancy expenses (306.4) (313.1) (293.6) (302.8) (321.8) 13 Administration expenses (44.5) (41.7) (41.3) (41.8) (46.0) 14 Other expenses (74.0) (48.7) (54.7) (62.3) (70.6) 15 Profit before tax 359.3 448.0 720.0 775.3 747.1 16 Tax expense (109.5) (145.7) (213.9) (230.4) (222.5) 17 Net profit after tax 249.8 302.3 506.1 544.9 524.6 18 19 Balance sheet data 20 2019 2020 2021 2022 2023 21 Current assets 22 Cash and cash equivalent 119.2 251.5 263.2 125.6 177.3 23 Trade and other receivables 254.4 220.3 102.8 132.6 146.5 24 Inventories 886.7 739.3 938.8 1,135.3 1,040.9 25 Other current assets 34.6 34.7 35.7 26 Total current assets 1,294.9 1,245.8 1,340.5 31.2 1,424.7 34.6 1,399.3 27 Non-current assets 28 Plant and equipment 191.5 172.3 169.0 169.0 182.8 29 Deferred tax assets 2.7 22.2 30.3 30.6 41.1 30 Other non-current assets 40.8 38.4 39.0 44.1 50.2 31 Intangibles & goodwill 1,037.3 1,031.4 1,031.4 1,031.4 1,031.4 32 Right-of-use assets 642.2 536.3 461.6 33 Total non-current assets 1,272.3 1,906.5 1,806.0 1,736.7 530.1 1,835.6 34 Total assets 2,567.2 3,152.3 3,146.5 3,161.4 3,234.9 35 Current Liabilities 36 Trade and other payables 672.7 854.1 668.6 721.6 660.5 37 Deferred revenue 165.8 196.6 212.9 253.5 231.0 38 Provisions 93.9 98.9 105.5 109.4 115.0 39 Lease liabilities 164.0 167.3 167.0 174.1 40 Current tax liabilities 5.1 32.3 92.2 54.8 4.3 41 Other current liabilities 8.0 42 Total current liabilities 945.5 1,345.9 1,246.5 1,306.3 1,184.9 43 Non-current liabilities 44 Borrowings 439.1 59.4 49.8 45 Deferred revenue 90.1 81.6 85.0 94.7 106.9 46 Provisions 15.2 41.5 42.6 42.7 42.5 47 Other non-current liabilities 33.2 48 Lease liabilities 577.6 464.0 378.0 431.2 49 Total non-current liabilities 577.6 700.7 591.6 574.8 630.4 50 Total liabilities 1,523.1 2,046.6 1,838.1 1,881.1 1,815.3 51 Equity 52 Contributed equity 434.8 403.2 393.0 53 Reserves 53.7 66.8 54 Retained earnings 555.6 55 Total equity 1,044.1 56 Total liabilities and equity 2,567.2 635.7 1,105.7 3,152.3 3,146.5 83.8 831.6 346.8 22.8 329.3 25.4 1,308.4 910.7 1,280.3 1,064.9 1,419.6 3,161.4 3,234.9 57

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Consider the data from the happiness survey (see exercise 11.40). If you do a series of two-sample t-tests comparing mean happiness of all pairs of the seven age groups, you will find that the...

A computer science professor rewarded her students by giving each student 10 extra credit points on their last homework assignment. After 10 points were added to every score in the gradebook the mean...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

I can get about halfway through this problem but I'm stuck. Please help if you can! help if you can! AutoSave OFF A B 2.C ? - Home Insert Draw Page Layout Formulas Data Review View Conditional...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

I need help in the ratio analysis of following company. I need the below ratios and company balance sheet, income statement and cash flow statement is given below. Please do it correctly and 100%...

please fill out the empty yellow cells. the ones already filled out are correct AE6134 Insert Draw Page Layout Formulas Data Review View Tell me X Arial ] 12 Wrap Text General B 1 = = = Merge Center...

Create a statement based on the informaton provided below using hystorical, trend, ratio data, and current/future economic projects as well as information from the companys MD&A to aid in preparing...

Required: 1.Using Excel, prepare the following budgets for the twelve-month period from January 2018 to December 2018.The first worksheet should contain your raw data and assumptions and all future...

Hi I would like to know how to do these budget in the following: Manufacturing Overhead Budget Monthly Operating Cost Budget Ending Inventory budget for Finished Goods Cost of Sales Budget Budgeted...

Given the right triangle pictured in Fig. 5-6: (a) Find the average value of h. (b) At what point does this average value occur? (c) Determine average value of the f(x) = sin x, 0 x 1/1/0 (Use...

A flat object in the xy -plane is free to rotate about the z -axis. The gravitational field is uniform in the y -direction. Think of the object as a large number of particles with masses mi located...

Please watch this infamous Ted Talk by Mellody _ Hobson. Based on your research, how can organizations move beyond superficial diversity initiatives to create genuinely inclusive environments where...

Mitchell, Nelson, Olsen, and Parker, experts in manufacturing baubles, each owned fifteen out of one hundred authorized shares of Baubles, Inc., a corporation of State X, which does not permit...

Last year, only four of 32 professional sports teams in a new league turned a nominal accounting profit. Betty purchased such a team this year. Her taxable loss was determined to be $ 950,000. Can...

The Beef-up ranch feeds cattle for midwestern farmers and delivers them to processing plants in Topeka, Kansas and Tulsa, Oklahoma. The ranch must determine the amounts of cattle feed to buy so that...

The Faster Modem Corporation was founded by two engineers who managed to capitalize their firm with $150,000. They were able to raise this money because their test model performed much faster than...

A flat, triangular piece of metal with rounded corners has a net positive charge on it. Sketch the charge distribution on the surface and the electric field lines near the surface of the metal...

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

What happens when a thread calls await and no other thread calls signalAll or signal?

Write a program that lets users design bar charts with a mouse. When the user clicks inside a bar, the next mouse click extends the length of the bar to the x-coordinate of the mouse click. (If it is...

Worked Example 19.1 showed you how to find all words with five distinct vowels (which might occur more than once). Using a similar approach, find all words in which each vowel occurs exactly once....

The year-end dollar value (in millions) of deposits for Bank of the Ozarks, Inc., for the years 19972010 are shown below Develop a chart that effectively displays the deposit data over time.

VanAuker Properties controller collected the following data on annual sales and the years of experience of members of his sales staff: a. Construct a scatter plot representing these data. b....

In July 2005, Greg Sandoval of the Associated Press authored a study of the video game industry that focused on the efforts of the industry to interest women in the games. In that study, he cited...