the data source is the Annual Report (including the Audited Financial Statements) of Australian publicly listed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
the data source is the Annual Report (including the Audited Financial Statements) of Australian publicly listed company JB Hi-Fi. JB Hi-Fi is sells and specialises in the world's leading brands of Computers, Tablets, TVs, Cameras, Hi-Fi, Speakers, Car Sound, Home Theatre and Portable Audio. JB Hi- Fi also offers a large range of games, recorded music, DVD music + Blu-Ray and DVD movies and TV shows. It has locations in both Australia and New Zealand. You have been provided with the following: 1. Select extracted Financial Information for JB Hi-Fi in an Excel file. Please use only the financial information as provided in the Excel file. There is no need to find or refer to other information in the Financial Statements. Required: 1. In the Excel file that has been provided to you, with the select extracted financial information for JB Hi-Fi, use appropriate Excel formulas to calculate ratios that provide information about the following: a. Two (2) ratios in relation to the liquidity of the company for the 2018 year. b. Two (2) ratios in relation to the solvency of the company for the 2018 year (note: Free Cash Flow is not an accepted ratio calculation for this assessment piece). c. Two (2) ratios in relation to the profitability of the company for the 2018 year. You must clearly identify the ratios selected (i.e. clearly name the ratio that has been calculated) for each of the above categories, in addition to performing the calculation in the corresponding section of the Excel file. Use only the area provided on the Excel file. In performing your ratio calculations you are to use the formula as provided for the ratio from the current set textbook only. No other formulas will be accepted. Selected Statement of Financial Position Information Cash and Cash Equivalents Trade Receivables Inventories Total Current Assets Total Assets Total Current Liabilities Total Liabilities Retained Earnings. Shareholders Equity Selected Statement of Financial Performance Information Revenue (cash and credit sales) Income Tax Expense Interest Expense (Finance Costs) Cost of Sales Gross Profit Operating Expenses Profit After Tax Selected Other Financial Information (including Cash Flow Information) Net Cash Provided by Operating Activities Dividends paid Weighted Average Number of Ordinary Shares Excel Worksheet JB Hi-Fi Selected Comparative Financial Information from the Financial Statements for the year ended Market Price per share ($) as at 28 June 2018 2018 ($'000) 2018 ($'000) 2018 ($'000) 72.0 204.7 891.1 1,210.5 2,491.7 917.2 1,544.1 463.2 947.6 6,854.3 101.3 16.6 5,384.1 1,470.2 1,120.2 233.2 292.1 151.6 115.9 25.85 2017 ($'000) 72.8 193.6 859.7 1,167.5 2,459.8 885.4 1,606.3 381.6 853.5 NAME AND CALCULATE YOUR RATIOS HERE (AS INDICATED BELOW): Liquidity Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE Solvency Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE Profitability Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE USING THE RATIOS YOU CALCULATED ABOVE, EVALUATE THE LIQUIDITY, SOLVENCY AND PROFITABILITY OF PREMIER INVESTMENTS CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE #N/A #N/A #N/A #N/A #N/A #N/A the data source is the Annual Report (including the Audited Financial Statements) of Australian publicly listed company JB Hi-Fi. JB Hi-Fi is sells and specialises in the world's leading brands of Computers, Tablets, TVs, Cameras, Hi-Fi, Speakers, Car Sound, Home Theatre and Portable Audio. JB Hi- Fi also offers a large range of games, recorded music, DVD music + Blu-Ray and DVD movies and TV shows. It has locations in both Australia and New Zealand. You have been provided with the following: 1. Select extracted Financial Information for JB Hi-Fi in an Excel file. Please use only the financial information as provided in the Excel file. There is no need to find or refer to other information in the Financial Statements. Required: 1. In the Excel file that has been provided to you, with the select extracted financial information for JB Hi-Fi, use appropriate Excel formulas to calculate ratios that provide information about the following: a. Two (2) ratios in relation to the liquidity of the company for the 2018 year. b. Two (2) ratios in relation to the solvency of the company for the 2018 year (note: Free Cash Flow is not an accepted ratio calculation for this assessment piece). c. Two (2) ratios in relation to the profitability of the company for the 2018 year. You must clearly identify the ratios selected (i.e. clearly name the ratio that has been calculated) for each of the above categories, in addition to performing the calculation in the corresponding section of the Excel file. Use only the area provided on the Excel file. In performing your ratio calculations you are to use the formula as provided for the ratio from the current set textbook only. No other formulas will be accepted. Selected Statement of Financial Position Information Cash and Cash Equivalents Trade Receivables Inventories Total Current Assets Total Assets Total Current Liabilities Total Liabilities Retained Earnings. Shareholders Equity Selected Statement of Financial Performance Information Revenue (cash and credit sales) Income Tax Expense Interest Expense (Finance Costs) Cost of Sales Gross Profit Operating Expenses Profit After Tax Selected Other Financial Information (including Cash Flow Information) Net Cash Provided by Operating Activities Dividends paid Weighted Average Number of Ordinary Shares Excel Worksheet JB Hi-Fi Selected Comparative Financial Information from the Financial Statements for the year ended Market Price per share ($) as at 28 June 2018 2018 ($'000) 2018 ($'000) 2018 ($'000) 72.0 204.7 891.1 1,210.5 2,491.7 917.2 1,544.1 463.2 947.6 6,854.3 101.3 16.6 5,384.1 1,470.2 1,120.2 233.2 292.1 151.6 115.9 25.85 2017 ($'000) 72.8 193.6 859.7 1,167.5 2,459.8 885.4 1,606.3 381.6 853.5 NAME AND CALCULATE YOUR RATIOS HERE (AS INDICATED BELOW): Liquidity Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE Solvency Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE Profitability Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE USING THE RATIOS YOU CALCULATED ABOVE, EVALUATE THE LIQUIDITY, SOLVENCY AND PROFITABILITY OF PREMIER INVESTMENTS CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE CALCULATE RATIO HERE #N/A #N/A #N/A #N/A #N/A #N/A
Expert Answer:
Answer rating: 100% (QA)
aLIQUIDITY RATIOS 1Current RatioTotal Current assetsTotal Current Liabilities121059172 132 Current R... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Livermore Meatpackers, Inc. processes hogs into bacon, ham, pork roast, and spare ribs. The materials, labor and overhead processing costs to get the products to the point where they can be...
-
What role does cognitive ergonomics play in shaping user-centered interface designs for augmented reality applications ?
-
In the ZZZZ Best case, explain the kinds of evidence that the auditors gathered and how the auditors failed. just write one or two paragraph to support ZZZZ Best Case On May 19, 1987, a short article...
-
If you invested $320 million into a project today, and achieved operating cash flows of $180million, $60 million, $50 million, $50 million, and $40 million, how would you measure the following: a....
-
In the above example, calculate your net pay and spendable income if you save $200 per pay period in a tax-sheltered annuity.
-
Suppose that in 2016, Global launches an aggressive marketing campaign that boosts sales by 15%. However, their operating margin falls from 5.57% to 4.50%. Suppose that they have no other income,...
-
Wayflaire Inc. produces home products. The cost to manufacture a case ( 36 sets) of its most popular set of casual dinnerware is as follows: The average sales price for a case of dinnerware is \(\$...
-
How does a decrease in U.S. interest rates affect the EU/U.S. exchange rate?
-
Evaluate the following integral in cylindrical coordinates. 0 2 0 5 - 5 5 d z r d r dtheta
-
The woman A, the captain B, and the sailor C weigh 120, 180, and 160 lb, respectively, and are sitting in the 300-lb skiff, which is gliding through the water with a speed of 1 knot. If the three...
-
A selected area in Ajloun City is to be served by a water distribution network as shown in Figure 1. A two-loop water-distribution system is depicted in Figurel. The demands on the system are...
-
Determining the most equitable method of judicial selection is a nuanced task influenced by factors such as transparency, public participation, and judicial independence. From my standpoint, the...
-
Because he has a gambling problem and owes a great deal of money to some scary people, Jason is desperate for money. His girlfriend Samantha works at a local bar. She is terrified that someone is...
-
Estimate the following limit t-0 lim t 76 + 77 6
-
Solve: log4(-8x-15)- log4(-9x-2) = 3
-
Please discuss the significance of the Supreme Court of Canada's decision in R. v. Barton by answering the following questions: (1) How did the Court reframe the defence of "Mistaken belief in...
-
Suppose citizens fear power outages in the near future. Could we see an electricity run leading to shortages today? Why or why not? Suppose someone says, "The experience in Colorado shows that the...
-
Anna, a high school counselor, devised a program that integrates classroom learning with vocational training to help adolescents at risk for school dropouts stay in school and transition to work...
-
The following transactions pertain to the March 31, 2013, year end, for a province reporting in accordance with the CICA PSA Handbook: 1. Assume the accrual for the year-end estimate of income tax...
-
Big Bucks (BB) is an association formed in 2013 by wealthy individuals wanting to network with other wealthy individuals. An individual applies to be a member in the association and must supply...
-
Food Services (FS) collects food for distribution to people in need. During November 2013, its first month of operations, the organization collected a substantial amount of food and also $54,000 in...
-
What are the basic rights of the owner of a share of corporate stock? In what way are these basic rights commonly modified with respect to the owner of a share of preferred stock?
-
Explain the following terms: a. Stock transfer agent. b. Stockholders subsidiary ledger. c. Underwriter. d. Stock registrar.
-
On April 1,2008 , Sanders Construction paid \(\$ 10,000\) for equipment with an estimated useful life of 10 years and a residual value of \(\$ 2,000\). The company uses the doubledeclining-balance...
Study smarter with the SolutionInn App