Prepare a common-size statement for the balance sheet

Assignment Help Auditing
Reference no: EM131455284

Guide of Case Study Assignment- Audit Planning- Cloud 9 Pty Ltd

W&S Partners commenced the planning phase of the Cloud 9 audit with procedures to gain an understanding of the client's structure and its business environment. You have completed your research on the key market forces, as they relate to Cloud 9's operations. The topics you researched included the general and industry-specific economic trends and conditions; the competitive environment; product; customer and supplier information; technological advances and the effect of the internet; and laws and regulatory requirements. The purpose of this research is to identify the inherent risks. The auditor needs to indentify which financial report assertions may be affected by these inherent risks. Identifying these risks will help determine the nature of the audit procedures to be performed.

Management implicitly or explicitly makes assertions regarding the recognition, measurement, presentation and disclosure of the various elements of a financial report. Auditors use assertions for account balances to form a basis for the assessment of risks of material misstatement. That is, assertions are used to identify the types of errors that could occur in transactions that result in the account balance. Consequently, further breaking down the account into these assertions will direct the audit effort to those areas of higher risk. The auditors broadly classifies assertions as existence or occurrence; completeness; valuation or allocation; rights and obligations; and presentation and disclosure.

An additional task during the planning phase is to consider the concept of materiality as it applies to the client. The auditor will design procedures in order to identify and correct errors or irregularities that would have a material effect on the financial report and affect the decision making of the users of the financial report. Materiality is used in determining audit procedures and sample selections, and evaluating differences from client records to audit results. It is the maximum amount of misstatement, individually or an aggregate, that can be accepted in the financial report. In selecting the base figure to be used to calculate materiality, an auditor should consider the key drivers of the business. They should ask, "what are the end users (that is, shareholders, banks etc) of the accounts going to be looking at?" For example, will shareholders be interested in profit figures that can be used to pay dividends and increase share price?

W&S Partners' audit methodology dictates that one planning materiality (PM) amount is to be used for the financial report as a whole (that is, rather than separate PMs for the income statement and the balance sheet). Further, only one basis should be selected- a blended approach or average should not be used. The basis selected is the one determined to be the key driver of the business.

W&S Partners use the following percentages as starting points for the various bases:

BASE

THRESHOLD (%)

Profit before tax

5.0

Turnover

5.0

Total assets

0.5

Equity

1.0

These starting points can be increased or decreased by taking into account qualitative client factors, which could be:

- the nature of the client's business and industry (for example, rapidly changing, either through growth or downsizing, or an unstable environment)
- if the client is a listed entity (or subsidiary of) subject to regulations
- the knowledge of or high risk of fraud.

Typically, profit before tax is used; however, it cannot be used if reporting a loss for the year or if profitability is not consistent.

When calculating PM based on interim figures, it may be necessary to annualise the results. This allows the auditor to plan the audit properly based on an approximate projected year-end balance. Then at year-end the figure is adjusted, if necessary, to reflect the actual results.

Part 1- Materiality

Required

Answer the following question based on the information presented for Cloud 9 in the appendix to this case study.

(a) Using the 30 September 2011 trial balance (appendix to this case study) calculate planning materiality and include the justification for the basis that you have used for your calculation.

1. Planning Materiality (PM)

The students' PM worksheet should be as follows. However, that there may be alternate formats:

Planning Materialty

 

 

 

 

 

 

 

Base amount

$

%

PM

Profit before tax

 

 

 

Turnover

 

 

 

Turnover

 

 

 

Total assets

 

 

 

Equity

 

 

 

Students should select Revenues or Turnover as the basis for calculating PM.

Note: The students can select any answer from the three options given above except net loss. The planning materiality can be computed out of Revenue (Turnover) or total assets. They need to write about two paragraphs justifying their answer.

Part 2- Analytical Procedures

Required

Answer the following questions based on the information presented for Cloud 9 in the appendix to case study.

