Excel Magic Trick 1431

XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations

DESCRIPTION

See how to:
(00:10) Introduction
(00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project
(10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project
(13:09) Summary

WORKBOOKS

Download “Excel Magic Trick 1431-1434” Excel-Magic-Trick-1431-1434.zip – Downloaded 29 times – 2 MB







Be the first to comment

Leave a Reply