Review using horizontal analysis of income statement

Assignment Help Accounting Basics
Reference no: EM131836886

Details of your task

You are planning an audit and have access to the preliminary trial balance for your client. You would like to use the trial balance to identify accounts that are likely to require significant audit attention. Follow the directions to the appropriate worksheet.

Ryanco - Trial Balance

    Jul 1, 2016 - Mar 31, 2017 Jul 1, 2015 - June 30, 2016
    Debit Credit Debit Credit
Cash at Bank          89,750        83,000  
Accounts receivable       109,850      103,585  
Inventory       164,500      174,000  
Machinery          64,000        64,000  
Accumulated Depreciation          30,207        24,000
Motor Vehicles          66,000        66,000  
Accumulated Depreciation          40,913        21,000
Furniture              7,400           7,400  
Accumulated Depreciation            2,760           2,220
Bank Loan          240,000      240,000
Sales            145,894      187,450
Cost of sales          44,288        63,595  
Consultancy fees            44,438        57,000
Interest income                    36                 50
Bank charges                261              350  
Depreciation          26,659        15,738  
Interest expense            8,625        12,000  
Printing                  278              375  
Miscellaneous            1,080                  -    
Wages            39,428        53,000  
Superannuation            3,746           5,035  
Owner's Equity          121,616      116,358
          625,864        625,864    648,078    648,078

Your task:

You must choose six (6) accounts from the trial balance for audit testing. In doing so, you should:

- Complete an analytical review using horizontal analysis of the Income Statement and the Balance Sheet using the trial balance provided. Your analysis should include the gross profit margin, the net profit margin and one other ratio that you select. Explain why you have selected that ratio.

- Make a preliminary judgement of materiality using the blended Method. Complete an overall (for the financial report as a whole)
and performance materiality, justify your selected level and cite your sources.

- Use the analytical review and materiality assessment to identify accounts that are at-risk of material misstatement.

- Consider whether there are any accounts that should be selected regardless of their quantitative materiality, including one account that may be at-risk of fraud.

- Provide a brief rationale for the selection of each of the 6 accounts.

- For each account that you have selected, identify one assertion that is at risk (i.e. identify 6 assertions in total). Please include an explanation as to why the assertions are at risk.

- For each account/assertion briefly explain an audit procedure that could provide evidence relevant to the assertion.

Verified Expert

In the given assignment, and an analytical review using horizontal analysis of the Income Statement and the Balance Sheet using the trial balance provided has been done. further the required ratios are calculated, Materiality analysis, identification of accounts at risk, and for accounts / assertion selected audit procedures are discussed.

Reference no: EM131836886

Questions Cloud

What can you do to help solve the e-waste problems : 1-What new terms were introduced? 2-What e-waste problems were presented?
Calculate the final equilibrium temperature : 400 cm3 of water at 92°C is mixed with 120 cm3 of water at 18°C. Calculate the final equilibrium temperature, assuming no heat is lost to outside the water.
Intracellular fluid and extracellular fluid : What major factors can alter the distribution of K + between intracellular fluid and extracellular fluid?
Identify and describe siem : Identify and Describe SIEM and Underlying Principles of SIEM and explain the SIEM Implementation.
Review using horizontal analysis of income statement : ACC621 - Complete an analytical review using horizontal analysis of the Income Statement and the Balance Sheet using the trial balance provided
Write descriptive evaluations of the sources : This assignment requires that you collect, review, and write descriptive evaluations of the sources that you will incorporate in your term paper.
What is the positive and negative feedback : What is the Positive and negative feedback? What are they, and how they affect physiology?
Proteins modified by calcium binding : 1.Proteins modified by calcium binding and/or phosphorylation do not control
Should the trauma patient be tested for hiv : Should the trauma patient be tested for HIV? Why or why not? Should the patient enjoy the right to consent to the HIV test? Why or why not?

Reviews

len1836886

1/29/2018 5:48:49 AM

Spelling, grammar, referencing and overall presentation (2 marks) None or minimal spelling and grammar errors. None or minimal referencing errors. A well-presented report. (2/2) Mostly free from spelling and grammar errors. Mostly free from referencing errors. A reasonably well- presented report.(1.75/2) A moderate level of spelling and/or grammar errors. A moderate level of referencing errors. These errors did not significantly impede the communication. A moderately well- presented report. (1.5/2) A moderate level of spelling and/or grammar errors making the report difficult to read. A moderate level of referencing errors. A poorly presented report with sections missing. (1/2) Significant errors which made assignment difficult to interpret. References missing. Little evidence of a report format being used. (0 to 0.5/2) Research quality and range of sources (3 marks) More than 3 sources cited that were highly relevant to the topic and well linked to the task. (3/3) Three (3) sources cited that were highly relevant to the topic and well linked to the task. (2.5/3)

