Note: Use appropriste factor$($s$)$ from the tables provided.

$\backslash$table$[[1,$A$,$B$,$c$],[,$Chapter $14$: Applying Excel,,$],[2,,,],[3,$Data,,$],[4,$Example E$,,],[\backslash$table$[[5],[6]],$Cost of equpment needed,$ $150,000,],[7,$V orking capital neoded,$ $500,000,],[,$Cverhaul of equipment in four years,$ $10,000,],[8,$Salvage value of the equipment in five years,$ $40,000,],[9,$Ancual revenues and costs,,$],[\backslash$table$[[10],[11]],$Sales revenues,$ $410,000,],[12,$Cost of goods sold,$ $275,000,],[,$Out$-$of pocket oserating costs,$ $85,000,],[13,$Dscount fale,$18,5]]$

a$.$ What is the net present value of the project?

Note: Negotive omount should be indiceted by a minus sign. Round your present valve factor to $3$ decimals and round all other intermediete colculotions to nearest whole dollor,

$$

Net presemt valiuec. The internal rate of return is between what two whole discount rates $($e$.$g$.,$ between $10\%$ and $17$ k $,$ between its and $12\%,$ between $12\%$ and $13\%,$ between $13\%$ and $14\%,$ etc.$)?$

$\backslash$table$[[$The internal rate of echurn is betwoon,$\%,$and,s$]]$

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

Winmum salvage value required to genorase a positive present value