SOLUTION: Hermann Industries is forecasting the following income statement: Sales $10,000,000 Operating costs (excluding depreciation and amortization) 5,500,000 EBITDA $4,500,000 D

Algebra.Com
Question 359118: Hermann Industries is forecasting the following income statement:
Sales $10,000,000
Operating costs (excluding depreciation and amortization) 5,500,000
EBITDA $4,500,000
Depreciation and amortization 1,000,000
EBIT $3,500,000
Interest 500,000
EBT $3,000,000
Taxes (40%) 1,200,000
Net income $1,800,000
The CEO would like to see higher sales and a forecasted net income of $2,430,000.
Assume that operating costs (excluding depreciation and amortization) are 55% of sales, and depreciation and amortization and interest expenses will increase by 10%. The tax rate, which is 40%, will remain the same. What level of sales would generate $2,430,000 in net income? If necessary, round your answer to the nearest dollar at the end of the calculations.


Answer by solver91311(24713)   (Show Source): You can put this solution on YOUR website!






D&A was $1M, but increased 10%, so is now $1.1M, hence:





Interest was $0.5M, but increased 10% so is now $0.55M, hence:







Now solve for Sales as a function of Net Income (NI):









Don't forget to round your answer.

John

My calculator said it, I believe it, that settles it
The Out Campaign: Scarlet Letter of Atheism


RELATED QUESTIONS

Compute for budgeted income statement of XYZ Corporation. Below are the data of XYZ... (answered by ikleyn)
Sales $8,000,000 Operating costs $4,400,000 (excluding depreciation & amortization)... (answered by jim_thompson5910)
(20%). Learning outcome 1, 2 and 3 James Corporation gathered the following information: (answered by ikleyn)
Consider the following simplified financial statements of XYZ Corporation, assuming there (answered by ikleyn)
(6 pts) A particular state computed income tax, T (in dollars) on a person’s income, x (answered by CubeyThePenguin)
(6 pts) A particular state computed income tax, T (in dollars) on a person’s income,... (answered by mananth,math_tutor2020)
A fabrication company engaged in production with a capacity of 150, 000 pieces per year.... (answered by ankor@dixie-net.com)
H. LTD consolidated financial statement on 31 December 2020 was as follows; Credit sales (answered by ikleyn)
An equipment costs 50,000 pesos. It will have an annual operating cost of 20,000 pesos... (answered by CPhill)