Discount Rate

If you dream to start an FMCG Distribution business, the template is the first step in making your dream into…

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

This is a full 10-year startup lending business financial model, including a 3-statement model. Accurately scale the origination of 3…

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

This is a bundle of all the most useful and efficient google sheet templates I have built over the years.…

Price: $369.00
Add to wish list
$369.00 – Purchase Excluding 7.7% tax

Produce a DCF Analysis for single or multiple scenarios and up to 6 discount rates. Includes unique visual analysis.

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

Advanced financial model presenting a potential Hotel acquisition.

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

Average rating:

3 statement 5 year rolling financial projection Excel model for a startup or existing digital media business generating revenue through…

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

Supermarket Financial Model presents the business case of an already operating supermarket / grocery chain business. The model generates the…

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

DCF & Business Valuation template for any type of business/industry

Price: $49.00
Add to wish list
$49.00 – Purchase Excluding 7.7% tax

3 statement 5 year rolling financial projection Excel model for existing/startup dental clinic/practice with valuation

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

User-friendly 3 statement 5 year rolling financial projection Excel model for existing/startup healthcare business

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

Plan out the assumptions and the resulting financials that show how a driving range can be developed and operated.

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

Time Value of Money, Bond and Stock Valuation Excel Model template presents various financial tools which allow you to discount…

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

Economic Value Added Model presents another valuation method which is based on a residual income approach which takes the perspective…

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

This Capital Budgeting Analysis model is used to provide an analysis of a proposed project. This model includes key metrics…

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

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

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

Catering Equipment for HIRE Business will assist you in arriving at accurate and validated decisions about either Starting or Expanding…

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

This is a 5-year monthly and annual financial model that was built to fit revenue drivers that are directly related…

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

Analyse the Start or Expansion of a Building Equipment Hire Business with Cash Flow Statements, Income Statements and Balance Sheets…

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

User-friendly 3 statement 5 year rolling financial projection Excel model for a Multi-entity Group (4 entities)

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

This is simple and easy to understand Discounted Cash Flow Model of Bajaj Automobiles Limited (India), prepared in November 2020.…

Price: $20.00
Add to wish list
$20.00 – Purchase Excluding 7.7% tax

A dynamic financial model to forecast monthly and annual customers/revenues/expenses for a SaaS company.

Price: $175.00
Add to wish list
$175.00 – Purchase Excluding 7.7% tax

Dynamic Arrays Financial Model generates the three financial statements (profit & loss, balance sheet and cash flow), as well as…

Starting at: $0.00
  •  x 
  •  x 
Add to wish list
Purchase Excluding 7.7% tax

The template contains the cash flow statement, the income statement, the balance sheet statement as well as ratios, variance analysis,…

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

This Online Coaching Model is a perfect tool for financial feasibility study on launching a Online Coaching platform.

Price: $99.00
Add to wish list
$99.00 – Purchase Excluding 7.7% tax

The Development Property Valuation calculator is suitable for accurately analysing development opportunities and projects. The Financial analysis makes use of…

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

The model helps the users to avoid failure or going out of business and improve the power for knowing the…

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

Average rating:

This is simple and easy to understand Discounted Cash Flow Model of Dr. Reddy's Laboratories India prepared in October 2020.…

Price: $20.00
Add to wish list
$20.00 – Purchase Excluding 7.7% tax

The 12 Questions Model based on only 12 simple questions generates the three financial statements (Profit & Loss, Balance Sheet…

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

Professional Realtors need a professional Toolkit which allows them to operate at a higher level. The ALL-IN-ONE Quintessential Real Estate…

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

Value any Non-Listed Business and assess how gearing will affect the returns achieved. The QUINTESSENTIAL Business Valuation Calculator makes use…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% 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.