Quick valuation: Net present value (NPV) Calculator
Originally published: 23/07/2018 06:16
Last version published: 28/01/2019 10:58
Publication number: ELQ-62672-5
View all versions & Certificate

Quick valuation: Net present value (NPV) Calculator

A calculator for a quick net present value (NPV) calculation for valuing a business

One of the fundamental valuation techniques is the net present value (NPV) calculation. This relies on calculated the sum of the discounted cash flows produced by a business or project in order to determine the business or projects value today.

The tool helps the user to determine what the free cash flows are for the business today and how these might grow over time. The tool also takes into account any terminal growth beyond the end of the 10 year timeline. Discount rates are applied to these free cash flows in order to discount them. The discount rates are entered on an annual basis and for the terminal value.

To use the tool, simply enter your assumptions regarding the components of free cash flow today, the free cash flow growth assumptions, terminal growth assumptions, and discount rates. Assumptions are entered into section "3 Assumptions".

The tool is laid out as a one page document for ease of use so that the user can assess the impact of assumptions on the valuation depicted in section "1 Results".

Section "2 Cell formats and summary" contains a key for cell formats and a summary of what the tool is used for an how to use it.

This Best Practice includes
1 excel document

Acquire business license for $15.00

Add to cart

Add to bookmarks


Further information

To produce a quick valuation of a business or a project based on discounted free cash flows using NPV and DCF

Anyone requiring a quick estimate of value

Anyone who requires any sophisticated calculations for free cash flow and how it changes over time

5.0 / 5 (1 votes)

please wait...