Acid Test Ratio - Return on Net Sales - Woolworths Limited - Report Writing Assignment Help

Assignment Task:

Assignment Task:
Scenario 1

Goal: Create an excel spreadsheet that calculates financial ratios over service years to evaluate a potential investment:

You have recently received a $1000 gift from your parents, you have been thinking about investing the money in the stock market. Your parents think that  Woolworths is a good investment.

Before making the purchase, your task is to create an excel spreadsheet to calculate the following ratios for Woolworths limited over the past five years:

1. Acid – test (quick) ratio.
2. Return on assets
3. Times-interest earned ratio
4. Return on net sales

When done with the spreadsheet comment on the trend in each of these rations.

Step-by-step:

1. Locate the data required for each ratio in the annual reports and other financial information of Woolworths limited at www.woolworths.com.au
2. Open a new excel spreadsheet
3. Create a bold-faced heading for your spreadsheet that contains the following
a. Chapter 19 Decision guideline
b. Use Ratios in the financial statement analysis
c. Woolworths Limited – Trends
d. Today’s date
4. In the first column, enter the names of all four ratios. Skip a row between each ratio name.
5. Create boldfaced, unlined column heading for the past five years
6. Enter the data located in step 1 using the correct ration formulas found in the decision Guidelines. Format all cells as necessary
7. Save and print a copy for your files

After completing Scenario 1 above, write a report and discuss the following: Woolworth's performance improving or worsening, based on your analysis explain the contributing factors.

Scenario 2

Goal: Create an excel spreadsheet that calculates financial ratios over service years to evaluate a potential investment:

Before you make you decide to purchase you decide to compare the Woolworths analysis to the Goodman Group in this activity you are required to locate the required data for each ration in the annual reports 
Following the steps above calculate the ratios for this Company                                       

Scenario 3

From the two Reports prepare a diagrammatic analysis using the appropriate details from the information you have prepared to show the visual comparison from both companies. You can demonstrate the comparisons utilizing any of the following methods:

graphs:
• line
• bar
• pie
diagrams:
• tree
• flowcharts
• network
• cluster
• Venn

This Case Study has been solved by our Case Study 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 styles.

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.