What formula is used to calculate the NPV in cell D49?
The NPV is calculated in cell D49 using the formula "=D47D48", which subtracts the initial cash outflow (CF0) from the present value of the future cash flows.