len1836886

1/29/2018 5:48:39 AM

Consideration of qualitative factors (2 marks) Student demonstrated insightful consideration of fraud factors with regards to at least 1 selection. (2/2) Student demonstrated logical consideration of fraud factors with regards to at least 1 selection. (1.75/2) Student demonstrated reasonable consideration of fraud factors with regards to at least 1 selection. (1.5/2) Student demonstrated some consideration of fraud factors. (1/2) Insufficient consideration of fraud factors was evident. (0 to 0.5/2) Assertions and procedures (4.5 marks) Assertions identified are well justified and realistic. Audit procedures are realistic and would provide strong evidence for the assertions. (4 to 4.5/4.5) Assertions identified are valid and well justified. Audit procedures would provide evidence for the assertions. (3.5/4.5) Most assertions identified are valid and justified. Most of the identified audit procedures would provide evidence for the assertions. (3/4.5) Many assertions identified are valid and justified. Many of the identified audit procedures would provide evidence for the assertions. (2 to 2.5/4.5)

len1836886

1/29/2018 5:48:25 AM

Materiality assessment (4.5 marks) Materiality assessments were realistic and logical. (4 to 4.5/4.5) Materiality assessments were logical. Minor improvements could have been made to materiality assessment. (3.5/4.5) Materiality assessments were mostly logical. Some errors were noted in materiality assessment. (3/4.5) Materiality assessments were somewhat logical. Significant errors were noted in materiality assessment. (2 to 2.5/4.5) Materiality assessments were missing or significantly flawed. (0 to 1.5/4.5) Selection and justification of accounts (4.5 marks) Student identified 6 valid accounts. All selections were well justified and realistic. (4 to 4.5/4.5) Student identified 5 valid accounts. All selections were well justified. (3.5/4.5) Student identified 4 valid accounts. Most selections were well justified. (3/4.5) Student identified 3 valid accounts. Some justification was evident. (2 to 2.5/4.5) Student did not successfully identify at least 3 valid accounts. Justification was inadequate. (0 to 1.5/4.5)

len1836886

1/29/2018 5:48:19 AM

HD D Cr P F Analytical review in specified format (4.5 marks) Analytical review was well- considered and effective. (4 to 4.5/4.5) Analytical review was effective. Minor improvements could have been made to analytical review. (3.5/4.5) Analytical review was mostly effective. Some errors were noted in analytical review. (3/4.5) Analytical review was somewhat effective. Significant errors were noted in analytical review. (2 to 2.5/4.5) Analytical review was missing or significantly flawed. (0 to 1.5/4.5)

len1836886

1/29/2018 5:48:12 AM

The stated total word count is 1,600 words. However assignments between 1,400 and 1,800 words in length will be considered acceptable. The criteria rubric with which your assignment will be marked This assignment is worth 25% of your overall grade. It will be marked out of 25.

len1836886

1/29/2018 5:47:49 AM

Therefore, it is critical that you provide complete referencing for any sources of information you use in preparing your assignment. This includes both in-text references and a list of references at the end of your assignment. Referencing should be in accordance with USC’s guidelines for Harvard referencing. The assignment should only be submitted electronically via Safe Assign on the course Blackboard site. If you wish to apply for an extension to your submission date, please email Donald Jamieson to explain the circumstances and attach any necessary supporting documentation. Extensions will only be considered in very limited circumstances as per USC policy. Late penalties will be applied for assignments submitted after 5pm on the due date without an approved extension. More details on late penalties are provided in the course outline.

len1836886

1/29/2018 5:47:25 AM

ACC621 Assignment – Semester 3 Due Date: Monday 5 at 5pm Weighting: 25% In this document you will find: • General information about the assignment, • Details of your task, • A suggested template for your answer, and • The criteria rubric with which your assignment will be marked. General information about the assignment The assignment must be your own individual work; i.e. it is not a group assignment. If it is believed that a student has copied material from another student or any other source without appropriate referencing, the necessary action will be taken under the University’s Student Academic Misconduct Policy

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