Analysis of the reported compnet financial statements

Assignment Help Accounting Basics
Reference no: EM13832760

As a non accounting manager, you will examine your company's financial statements as well as the financial statements of other companies. You must be able to recognize differences in these statements and have a general understanding of the various accounts listed on each statement.

In this assignment, you will determine the nature of various financial statement accounts, using the example of Compnet International.

Note: You will apply your learning from this assignment to calculate ratios for Compnet in the discussion for this week.

Tasks:

Consider the following scenario for this assignment: You are a manager at Compnet and your CEO has asked you to break down the financial statements into categories of accounts so that you can analyze trends within the company.

Part I: Computations

Select the links that follow to download and review the financial statements of Compnet International:

Compnet Balance Sheet Income Statement

Ratio Calculator

Cost-Volume-Profit Analysis Template

Compnet Budget Template

As you create the new Excel worksheet, use the prepared financial statements of Compnet.

Complete the following:

Create a horizontal trend analysis of the reported Compnet financial statements. This worksheet should list each financial statement (balance sheet and income statement in this order) on two Excel worksheets (one worksheet file).

In column A, you would list each account on the statement (make sure you show the various categories of accounts).

In column B and following, you would present the annual totals of each account with a monetary difference (absolute) column to compare one year to the next year and a percentage difference column.

Therefore, for each of the two years reported, you will have Y1, Y2, Difference, and Percentage Difference columns. Your trend analysis must include three historical years. Therefore you need to compare Y1 to Y2 and then Y2 to Y3 (fiscal years 2012-2014).

Part II: Summary

After completing the computations on each of the three financial statements, provide a 1-page summary of the trends that you have observed. Describe the material trends by the category of accounts. Did that category of account increase, decrease, and if so by what amount and percentage. Remember to only discuss the major or material trends that you have observed.

Reference no: EM13832760

Questions Cloud

Challenges and opportunities for growth : This assignment will require you to assess your concept of self, your communication skills, strengths and weaknesses, challenges, and opportunities for growth
Why do the pueblo peoples most likely view chaco canyon : Why do the Pueblo peoples most likely view Chaco Canyon
Prepare dine-corp''s march bank reconciliation : Dine-Corp International publishes ratings and reviews of the world's finest restaurants. Following are facts you need to prepare Dine-Corp's March bank reconciliation
How does the telemachy provoke thought : What is the most important lesson that Telemachus stands to learn from the Telemachy? and How does the Telemachy provoke thought about this particular lesson
Analysis of the reported compnet financial statements : Create a horizontal trend analysis of the reported Compnet financial statements. This worksheet should list each financial statement (balance sheet and income statement in this order) on two Excel worksheets (one worksheet file).
What is the minimum mass of water : What is the minimum mass of water
Pro forma income statement and balance sheet : the income statement and balance sheet for Blue Bill Corporation for 2013. Based on the historical statements and the additional information provided, construct the firm's pro forma income statement and balance sheet for 2014.
Evaluate business level strategies use by temple and webster : Identify, discuss and evaluate the business level strategies used by Temple & Webster to compete in the online homewares industry.
Arguementive essay on ambrose bierce short story : Write 1,000 word Arguementive Essay on Ambrose Bierce short story out of the book "Civil War Stories"

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