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

Solutions

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


Related Solutions

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?
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:
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT