Question

In: Finance

Lemon Auto Wholesalers had sales of $1,310,000 last year, and cost of goods sold represented 77...

Lemon Auto Wholesalers had sales of $1,310,000 last year, and cost of goods sold represented 77 percent of sales. Selling and administrative expenses were 13 percent of sales. Depreciation expense was $11,000 and interest expense for the year was $11,000. The firm’s tax rate is 30 percent. a. Compute earnings after taxes. b-1. Assume the firm hires Ms. Carr, an efficiency expert, as a consultant. She suggests that by increasing selling and administrative expenses to 15 percent of sales, sales can be increased to $1,360,600. The extra sales effort will also reduce cost of goods sold to 73 percent of sales. (There will be a larger markup in prices as a result of more aggressive selling.) Depreciation expense will remain at $11,000. However, more automobiles will have to be carried in inventory to satisfy customers, and interest expense will go up to $18,200. The firm’s tax rate will remain at 30 percent. Compute revised earnings after taxes based on Ms. Carr’s suggestions for Lemon Auto Wholesalers. (Round taxes and earnings after taxes to 1 decimal place.) b-2. Will her ideas increase or decrease profitability? Increase profitability Decrease profitability

Solutions

Expert Solution

a) Sales $ 13,10,000.0
Cost of goods sold at 77% of sales $ 10,08,700.0
Selling and administrative expenses at 13% of sales $     1,70,300.0
Depreciation expense $        11,000.0
Interest expense $        11,000.0
Income before tax $     1,09,000.0
Tax at 30% $        32,700.0
Net income $        76,300.0
Profit margin = NI/Sales = 5.82%
b-1) Sales $ 13,60,600.0
Cost of goods sold at 73% of sales $     9,93,238.0
Selling and administrative expenses at 15% of sales $     2,04,090.0
Depreciation expense $        11,000.0
Interest expense $        18,200.0
Income before tax $     1,34,072.0
Tax at 30% $        40,221.6
Net income $        93,850.4
Profit margin = NI/Sales = 6.90%
b-2) Yes, her ideas will increase profitability.
The profits increase from $76300.00 to $93,850.40
The profit margin also increases from 5.82% to 6.90%.

Related Solutions

Lemon Auto Wholesalers had sales of $1,480,000 last year, and cost of goods sold represented 76...
Lemon Auto Wholesalers had sales of $1,480,000 last year, and cost of goods sold represented 76 percent of sales. Selling and administrative expenses were 13 percent of sales. Depreciation expense was $14,000 and interest expense for the year was $10,000. The firm’s tax rate is 30 percent. a. Compute earnings after taxes in Income statement form:
Last​ year, Stevens Inc. had sales of ​$405 comma 000​, with a cost of goods sold...
Last​ year, Stevens Inc. had sales of ​$405 comma 000​, with a cost of goods sold of ​$110 comma 000. The​ firm's operating expenses were $ 133 comma 000​, and its increase in retained earnings was ​$53 comma 000. There are currently 22 comma 100 common stock shares outstanding and the firm pays a ​$1.57 dividend per share. a. Assuming the​ firm's earnings are taxed at 34 ​percent, construct the​ firm's income statement. b. Compute the​ firm's operating profit margin....
Last year, Dollar General had $7,000 in sales, and cost of goods sold was $4,000. Depreciation...
Last year, Dollar General had $7,000 in sales, and cost of goods sold was $4,000. Depreciation expenses totaled $1000 and interest expense was $1400. If the tax rate is 25%, what is the net profit margin for Dollar General? What is its NOPAT margin?
(Evaluating profitability​) Last​ year, Stevens Inc. had sales of ​$398,000​, with a cost of goods sold...
(Evaluating profitability​) Last​ year, Stevens Inc. had sales of ​$398,000​, with a cost of goods sold of ​$110,000. The​ firm's operating expenses were $134,000​, and its increase in retained earnings was ​$57,000. There are currently 21,800 common stock shares outstanding and the firm pays a ​$1.61 dividend per share. a. Assuming the​ firm's earnings are taxed at 34 ​percent, construct the​ firm's income statement. b. Compute the​ firm's operating profit margin. c. What was the times interest​ earned? a. Assuming...
Last​ year, Stevens Inc. had sales of​$404 comma 000 with a cost of goods sold of...
Last​ year, Stevens Inc. had sales of​$404 comma 000 with a cost of goods sold of $120 comma 000. The​ firm's operating expenses were $129 comma 000 and its increase in retained earnings was ​$60 comma 000. There are currently 23 comma 000 common stock shares outstanding and the firm pays a $1.59 dividend per share. a. Assuming the​ firm's earnings are taxed at 34 ​percent, construct the​ firm's income statement. b. Compute the​ firm's operating profit margin. c. What...
Last year, HCC, Inc had Sales of $500,000, cost of goods sold of $290,000, ending accounts...
Last year, HCC, Inc had Sales of $500,000, cost of goods sold of $290,000, ending accounts receivable of $75,000 and ending inventory balance of $25,000. The company’s inventory turnover was closest to: A. 12.08 B. 11.60 C. 5.80 D. 11.15 Granger Corp had $180,000 in Sales on account last year and offered a 10% discount. The ending accounts receivable balance was $14,000, after bad debt expense of $5,000. The company’s average collection period (DSO) was closest to: A. 20.3 days...
Butterfly Tractors had $17.50 million in sales last year. Cost of goods sold was $8.70 million,...
Butterfly Tractors had $17.50 million in sales last year. Cost of goods sold was $8.70 million, depreciation expense was $2.70 million, interest payment on outstanding debt was $1.70million, and the firm’s tax rate was 30%. a. What was the firm’s net income? (Enter your answers in millions rounded to 2 decimal places.) b. What was the firm’s cash flow? (Enter your answers in millions rounded to 2 decimal places.) c. What would happen to net income and cash flow if...
Butterfly Tractors had $21.50 million in sales last year. Cost of goods sold was $9.50 million,...
Butterfly Tractors had $21.50 million in sales last year. Cost of goods sold was $9.50 million, depreciation expense was $3.50 million, interest payment on outstanding debt was $2.50 million, and the firm’s tax rate was 30%. a. What was the firm’s net income and net cash flow? (Enter your answers in millions rounded to 2 decimal places. For example, for $3.92 million, enter "3.92", not "3920000")   Net income $  million   Net cash flow $  million b. What would happen to net income...
Butterfly Tractors had $15.00 million in sales last year. Cost of goods sold was $8.20 million,...
Butterfly Tractors had $15.00 million in sales last year. Cost of goods sold was $8.20 million, depreciation expense was $2.20 million, interest payment on outstanding debt was $1.20 million, and the firm’s tax rate was 21%. a. What was the firm’s net income? (Enter your answers in millions rounded to 2 decimal places.) b. What was the firm’s cash flow? (Enter your answers in millions rounded to 2 decimal places.) c. What would happen to net income and cash flow...
Premium Excavators had $14 million in sales last year. Cost of goods sold was $8 million,...
Premium Excavators had $14 million in sales last year. Cost of goods sold was $8 million, depreciation expense was $2 million, interest payments on outstanding debt was $1 million, and the firm’s tax rate was 21%. What was the firm’s net income? What was the firm’s cash flow? What would happen to net income and cash flow if depreciation were increased by $1 million? Would you expect the change in depreciation o have a positive or negative impact on the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT