Surmec, Inc. has sales of $2.1 million last year. The companyAc€?cs primary business line is manufacturing of nuts and bolts. Since this is a mature industry, the analysts are certain that the sales will grow at a steady rate of 7 percent a year for as far as they can tell. The company reports net income that represents 23 percent of sales. The management would like to buy a new fleet of trucks, but can only do so only once the profit reaches $620,000 a year.

At the end of what year will Surmec be able to buy the new fleet of trucks?

Hint:    Determine the current level of net income based upon the information given. Create a solution that illustrates how long it will take for this current level of income to grow to the target profit level, first using time value of money equations and then the NPER financial function: NPER(rate,pmt,pv,fv,type). Make sure that all cells are properly formatted.

Profit Margin:

Current Net Income:

Target Profit Level

Projected growth rate of sales:

Results in Years (Equation):

Results in years (NPER Function:

The company will reach its profit target during year??

What will the sales & profit be that year?

Hint: Find the level of sales for the year in which the profit level is reached and then use this sales figure to compute the profit level.

Current Sales Level:                 

Projected growth rate of Sales:

Target profit year:

Target Year sales (Equation):

            Target year sales (FV Function):

            Target Year Profit: