Perform a sensitivity analysis of the salvage value

The second table is Sales. You dont need to do analysis but welcome to do it.

Then select the better project and make a specific recommendation. Thoroughly explain why the project chosen is a more appropriate choice than the other project. use robust sentences.

Increase 8% Old Salvage Old NPV New Salvage New NPV Change in % Salvage Project 1 Project 2 $ 39,000.00 $ 131,000.00 $ 103,795.28 $ 120,605.03 $ 42,120.00 $ 141,480.00 $ 105,123.06 $ 125,065.01 1.279% 3.698% Decrease 8% Project 1 Project 2 Old Salvage $ 39,000.00 $ 131,000.00 Old NPV $ 35,880.00 $ 120,520.00 New Salvage $ 103,795.28 $ 120,605.03 New NPV $ 102,467.51 $ 116,145.06 Change in % -1.279% -3.698% Increase 8% Base Case New NPV Change in % Project 1 Project 2 $ 103,795.28 $ $ 138,610.92 $ 33.543% 120,605.03 175,444.60 45.470% Drcease 8% Base case New NPV Change in % Project 1 Project 2 $ 103,795.28 $ $ 68,979.65 $ -33.543% 120,605.03 65,765.46 -45.470% Increase 8% Old Salvage Old NPV New Salvage New NPV Change in % Salvage Project 1 Project 2 $ 39,000.00 $ 131,000.00 $ 103,795.28 $ 120,605.03 $ 42,120.00 $ 141,480.00 $ 105,123.06 $ 125,065.01 1.279% 3.698% Decrease 8% Project 1 Project 2 Old Salvage $ 39,000.00 $ 131,000.00 Old NPV $ 35,880.00 $ 120,520.00 New Salvage $ 103,795.28 $ 120,605.03 New NPV $ 102,467.51 $ 116,145.06 Change in % -1.279% -3.698% Increase 8% Base Case New NPV Change in % Project 1 Project 2 $ 103,795.28 $ $ 138,610.92 $ 33.543% 120,605.03 175,444.60 45.470% Drcease 8% Base case New NPV Change in % Project 1 Project 2 $ 103,795.28 $ $ 68,979.65 $ -33.543% 120,605.03 65,765.46 -45.470%