NPV is a tool to compare alternative investment options in terms of present day dollars. Jackson Aviation has several proposals for new Jet introductions. The attached excel worksheet $($CH$01-$Jackson$\_$Aviation$-$NPV$-$V$3.$xlsx$)$ provides the initial fixed investment and projected cash flows for the first five years for this new aircraft. The guided practice video $($below$)$ provides a solution for calculating NPV for a single investment option. The assignment may look different from the videos as data may change by term. You must prepare the NPV and IRR calculations for each alternative presented and then discuss how you would rank the investments and propose a recommendation, considering the fact that capital resources may be limited$,$ requiring the company to make some consumption choices on these investments.Excel Instructions

Use the Excel SUM formula to calculate the total of the projected cash flows.

Use the Excel NPV formula to calculate the net present value of this investment proposal using discount rates from $2\%$ up to $20\%,$ using increments of $1\%.$

Compute the Internal Rate of Return for each Option. $($hint: Excel formula IRR$)$

Prepare any charts you feel will be helpful in this analysis.

Save your work in a $.$xlsx file and upload it to the discussion board with your post.