Question: Question: Use a spread sheet to construct a common-size balance sheet from the following balance sheet and the income statement. Balance Sheet Assets Liabilities Cash

Question:
Use a spread sheet to construct a common-size balance sheet from the following balance sheet and the income statement.
Balance Sheet
Assets Liabilities
Cash $10,000 Accounts payable $12,000
Accounts receivable 100,000 Notes payable 50,000
Inventory 110,000 Total current liabilities $62,000
Total current assets 220,000 Long-term debt 128,000
Gross plant and equipment 500,000 Total liabilities 190,000
Less: accumulated depreciation 125,000 Common stock ($1 par, 100,000 shares) 100,000
Net plant and equipment 375,000 Paid-in-capital 155,000
Total assets 595,000 Retained earnings 150,000
Total stockholders' equity $405,000
Total liabilities and equity $595,000
Income Statement
Sales $2,175,000
Cost of goods sold $575,000
Gross profit $1,600,000
General and administrative expense $200,000
Selling and marketing expense $250,000
Depreciation $50,000
Operating income $1,100,000
Interest $100,000
Income before taxes $1,000,000
Income taxes (30%) $300,000
Net income $700,000
Answers:
Common-size Balance Sheet
Assets Liabilities
Cash Accounts payable
Accounts receivable Notes payable
Inventory Total current liabilities
Total current assets Long-term debt
Gross P&E Total Liabilities
Less accumulated Common stock
Depreciation Paid-in capital
Net P&E Retained earnings
Total assets Total stockholders equity
Total liabilities and equity
Common-size Income Statement
Sales
COGS
Gross profit
G&A expense
Sales & Marketing expense
Depreciation
Operating income
Interest
Income before taxes
Income taxes (30%)
Net income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!