It encompasses many financial topics in one formula: cash flows, the time value of money, terminal value ... Most analysts use Excel to calculate NPV. You can input the present value formula ...

This video breaks down Buffett’s simple yet effective formula for estimating intrinsic value and provides a free Excel spreadsheet ... Determine the terminal value and apply a discount rate.