Examine your companys financial statements

Assignment Help Financial Accounting
Reference no: EM131146228

Assignment: Setting up a Financial Statement

As a nonaccounting 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:

• AUO_MS6010_Compnet_Balance_Sheet_Income_Statement-3.xls
• AUO_MS6010_Ratio_Calculator-2.xls
• AUO_MS6010_Cost_Volume_Profit_Analysis_Template-2.xls
• AUO_MS6010_Compnet_Budget_Template-2.xls

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.

Submission Details:

Apply APA standards to citation of sources. Submit both parts 1 and 2 together and be sure to clearly label each part.

Attachment:- Attachments.rar

Reference no: EM131146228

Questions Cloud

Projects are goal directed and time framed : Projects are goal directed and time framed, and when managed well, projects deliver on time and within budget and the class are familiar that all projects are temporary and undertaken to create a product, service, or result.
Do online education sites help students to get higher marks : Write a custom essay on the given topic "Do online education sites help students to get higher marks"
Find the complete solution representing the motion of mass : A harmonic force of amplitude 180 N and frequency 3.5 Hz acts on the mass. If the initial displacement and velocity of the mass are 15 mm and 5 m/s, find the complete solution representing the motion of the mass.
Examine your companys financial statements : As a nonaccounting manager, you will examine your company's financial statements as well as the financial statements of other companies.
Competitor opened up down the street : John owns a UWM Brew Pub. Business has been slow because a competitor opened up down the street and they have better food and drink specials. Instead of trying to compete, John wants out of the bar business. Who wins and why? What defenses does John ..
Find out the maximum stress within the beam in the snapping : Use ANSYS to model the undeformed beam, derive the upward buckled shape, snap the beam from its upward buckled shape to its downward buckled shape. Simulate the snapping process of the buckled beam within ANSYS. Find out the maximum stress within ..
Discuss how you might incorporate the theories : Differences between the theories. Discuss how you might incorporate the theories into your teaching practice and explain why.
Describing a social determinant of health : Describing a social determinant of health that impacts the pre-natal experience of mental health among women.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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