Templates and Checklists

Business Valuation Template

Armin Laidre
Armin Laidre | Senior Appraiser

Feel free to download this MS Excel-based worksheet that utilizes DCF (Discounted Cash Flow) – a widely-accepted method for calculating the value of a profitable and ongoing business.

Download the file (XLSX)

A screenshot of the DCF Valuation Model (XLSX-spreadsheet)
Pictured: how it works


Don't Miss the Gold Rush: 4 Reasons to Sell Your Business in 2021

How Does the Concept Work?

In business finance, Discounted Cash Flow (DCF) analysis is a method of valuing a business or its money-generating assets using the concept of the time value of money. Future cash flows are estimated and discounted by using the cost of equity to determine present value. The sum of all future cash flows that belong to business owners, both incoming and outgoing, is taken as the value of the business in question.

This model is intended to provide business owners with a starting point for determining the asking price. Any definitive valuation would require a review by a qualified appraiser.

Read more about the DCF method

Download Business Valuation Template for
(preview below)

Or get the full collection (30+ files) for $59