Questions
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.1x...

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×...

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×...

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...

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...

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...

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×...

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: Total assets turnover: 1×...

Complete the balance sheet and sales information using the following financial data:

Total assets turnover: 1×
Days sales outstanding: 36.5 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 = 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 54,000
Inventories    Common stock   
Fixed assets    Retained earnings 108,000
Total assets $360,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.3×...

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...

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