Prepare common size income statements and balance sheets

Assignment Help Accounting Basics
Reference no: EM132013808

Assignment -

This Assignment requires that you prepare an Excel Spreadsheet - similar to one that would be used in practice in the planning phase of the audit. The auditor must first develop an expectation, usually based on the performance in the prior period (taking into consideration any unusual circumstances in the current period). We will assume no unusual circumstances in the current period. This company is a new and growing company, and we would expect sales to increase in the current period (compared to the previous period).

Requirements:

(a) Prepare common size Income Statements and Balance Sheets for the prior and current periods.

(b) Based on the relationships in the prior period Income Statements and assuming Sales of $900,000, calculate the expected amounts (dollar amounts) for the various expense accounts (including COGS). All calculations should be completed in the Excel spreadsheet.

(c) Prepare a column that shows the dollar difference between our expected amounts and actual amounts (for expense accounts and COGS). Assuming that the tolerable misstatement for planning purposes on the audit is $ 15,000 highlight accounts that will require more extensive examination and testing (based only on this particular measure).

(d) Some income statement accounts are better analyzed by looking at their relationship to balance sheet accounts (and vice versa). For example, the investment income (an income statement account) is dependent on rates of return and changes in the Investment account (a balance sheet account). In the Foxx Statements, there has been no change in the amount of their investment, so it is reasonable that there has been little change in the Investment Income account. Using the Foxx Corporation Financial Statements, provide a similar example and an explanation of the relationship.

Attachment:- Assignment File.rar

Reference no: EM132013808

Questions Cloud

Efficiency of executive branch offices : What are your thoughts on the role of the bureaucracy? What could be done to increase the efficiency of executive branch offices?
Why would someone want to limit campaign contributions : Why would someone want to limit campaign contributions? What effect do campaign contributions have on elected representatives?
What is the yield to call in given case : New Homes has a bond issue with a coupon rate of 5.5 percent that matures in 12.5 years and is callable in 8.5 years. The bonds have a par value of $1,000.
Why did brexit occur and are other countries : Why did Brexit occur and are other countries likely to follow suit? Are their downsides of joining the EU?
Prepare common size income statements and balance sheets : This company is a new and growing company, Prepare common size Income Statements and Balance Sheets for the prior and current periods
What would new mexico record as annual depreciation expense : New Mexico Corporation leased equipment under an agreement that qualifies as a capital lease. The present value of the minimum lease payments is $120,000.
What do you think accounts for this change over time : What sense do you and others make of this? We see that civil war is on the increase, the total number of lives lost has been on the continual decline.
Commands the nation only source of clean water : The government refuses, claiming that the territory in question, which commands the nation's only source of clean water, is vital to security.
How culture is filtered through technology : Are these changes fundamentally altering culture or are they more superficial alterations of how culture is filtered through technology?

Reviews

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