B. Problem Statement (30 questions) Business is thriving and, as a result, the Soho Paving Company is contemplating the purchase of additional landscaping equipment. While the Company has done the necessary due diligence, it is doubtful that the investment would perform exactly as projected by the dealership consultant . Due to lingering uncertainty, you have been mandated by the Company to perform a one-way sensitivity analysis of your potential purchase. The current "best" guesses for the project parameters are: 1. Initial Cost (P) = $960,000 2. Salvage value (SV) = $12,133 3. Annual operating revenues (AOR) - $600,000 4. Annual operating costs (AOC) = $325,000 5. Economic life (N) - 5 years 6. MARR = 10% 7. Inflation Rate = 0%. 2 One-way Sensitivity Table Parameters -15% +10% +15% Net Present Worth (NPW) -10% -5% Reference +5% Scenario AA BB CC P AOR DD EE AOC FF GG HH KK SV N LL MM MARR NN 00 PP 1. The dollar value of cell AA is The dollar value of cell BB is 2. 3. 4. The dollar value of cell CC is The dollar value of cell DD is The dollar value of cell EE is 5. B. Problem Statement (30 questions) Business is thriving and, as a result, the Soho Paving Company is contemplating the purchase of additional landscaping equipment. While the Company has done the necessary due diligence, it is doubtful that the investment would perform exactly as projected by the dealership consultant . Due to lingering uncertainty, you have been mandated by the Company to perform a one-way sensitivity analysis of your potential purchase. The current "best" guesses for the project parameters are: 1. Initial Cost (P) = $960,000 2. Salvage value (SV) = $12,133 3. Annual operating revenues (AOR) - $600,000 4. Annual operating costs (AOC) = $325,000 5. Economic life (N) - 5 years 6. MARR = 10% 7. Inflation Rate = 0%. 2 One-way Sensitivity Table Parameters -15% +10% +15% Net Present Worth (NPW) -10% -5% Reference +5% Scenario AA BB CC P AOR DD EE AOC FF GG HH KK SV N LL MM MARR NN 00 PP 1. The dollar value of cell AA is The dollar value of cell BB is 2. 3. 4. The dollar value of cell CC is The dollar value of cell DD is The dollar value of cell EE is 5