BioBoyScout's DCF (Discounted Cash Flow) Calculators        
The yellow highlighted cells can be adjusted to the user's preferences.  The user should have a working knowledge of DCF modeling.  The result is a DCF valuation showing the calculated net present value (NPV).  Two DCF Calculators are provided for side-by-side comparison.
             
             
    DCF VALUATION #1  
    YEAR 1  
    Free Cash Flow (FCF)  
    Discount Period (DP)  
    Discount Factor (DF)  
    NPV of Free Cash Flow (NFCF)  
  DCF METRICS #1     Valuation #1      
    Select Starting Year       Terminal Value (TV)                
    # of Years to Calculate NPV       NPV of FCF   Net Cash/(Debt)      
    Monetary Scale (MS) ($)
      NPV of Terminal Value (NPVTV)   Equity Value      
    Terminal Growth Rate (TGR)       Total NPV   $ / Share      
    Discount Rate (DR)       TV as a % of total   Shares outstanding      
                                       
    DCF VALUATION #2  
    YEAR 1  
    Free Cash Flow (FCF)  
    Discount Period (DP)  
    Discount Factor (DF)  
    NPV of Free Cash Flow (NFCF)  
  DCF METRICS #2     Valuation #2      
    Select Starting Year       Terminal Value (TV)                
    # of Years to Calculate NPV       NPV of FCF   Net Cash/(Debt)      
    Monetary Scale (MS) ($)
      NPV of Terminal Value (NPVTV)   Equity Value      
    Terminal Growth Rate (TGR)       Total NPV   $ / Share      
    Discount Rate (DR)       TV as a % of total   Shares outstanding      
              Copyright © 2019, Robert Toczycki. All Rights Reserved.      
                                       
    Discount Factor = 1 / (1 + DR)^(DP)   NPV of FCF = Sum of NFCF values   TV as a % of total = NPVTV / Total NPV      
    NPV of Free Cash Flow = FCF * DF   NPV of Terminal Value = TV / (1 + DR)^(Last DP)   Equity Value = Total NPV + Net Cash/(Debt)      
    Terminal Value = (Last FCF * (1 + TGR)) / (DR - TGR)   Total NPV = NPV of FCF + NPVTV   $ / Share = Equity Value * MS / Shares Outstanding