Creating Complex Formulas for Financial Analysis
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.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
Define cash-flow signs, timing, period length and a discount rate consistent with those periods. Excel's NPV discounts its listed values as end-of-period cash flows; add a time-zero outflow separately.
For a teaching example, put −100 in B2 at time zero and 110 in B3 one year later, with the annual discount rate 10% in E1:...