Franklin Electric Co., Inc. (FELE) DCF Valuation

Franklin Electric Co., Inc. (FELE) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Franklin Electric Co., Inc. (FELE) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment strategies with the (FELE) DCF Calculator! Explore authentic Franklin Electric financial data, adjust growth predictions and expenses, and observe how these modifications affect the intrinsic value of (FELE) in real-time.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 1,314.6 1,247.3 1,661.9 2,043.7 2,065.1 2,334.3 2,638.6 2,982.6 3,371.4 3,810.9
Revenue Growth, % 0 -5.12 33.23 22.98 1.05 13.04 13.04 13.04 13.04 13.04
EBITDA 173.8 176.5 253.3 319.1 306.3 341.1 385.5 435.8 492.6 556.8
EBITDA, % 13.22 14.15 15.24 15.62 14.83 14.61 14.61 14.61 14.61 14.61
Depreciation 48.7 48.2 58.4 50.4 52.3 75.0 84.8 95.9 108.4 122.5
Depreciation, % 3.7 3.86 3.51 2.46 2.53 3.21 3.21 3.21 3.21 3.21
EBIT 125.1 128.3 194.9 268.8 254.0 266.0 300.7 339.9 384.2 434.3
EBIT, % 9.51 10.29 11.73 13.15 12.3 11.4 11.4 11.4 11.4 11.4
Total Cash 64.4 130.8 40.5 45.8 85.0 112.9 127.6 144.2 163.0 184.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 173.3 159.8 196.2 230.4 222.4
Account Receivables, % 13.18 12.81 11.8 11.27 10.77
Inventories 300.2 300.9 450.0 545.0 508.7 585.2 661.5 747.7 845.2 955.3
Inventories, % 22.84 24.13 27.08 26.67 24.63 25.07 25.07 25.07 25.07 25.07
Accounts Payable 82.6 95.9 164.8 139.3 152.4 177.8 201.0 227.2 256.8 290.2
Accounts Payable, % 6.28 7.69 9.91 6.81 7.38 7.62 7.62 7.62 7.62 7.62
Capital Expenditure -21.9 -22.9 -30.1 -41.9 -41.4 -43.7 -49.4 -55.9 -63.1 -71.4
Capital Expenditure, % -1.66 -1.83 -1.81 -2.05 -2.01 -1.87 -1.87 -1.87 -1.87 -1.87
Tax Rate, % 20.21 20.21 20.21 20.21 20.21 20.21 20.21 20.21 20.21 20.21
EBITAT 102.2 104.2 158.1 214.0 202.7 214.7 242.7 274.3 310.0 350.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -261.9 155.7 69.8 67.8 270.9 137.9 188.5 213.1 240.9 272.3
WACC, % 8.87 8.86 8.86 8.86 8.86 8.86 8.86 8.86 8.86 8.86
PV UFCF
SUM PV UFCF 800.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 278
Terminal Value 4,047
Present Terminal Value 2,647
Enterprise Value 3,447
Net Debt 71
Equity Value 3,376
Diluted Shares Outstanding, MM 47
Equity Value Per Share 71.98

What You Will Get

  • Real FELE Financial Data: Pre-filled with Franklin Electric’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Franklin Electric’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Customizable Financial Inputs: Adjust essential factors such as sales growth, operating margin, and capital investments.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and various financial metrics.
  • High-Precision Accuracy: Leverages Franklin Electric's actual financial data for dependable valuation results.
  • Effortless Scenario Analysis: Evaluate diverse assumptions and analyze results with ease.
  • Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.

How It Works

  • 1. Open the Template: Download and open the Excel file containing Franklin Electric Co., Inc.'s (FELE) preloaded data.
  • 2. Edit Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures specific to Franklin Electric Co., Inc. (FELE).
  • 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV for Franklin Electric Co., Inc. (FELE).
  • 4. Test Scenarios: Evaluate various forecasts to explore different valuation possibilities for Franklin Electric Co., Inc. (FELE).
  • 5. Use with Confidence: Present professional valuation insights for Franklin Electric Co., Inc. (FELE) to support your investment decisions.

Why Choose Franklin Electric Co., Inc. (FELE)?

  • Save Time: Quickly access essential data without the hassle of building complex models.
  • Enhance Accuracy: Utilize dependable financial metrics and formulas to minimize valuation errors.
  • Completely Customizable: Adjust the parameters to suit your specific assumptions and forecasts.
  • User-Friendly: Intuitive graphs and outputs facilitate straightforward analysis of results.
  • Preferred by Professionals: Crafted for experts who prioritize both accuracy and ease of use.

Who Should Use This Product?

  • Investors: Evaluate Franklin Electric Co., Inc.'s (FELE) market position before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Franklin Electric Co., Inc. (FELE).
  • Startup Founders: Understand the valuation strategies of established companies like Franklin Electric Co., Inc. (FELE).
  • Consultants: Provide comprehensive valuation analyses and reports for clients involving Franklin Electric Co., Inc. (FELE).
  • Students and Educators: Utilize actual data from Franklin Electric Co., Inc. (FELE) to learn and teach valuation principles.

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations for Franklin Electric Co., Inc. (FELE).
  • Real-World Data: Franklin Electric's historical and projected financials preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for deeper insights into performance.
  • Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Franklin Electric Co., Inc. (FELE).
  • Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to Franklin Electric Co., Inc. (FELE).

No products were found matching.