Subject Code : BSB110
Assessment Task:

PART B

Submission Requirements Part B:  You must upload your Excel worksheet (must be a .xls or .xlsx (Excel type) file not a .pdf file) via Turnitin through Assessment 1:  Accounting for Decision Making Assignment/Assignment Submission Area on the BSB110 Blackboard site by 11.59pm on 23rd September 2019.

It is each student’s responsibility to check online submissions have been uploaded correctly (i.e. you should open the file from Turnitin to check this, once your files have been uploaded).

Background

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. 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:

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:

 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:
Two (2) ratios in relation to the liquidity of the company for the 2018 year.


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).

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.

Marks are allocated for the correct use of formulas in Excel. Not complying with this requirement will have an impact on the marks you receive for this part of the assignment. You will not have successfully completed the assignment requirements if you simply type in or hard code your ratio answers, they must all be calculated using an Excel formula.

Evaluate the liquidity, solvency and profitability of JB Hi-Fi based on the ratios you have calculated.   Use only the area provided in the excel worksheet to respond.  The word limit is 100 – 200 words. Support Provided

Materials will be available on Blackboard to assist with using Excel, including a video and a demonstration exercise showing how to use and format an Excel worksheet, save an Excel file in the appropriate format etc. A Discussion Board will be opened and available on Blackboard where you can post questions.

Answers to Common Questions:

How strict is the word count?
Like any other piece of assessment the 100 - 200 word limit for your evaluation needs to be closely adhered to (10% above the word limit is considered acceptable).

Should I check my ratio calculations?
It is recommended that you double check the calculation of ratios that you have produced in Excel, particularly if you are not proficient at using Excel. You can calculate the ratios manually using a calculator and use this to double check the answers that you have calculated in Excel. Be particularly careful and vigilant with the use of brackets in Excel.

 

This BSB110: Accounting Assessment has been solved by our Accounting experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Noah
  • Posted on : November 13th, 2018

Whatsapp Tap to ChatGet instant assistance