Reference no: EM13889373
Surmec, Inc. has sales of $2.1 million last year. The company’s 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:
|
Find the APR or stated rate
: Find the APR, or stated rate, in each of the following cases (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.):
|
|
Explain the concept of opportunity cost
: Explain the concept of opportunity cost
|
|
Calculate the variances and the standard deviations
: The rate of return on Cherry Jalopies, Inc., stock over the last five years was 19 percent, 11 percent, -7 percent, 6 percent, and 9 percent. Over the same period, the return on Straw Construction Company’s stock was 16 percent, 20 percent, -3 percen..
|
|
Dennison manufacturing makes large helical springs
: 1.Dennison Manufacturing makes large helical springs used in aircraft landing gear.
|
|
Use this sales figure to compute the profit level
: Surmec, Inc. has sales of $2.1 million last year. The company’s 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 f..
|
|
Effective annual return on its consumer loans
: Magnus Credit Corp. wants to earn an effective annual return on its consumer loans of 15.5 percent per year. The bank uses daily compounding on its loans. What interest rate is the bank required by law to report to potential borrowers?
|
|
Write a comprehensive report on cyber forensics
: Write a comprehensive report on cyber forensics and digital evidence.
|
|
What level of quality and reliability-mean time between fail
: What level of quality and reliability-mean time between failure (MTBF)-did you build into your products?
|
|
Relationship with sales increase in financial forecasting
: Forecast and holding company balance sheet, you bring a balance sheet and determine all items that have direct relationship with sales increase, don’t bring a template version of a balance sheet, bring a new/real one and determine all the items that ..
|