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

Total assets turnover: 1.3×
Days sales outstanding: 36.5 days^a
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.

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)

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

Total assets turnover: 1.3x
Days sales outstanding: 31.5 days^a
Inventory turnover ratio: 7x
Fixed assets turnover: 3.5x
Current ratio: 2x
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 answer to the nearest cent.

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

Total assets turnover: 1.1x
Days sales outstanding: 34.5 days^a
Inventory turnover ratio: 3x
Fixed assets turnover: 3x
Current ratio: 2.2x
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 answer to the nearest cent.

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

Total assets turnover: 1x
Days sales outstanding: 38 days^a
Inventory turnover ratio: 4x
Fixed assets turnover: 2.5x
Current ratio: 2x
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 answer to the nearest cent.

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

Total assets turnover: 1.3x
Days sales outstanding: 36 days^a
Inventory turnover ratio: 7x
Fixed assets turnover: 3.5x
Current ratio: 2.3x
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.

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

Total assets turnover: 1x
Days sales outstanding: 41 days^a
Inventory turnover ratio: 7x
Fixed assets turnover: 3x
Current ratio: 2.2x
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 answer to the nearest cent.

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

Total assets turnover: 1.4x
Days sales outstanding: 33 days^a
Inventory turnover ratio: 4x
Fixed assets turnover: 3.5x
Current ratio: 1.6x
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 answer to the nearest cent.

Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1x Days sales outstanding: 41.5 daysa Inventory turnover ratio: 7x Fixed assets turnover: 3.5x Current ratio: 2.3x 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 answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 41,250 Inventories Common stock Fixed assets Retained earnings 96,250 Total assets $275,000 Total liabilities and equity $ Sales $ Cost of goods sold $