Question

In: Finance

Last year, Your Company, Inc. had sales of $750,000, with a costof goods sold of...

Last year, Your Company, Inc. had sales of $750,000, with a cost of goods sold of $350,000. Your Company's operating expenses were $200,000, and its increase in retained earnings was $75,000. There are currently 25,000 common stock shares outstanding and Your Company paid dividends of $ 1.00 per share.

a) Assuming the firm's earnings are taxed at 35 percent, construct the firm's income statement:

b) Compute the firm's operating profit margin (%):

c) Compute the firm's times interest earned

Expert Solution

- Increase in Retained earnings = $75,000

- Dividend paid during the year = No of shares*Dividend per share

= $25000*$1

= $25,000

Net Income = Increase in Retained earnings + Dividend paid during the year

= $75,000 + $25,000

= $100,000

Income before Tax = Net Income/(1-Tax Rate)

= $100,000/(1-0.35)

= $153,846.15

a). Preparing Firm's Income Statement:-

Particular	Amount in $
Sales	750,000.00
COGS	(350,000.00)
Gross Profit	400,000.00
Operating exp.	(200,000.00)
EBIT	200,000.00
interest Expenses (Note)	46,153.85
Taxable Income	153,846.15
Taxation (35%)	(53,846.15)
Net income	100,000.00

Note- Interest expenses =EBIT - Income before Tax

= $200,000 - $153,846.15 = $46,153.85

b). Operating Profit Margin = Operating profit(or EBIT)/Net sales

= $200,000/$750,000

Operating Profit Margin = 26.67%

c). Firm's Times Interest earned = EBIT/Interest expenses

= $200,000/$46,153.85

Firm's Times Interest earned = 4.33 times

jeff jeffy answered 2 years ago

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

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

Last year, Carriage House Corporation had sales of $18 million and costs of goods sold of...

Last year, Carriage House Corporation had sales of $18 million and costs of goods sold of $3 million. Operating expenses amounted to $2,500,000. The firm had $8 million in 6.5% bonds outstanding. The firm had $830,000 in depreciation expense. Also, Carriage House sold 1,250 shares of Textron Corporation stock for $150 per share. Carriage House had purchased the shares for $110 per share two years ago. Carriage House also sold land for $2.8 million that it had purchased earlier for...

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?

For the most recent year, Camargo, Inc., had sales of $570,000, cost of goods sold of...

For the most recent year, Camargo, Inc., had sales of $570,000, cost of goods sold of $249,870, depreciation expense of $64,900, and additions to retained earnings of $77,300. The firm currently has 24,500 shares of common stock outstanding and the previous year’s dividends per share were $1.52. Assuming a 24 percent income tax rate, what was the times interest earned ratio?

Butterfly Tractors had $18.00 million in sales last year. Costof goods sold was $8.80 million,...

Butterfly Tractors had $18.00 million in sales last year. Cost of goods sold was $8.80 million, depreciation expense was $2.80 million, interest payment on outstanding debt was $1.80 million, and the firm’s tax rate was 21%.a. What was the firm’s net income? 3.63 millionb. What was the firm’s cash flow? 6.43 millionc. What would happen to net income and cash flow if depreciation were increased by $1.80 million?(Enter your numeric answers in millions rounded to 2 decimal places. Select "unaffected"...

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

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: