Clearly identify all alternatives (your model should evaluate three alternatives). Construct an NPW or EUAW (or EUAC) graph showing all alternatives…

$12,000

  1. Compute NPW of each alternative
  2. Generate an NPW graph with NPW on the Y-axis and interest rate on the X-axis with all alternatives on one graph (see Figure 8-6 for an example).
  3. Generate an EUAW graph (see figure 8-5 for an example).
  4. Construct a choice table for interest rates from 0% – 100%.
  5. Using a MARR of 15% and a rate of return analysis, which alternative, if any, should be selected?

I need help with this Excel spread sheet.

Thanks

Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!