What is the fastest way to compare two balance sheets of different months in Excel?

Hi. I need to compare two balance sheets of different months in Microsoft Excel. The ledger (line items) may not be exactly the same for the balance sheet of each month. I need to calculate the fluctuation of identical ledger (line items) across 2 months. There is an account number attached to each ledger (line item).

What Excel formulas (other than Sum and If) would help me to complete this task in the fast possible time?

I currently take at least about 4 hours to complete this task as there are hundreds of lines.

Retained earnings figures on a balance sheet represents what?

A. A pool of cash readily available tot he firm and its stockholders
B. An accounting of that portion of a firms assets that were financed from past earnings
C. A permanent part of the firms equity base
D. A deferred liability owed to preferred stockholders

Do you think this manager is correct in the way he uses the financial statements? Why or why not?

An officer of Carson Company recently commented that when he receives the firm’s financial statements. He looks at just the bottom line of the income statement — the line that shows the net income or net loss for the period. He said that he does not bother with the rest of the income statement because “it’s only the bottom line that counts.” He also does not read the balance sheet. Do you think this manager is correct in the way he uses the financial statements? Why or why not?

Accounting defects trouble wine giant (North Queensland Register)

CONSTELLATION Brands, parent of Australia’s second-largest wine company, has admitted that a defective accounting system at its Australian operation, first identified in February, has still not been fixed.

Original post: 
Accounting defects trouble wine giant (North Queensland Register)

CORRECT:BofA CFO Price:$125 Billion Is From Accounting-Rule Changes (Nasdaq)

(Bank of America CFO Price said in a conference call that $125 billion of assets going onto the bank’s balance sheet next year are being moved due to an accounting-rule change. A headline at 10:29 AM eastern time said the amount due to the rule change would be $195 billion.)

Go here to see the original:
CORRECT:BofA CFO Price:$125 Billion Is From Accounting-Rule Changes (Nasdaq)

i want to practice online on making balance sheet and income statements, where could i find such a site to do?

please tell me somme site to practice financial accounting

Financial statements report financial data for either a period of time or for a particular date.which one ?

a ) the balance sheet
b) the cash flow statement
c) the income statement

find me which one of followiong financial statements reports finiacial information for a particular date.

finding the weight of debt and equity in a certain company? HOW?

I have the balance sheet and cash flow statements .. everything but how can i find the debt to equity ratio? is it the whole liability and owners equity or the long term/short term debt .. or what??