(a) Using analytical procedures and the information provided in the appendix, perform an analysis of Cloud 9's financial position and its business risks. Discuss the ratios indicating a significant or an unexpectedfluctuation.

Analytical Review

 

 

 

 

 

Year ending 30 Sept

Year ending 31 Dec

Description

Formula

2011

2010

Liquidity ratios

 

 

 

Current ratio

 

 

 

Quick Ratio

 

 

 

Inventory turnover

 

 

 

Accounts receivable

 

 

 

 

 

 

 

Solvency ratios

 

 

 

Debt to equity

 

 

 

Times interest earned

 

 

 

 

 

 

 

Profitability ratio

 

 

 

Gross profit ratio

 

 

 

Net profit ratio

 

 

 

ROA or ROEC

 

 

 

Retrun on equity

 

 

 

 

 

 

 

You need to add explanations.

Note: 6 marks to be given for the above worksheet. The students need to compute a minimum of 6 ratios out of 10 ratios given above. 4 marks should be given for the above comments.

(b) Prepare a common-size statement for the balance sheet of Cloud 9, use total assets as the basis for the balance sheet.

Please google examples of common-size statement for the balance sheet.

https://www.youtube.com/watch?v=S4L49s9Q5b

You also need to add comments and analysis of Common size statements.

Notes: 1. 6 marks should be given for the above worksheet. The student answers may be different because they might classify current and non current liabilities in different ways for the interest bearing loans and long service leave provisions.

(c) Which specific areas do you believe should receive special emphasis during your audit? Consider your discussion of the analytical procedures results, comments on the common-size statement and as well as your preliminary estimate of materiality. Prepare a memorandum to Suzie Pickering, Audit Senior outlining potential problems areas (that is, where possible material misstatements in the financial report exist) and any other special concerns (for example, going concern). Specify the accounts and related assertions that would require particular attention.

Memo to include the following:

The major areas to be considered by the audit are as follows:

1. The total revenue change
2. Advertising expenses, sales and promotional expenses
3. The Insurance expenses
4. Current and quick ratio
5. Accounts receivable turnover
6. Overall liquidity and solvency and profitability
7. Inventory balance
8. PPE
9. Increase in payables
10. Special disclosures

Note: 1 mark for each of above points. The students need to write only 10 points to get the total marks

Verified Expert

This is an individual assignment of audit. Bifurcation into three part. This assignment requires to prepare an audit plans. And request us to calculate various ratio and impact of same in financial position of company.Moreover there are 10 ration specially given in, we need to identify the impact and consequently on financial position of given company.

Reference no: EM131455284

Questions Cloud

Promoting diversity and racial equality : What evidence can you locate that unions, in general, have a good or bad track record in promoting diversity and racial equality?
Review the case peterson v hewlett-packard co : Employee sued employer for religious discrimination and alleged religious harassment after being terminated for repeatedly refusing to remove biblical passages.
Determine background and foreground color : Determining Background and Foreground Color. Each pixel on the screen had a single byte that stored the background and foreground color.
Discuss the importance of leadership team : Discuss the importance of leadership team buy-in of the strategy. Discuss the use of at least two analytical tools in performing a situational analysis
Prepare a common-size statement for the balance sheet : ACC305- Auditing and Assurance Services - Prepare a common-size statement for the balance sheet of Cloud 9, use total assets as the basis for the balance sheet - perform an analysis of Cloud 9's financial position and its business risks. Discuss the..
Write program that ask user which bit in a signed short int : Write a program that will ask a user which bit in a signed short int that they would like to switch its value (from 0 to 1 or 1 to 0).
Write program that will ask user how much their purchase was : Write a program that will ask a user how much their purchase was, and then how much money they gave to a sales person.to a sales person.
Is evidence of discrimination sufficient to support a claim : Calder, aged 60, worked as an account executive for TCI Cable, selling advertising time. Calder believed that she had a number of negative experiences at TCI.
How does the monitoring of a daily activity help a company : How does an everyday activity such as driving to and from the workplace affect the efficiency and productivity of an employee?

