PDA

View Full Version : Balance sheet/income statement conversion


Real Deal
Apr 6, 2008, 02:34 AM
:cool: I am not sure where to post this accounting or finance I am thinking now probably accounting after ready another enmail so sorry for the duplication


Income Statement

--------------------------------------------------------------------------------

Balance Sheet
December 31, 2006


Assets
Cash 70,000
A/R 150,000
Inventory 280,000
Total current assets$500,000

Plant and Equip $1,250,000
Less Accum. Deprec 250,00
Net plant and Equip $1,000,000
Total Assets $1,500,000

Liabilities
A/P $ 100,000
Notes Payable 120,000
Bonds Payable 300,000
Total Liabilities $520,000

Equity
Common Stock 300,000
Paid in Capital 200,000
Retained earnings 480,000
Total equity $980,000

Total liab and equity $1,500,000





Sales for 2006 were $2,000,000, with the cost of goods sold being 55% of sales. Depreciation expense was 10% of the gross plant and equipment at the beginning of the year. Interest expense was 9% on the notes payable and 11% on the bonds payable. Selling and administrative expenses were $200,000 and the firm's tax rate is 40%.
Prepare an income statement.

I get this far with an income statement but not I can not go any further. I think I must be missing some information of the balance sheet.



THIS IS WHAT I HAVE DONE SO FAR


EPICS CORPORATION
INCOME STATEMENT
DECEMBER 31, 2006
Sales $2,000,000
Cost of goods sold 1,100,000
Gross profits 900,000
Selling and administrative expense 200,000
Depreciation expense 125,000
Operating profit (EBIT) 575,000
Interest expense 43,800
Earnings before taxes 531,200
Taxes 212,480
Earnings after taxes (EAT) 318,720
Preferred stock dividends
Earnings available to common stockholders
Shares outstanding
Earnings per share

morgaine300
Apr 6, 2008, 12:54 PM
This is most definitely accounting, not finance. Although we have a homework help section where it really ought to go. (Lots of people post homework here.)

Your income statement is done. I see you've got info written down as though you're trying to do ESP, but I don't see where the problem has asked for it, nor does it have the information to do it. You have no preferred stock, so that's not an issue. But you don't have number of common shares. If the info isn't given, I have to assume they weren't expecting you to do ESP. A corporation in real life would do ESP, but homework problem are just to practice certain things and don't necessarily call for all pieces to be done.

The statement itself is fine though.

morgaine300
Apr 6, 2008, 12:54 PM
Er... EPS. Boy, that's hard to type correctly. :-)