Question

In: Finance

Local Co. has sales of $ 10.5 million and cost of sales of $ 6.4 million....

Local Co. has sales of

$ 10.5

million and cost of sales of

$ 6.4

million. Its​ selling, general and administrative expenses are  

$ 550 comma 000

and its research and development is

$ 1.2

million. It has annual depreciation charges of

$ 1.2

million and a tax rate of

35 %

.

a. What is​ Local's gross​ margin?

b. What is​ Local's operating​ margin?

c. What is​ Local's net profit​ margin?

d. If Local Co. had an increase in selling expenses of

$ 330 comma 000

​,

how would that affect each of its​ margins?

e. If Local Co.had interest expense of

$ 760 comma 000

​,

how would that affect each of its​ margins?

Solutions

Expert Solution

The following Income statement is the basis for answering various given questions

Sales 10,500,000
(-) Cost of sales 6,400,000
Gross margin 4,100,000
Operating expenses
Selling, general and admin 550,000
Research and development 1,200,000
Depreciation 1,200,000
Total Operating expenses 2,950,000
Operating Margin 1,150,000
(-) Tax expenses 402500
Net Profit 747,500

Answers to Question - (a), (b) and ( c )

(a) Gross Profit Margin 4,100,000
(b) Operating Profit Margin 1,150,000
(c) Net Profit Margin 747,500

Note : above Income statement explains how these values are obtained. Research expenses should be treated as part of operating expenses.

Question - d

If selling expenses increase by 330,000, there is no impact of Gross margin. But Operating margin and net profit margin shall reduce by 330,000 each.

(a) Gross Profit Margin 4,100,000 No effect
(b) Operating Profit Margin 820,000 Decrease by 330,000
(c) Net Profit Margin 417,500 Decrease by 330,000

Question - e

If the company had Interest expenses of 760,000. It may noted that for categorization of expenses items, interest is a non - operating exenses. Hence there is not effect on gross margin and also no effect on operating margin. But net profit margin shall decrease after tax interest expenses amount. That is 760,000 * ( 1 - 0.35) = 494,000

(a) Gross Profit Margin 4,100,000 No effect
(b) Operating Profit Margin 1,150,000 No effect
(c) Net Profit Margin 253,500 Decrease by 494000

Related Solutions

Local Co. has sales of $10.9 million and cost of sales of $6.4 million. Its​ selling,...
Local Co. has sales of $10.9 million and cost of sales of $6.4 million. Its​ selling, general and administrative expenses are   $450,000 and its research and development is $1.5 million. It has annual depreciation charges of $1.3 million and a tax rate of 35%. a. What is​ Local's gross​ margin? b. What is​ Local's operating​ margin? c. What is​ Local's net profit​ margin?
Local Co. has sales of $ 10.6 million and cost of sales of $ 6.2 million....
Local Co. has sales of $ 10.6 million and cost of sales of $ 6.2 million. Its​ selling, general and administrative expenses are  $ 490 comma 000 and its research and development is $ 1.3 million. It has annual depreciation charges of $ 1.5 million and a tax rate of 35 %. a. What is​ Local's gross​ margin? b. What is​ Local's operating​ margin? c. What is​ Local's net profit​ margin? d. If Local Co. had an increase in selling...
Local Co. has sales of $ 10.0 million and cost of sales of $ 6.0 million....
Local Co. has sales of $ 10.0 million and cost of sales of $ 6.0 million. Its​ selling, general and administrative expenses are  $ 500,000 and its research and development is $ 1.0 million. It has annual depreciation charges of $ 1.0 million and a tax rate of 35 %. ​Local's gross margin is 40.00​%, its operating margin is 15.00​%, and its net profit margin is 9.75​%. If Local Co. had interest expense of $ 800,000​, how would that affect...
Local Co. has sales of $10.6 million and cost of sales of $5.7 million. Its? selling,...
Local Co. has sales of $10.6 million and cost of sales of $5.7 million. Its? selling, general and administrative expenses are??$520,000 and its research and development is $1.1 million. It has annual depreciation charges of $1.1 million and a tax rate of 35%. a. What is? Local's gross? margin? b. What is? Local's operating? margin? c. What is? Local's net profit? margin? d. If Local Co. had an increase in selling expenses of $320,000?, how would that affect each of...
You are considering making a movie. The movie is expected to cost $ 10.5$10.5 million up...
You are considering making a movie. The movie is expected to cost $ 10.5$10.5 million up front and take a year to produce. After​ that, it is expected to make $ 4.1$4.1 million in the year it is released and $ 1.7$1.7 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of...
KO Co. has the sales of $37,266 million, net income of $8,920 million, and the book...
KO Co. has the sales of $37,266 million, net income of $8,920 million, and the book equity of $18,981 million. It has 4,300 million shares outstanding. The industry average P/E ratio is 23.82, Price/Book ratio is 4.72, and Price/Sales ratio is 3.42. What is the expected price of KO Stock using the P/E ratio? $49.41 $50.85 $20.83 $29.64
Tolo Co. plans the following​ repurchases: $10.5 million in one​ year, nothing in two​ years, and...
Tolo Co. plans the following​ repurchases: $10.5 million in one​ year, nothing in two​ years, and $20.1 million in three years. After​ that, it will stop repurchasing and will issue dividends totaling $26 million in four years. The total paid in dividends is expected to increase by 3% per year thereafter. If Tolo has 1.8 million shares outstanding and an equity cost of capital of 11.1%​, what is its price per share​ today?
You are considering making a movie. The movie is expected to cost $10.5 million up front...
You are considering making a movie. The movie is expected to cost $10.5 million up front and take a year to produce. After​ that, it is expected to make $4.3 million in the year it is released and $1.9 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of capital is 10.5%​?
You are considering making a movie. The movie is expected to cost 10.5 million up front...
You are considering making a movie. The movie is expected to cost 10.5 million up front and take a year to produce. After that, it is expected to make 4.9 million in the year it is released and 1.7 million for the following four years. What is the payback period of this investment? If you require a payback period of two years, will you make the movie? Does the movie have positive NPV if the cost of capital is 10.2%?...
Green Co. has a machine with a total cost of $70 million, and the machine is...
Green Co. has a machine with a total cost of $70 million, and the machine is placed in service at the beginning of 2018. The machine is depreciated using the the sum-of-the-years'-digits method with 10-year useful life and $4 million in residual value. At the beginning of 202, Green decides to change to the straight-line method with 11-year useful life and $5.6 million in residual value. Required: How much is the depreciation expense related to the machinein 2021? Please share...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT