It facilitates audits of a discounted cash-flow model. It illustrates the effect of compounding. It’s an alternative to using the XNPV and XIRR functions in Excel. What Is the Formula for the ...

Investment analysts commonly use Microsoft Excel for financial modeling ... such as determining a company's worth, with discounted cash flow (DCF) being one of the most popular methods.