Discounted Cash Flow (DCF) Model Template in Google Sheets
Originally published: 08/02/2019 11:07
Last version published: 20/07/2020 11:34
Publication number: ELQ-67245-6
View all versions & Certificate

Discounted Cash Flow (DCF) Model Template in Google Sheets

This Model provides an estimated investment return by discounting future cash flows to a present value.


You may open the model in the browser and check it before download here:

You may check methodology before you download the template here:

Now check details...

Key purposes which can be answered with help of the Discounted Cash Flow (DCF) GOOGLE SHEET financial model are as follows:

- to value an entire business;

- to value a project or investment within a company;

- to value an income producing property;

- to value the benefit of a cost-saving initiative at a company;

- to value anything that produces (or has an impact on) cash flow;

Discounted Cash Flow analysis is a valuation method which uses future cash flow predictions to estimate investment return potential by discounting these projections to a present value approximation and using this to assess the attractiveness of the investment.

Discounted Cash Flow (DCF) GOOGLE SHEETS Model Template aims to help you calculate the value of a business.

Feel free to leave a review and a rating if you have appreciated the model!

• About us

Do you need a cash flow projection for your business? Or are you looking for an ideal template to prepare your cash flow statement? Whether you are an intending business owner or you have started your business, we are here to simplify your financial recording.

Welcome to Finmodelslab.

• Who we are

We are a financial modelling company set up for small and large business owners. We specialize in financial modelling and dashboards. Our model comes in varying style. Most times we create a customized projection to meet the specific needs of our customers business.

Believe us when we say our financial designs are simply unique and efficient.

• Our Promise

Finmodelslab promises to make it easy for people to keep up with cash flow statements and cash flow projections with its efficient and simple designs. Ultimately, we simplify your financial recording process.

With unique and creative designs, Finmodelslab promises to help every business owner to maximize their profit and keep good records of their cash flow. We also provide step by step guide on how to use any templates purchased from us.

Let’s help you take your business to a new height of profitability

• Who We Serve

Cash flow projection helps one to preempt potential business shortfalls. Therefore, we are here to provide cash flow dashboards to help you keep track of your business. Take a look at our financial models and dashboards collection, and you would be convinced about our quality.

Welcome once again to your unique financial model store. Welcome to Finmodelslab.

- Henry Sheykin

This Best Practice includes
1 Discounted Cash Flow (DCF) Model GSHEETS Template, 1 Methodology

Henry Sheykin offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

The purpose of the Discounted Free Cash Flow Financial Model Template is to provide the user with a useful tool to estimate investment return potential by discounting future cash flow projections to a present value.

Can be useful for CFOs, Students, Teachers, Business controllers, M&A analysts, Private Equity analysts etc. The model is easy to use and has high flexibility.


People using this Best Practice also downloaded


More Best Practices from Henry Sheykin

See all

Any questions on Discounted Cash Flow (DCF) Model Template In Google Sheets?

The user community and author are here to help. Go ahead!

4.7 / 5 (6 votes)

please wait...