A manufacturer of electronic devices invests $650,000 in equipment for making compact piezoelectric accelerometers for general purpose vibration measurement. Estimate the rate of return from revenue of $225,000 per year for 10 years and $70,000 in salvage value from the used equipment sale in year 10. The company uses an MARR of 25%. Solve (a) Manually using interpolation, and (b) using Excel spreadsheet function.

A manufacturer of electronic devices invests $650,000 in equipment for making compact piezoelectric accelerometers for general purpose vibration measurement. Estimate the rate of return from revenue of $225,000 per year for 10 years and $70,000 in salvage value from the used equipment sale in year 10. The company uses an MARR of 25%. Solve (a) Manually using interpolation, and (b) using Excel spreadsheet function.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter17: Long-term Investment Analysis

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Plot the logarithm of arrivals for each transportation mode against time, all on the same graph. Which now appears to be growing the fastest?
Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+4X where N=monthlydemandforbagsofpottingsoil X=timeperiodsinmonths(March2006=0) Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: Forecast Bell Greenhouses demand for potting soil in March, June, August, and December 2007. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast.
Logarithms are especially useful for comparing series with two divergent scales since 10 percent growth always looks the same, regardless of the starting level. When absolute levels matter, the raw data are more appropriate, but when growth rates are whats important, log scales are better.
Metropolitan Hospital has estimated its average monthly bed needs as N=1,000+9X where X=timeperiod(months);January2002=0 N=monthlybedneeds Assume that no new hospital additions are expected in the area in the foreseeable future. The following monthly seasonal adjustment factors have been estimated, using data from the past five years: Forecast Metropolitans bed demand for January, April, July, November, and December 2007. If the following actual and forecast values for June bed demands have been recorded, what seasonal adjustment factor would you recommend be used in making future June forecasts?
The Questor Corporation has experienced the following sales pattern over a 10-year period: Compute the equation of a trend line (similar to Equation 5.4) for these sales data to forecast sales for the next year. (Let 2004=0,2005=1, etc., for the time variable.) What does this equation forecast for sales in the year 2014? Use a first-order exponential smoothing model with a w of 0.9 to forecast sales for the year 2014.
What life cycle cost concept begins raising concerns by year 5 with any electric vehicle (EV)? If that issue affected resale value at year 5, would that affect perceived value-in-use? How exactly?