Prepare a full set of general purpose financial reports

Assignment Help Accounting Basics
Reference no: EM131499917 , Length: word count:1600

Intermediate Corporate Accounting Individual or Group Assignment

TOPIC:  Preparation of Financial Statements and Report

DAISY TEXTILES

Daisy Textiles was registered as a company on 1 July 2012 under the name Daisy Textiles Distribution WA Pty Ltd and is involved in the wholesale distribution of textiles and haberdashery in Western Australia (WA). The company has been operating for 4 years. Inventory is sourced and imported from all around the world for clothes and furnishings. The Company employs' the services of a customs broker to ensure all import duty costs are minimised and goods entering the county comply with Western Australian Customs Regulations.

The Managing Director (MD) of Daisy Textiles is Mrs Rose Gardiner and she is the majority shareholder with 70% of the shares.  The remaining 30% is held by her husband Mr Ryan Gardiner (10%) and her two children Ms Iris Gardiner (10%) and son Mr Bryan Gardiner (10%).Mrs Rose Gardiner is listed as the only director of the company. All shares are classified as ordinary shares and dividends are determined at the end of each year by the MD. The MD Mrs Rose Gardiner is also paid a salary of $100,000 per annum.

Daisy textiles is classified as a small proprietary company under the requirements of the Corporations Act 2001, as evidenced by operating revenue being less than $25 million, gross assets are less than $25 million and they employ less than 50 staff. [6 full time staff excluding the MD and 9additional part time staff are currently employed].  Being classified as small, they are not required to prepare financial statements in accordance with Australian Accounting Standards.  However they are required to keep sufficient records for financial statements to be prepared and audited if required. 

The company has been notified in writing in a letter received 8 July 2017 that they are to be audited by the Australian Tax Office in the next 3 months. The company has been asked to provide a full set of financial statements for 2017 prepared in accordance with Australian Accounting Standards.  Daisy Textiles currently employs a part-time bookkeeper to pay bills and keep basic financial records.  To assist with the preparation of the necessary financial documents, Daisy Textiles has employed you as a Financial Accountant to assist in the preparation of the required financial statements and notes to the financial statements.  You work for ABC Accounting Services and have agreed in a written contract dated 15 July 2017 to prepare the requested general purpose financial reports for a set fee of $25,000 or $5,000 a day for 5 days.

REQUIRED -

Using Microsoft Excel and Word students are required to:

1) Prepare a full set of general purpose financial reports for 2017 (including as many notes and comparatives as possible) using the information and additional information for adjustments provided. This includes a Statement of Profit and Loss and Other Comprehensive Income, Statement of Financial Position, Statement of Equity and Statement of Cash Flows. (Note: comparatives means the current year and previous year data are required on the face of the statements and in the notes).

2) Prepare a concise report for the managing director explaining the financial performance of Daisy's Textiles Ltd. The report should follow the format of an executive summary and should be no more than 2 pages (using 1 ½ spacing and size 11 font).  

3) This assignment can be completed individually or as a small group with 2 members. Both group members are to submit the same assignment online to allow feedback to be provided to both group members. Students MUST clearly identify in their submission their fellow group member. IF students fail to do this, they risk being reported for plagiarism.

4) Students are to assume they need to submit documents that may be required if this was a real client and consulting contract.

5) Assignments are to be submitted via the assignment box link provided in Blackboard.

6) Assignment coversheets are required and will be made available on Blackboard.

7) Students are to submit the following:

