Instruction: Illustrate how to construct complex Excel formulas to evaluate financial models, including Net Present Value (NPV) and Internal Rate of Return (IRR).
Context: This question gauges the candidate's understanding of financial analysis principles and their application within Excel.