Question: Three mutually exclusive alternatives may replace the current equipment. Year A B C 0 -$20,000 -$24,000 -$25,000 1 $10,000 $10,000 $5,000 2 $5,000 $10,000 $5,000
- Three mutually exclusive alternatives may replace the current equipment.
| Year | A | B | C |
| 0 | -$20,000 | -$24,000 | -$25,000 |
| 1 | $10,000 | $10,000 | $5,000 |
| 2 | $5,000 | $10,000 | $5,000 |
| 3 | $10,000 | $8,000 | $5,000 |
| 4 | $5,000 | $5,000 | $25,000 |
- Construct a choice table for interest rates from 0 % to 100 %
- If the MARR is 12 % which alternative should be selected?
Do Nothing is not an alternative.
Please, can you show me step by step how to do this in excel and run it down? What do I put in year 5 to 100 because it gives me o% when I drag it down. Please show all excel formulas in cells
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help