Show work in excel and use excel functions and formulas.

Problem $11\mathrm{.}9$: You recently went to work for Allied Components Company, a supplier of auto repair parts used in the after$-$market with products from Daimler AG$,$ Ford, Toyota and other automakers. Your boss, the chief financial officer $($CFO$),$ has just handed you an assignment that includes the estimated cash flows for two proposed projects. The project's are related to the firm's ignition system line, but you are unsure if the projects are independent or mutually exclusive so ranking the two projects would be helpful. Allied requires a rate of return on projects like this of $14$ percent and a maximum payback period of $4$ years. The cash flows for the two projects are provided below and to prepare your analysis you have decided to do the following:

Calculate the payback period, NPV and IRR for both projects.

If you assume the two projects are independent $-$ that is$,$ that both could be accepted if both are acceptable, evaluate the two projects' acceptability using all three decision criteria from #$1$ above.

Rank the two projects and make a recommendation as to which $($if either$)$ should be accepted under the assumption that the projects are mutually exclusive.

$\backslash$table$[[$Year$,$Project A$,$Project B$],[0,-$$$750,000\mathrm{.}00,-$$$635,000\mathrm{.}00$