a. 1 x Excel spreadsheet with all workings and show a clear effort to utilise the functionalities of Excel to ensure information is linked and clearly displayed. (multiple worksheets may be used but they must be clearly labelled to allow the marker to adequately navigate through the data provided.

b. 1 x PDF file with signed assignment coversheet, copy of report, final financial statements and notes with comparatives that would be submitted to the MD and any other documents deemed necessary to fulfil the contract.

Additional Operating Information -

Notes

  • All adjustments listed should be included in the restatement of the adjusted trial balance.
  • The Statement of Profit and Loss should show the cost of sales, gross profit, distinguish between Administration, Selling and Financial Expenses and show the before and after income tax profit or loss.
  • Other expenses should be part of Administration Expenses unless otherwise specified.
  • Office related expenses should be treated as Administrative Expenses.
  • Sales and Workshop related expenses should be treated as Selling Expenses.
  • The salary related expenses of the MD should be included in Selling Expenses.
  • The company operates a financial year end of 30 June and prepares a Business Activity Statement annually. GST owing is paid in July each year and company tax of 30% is paid in September each year.
  • Depreciation is calculated using the diminishing balance method at the rates shown in the Depreciation Schedule below.
  • Tax depreciation is the same as Accounting Depreciation so there are no deferred tax assets or liabilities associated with non-current assets.
  • The COGS account is treated as a clearing account for the purchase and sale of inventory and is not required to be used for calculations in the general purpose financial statements.

Cost of sales in the statement of Profit and Loss should be calculated as follows:

  • Opening Inventory
  • Add: Purchases
  • Less Purchase Returns and Allowances
  • Less: Discounts Received
  • Add: Freight Inwards
  • Cost of goods available for sale
  • Less Closing Inventory
  • Cost of sales

Notes on Sales and Inventory

  • All Sales revenue and Purchases attract 10% GST. Sales and Purchase figures in the unadjusted trial balance are net of GST. That is GST Outlays and Collection accounts are used to determine GST payable ore receivable for the annual Business Activity Statement (BAS).
  • All sales and purchases of inventory are on credit.
  • Daisy Textiles provides discounts to some customers to encourage payments within 7 days.
  • Daisy Textiles receives some discounts for bulk purchases of inventory from suppliers.
  • Freight inwards is payable separately by Daisy Textiles when inventory is purchased.
  • Most customers pay separately for their own freight to have their goods delivered by their own preferred delivery mode.
  • Closing Inventory on the 30 June 2015 was $270,000.

Notes related to Employees' salaries

  • Superannuation is payable on total gross salary. Refer to Schedule of Employees' Salaries and Leave entitlements for details.
  • Full time staff (excluding the MD) are entitled to 2 weeks accumulating annual leave. (Note: this is in addition to the paid compulsory 4 week closedown period in December and January meaning that staff receive 6 weeks paid leave per annum).
  • Full time staff receive up to 2 weeks paid sick leave per annum. Sick leave is non-accumulating therefore there is no provision for sick leave.
  • Fulltime employees (excluding the MD) are entitled to 3 months Long Service Leave (LSL) on full pay after completing 10 years' of service. All employees are very loyal and are expected to reach the 10 years' of service. In addition if any employee leaves the organisation prior to this date they are entitled to a pro-rata payment for long service leave. This represents a present obligation and therefore a provision is required. The Provision for LSL should be treated as a non-current liability.
  • All Staff (excluding the MD) receive an annual bonus equivalent to 10% of their salary. The bonus amount is included in gross salary and attracts income tax and compulsory superannuation payments.
  • Salaries for full time staff and hourly rates for part-time staff (except the MD) increase 3% per annum.
  • Daisy Textiles are small and do not pay any overtime or Payroll tax as the monthly salary threshold is below $70,833 per month.
  • Part-time employees are not entitled to annual leave or sick leave but they do receive the same annual bonus as all other staff.
  • Daisy Textiles have a Provision for Long Service Leave entitlements and a separate accrual account for annual leave.

Adjustments outstanding

1) Depreciation for new Office Furniture purchased on 1/1/2017 and new Workshop Equipment purchased on 1/3/2017 have not been included in the unadjusted trial balance. (Refer to schedules provided).

2) A review of Office Supplies on hand as at 30 June 2017 indicated the balance should be $2,150 while Workshop Supplies should be $3,685.

3) Prepaid Rent for the workshop should be $4,000.

4) Gas and electricity expenses of $3800 related to the Workshop require accruing.

5) Prepaid Rent for the Office should be $2,000.

6) Income tax (30%) accrual for the financial year ended 30 June 2017 requires adjusting.

7) The Provision for Employee Entitlements needs to be updated for 2017. (refer to schedules provided)

8) Allowance for doubtful debts is estimated to be 5% of current accounts receivable. The allowance for 2017 requires adjusting.

9) The long term investment of $650,000 has continued to be invested at 3% per annum.  Interest is received annually on the 15th of July each year and is deposited directly into the bank account. Annual interest needs to be accrued as at 30 June 2017. 