Reviews

inf1455284

4/21/2017 5:54:22 AM

It truly helped me show signs of improvement review for my assignment. Much obliged to you for helping me alter my paper. Such a great amount for conveying my task appropriate on time and for your administration. Everlastingly appreciative.

inf1455284

4/21/2017 5:53:47 AM

Here is some requirement of project, ( where is a Trial Balance ??) Using the 30 September 2011 trial balance (appendix to this case study) calculate planning materiality and include the justification for the basis that you have used for your calculation. I need all financial statement of the given company. 1st three pages. 22643636_1IMG 0655.JPG 22643636_2IMG 0656.JPG 22643636_3IMG 0657.JPG last two pages. As requestee. 22643616_1IMG 0658.JPG 22643616_2IMG 0659.JPG

len1455284

4/8/2017 5:14:46 AM

The students can select any answer from the three options given above except net loss. The planning materiality can be computed out of Revenue (Turnover) or total assets. They need to write about two paragraphs justifying their answer. (5 marks for the computations and 5 marks for the reasons- Total - 1 mark for each of above points. The students need to write only 10 points to get the total marks 1 mark for each of above points. The students need to write only 10 points to get the total marks

len1455284

4/8/2017 5:12:21 AM

Please read every requirement carefully and do the needful. Subject Name: ACCG305- Auditing and Assurance Services The students can select any answer from the three options given above except net loss. The planning materiality can be computed out of Revenue (Turnover) or total assets. They need to write about two paragraphs justifying their answer. (5 marks for the computations and 5 marks for the reasons- Total 10 marks). 6 marks to be given for the above worksheet. The students need to compute a minimum of 6 ratios out of 10 ratios given above. 4 marks should be given for the above comments. 1. 6 marks should be given for the above worksheet. The student answers may be different because they might classify current and non current liabilities in different ways for the interest bearing loans and long service leave provisions

Write a Review

 

Auditing Questions & Answers

  Internal controls related to the use of p-cards

Organizations frequently use procurement cards (often referred to as P-Cards) to purchase goods or services using processes outside normal acquisition and cash disbursement procedures.

  Question audit sampling in tests of control activitiesa

question audit sampling in tests of control activitiesa. define audit sampling.b. which word properly completes each of

  Questionone aspect of the zzz best case focused on client

questionone aspect of the zzz best case focused on client acceptance and the predecessor-successor auditor

  What key points would you address and why

The Board of Directors asks you to prepare a report for a follow-up meeting indicating whether or not their long term liabilities have been properly valued. What key points would you address and why?

  Identify the ethical principles violated

Identify the ethical principles violated - In each discussion-excerpt above identify the specific threat to independence.

  What is involved in the evaluation process

What is the objective of this evaluation? What is involved in the evaluation process? Do you think this evaluation is an effective method to assess clients? Why or why not? What is the focus of the assessment?

  Identify transactions related to governmental entities

Identify specific transactions related to governmental entities How will accomplishing these objectives support your success in accounting?

  Describe the fundamental audit procedures

Assume you are an auditor for a firm that had $10 million dollars invested in Madoff Securities. Determine the fundamental audit procedures that you should have applied to this investment.

  Submit a feasibility report

You are required to submit a feasibility report. At a minimum level, your feasibility report should contain the following generic sections:

  Which role does each person in scenario closely represent

Which role does each person in the scenario most closely represent and how do the relationships between these roles differ from how these roles are related in a typical financial statement audit?

  Provide a brief overview of the nature of the auditing

Your assignment should answer the following questions: Provide a brief overview of the nature of the auditing/ethical issue/s involved. How does auditing promote common good

  Determine how much steve stole

They're going over the last six month's transactions to try to determine how much Steve stole.

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