attached finance assignments

profileiamnickok
week_2_assignment.xlsx

Sheet1

Using the financial statements for Snider Corporation, calculate the 13 basic rations found in chapter 3.
SNIDER COPORATION
Balance Sheet
December 31, 3013
Assets
Current assets:
Cash $ 52,200
Marketable secruities 24,400
Accounts receivable (net) 222,000
Inventory 238,000
Total current assets $ 536,600
Investments 65,900
Plant and equipment $ 615,000
Less" Accumulated depreciation $ (271,000)
Net plant and equipment $ 344,000
Total assets $ 946,500
Liabilities and Stockholders' Equity
Current Liablitities
Accounts payable $ 93,400
Notes Payable 70,600
Accrued Taxes 17,000
Total current liabilites $ 181,000
Long-term liabilities:
Bonds payable 153,200
Total liabilities $ 334,200
Stockholders' equity
Preferred stock, $50 per value $ 100,000
Common stock, $1 per value 80,000
Capital paid in excess of par 190,000
Retained earings 242,300
Total stockholders' equity $ 613,300
Total liabilities and stockholder's equity $ 946,500
SNIDER COPORATION
Income Statement
For the Year Ending Decemver 31, 2013
Sales (on credit) $ 2,064,000
Less: Cost of goods sold 1,313,000
Gross profit $ 751,000
Less: Selling and administrative expence 496,000*
Operating profit (EBIT) $ 255,000
Less Interest expense 26,900
Earnings befor taxes (EBT) $ 228,100
Less: Taxes 83,300
Earnings after taxes (EAT) $ 144,800
*Includes $36,100 in lease payments.

Sheet2

Sheet3