Chapter $12$: Applying Excel: Exercise $($Part $2$ of $2)($Algo$)$

$2.$ The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit $12$B$-1$ and Exhibit $12$B$-2.($Use appropriate factor$($s$)$ from the tables provided.$)$

a$.$ What is the net present value of the project? $($Negative amount should be indicated by a minus sign. Round your present value factor to $3$ decimals and round all other intermediate calculations to nearest whole dollar.$)$

c$.$ The internal rate of return is between what two whole discount rates $($e$.$g$.,$ between $10\%$ and $11\%,$ between $11\%$ and $12\%,$ between $12\%$ and $13\%,$ between $13\%$ and $14\%,$ etc.$)?$

d$.$ Reset the discount rate to $11\%.$ Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value?

PrevQuestion $2$ of $2$ Total$2$ of $2$Visit question mapThis is the last question in the assignment. To submit, use Alt $+$ S$.$ To access other questions, proceed to the question map button.Next