Ratio analysis and vertical analysis, Financial Accounting

Balance Sheets: contains the balance sheets as of December 31, 2010, 2009, and 2008. Accounting practice and tradition dictates that the most current year is placed nearest to the labels.

Income Statements:  contains the income statements and the statements of retained earnings for the years ended December 31, 2010, 2009, and 2008. Again accounting practice and tradition dictates that the most current year is placed nearest to the labels.

Cash Flows: contains the statements of cash flows for the years ended December 31, 2010, and 2009. Again accounting practice and tradition dictates that the most current year is placed nearest to the labels.

Ratios: contains a list of the ratios you need to calculate for years 2010 and 2009 only.

Vertical Analysis

Perform vertical analysis on the balance sheets and income statements for the three years presented. The vertical analysis should be performed on the same worksheet that the financial data appears on.

Ratio Analysis

Calculate the required ratios on the Ratios worksheet for the two years 2010 and 2009 only. The ratios should be calculated on that sheet. Hint: You may want to capture the needed information from the other worksheets onto the Ratios page first; think about what amounts are required from each statement and then capture those in an organized manner. Once all the needed info is in place, you can calculate the required amounts without leaving the Ratios worksheet; it's just a suggestion. 

Commentary

Is there anything that catches your attention as a result of the calculations you have performed?  Is some measure significantly improving or deteriorating.  Are there accounts or line items that you would specifically like to discuss with the management of Demonstration Corporation because they seem to indicate a current or pending problem for the company? Submit your thoughts and comments in a separate Word document.

Posted Date: 2/25/2013 2:47:27 AM | Location : United States







Related Discussions:- Ratio analysis and vertical analysis, Assignment Help, Ask Question on Ratio analysis and vertical analysis, Get Answer, Expert's Help, Ratio analysis and vertical analysis Discussions

Write discussion on Ratio analysis and vertical analysis
Your posts are moderated
Related Questions
Q. Show Calculation of project net present value? Sensitivity of NPV to sales volume Sales volume giving zero NPV = ((50000/3·605) + 10000)/1·35 = 17681 units This i

Analytical Procedures - Substantive tests of financial information that examine relationships among data as a means of obtaining evidence. Such procedures include: (1) comparison o

The intestate leaves no spouse and no children The net estate devolves as follows: to his Father; or if dead Mother; or if dead Brothers and sisters, and any child o

While many people know that Sonora, Mexico is a beautiful vacation spot, it is also a large furniture manufacturing location in North America. Guillermo Navallez made furniture for

a. Create a worksheet in your excel file and name it "Part A Q2". In column A to E set up general journal and input the necessary journal entries to record the transactions and eve

Prepare a statement of revenues - deferral method: Wise Owls, an NFPO, began operations at the beginning of 20X1 to provide free tutoring and homework assistance, as well as a


1. Describe the approach Zetar Plc uses to determine goodwill impairment losses. How does this approach differ from US GAAP? 2. Zetar Plc does not report any research and develo

SF is a division of Sell.com, an internet retailer. SF operates two large server farms, each of which is a set of interconnected computers and hard drives that are used to process

Let us assume that you deposit Rs.1000 in a bank that pays 10 percent interest compounded yearly for a period of 3 years. The deposit will grow as given details: Fir