Purchase Solution

Common Stock and Retained Earnings

Not what you're looking for?

Ask Custom Question

1. Using the EPSICO, INC Excel Spreadsheet below called " EPSICO, INC BS"
Please complete the Balance Sheet for December 31, 2010 Knowing the following:

Cash: as of 12/31/10 it increased by $8
Accounts Receivable: Decreased by $10 in July but increased by $16 by the end of the year.
Inventory: Due to an error in purchasing, the Inventory increased by 10% in the spring.
The sales department was able to reduce the inventory by $12 as of December 31, 2010.
Land: balance has not been increased with any other purchases
However, the overall market shows an increase in real estate of 15%.
Equipment: New equipment for $15 has been purchased in 2010
Note Payable: Increased by $9 as a result of a short term Bank Note
Accounts payable: Increased by $13
Long Tern debt: Has been paid down by 25%
Net income: the Income statement (IS) shows $26
Dividends paid: the Income statement (IS) shows $8
Explain and show how you got the Retained Earnings for 2010
Hint: Look for the End. Bal. RE in the 2009 BS.
The End. Bal. RE of 2009 becomes the Beg. Bal. RE for 2010
(Show and use the formulas)

FILL IN THE BLANKS (Yellow sections)
EPSICO, INC.
Consolidated Balance Sheets (MM)
December 31,2010
2010 2009 2010 2009
ASSETS LIABILITY
Current Assets Current Liabilities
Cash $30.00 Note Payable $ 40.00
Accounts Receivable $120.00 Accounts Payable $110.00
Merchandise Inventory $230.00

Total Current Assets $380.00 Total Current Liabilities $150.00

Long term Debt $ 80.00

Total Liabilities $230.00

Property, Plant and Equipment Owners' Equity
Land $25.00 Common Stock $ 200.00 $200.00
Equipment $375.00 Retained Earnings $190.00
Less Accumulated depreciation ($180.00) ($160.00)

Total Property, Plant and Equipment $240.00 Total Owners' Equity $390.00

TOTAL ASSETS $620.00 TOTAL LIABILITIES & OWNERS' EQUITY $620.00

Attachments
Purchase this Solution
Solution Summary

The common stocks and retained earnings are provided.

Solution Preview

Check the attached sheet.

1. Using the EPSICO, INC Excel Spreadsheet below called " EPSICO, INC BS"
Please complete the Balance Sheet for December 31, 2010 Knowing the following:

Cash: as of 12/31/10 it increased by $8
Accounts Receivable: Decreased by $10 in July but increased by $16 by the end of the year.
Inventory: Due to an error in purchasing, the Inventory increased by 10% in the spring.
The sales department was able to reduce the inventory by $12 as of December 31, 2010.
Land: balance has not been increased with any other purchases
However, the overall market shows an increase in real ...

Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Stock Dividend

    The coomon stock will increase by the par value 1,080. The capital surplus will increase by 29,160 and retained earnings will decrease by 30,240. Common Stock10,080 Capital Surplus 198,160 Retained Earnings520,760 Total 729,000 b.

  • Retained Earnings, Stockholders' Equity and Earning Per Share for Nakona Corporation

    On December 31, a 10% common stock dividend was declared out of retained earnings on common stock when the market price per share was $7. 8. Net income for the year was $795,000. 9.

  • Calculate EPS and Cash Dividend.

    Closing Retained Earnings = Begin Retained earnings + Net Income for the year - Preferred Dividend - Common Stock Dividend If we input the given values, we have 1,119,000 = 878,0000+593000-74,000 - Common Stock Dividend So, Common Stock Dividend

  • Weighted average cost of capital if retained earnings

    338035 Weighted average cost of capital if retained earnings Company has a target capital structure of 40% debt, 10% preferred stock, and 50% common equity.

  • weighted average cost of capital

    90142 What are the firm's after tax cost of debt, cost of preferred stock, cost of a new issue of common stock, cost of retained earnings, and the weighted average cost of capital (up to the point when retained earnings are exhausted and after all retained

  • Sycamore Inc., Wells Fargo & Company, Pepp Company

    Common Stock $6,500,000 Additional Paid-in Capital 1,800,000 Retained Earnings 1,200,000 Transactions during 2007 and other information related to stockholders' equity accounts were as follows. 1.

  • The answer to Stockholders equity transactions

    The entry is Retained Earnings Dr 90,000 Dividends Payable - Preferred Cr 18,000 Dividends Payable - Common Cr 72,000 2) A 10% common stock dividend was declared.

  • Retained Earnings and Stockholders Equity

    common stock 1,600,000 Total additional paid-in capital 1,800,000 Total paid-in capital 5,050,000 Retained earnings (See Note A) 3,060,000 Total stockholders' equity $8,110,000 Note A: Retained earnings restricted for

  • Component costs of capital

    Calculate cost of debt, cost of common stock, cost of new common stock, cost of preferred stock and cost of retained earnings. Cost of retained earnings is the same as the cos t of commons stock Ke.

  • Common stock dividends and retained earnings

    The solution computes Common stock dividends and retained earnings with the given data.

View More Related Solutions