Write your interpretation of the ratio analysis in a report

Assignment Help Accounting Basics
Reference no: EM132312170

Principles Of Accounting Assignment -

Task rationale and description: This assessment is set on practical exercises to assess students' ability to apply theoretical learning concerned with use of accounting information and its analyses and interpretation using 'real-world' situation.

Assessment Details and Requirements -

This assignment consists of two parts: Part A and Part B. Part A involves written assignment and Part B involves written report and group oral presentation on selected topics from the financial analyses of an ASX listed company's performance.

Task Description - Students' are, firstly, required to manually record and post business transactions to accounts and prepare financial statements of the following hypothetical company called <Group Name> Limited. Based on the information provided (see over the pages for the question), you are required to complete journal entries, ledger accounts, trial balance, statements of profit or loss and financial position (Balance Sheet).

Secondly, students are to collect financial statements information of a company listed in Australian Stock Exchange (ASX). A company will be assigned to you by your lecturer.

You are supposed to carry out analyses and interpretations of the assigned company. In particular, you need to calculate relevant ratios based on the financial statements provided in the annual report in the context of the assigned company's profitability, liquidity, efficiency, solvency, gearing and investment performance (related lecture topic Week 6 - Analysis and interpretation of financial statements). Each group only needs to carry out two selected areas out of these five areas.

What needs to be carried out to do these ratio analyses:

  • Down load the annual report 2016 of the assigned company.
  • Do not print all the annual report - it is too long. Just read the relevant sections and print, if required.

In this section, you need to interpret the company's performance on the selected two areas from the above five areas. The structure of this section should include company background, analyses on two selected areas, conclusions and findings, and recommendations. Please note that all the sources used in the body of the written assignment must be acknowledged and properly referenced. Please go through the subject outline for all other requirements on the submission of this assignment.

Part A: You have received an invitation from your lecturer to register in XERO. After the completion of the registration complete the following tasks.

Task 1: Change the organisation details in "Organisation settings"

  • Display name : <Group Name> Limited.
  • Legal/Trading name : <Group Name> Limited.
  • Organisation type : Company

 

Task 2: Make the following changes in the chart of accounts:

  • Add a new current assets account and name it "ANZ Bank"
  • Change the name of the account #970 to "Capital"

Task 3: The following are the extract of <Group Name> Limited on 28 February 2019. Enter these account balances in XERO and take a print out of the balance sheet. [Hints: Conversion month: Feb 2019.]

Trial Balance 28 February 2019

Code

Name

DR

CR

601

ANZ Bank

*

 

610

Accounts Receivable

4,725.00

 

620

Prepayments

7,700.00

 

630

Inventory

100,174.00

 

710

Office Equipment

7,500.00

 

711

Less Accumulated Depreciation on Office Equipment

 

1,250.00

720

Computer Equipment

15,000.00

 

721

Less Accumulated Depreciation on Computer Equipment

 

2,500.00

800

Accounts Payable

 

8,500.00

970

Capital

 

?

* Total of last 4 digit of the group members student ID.

You need to add 1 invoice for accounts receivable $4725 and 1 bill for accounts payable for $8500 to complete the process of conversion balances.

Task 3: Enter the following transaction in XERO. These transactions took place during the month of March 2019: (All sales & purchases amounts are tax inclusive, so make sure you do it accordingly in XERO)

Mar 1 Owner contributed additional $15,000 to his business <Group Name> Ltd.

Mar 4 Purchased new office equipment for $2000 from Officeworks.

Mar 5 Received purchase invoice from supplier XYZ Ltd. for inventory $8,000.

Mar 5 Received telephone bill $300 from Optus.

Mar 6 Received electricity bill $250 from Dodo.

Mar 6 Sales for the day - cash sales $2,000 and credit sales 3,000 (ABC Ltd.)

Mar 8 Billed an invoice for $5,000 to a new credit customer EF Ltd.

Mar 10 Paid salaries $3,000.

Mar 12 Sales for the day - cash sales $3,000 and credit sales $2,000 (MN Ltd).

Mar 13 Received a cheque from EF Ltd. for the sales on Mar 8.

Mar 15 Paid telephone bill.

Mar 16 Paid electricity bill.

Mar 18 Paid rent to P&P Real Estate for the month $2200.

Mar 20 Paid for Advertisement expenses $500.

Mar 21 Paid to suppliers XYZ Ltd. for inventory purchased on Mar 5.

Mar 21 Received an invoice from XYZ Ltd. for inventory purchase $6,000.

Mar 21 Sales for the day - cash sales $4,000 and credit sales $5,000 (RPO Ltd.).

Mar 24 Paid salaries $2000.

Mar 25 Sent a quote for a Prospective Pty Ltd. for $10,000

Mar 27 Received payment from RPO Ltd. for the sale on Mar 21.

Mar 30 Sales - cash $2,000 and credit $5,000 (KPM Ltd.).

Adjusting Entries

Mar 31 Insurance expense for March $250 is adjusted from prepayments.

Mar 31 Depreciation for office equipment to be recorded for the month $1150.

Mar 31 Depreciation for computer equipment to be recorded for the month $1500.

Mar 31 Inventory on hand counted at the end of the month $100,500.

Print the journal entries for all the above transactions.

Task 4: Print the Trial Balance.

Task 5: Print the statement of profit or loss.

Task 6: Print the Balance Sheet as at 31 March 2019.

Task 7: Hand in all the printouts with the coversheet signed by each members of the group.

Part B: Complete the following tasks:

Task 1: Get approval from your lecturer for ASX listed company.

Task 2: Download the annual report.

Task 3: Select 2 areas for ratio analysis.

Task 4: Calculate the ratio, write your interpretation of the ratio analysis in a report.

Task 5: Submit submission of the word file for this section by due date.

Task 6: Hand in the printout of the word file with cover page to your lecturer.

Task 7: Prepare a PowerPoint presentation and present in class at your allocated time in week 11 or 12.

Attachment:- Assignment File.rar

Reference no: EM132312170

Questions Cloud

How to write essay about focusing on marketing and ethics : It is about focus on one or up to two marketing areas only (Product, Pricing, Distribution and Promotion including Advertising).
Essay focusing on marketing and ethics : Focus on one or up to two marketing areas only (Product, Pricing, Distribution and Promotion including Advertising).
Determine the effect of marangoni convection on mixing : 300597 Master Project 1 Western Sydney University Australia-Determine the effect of Marangoni convection on mixing of molten glasses.
Write a reflection integrating both the diep structure : PREP1012 - Personal and Professional Development - George Brown College - Beginning Reflection - write a reflection integrating both the DIEP structure
Write your interpretation of the ratio analysis in a report : ACC100 Principles Of Accounting Assignment, Polytechnic Institute Australia. Calculate the ratio, write your interpretation of the ratio analysis in a report
Production and operations management : How can Internet and other information technologies support business processes within the business functions of accounting, finance, human resource management
Examples of organizational behavior concepts enacted : You may write a 2-3 page paper outlining examples of organizational behavior concepts enacted in class. The teacher pays attention to each student's performance
Factors and give examples of each force : What is Porter's 5 factors and give examples of each force.
What you already knew about your bargaining style : What if anything did you learn about yourself? Were you surprised, or did the survey confirm what you already knew about your bargaining style?

Reviews

len2312170

5/27/2019 12:37:44 AM

Formation of Group: Maximum 4 members in a group. Assessment due date: Part A – Written assignment (10 marks) – Week 6 Friday. Part B – Written report on the analyses of assigned company (10 marks) – Week 10 Friday. Part B – Group presentation on the analyses of assigned company (5 marks) – Week 11 and 12 in class.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd