$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

IMAT5209 Evaluation Of Ratio

tag 0 Download4 Pages / 888 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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 01 August 2021].

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 01 August 2021.

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


Myassignmenthelp is a standout amongst other paper writing services as our prices at amazingly low and quality great. All our works go through multiple checks and audits before being rendered to students. We have domain specific experts all having PhD degrees and 10+ years of teaching experience. All the works provided are in line with the set regulations of the University. To avoid plagiarism issues, that has been a rage this year, our experts manually check all your references and ensure that it is according to the apa format, chicago format, mla format and other referencing styles that has been prescribed by University/College.

Latest Finance Samples

HLT54115 Diploma Of Nursing

Download : 0 | Pages : 8

Answer: The Nursing and Midwifery Board (NMBA) regulates the health professionals such as nursing students, enrolled nurses and the registered nurses. The boards have standards of practice to which the registered nurses are accountable. Nurses should be aware of standard 4 of NMBA, according to which health care assessments should be conducted comprehensively and systematically, analyse the information, interpret data and communicate the outco...

Read More arrow Tags: Australia Brisbane Economics University of New South Wales Management 

FINC20018 Managerial Finance

Download : 0 | Page : 1

Answer:   Opening  Intallment Interest Closing 1 0 11472.3975 0 11472.3975 2 11472.3975 11472.3975 1491.412 24436.2066 3 24436.2066 11472.3975 3176.707 39085.3110 4 39085.3110 11472.3975 5081.09 55638.7989 5 55638.7989 11472.3975 7233.044 74344.2402 6 74344.2402 11472.3975 9664.751 95481.3889 7 95481.3889 11472.3975 12412.58 119366.3670 8 119366.3670 11...

Read More arrow

FIN91110 Finance

Download : 0 | Pages : 9

Answer: All the data has been taken from the reliable sources : (a) Calculation of monthly percentage return for the company’s shares during period? In order to answer this question company JB HI- FI Company has been taken for the further analysis (Brigham and Houston, 2004). Interpretation There has been shown monthly percentage return on the basis of Historical price of JB HI- FI finance from 30th June 2015 to 30th J...

Read More arrow Tags: Australia Rosemeadow Management Explain sociologically how social inequality (in terms of class and/or ethnicity) is constructed and Univers 

BUS 4283 Islamic Finance And Banking

Download : 0 | Pages : 15

Answer: Introduction Overview of the project This project will explain the detail about the Islamic bank, their operation and organizational structure. This report will illustrate the shariah regulation under which the bank is regulated and details regarding the contracts that are allowed and that are forbidden under Shariah Purpose of the project The main aim and objective of this report is to present the details of the Dubai Islamic Bank...

Read More arrow

BSBFIM801 Manage Financial Resource

Download : 0 | Pages : 10

Answer: Introduction With the increasing ramified economic changes and complex business structure, each and every organization needs proper level of finance to run the business effectively. This report reflects the forecasted budgeted financial plans and business functioning for raising the funds from the banks. Present description of the proposed company  The name of the business is Royal fashion limited which will be operated at dom...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?