10) The company director declared a 10% dividend to all shareholders. All dividends are paid by 31 August in the relevant financial year. This adjustment is still required as at 30 June 2017.

Attachment:- Assignment Files.rar

Reference no: EM131499917

Previous Q& A

  Evaluate the current myers-briggs type indicator

Examine your figure or character from the perspective of Jung's theoretical approach to personality and describe your chosen figure.

  Consumer buying behavior vs. the business buying behavior

Discuss the differences between the Models of Consumer Buying Behavior vs. the Business Buying Behavior.

  What are the procedural steps at trial

What are the procedural steps at trial? What is the significance of the procedural steps? How do these steps vary within the United States?

  What is the purpose of adjusted gross income for individual

What is the purpose of adjusted gross income for an individual? What are the four filing statuses for which there are standard deductions?

  Analyze why your memories may have differed

Briefly describe a situation where you or another person remembered an experience or situation differently.

  Compute each stock average return and standard deviation

Compute each stock’s average return, standard deviation, and coefficient of variation.

  Potential sources and methods of networking

If you were starting out as a consultant, how would you locate future clients? Please discuss your potential sources and methods of networking.

  Discuss the niskanen model of bureaucracy

In the aftermath of September 11 there were fears that terrorists would attempt to sabotage the countrys food supply. Food safety is under the jurisdiction.

  What is par or stated value per share of apples common stock

What is the par or stated value per share of Apple's common stock? What percentage of Apple's authorized common stock was issued at September 27, 2014?

  Inpatient and outpatient services

What are some differences between inpatient and outpatient services? How do these differences affect the coding and billing process?

Reviews

len1499917

5/18/2017 2:00:34 AM

Subject- Corporate Accounting. Report should include - Content of Report/Executive Summary, Presentation & Layout, Spelling and Grammar, Correct Profit figure , Correct figures for Assets, Liabilities and Equity and Correct Cashflow figures. Reports as at 30 - Adjusted Trial Balance, Statement of Profit and Loss and Other Comprehensive Income (and Comparatives and Notes), Statement of Financial Position (and Comparatives and Notes), Statement of Equity(and Comparatives) and Statement of Cash Flows for only. All adjustments listed should be included in the restatement of the adjusted trial balance. Depreciation is calculated using the diminishing balance method at the rates shown in the Depreciation Schedule.

Write a Review

 

Similar Q& A

  How to include depreciation and working capital

how to include depreciation and working capital in the following NPV analysis, because depreciation for the machinery goes for longer than the project timeline, and working capital needs to be accounted for as a percentage of sales.

  Determine the correct amount of net income

Determine the correct amount of net income for October and thetotal assets, liabilities, and stockholders' equity atOctober 31. In addition to indicating the corrected amounts.

  Assume that the company estimates its bad debts expense

info providedtotal credit salesnbspnbspnbsp2200000accounts receivable at december 31nbspnbspnbspnbsp825000bad debts

  Product a has a unit contribution margin ucm of 200 and

product a has a unit contribution margin ucm of 200 and product b a ucm of 100. product a takes 10 hours to produce and

  Compare the internal rate of return for both projects

q1.project alpha requires an outlay of 10000 immediately. project alpha has a 1-year life and is expected to produce a

  Commonly used bases other than gaap

Auditors frequently audit statements prepared on bases other than GAAP. Identify and discuss four (4) commonly used bases other than GAAP.

  Acme co is considering two options for acquiring a new

acme co. is considering two options for acquiring a new company car. details on the two options areoption 1. lease the

  What are the required financial statements

What are the required financial statements?

  Lennox company uses a job order costing system

Lennox Company uses a job order costing system.

  Randycom is a direct marketer of popular music following is

randy.com is a direct marketer of popular music. following is information about its revenue and cost structure selling

  Significance of autoregressive term

1. OPEC production, part 2. Using the data from Exercise 54, develop and compare the following models. a) Fit an appropriate autoregressive model by testing for the significance of each autoregressive term.

  Dividend policy at growth firms

Assume that you are following a growth firm whose growth rate has begun easing. Which of the following would you most likely observe in terms of dividend policy at the firm?

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