Use the XNPV and XIRR functions for non-periodic cash flows

Use the XNPV and XIRR functions for non-periodic cash flows

Syntax: XNPV(rate, values, dates) and XIRR(values, dates, [guess])

Step 1: Define the discount rate, cash flow values, and corresponding dates.

Step 2: Enter the appropriate formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com