Question: 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


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 11. . 12. The dollar value of cell KK is The dollar value of cell LL is The dollar value of cell MM is 13. 14 The dollar value of cell NN is 15. The dollar value of cell OO is
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
