Discount Rate
Listed here are financial model templates which include the discount rate. The discount rate or cost of capital is used to discount future cash flows to their present value.

Get both Airport | Airline financial model templates in a bundle.

Price: $140.00
Add to wish list
$140.00 – Purchase Excluding 0% tax

Airline Operator Financial Model presents the case of a company operating an airline business. The model generates the three financial…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Leveraged Buy Out (LBO) Model presents the business case of the purchase of a company by using a high level…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

User-friendly Excel model intended for the preparation of a Cost-Benefit Analysis to determine the financial viability for a proposed project…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Online Shop Financial Model presents the business case of a brand new start up Online Shop with an upfront investment…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Nail Salon Financial Model presents the business case of a brand new start up Nail Salon with an upfront investment…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Airport Operator Financial Model presents the business case of an already operating airport (with planned refurbishments) and an investment in…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Port Operator Financial Model presents the business case of an already operating port terminal (with planned refurbishments) and an investment…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Shipping Vessel’s Financial Model presents the business case of the purchase of two vessels with the intent of chartering them…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

This model makes it easier to forecast the scaling out of a SaaS model that is dependent on Account Executives…

Price: $125.00
Add to wish list
$125.00 – Purchase Excluding 0% tax

Commercial Banking Financial Model presents the case of a commercial bank with regulatory thresholds based on Basel 3. The model…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Weighted Average Cost of Capital (or WACC) is an excel tool that calculates the discount rate of a company, which…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

A 5-year startup financial model template geared toward the revenue and expense logic of a security monitoring and alarm services…

Price: $125.00
Add to wish list
$125.00 – Purchase Excluding 0% tax

Steel Industry Financial Model presents the business case of the operation of a steel plant using the mini mill technology.…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties with the intent…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Shared Use Kitchens Financial Model presents the business case of a commercial shared use kitchen with 21 stations that generates…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Build a strategy for adding recurring revenues services to your product.

Price: $75.00
Add to wish list
$75.00 – Purchase Excluding 0% tax

Start Up Hydro Dam Excel Model presents the business case of an investment in the construction of a dam and…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Start Up Solar Farm Excel Model presents the business case of an investment in the construction of a solar farm…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Start Up Wind Farm Excel Model presents the business case of an investment in the construction of a wind farm…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

This detailed, yet easy to use three statement financial model will allow you to calculate your business' profit and loss,…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Excel model for a start up Greenhouse business for you to download and use.

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Commercial Real Estate Excel model which generates the cash flows of the project as well as for equity investors and…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

This detailed, yet easy to use three statement financial model will allow you to calculate your business' profit and loss,…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Specific revenue and expense logic for modeling the build-up of an ATM machine business over 10 years.

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 0% tax

Financial Model Templates that generates a three statement financial model and a valuation for a fish farm start up and…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

Hotel financial model which generates the 3 financial statements as well as a valuation (incl. sensitivity analysis) from business assumptions.

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

This financial model focuses on a DCF valuation of a company in the Manufacturing industry. This model can be used…

Starting at: $0.00
Add to wish list
Purchase Excluding 0% tax

A 5-year financial model tailored to starting a golf course and projecting financial performance for its business plan.

Price: $125.00
Add to wish list
$125.00 – Purchase Excluding 0% tax

A transaction facilitator of any kind can benefit from this fee-based financial model. It is geared towards startups.

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 0% tax


The Discount Rate in DCF Analysis


As you already know, the discounted cash flow analysis or also known as the DCF Valuation makes use of a key metric such as the discount rate. As time passes by, the value of money tends to change which is mostly decreasing, thus, its purchasing power of income at a period in the future should be worth less compared today’s value. Hence, it is very important to take into account the time value of money when conducting a valuation which pretty much depends mostly on the projection of cash flows in the future.

Basically, the discount rate is the interest rate used in DCF analysis to determine the present value of the future cash flows. It also stands as the interest rate charged to banks and other financial institutions.

For example, we will use a DCF Valuation calculation table to determine the present value of the future cash flows by applying the discount rate.

Discounted Cash Flow Calculation
Discounted Cash Flow Calculation


Using the DCF formula:



The discount rate used here is the WACC which stands for as the average cost the business paid for capital from either borrowing or selling equity.

 

Calculating the Discount Rate - Using Weighted Average Cost of Capital Calculation


To calculate the discount rate, one must first determine what is the appropriate discount rate to use. Many businesses tend to use their Weighted Average Cost of Capital or WACC if its risk report is similar to that of the business, otherwise, the other option would be to use the Capital Asset Pricing Model (CAPM) as the discount rate instead.

 

To calculate the discount rate using the WACC, one will need to use the following formula:



Where:

Ke = Cost of Equity
Kd = Cost of Debt (average interest rate on business’ debt or use Book Value)
T = Corporate Tax Rate (marginal tax rate)
Ve = Value of Equity (business market cap – cash + debt)
Vd = Value of Debt (proxy is Book Value)

 

To calculate the discount rate using the CAPM, use the following formula:



Where:

Rf = Risk-free rate of return
B (Beta) = Sensitivity of the expected stock return to the market return or covariance of the historical return of a particular stock and the market divided by the variance of the market; B = Cov (Rs,Rm)/Var(Rm)
Rm = Market rate of return

 

Discount Rate Example Models


If you are looking for DCF Models and learn how to build one yourself, you can see it here: Discounted Cash Flow Models. If you want to learn more how to apply discount rate and how it works, we compiled a list of discount rate example models found above which are specifically designed for different industries and other use cases. These discount rate example models are using the weighted average cost of capital calculation mostly as the basis since it is the most use case when determining the discount rate.

These discount rate example models are ready-made by experienced financial modelers with a wide range of experience in financial modeling and industry know-how. So, the model itself will only need you to input the values according to your figures and customize the ranges or metrics according to your requirements. If you still need help with creating a custom model with discount rate applied, then we can also help you with that. Just feel free to provide us your specifications and we’ll draft you the model as well as give you a proper quotation.