Reference no: EM137952
Q. Sensitivity Analysis: using excel
Lane Construction ltd. is considering the acquisition of a new eighteen wheeler.
-The truck base price is $80,000 and it will cost another $20,000 to modify it for special use by the company.
-This truck falls into MACRS five year class. It will be sold after three years for $30,000.
-The truck purchase will have no effect on revenues, but it is expected to save the firm $45,000 per year in before-tax operating costs, mainly in leasing expenses.
-The firm marginal tax rate (federal plus state) is 40%, and its MARR is 15%.
(a) Is this project acceptable, based on the most likely estimates given in the problem?
(b)If the firm's MARR is increased to 25%, what would be the required savings in leasing so that the project would remain profitable?
|
Prediction interval for a new patient
: The 95% prediction interval for a new patient with a 2-day cholesterol level of 220 is
|
|
What is the wavelength of light
: A diffraction grating with 395 lines/mm is 1.00 m in front of a screen. What is the wavelength of light whose first-order maxima will be 16.9 cm from the central maximum on the screen.
|
|
Suppose that the market price
: Suppose that the market price for a bottle of vitamins is $2.50 and that at that price the total market quantity demanded is 75,000,000 bottles.
|
|
What is the percent error for an experiment
: A 1.20 liter flask contains a certain quantity of ideal gas at 305 K. next an equal number of molecules of the same gas are added to the flask, after which the absolute pressure is 1.30 times its original value. What is the final temperature.
|
|
Project would remain profitable
: If the firm's MARR is increased to 25%, what would be the required savings in leasing so that the project would remain profitable.
|
|
Molecules angular speed about the center of mass
: The molecule has a rotational kinetic energy that is of the translational kinetic energy of its center of mass. What then is molecule's angular speed about the center of mass.
|
|
Degrees of freedom for the t test for the slope
: I have fit a line to data representing cholesterol readings for 28 individuals starting a cholesterol reducing drug. The computer provides the following output, The degrees of freedom for the t test for the slope are
|
|
Depreciation taken in the third year
: Depreciation taken in the third year if the machine is also sold during the third year.
|
|
Particular budget cutting policy
: Do you think this particular budget cutting policy helpful to curb the growing budget deficit.
|