for Katetutor
Sheet1
| Defender | Challenger | ||
| pi | 10 | 9 | Initial cost |
| a_c | 1 | 0.9 | annual cost |
| a_b | 1.1 | 0.99 | annual benefit |
| a_net | 0.1 | 0.09 | benefit-cost |
| f | -3 | -2.4 | Future maintenance cost at year 10 |
| nf | 10 | 10 | Maintenance year |
| s | 0.00 | 0.00 | Salvage |
| n | 20 | 20 | |
| ROR | -12% | By changing this value | |
| AW | $0.007 | $0.006 | |
| Diff, % | 0.0006744324 | Set this value to zero |