Complete the balance sheet and sales information using the
following financial data: Total assets turnover: 1.1x Days sales
outstanding: 33 daysa Inventory turnover ratio: 3x Fixed assets
turnover: 3x Current ratio: 1.6x Gross profit margin on sales:
(Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a
365-day year. Do not round intermediate calculations. Round your
answer to the nearest cent.
Balance Sheet:
Cash $ = ?
Current liabilities $ = ?
Accounts receivable = ?
Long-term debt = 48,750
Inventories = ?
Common stock = ?
Fixed assets = ?
Retained earnings= 81,250
Total assets= $325,000
Total liabilities and equity $ = ?
Sales $ = ?
Cost of goods sold $ = ?
In: Finance
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1× Days sales outstanding: 73.0 daysa Inventory turnover ratio: 4× Fixed assets turnover: 2.5× Current ratio: 2.0× Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answers to the nearest dollar. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 66,000 Inventories Common stock Fixed assets Retained earnings 99,000 Total assets $330,000 Total liabilities and equity $ Sales $ Cost of goods sold $
In: Finance
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.1×
Days sales outstanding: 73.0 daysa
Inventory turnover ratio: 5×
Fixed assets turnover: 3.0×
Current ratio: 2.5×
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
15%
aCalculation is based on a 365-day year.
Do not round intermediate calculations. Round your answers to the nearest dollar.
| Balance Sheet | ||||
| Cash | $ | Current liabilities | $ | |
| Accounts receivable | Long-term debt | 67,500 | ||
| Inventories | Common stock | |||
| Fixed assets | Retained earnings | 94,500 | ||
| Total assets | $270,000 | Total liabilities and equity | $ | |
| Sales | $ | Cost of goods sold | $ | |
In: Finance
Lupo Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on machine-hours. The company based its predetermined overhead rate for the current year on the following data:
| Total machine-hours | 32,800 | |
| Total fixed manufacturing overhead cost | $ | 164,000 |
| Variable manufacturing overhead per machine-hour | $ | 5 |
Recently, Job T687 was completed with the following characteristics:
| Number of units in the job | 10 | |
| Total machine-hours | 30 | |
| Direct materials | $ | 745 |
| Direct labor cost | $ | 1,490 |
The amount of overhead applied to Job T687 is closest to: (Round your intermediate calculations to 2 decimal places.)
Multiple Choice
$164.00
$300.00
$60.00
$401.40
In: Accounting
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.2x
Days sales outstanding: 33.5 daysa
Inventory turnover ratio: 6x
Fixed assets turnover: 3.5x
Current ratio: 1.9x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
35%
aCalculation is based on a 365-day year. Do not round
intermediate calculations. Round your answers to the nearest
cent.
| Balance Sheet | ||||
| Cash | $ | Current liabilities | $ | |
| Accounts receivable | Long-term debt | 60,000 | ||
| Inventories | Common stock | |||
| Fixed assets | Retained earnings | 75,000 | ||
| Total assets | $300,000 | Total liabilities and equity | $ | |
| Sales | $ | Cost of goods sold | $ | |
In: Finance
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.3x
Days sales outstanding: 37.5 daysa
Inventory turnover ratio: 7x
Fixed assets turnover: 2.5x
Current ratio: 2.5x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
30%
aCalculation is based on a 365-day year. Do not round
intermediate calculations. Round your answers to the nearest
cent.
| Balance Sheet | ||||
| Cash | $ | Current liabilities | $ | |
| Accounts receivable | Long-term debt | 40,000 | ||
| Inventories | Common stock | |||
| Fixed assets | Retained earnings | 70,000 | ||
| Total assets | $200,000 | Total liabilities and equity | $ | |
| Sales | $ | Cost of goods sold | ||
In: Finance
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.2×
Days sales outstanding: 73.0 daysa
Inventory turnover ratio: 4×
Fixed assets turnover: 3.0×
Current ratio: 2.0×
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
30%
aCalculation is based on a 365-day year.
Do not round intermediate calculations. Round your answers to the nearest dollar.
| Balance Sheet | ||||
| Cash | $ | Current liabilities | $ | |
| Accounts receivable | Long-term debt | 31,500 | ||
| Inventories | Common stock | |||
| Fixed assets | Retained earnings | 73,500 | ||
| Total assets | $210,000 | Total liabilities and equity | $ | |
| Sales | $ | Cost of goods sold | $ | |
In: Finance
|
Complete the balance sheet and sales information using the
following financial data: Do not round intermediate calculations. Round your answers to the nearest dollar.
|
||||||||||||||||||||||||||||||||||||||||
In: Finance
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.3×
Days sales outstanding: 36.5 daysa
Inventory turnover ratio: 5×
Fixed assets turnover: 3.0×
Current ratio: 2.5×
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
35%
aCalculation is based on a 365-day year.
Do not round intermediate calculations. Round your answers to the nearest dollar.
| Balance Sheet | ||||
| Cash | $ | Current liabilities | $ | |
| Accounts receivable | Long-term debt | 66,000 | ||
| Inventories | Common stock | |||
| Fixed assets | Retained earnings | 115,500 | ||
| Total assets | $330,000 | Total liabilities and equity | $ | |
| Sales | $ | Cost of goods sold | $ | |
In: Finance
Problem Two: (30%)
“Pilot Pens” has sold 1,000,000 pens in 2017. Each pen was sold at price of $0.33 per pen and had a variable cost equal to $0.15 per pen. Furthermore, the company incurred a total of $80,000 in fixed costs. Pilot Pens has no preferred equity, paid $20,000 for interest and has a tax rate of 40%.
Required: Perform the Breakeven and leverage analysis for Pilot Pens by calculating the below figures for 2017:
- Total Revenues
- Total Variable Cost
- EBIT
- EBT
- Breakeven point (in terms of units and dollars)
- Degree of operating leverage, DOL
- Degree of financial leverage, DFL
- Degree of combined leverage, DCL
(SOLUTION MUST BE ON EXCEL)
In: Finance