Question
Determine the best alternative among the options in the table below if the MARR is 6%. Option A B C Initial cost $2500 $4000 $5000
Determine the best alternative among the options in the table below if the MARR is 6%.
Option | A | B | C |
Initial cost | $2500 | $4000 | $5000 |
Annual net benefits | $410 | $639 | $700 |
n= 20 years. | |||
NPV= | |||
IRR= | |||
NPV | |||
i | A | B | C |
0% | |||
1% | |||
2% | |||
3% | |||
4% | |||
5% | |||
6% | |||
7% | |||
8% | |||
9% | |||
10% | |||
11% | |||
12% | |||
13% | |||
14% | |||
15% | |||
16% | |||
17% | |||
18% | |||
19% | |||
20% | |||
21% | |||
22% | |||
23% | |||
24% | |||
25% |
a) Using Excel, construct a choice table for interest rates from 0% to 25% showing the NPV of each option for each interest rate using the NPV function. Based on the table, state the range of interest rates over which each option should be chosen.
b) Using Excel, plot the values for the three options for a rate interest ranging from 1% to 25%. This table will plot the NPV of each option as a function of interest rate. On the plot, label the internal rate of return for each option. Interpret the results of the graph.
c) In Excel, use the IRR function that you have to perform a rate of return analysis on the three options.The MARR=6%. Show the calculated values of each internal rate of return, expressed to 2 decimal places. Explain any decision to consider or reject an option.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started