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

  Information about cost of borrowing

Pyramid Products Company has a revolving credit agreement with its bank. The company can borrow up to $1 million under the agreement at an annual interest rate of 9 percent.

  Prepare an audit programme to audit the transactions

Prepare an audit programme to audit the transactions surrounding the sale and leaseback of the head office of Seaside Ltd and prepare a report to the group financial manager on the appropriateness of the motor vehicle retailing division's recognitio..

  Audit engagement letter sample

What items are usually included in an effective engagement letter? Have you seen an engagement letter at your workplace or familiar with one and how are you involved in the process? Please find an engagement letter and comment on it

  Audit interest expense and interest payableaccounts

Your client, Red Horse, Inc., prepared the following schedule for long term debt for the audit of financial statements for the year ended December 31, 2013:

  Recognize and discuss the pressures faced by andy card

Differences between the book value and the fair value of the identifiable assets of Salem Company

  Toadycom is a new public phone and internet company heavily

toady.com is a new public phone and internet company heavily financed by the eastpac bank. during your audit of

  How would you justify the incremental expenses

How would you justify the incremental expenses of establishing an internal audit function in this company? Response should be in own words with a minimum of 90-word count.

  Fair value estimates make the audit

1.Briefly explain why accounting standards related to fair value estimates make the audit of financial instruments more complex.

  Increased inherent risk assessment at account balance level

HA3032 AUDITING AND ASSURANCE SERVICES INDIVIDUAL ASSIGNMENT. List and discuss several inherent risk factors that would have contributed to an increased inherent risk assessment at the account balance level

  Reporting for operational and financial auditing

What are the major differences between reporting for operational and financial auditing?

  Ipo registration report on behalf of the client

You are an auditor filing an 8-K Interim Event. Describe your client and what circumstances led you to decide you needed to file this report.

  Create a continuous internal control process

Choose a control that you find interesting, and do additional research to thoroughly explain it to your peers. Be sure to share your references - This organization is made up of representatives from the AICPA, the IIA, IMA, and other leading authorit..

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