Your command wants $to$ maintain the end$-$strength $of100$ mission capable fighter aircraft. There are two options; $F-XX$ and $F-XY.$ Assuming both aircraft are comparable $in$ terms $of$ capability, which aircraft $is$ more economical? Use the annual discount rates $of2\%,5\%,$ and $7\%$ and compare $NPVsin$ Year $0$ dollars. Assume that the acquisition cost will $be$ paid $in$ Year $0,$ one year prior $to$ the first year $of$ operation. You may use the $LCC$ template Prob $5_{N}PV$ tab $to$ perform $NPV$ calculations.

$\begin{array}{cc}?& F-XX\text{A}\text{i}\text{r}\text{c}\text{r}\text{a}\text{f}\text{t}\\ F-XY\text{A}\text{i}\text{r}\text{c}\text{r}\text{a}\text{f}\text{t}& \text{E}\text{n}\text{d}-\text{s}\text{t}\text{r}\text{e}\text{n}\text{g}\text{t}\text{h}\\ 100& 100\\ \text{E}\text{x}\text{p}\text{e}\text{c}\text{t}\text{e}\text{d}Ao& .85\\ .82& \text{N}\text{u}\text{m}\text{b}\text{e}\text{r}of\text{a}\text{i}\text{r}\text{c}\text{r}\text{a}\text{f}\text{t}tobe\text{a}\text{c}\text{q}\text{u}\text{i}\text{r}\text{e}\text{d}\\ ?& ?\\ \text{U}\text{n}\text{i}\text{t}\text{C}\text{o}\text{s}\text{t}& \text{\$}30000000\\ \text{\$}20000000& \text{A}\text{n}\text{n}\text{u}\text{a}\text{l}\text{O}\text{p}\text{e}\text{r}\text{a}\text{t}\text{i}\text{o}\text{n}\text{s}\text{a}\text{n}\text{d}\text{M}\text{a}\text{i}\text{n}\text{t}\text{e}\text{n}\text{a}\text{n}\text{c}\text{e}\text{C}\text{o}\text{s}\text{t}\text{s}\text{p}\text{e}\text{r}\text{a}\text{i}\text{r}\text{c}\text{r}\text{a}\text{f}\text{t}\\ \text{\$}6000000& \text{\$}6500000\\ \text{E}\text{x}\text{p}\text{e}\text{c}\text{t}\text{e}\text{d}\text{L}\text{i}\text{f}\text{e}& 20\text{y}\text{e}\text{a}\text{r}\text{s}\\ 20\text{y}\text{e}\text{a}\text{r}\text{s}& \text{S}\text{a}\text{l}\text{v}\text{a}\text{g}\text{e}\text{V}\text{a}\text{l}\text{u}\text{e}or\text{D}\text{i}\text{s}\text{p}\text{o}\text{s}\text{a}\text{l}\text{C}\text{o}\text{s}\text{t}\\ \text{\$}0& \text{\$}0\end{array}$