Selected Statement of Financial Position Information 2019 2018 Cash and Cash Equivalents $'000) $'000) Trade Receivable 119.2 72.0 Inventories 236.0 204.7 Total Current Assets 886.7 891.1 Total Assets ,276.5 1,210.5 Total Current Liabilities 2,548.8 ,491.7 Total Liabilities 927.1 917.2 Retained Earnings ,504.7 ,544.1 Shareholders Equity 555.6 463.2 044.1 947.6 Selected Statement of Financial Performance Information 2019 Revenue (cash and credit sales) $'000 ncome Tax Expense ,095.3 Interest Expense (Finance Costs) 109.5 Cost of Sale 14.3 Gross Profit ,568.2 Operating Expenses 1,527.1 Profit After Tax ,155.9 249.8 Selected Other Financial Information (including Cash Flow Information) 2019 Net Cash Provided by Operating Activities ($'000) Dividends paid 301.6 Weighted Average Number of Ordinary Shares 157.4 116.1 Market Price per share ($ ) as at 30 June 2019 25.66 NAME AND CALCULATE YOUR RATIOS HERE (AS INDICATED BELOW): Liquidity Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE CALCULATE RATIO HERE #N/A CALCULATE RATIO HERE #N/A Solvency Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE CALCULATE RATIO HERE #N/A CALCULATE RATIO HERE #N/A Profitability Ratios INSERT NAME OF RATIO HERE INSERT NAME OF RATIO HERE CALCULATE RATIO HERE #N/A CALCULATE RATIO HERE #N/A You are looking for a long term investment which will provide you with a high retum. Would you buy shares in JB Hi-Fi Ltd? Discuss your reasons why, using only the liquidity, solvency, and profitability ratios you have calculated as justification.Backg rou n d In this assignment 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. .13 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 lnforrnation for JB Hi-Fi Ltd in an Excel le. Please use only the nancial information as provided in the Excel file. There is no need to find or refer to other information in the Financial Statements. Reguired: 1. In the Excel file that has been provided to you, with the select extracted nancial information for JB Hi-Fi Ltd, 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 2019year. b. Two (2) ratios in relation to the solvency of the company for the 2019year (note: Free Cash Flow is not an accepted ratio calculation for this assessment piece). 1:. Two (2) ratios in relation to the protability of the company for the 2019 yeah You must clearly identify the ratios selected (is. 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 le. 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