User Account

All Pages

Perform a horizontal analysis

Assignment Help Accounting Basics
Reference no: EM131565057

Analytical Procedures Exercise

You are a staff auditor at Willis & Adams, LP Audit Firm and you are working on the 2014 audit of Bengro, Inc., a manufacturer of outdoor patio furniture. You have been asked by the audit manager to perform a preliminary analytical procedure on Bengro's financial statement (FS) accounts as of year-end. Bengro has downloaded its unadjusted trial balance into excel for your convenience.

Requirements

1. Following Willis & Adam's LP Materiality Guidelines, determine Planning Materiality. A tab has been included in the excel workbook for your benefit. Round PM to the hundred thousand dollar mark (e.g., $13,100,000, not $13,128,500). Using a formula for rounding would be smart.

2. Use Excel's Pivot Tables function to create three distinct pivot tables: (1) for the Corporate Location; (2) a combined table for the three store locations (i.e., Atlanta, Dallas, Oxford); (3) a consolidated table for all locations (Corporate, Atlanta, Dallas, and Oxford). You must use the Pivot Tables function, you cannot create the tables manually. You should only include balance sheet accounts. You should include Location as a Report Filter. The Pivot Tables should be classified using the FS Account column, and you should include 2014, 2013, 2012, and 2011 balances. You should finish with 3 separate pivot tables on 3 separate tabs in your Excel document. Name the three tabs: ConsolidatedPT, StoresPT, and CorporatePT.

3. Perform a Horizontal Analysis. This involves calculating a dollar difference, and a percentage difference for 2014 vs. 2013 FS Account balances. These calculations must be done using a formula, not by hand, and the formulas should be adjacent to the pivot table. Format the dollar difference cells using the accounting number format and no decimal places (i.e., $13,827,000). Format the percentage difference cells using one decimal place (i.e., 8.1%). Horizontal Analysis should be performed on each of your three pivot tables.

4. Based on the horizontal analysis, identify at least four FS accounts that you believe are important for the auditor to further investigate.  At least one FS account should be identified from each of your three Pivot Tables. It is important that you use your accounting knowledge when considering year-to-year fluctuations. Just because a large change occurs, does not mean that it is unexpected, and it may not require any additional audit attention. The accounts you identify can come from any of the three Pivot Tables. Willis & Adams' LP instructs their auditors to use a "scope" for this analysis of Planning Materiality and a ten percent change.

5. Based on the FS accounts that you identified in Step 4, above, list 2 (and only 2) assertions that you believe represent the greatest risk of material misstatement.

Upload your completed file to iCollege. Save your Excel document using a combination of your class section, team number, separated by periods.

Attachment:- Assignment Files.rar

Reference no: EM131565057

Questions Cloud

What characteristics does the author state are needed : What characteristics does the author state are needed for an organization to develop an evaluation culture? Explain in detail.
What is the shareholders tax basis in her company stock : Company reports current E&P of $310,000 and accumulated E&P of negative $282,500. What is the shareholders tax basis in her company stock after the distribution
List clearly each of the types of loan requested and amounts : List clearly each of the types of loans requested, amounts, what are the terms, the collateral provided by the company to the bank (if specified).
Discuss how walker and stewart''s ideas : Write a post in which you discuss how Walker and Stewart's ideas are represented in modern American society
Perform a horizontal analysis : Perform a Horizontal Analysis. This involves calculating a dollar difference, and a percentage difference for 2014 vs. 2013 FS Account balances
Discuss killings of alton sterling and philando castile : Does this 21st century tragedy and the response reflect Wells-Barnett's ideas about the problem of and solutions
Compute the net present value and profitability index : Compute the (1) net present value, (2) profitability Index, and (3) internal rate of return for each option
Think about what your source tells you about the event : Why was this event important,and how does it fit into the conflicts and changes of the 1920s?Think about what your source tells you about the event.
Examine the mission and history of the sec : Examine the mission and history of the SEC. Determine whether the regulatory bodies of securities market have been helpful or hurtful to the average investor.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Create an innovative idea for a new product or service

During this course you will work within a CLC to create an innovative idea for a new product, service, or business. Each member of the team will be responsible for contributing an innovative idea to the team for consideration.

  The chief administrator of uptown clinic a community mental

In an Excel spreadsheet: Provide a dollar range of costs to reduce budgets (worst and best case analysis). She needs to cut $94,000 in cost. Prioritize those cuts that can be made without impacting the operation or quality care of the organization.

  The following information in millions of dollars is

the following information in millions of dollars is available for designer brands for 2007 sales revenue 12580 net

  In the video that you watched a grocery clerk brought a

in the video that you watched a grocery clerk brought a woman that had gone into labor to the hospital using the

  Oscar is retiring from the jms partnership in january of

oscar is retiring from the jms partnership. in january of the current year he has a 120000 basis in his partnership

  Determine for each plan the earnings per share of common

three different plans for financing a 5000000 corporation are under consideration by its organizers. under each of the

  Briefly describe the components of each side of the equation

What is the budgetary equation? Briefly describe the components of each side of the equation.

  Pay all of the liabilities

Identify two ways to finance the remaining $20,000 you will need, so you can pay all of the liabilities when they are due.

  An asset costing 10000 was reclassified from the

an asset costing 10000 was reclassified from the generalcapital assets accounts of a governmental unit to the

  Prepare a depreciation schedule for the asset showing

clary jensen farms purchased power equipment with an expected useful life of four years or 1000 hours of usage. the

  What types of industries have unearned revenue

What types of industries have unearned revenue? Why is unearned revenue considered a liability? When is the unearned revenue recognized in the financial statements?

  Total of manufacturing overhead applied

Which one of the following should be equal to the balance of the work in process inventory account at the end of the period?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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