BSB110: Accounting for Decision Making - Report Writing - Accounting Assignment Help

Assignment 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 5th May 2020.

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 Blackmores Ltd. Blackmores Limited is an Australian health supplements company founded in the 1930s by naturopath Maurice Blackmore, when Blackmore opened the first health food shop in Australia in Brisbane, Queensland. Today, Blackmores is an ASX 200 company with a market capitalisation of $2 billion.

You have been provided with the following:

1. Select extracted Financial Information for Blackmores Ltd 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 Blackmores Ltd, use appropriate Excel formulas to calculate ratios that provide information about the following:

   1. Two (2) ratios in relation to the liquidity of the company for the 2019 year.

2. 2. Two (2) ratios in relation to the solvency of the company for the 2019 year

(note: Free Cash Flow is not an accepted ratio calculation for this assessment piece).

2. 3. Two (2) ratios in relation to the profitability of the company for the 2019 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.

2. Would you buy shares in Blackmores Ltd?  Discuss your reasons why, using only the liquidity, solvency, and profitability ratios you have calculated as justification.

This BSB110: Accounting Assignment has been solved by our Accounting Experts at My Uni Paper. 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.