Access over 20 million homework & study documents
search

Ratio, Interest & Inventory Turnover Excel Worksheet

Content type

User Generated

Subject

Finance

Type

Worksheet

Rating

Showing Page:
1/4

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/4

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/4

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

Balance Sheet Cash Market Securities Accounts Receivable Inventory Total Current Assets Property, Plant & Equipment Total Assets YEAR 2 $ 400.00 $ 500.00 $ 3,200.00 $ 5,800.00 $ 9,900.00 $ 7,100.00 $ 17,000.00 Accounts Payable Income Taxes Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ($1 par value) Paid-in Capital in excess of par Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity $ $ $ $ $ $ $ $ $ $ $ 3,700.00 900.00 1,700.00 6,300.00 2,000.00 8,300.00 2,700.00 1,000.00 5,000.00 8,700.00 17,000.00 Income Statement For Year Ended November 30, Year 2 Sales (net) $ 31,000.00 Cost and Expenses Cost of good sold $ 17,600.00 Selling and administration expenses $ 3,550.00 Depreciation and amortization expense $ 1,890.00 Interest expense $ 900.00 Total Cost and Expenses $ 23,940.00 Income Before Taxes $ 7,060.00 Income Taxes $ 2,900.00 Net Income $ 4,160.00 Current Ratio Acid-Test Ratio Times Interest Earned Debt to Equity Inventory Turnover $ $ $ $ $ Year 2 1.57 0.65 8.84 0.95 3.03 CURRENT RATIO (Current assets divided by current liabilities) What this does is help creditors and investors ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4