Using the ï¬nancial statement information from below, create balance sheets and (traditional gross-margin format) income statements for the given years. ⢠From those ï¬nancial statements determine the following for the most current year:
1) Working Capital
2) Current Ratio
3) Quick Ratio
4) Inventory Turnover
5) Average Sales Period
6) Total Asset Turnover
7) Times Interest Earned Ratio
8) Debt-to-Equity Ratio
9) Gross Margin percentage
10) Cost of Goods Sold percentage 1
11) Net Proï¬t Margin percentage
12) Return on Total Assets
13) Return on Equity
14) Earnings per Share
15) Book Value per Share
Year ended Dec. 31, 2016
Cost of Goods Sold 400,000
Cash 35,000
Selling & Administrative Expenses 160,000
Salaries Payable 40,000
Long-term liabilities 270,000
Finished Goods Inventory 55,000
Accounts Payable 20,000
Interest Expense 8,000
Income Tax Expense 30%
Sales Revenue (all on account) 700,000
Plant, Property, and Equipment, net 300,000
Accounts Receivable 60,000
Common Stock ($1 par) 120,000
Year ended Dec. 31, 2015
Cash 30,000
Accounts Receivable 50,000
Finished Goods Inventory 60,000
Plant, Property, and Equipment, net 320,000
Accounts Payable 20,000
Salaries Payable 20,000
Long-term liabilities 300,000
Common Stock ($1 par) 120,000
Using the ï¬nancial statement information from below, create balance sheets and (traditional gross-margin format) income statements for the given years. ⢠From those ï¬nancial statements determine the following for the most current year:
1) Working Capital
2) Current Ratio
3) Quick Ratio
4) Inventory Turnover
5) Average Sales Period
6) Total Asset Turnover
7) Times Interest Earned Ratio
8) Debt-to-Equity Ratio
9) Gross Margin percentage
10) Cost of Goods Sold percentage 1
11) Net Proï¬t Margin percentage
12) Return on Total Assets
13) Return on Equity
14) Earnings per Share
15) Book Value per Share
Year ended Dec. 31, 2016
Cost of Goods Sold 400,000
Cash 35,000
Selling & Administrative Expenses 160,000
Salaries Payable 40,000
Long-term liabilities 270,000
Finished Goods Inventory 55,000
Accounts Payable 20,000
Interest Expense 8,000
Income Tax Expense 30%
Sales Revenue (all on account) 700,000
Plant, Property, and Equipment, net 300,000
Accounts Receivable 60,000
Common Stock ($1 par) 120,000
Year ended Dec. 31, 2015
Cash 30,000
Accounts Receivable 50,000
Finished Goods Inventory 60,000
Plant, Property, and Equipment, net 320,000
Accounts Payable 20,000
Salaries Payable 20,000
Long-term liabilities 300,000
Common Stock ($1 par) 120,000
Related questions
I would love some help with finding the below ratios for Nike in 2017 10-K Section 4 â Ratio calculations and analysis http://s1.q4cdn.com/806093406/files/doc_financials/2017/ar/docs/nike-2017-form-10K.pdf
| RATIO | FORMULA | CURRENT YEAR | PREVIOUS YEAR |
| Current Ratio | Current Assets Current Liabilities | ||
| Accounts Receivable Turnover | Net Total Sales Avg. Accounts Rec. | ||
| Inventory Turnover | Cost of Goods Sold Average Inventory | ||
| Gross Profit Margin | Gross Profit Net sales | ||
| Net Profit Margin | Net Income Net Sales | ||
| Return on Total Assets | Net Income Avg. Total Assets | ||
| Return on Stockholdersâ Equity | Net Income Avg. Stockholdersâ Eq. | ||
| Earnings Per Share | (given on annual report) | ||
| Market Price Per Share at Year End | (available at Yahoo.com and other websites) | ||
| Price/Earnings Ratio | Year End Market Price Earnings Per Share | ||
| Debt Ratio | Total Liabilities Total Assets | ||
| Equity Ratio | Total Stockholdersâ Eq. Total Assets | ||
| Times Interest Earned | Income before Int. + Tax Interest Expense |
20. Brigman Inc. has the following financial statementinformation for 2009 and 2008:
Balance Sheet Information: | 2009 | 2008 | |
Assets: | |||
Cash | $ 5,000 | $ 12,000 | |
Accounts receivable | 14,000 | 10,000 | |
Inventory | 35,000 | 30,000 | |
Total current assets | $ 54,000 | $ 52,000 | |
Property and Equipment (net) | 50,000 | 45,000 | |
Total assets | $104,000 | $ 97,000 | |
Liabilities: | |||
Accounts payable | $ 9,000 | $ 3,000 | |
Salaries payable | 3,000 | 1,000 | |
Total current liabilities | $ 12,000 | $ 4,000 | |
Notes payable | 20,000 | 25,000 | |
Total liabilities | $ 32,000 | $ 29,000 | |
Stockholders' Equity: | |||
Common stock | $ 40,000 | $ 40,000 | |
Retained earnings | 32,000 | 28,000 | |
Total stockholders' equity | $ 72,000 | $ 68,000 | |
Total liabilities and stockholders' equity | $104,000 | $ 97,000 | |
Income Statement Information: | |||
Net sales | $650,000 | $556,000 | |
Cost of goods sold | 380,000 | 290,000 | |
Gross profit | $270,000 | $266,000 | |
Selling and administrative expenses | 75,000 | 70,000 | |
Interest expense | 4,000 | 10,000 | |
Income before income taxes | $191,000 | $186,000 | |
Income tax expense | 57,300 | 56,300 | |
Net income | $133,700 | $129,700 | |
Other Information: | |||
Number of common shares outstanding | 4,000 | 4,000 | |
Dividends paid | $ 0 | $ 0 | |
Market price per share (12/31) | $40 | $30 | |
Income tax rate | 30% | 30.27% |
Required: Compute the following ratios for the year endingDecember 31, 2009: (round to two decimal places)
A. | Inventory turnover |
B. | Return on assets (ROA) ratio |
C. | Asset turnover ratio |
D. | Earnings per share (EPS) |
E. | Price earnings (P/E) ratio. |
F. Return on common stockholdersâ equity
G. Current ratio
H. Quick ratio
I. Debt-to-equity ratio
