← Back to Templates

DCF model

Description

DCF model thumbnail

Discounts projected free cash flows back to a per share value. Historical free cash flow seeds the projection, beta drives the cost of equity, and interest expense against long term and total debt gives an after tax cost of debt, so the discount rate is built from the company's own capital structure instead of typed in.

Share count converts the result to a per share figure shown next to the current ask price. Growth rates, the terminal assumption and the forecast horizon are all inputs, with a sensitivity table showing how much the answer depends on them.

Template Screenshots

DCF model screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found