New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

# IMAT5209 Evaluation Of Ratio

0 Download 4 Pages / 888 Words 05-11-2020

## Question:

You are required to complete the worksheet in the ‘Assignment 2 Template’ for Sunbay Sales. Using the sheet labelled ‘Worksheet’ identify Sunbay Sales' business transactions for June and construct an accounting worksheet.
Note:
1. Illustrative example 4.4 on pg. 126 of the text can be used as a guide to the format required for the worksheet. You should not limit yourself to this Illustrative example only. You should also review the tutorial questions we have provided the solutions to, as well as any other subject material available.

2. Opening balances as at 31 May 2017 should be used as your starting point in your accounting worksheet.

3. In your worksheet, you must demonstrate the use of the following Excel functions:
• 'sum'
• bordering
• cell merging
• wrap text
• date.

4. Ensure that you ‘sum’ each side of your worksheet to prove the accounting equation.

Using the same Excel file that you used for Part A, you need to prepare the following financial statements of Sunbay Sales from the accounting worksheet for the 2017 financial year:
• Income statement.
• Statement of changes in equity.
• Balance sheet.
Note:
1. Illustrative example 4.5 on pp.126-127 of the text can be used as a guide to the format required for the income statement and balance sheet. Illustrative example 6.8 on the bottom of p. 245 of the text can be used as a guide to the format required for the statement of changes in equity. You should not limit yourself to these illustrative examples only. You should also review the tutorial questions we have provided the solutions to, as well as any other subject material available.

2. Each financial statement should be prepared using the named worksheets provided in the Excel template. You are required to use formulas only to transfer the figures from the worksheet into the statements (do not type figures directly into the statements, with the exception of note 4. below).

3. In your financial statements, you must demonstrate the use of the following Excel functions:
• formulas for each subtotal and total
• bordering
• cell merging
• wrap text.
4. Assume expenses incurred up to 31 May 2017 consisted of:  \$350 for supplies, \$25,000 for wages, \$880 for internet services, \$8,000 for rent and \$4,220 for advertising.
In the same Excel template that you used for Part A and B use the sheet labelled ‘Ratio Analysis', to complete the following:
• the table labelled 'Ratio Figures'. You are required to use formulas only to transfer the figures needed from the statements into this table (do not type answers directly into this table).
• the column labelled ‘formula’. You are required to provide the written formula for each of the ratio’s provided (first one completed for you as an example).
• the column labelled ‘2017’. You are required to use formula only by pulling figures from the table completed above 'Ratio Figures' to show the ratio calculation. (Do not type ratio answer directly into the table).
Note:
In completing the ‘Ratio Analysis’ Sheet in the Excel template, you must demonstrate that you have used the following Excel functions:
• '=/+/-'
• bordering
• merging cells
• wrap text.

Write a report to Karin Nilson, on behalf of Megan Gordon, on the financial health of Sunbay Sales for the 2017 financial year. Your report should contain the following details:

• Executive summary
• Evaluation and comparison of ratios calculated in Part C for the following areas (a minimum of two ratios for each category below).
o Profitability
o Asset efficiency
o Liquidity
o Capital structure
• Limitations of the analysis
• Conclusion, including recommendations on areas of improvement for Sunbay Sales.

In writing your report, you should refer to the online meeting in week 2, which will focus on a report writing presentation provided by the Academic Literacy Learning and Numeracy (ALLaN) team.

Your report should be between 600-700 words, excluding the cover page, contents page and references.

Rationale
This assessment task covers topics 3, 4 and 5. It has been designed to ensure that you are engaging with the subject content on a regular basis. More specifically it seeks to assess your ability to:
Analyse and interpret a range of accounting and financial transactions and reports;
Use a computer spreadsheet to assist in the preparation of business information and be able to generate and analyse a range of business results and reports; and
Employ research and report writing skills.

### Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2020) Evaluation Of Ratio [Online]. Available from: https://myassignmenthelp.com/free-samples/imat5209-evaluation-of-ratio/ratios-comparison-and-recommendations.html
[Accessed 11 August 2022].

My Assignment Help. 'Evaluation Of Ratio' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/imat5209-evaluation-of-ratio/ratios-comparison-and-recommendations.html> accessed 11 August 2022.

My Assignment Help. Evaluation Of Ratio [Internet]. My Assignment Help. 2020 [cited 11 August 2022]. Available from: https://myassignmenthelp.com/free-samples/imat5209-evaluation-of-ratio/ratios-comparison-and-recommendations.html.

### Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

## 5% Cashback

On APP - grab it while it lasts!

### Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!