Explore BrainMass

Balance Sheets, Statement of Accounts

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

ACC 300
WIDGET Company has the following adjusted trial balance at December 31, 2006. No dividends have been declared.
Account Debit Credit
Cash $1,500
Accounts Receivable 2,000
Interest receivable 30
Prepaid Insurance 2,300
Notes Receivable 3,000
Equipment 12,000
Accumulated Depreciation $300
Accounts payable 1,600
Accrued Expenses Payable 3,820
Income Taxes payable 2,900
Unearned rent revenue 600
Contributed capital 2,400
Retained earnings 1,000
Sales revenue 42,000
Interest Revenue 30
Rent revenue 300
Wages expense 21,600
Depreciation expense 300
Utilities expense 220
Insurance expense 100
Rent expense 9,000
Income Tax Expense 2,900
TOTAL $54,950 $54,950

1. Prepare in proper form an income statement for 2006. Widget Company's core operations related to computer technology. How much net income did Widget Company generate during 2006?
2. Prepare in proper form a statement of retained earnings for 2006.
3. Prepare in proper from a balance sheet on December 31, 2006. Are the company's assets financed primarily by debt or equity?
4. Prepare the closing journal entries on December 31, 2006.


The comparative financial statements for Joe's Company showed the following summarized data:

1. Complete the final two columns shown beside each item in the comparative financial statements above. Does anything jump out at you from the year over year analysis?
2. Given the data above, compute the following:

a. Compute the gross profit percentages in 2004 and 2003. Is the trend going in the right direction?
b. Compute the net profit margin ratios in 2004 and 2003. Is the trend going in the right direction?
c. Compute the earnings per share for 2004 and 2003. Does the trend look good or bad? Explain.
d. Stockholders' equity totaled $100,000 at the end of 2002. Compute the return on equity ratios for 2004 and 2003. Is the trend going in the right direction?
e. Net property and equipment totaled $110,000 at the end of 2002. Compute the fixed asset turnover ratios for 2004 and 2003. Is the trend going in the right direction?
f. Compute the debt-to-assets ratios for 2004 and 2003. Is debt providing financing for a larger or smaller proportion of the company's asset growth? Explain.
g. Compute the times interest earned ratios for 2004 and 2003. Do they look good or bad? Explain.
h. After Joe released its 2004 financial statements, the company's stock was trading at $18. After the release of its 2003 financial statements, the company's stock price was $15 per share. Compute the P/E ratios for both years. Does it appear that investors have become more (or less) optimistic about Joe's future

© BrainMass Inc. brainmass.com October 16, 2018, 11:22 pm ad1c9bdddf


Solution Preview

Please see attached speadsheet for illustration. (Note: each tab along the bottom of the sheet is a separate portion of the problem.)

A few general notes:
When creating a Balance Sheet, the accounts are listed by level of liquidity. "Current" items, in either Assets or Liabilities are those items which have a value that must be paid (liability) or can be converted to cash (asset) within one year.
If the asset or liability has a longer maturity date than 1 year, they are considered long-term. (Remember, a Balance Sheet must balance. (Assets = Liaibilies + Owner's ...

Solution Summary

The solution examines balance sheets and statements of accounts for a Widget Company's core operations.

Similar Posting

Income Statements and Balance Sheets

Using the income statement and balance sheet below, can you please help me with the following questions?

Thank you!

a. Calculate the amount of dividends Firm A and Firm B paid using the information given.
b. Prepare a statement of cash flows for each firm using the indirect method.
c. Analyze the difference in the two firms.


The following income statement and balance sheet information are available for two firms, firm A and Firm B.

Income Statement for Year Ended December 31, 2012
Firm A Firm B
Sales $ 1,000,000 $ 1,000,000
Cost of goods sold $ 700,000 $ 700,000
Gross profit $ 300,000 $ 300,000
Other expenses
Selling and administrative $ 120,000 $ 115,000
Depreciatin $ 10,000 $ 30,000
Interest expense $ 20,000 $ 5,000
Earnings before taxes $ 150,000 $ 150,000
Income tax expense $ 75,000 $ 75,000
Net Income $ 75,000 $ 75,000

Changes in Balance Sheet Accounts December 31, 2011, to December 31, 2012

Firm A Firm B
Cash and cash equivalents $ 0 $+10,000
Accounts receivable +40,000 +5,000
Inventory +40,000 -10,000
Property, plant, and equipment +20,000 +70,000
Less accumulated depreciation (+10,000) (+30,000)
Total Assets $+90,000 $+45,000
Accounts payable $-20,000 $ -5,000
Notes payable (current) +17,000 +2,000
Long-term debt +20,000 -10,000
Deferred taxes (noncurrent) +3,000 +18,000
Capital, stock ---------- -- ---------
Retained earnings +70,000 +40,000
Total Liabilities and Equity $+90,000 $+45,000

View Full Posting Details