Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Franklin Electric Co. Inc. logo

Franklin Electric Co. Inc.

Sector: Industrials   

Industry: Diversified Industrials

100.51
 
USD
  
0.32
  
(0.32%)
Optionable: Yes  Market Cap: 4,649 M  90-day average vol: 175,436

Previous close: 100.19  Open: 100.26  Bid: 85.0  Ask: 160.73
52 week range    
82.61   
   107.89
Peers   
AOS / 
GRC / 
FLS / 
AMOT / 
AME / 
CFX / 
XYL / 
DOV / 
DHR / 
Last updated: Friday 19th April 2024
57
MarketXLS Rank
80
Value
46
Technical
47
Quality

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

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

FELE Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""15 M34 M33 M34 M101 M112 M32 M14 M113 M143 M
Accounts payable58 M71 M58 M64 M79 M77 M83 M96 M165 M139 M
Accounts receivable115 M144 M127 M146 M171 M173 M173 M160 M196 M230 M
Accrued expenses122 M166 M112 M124 M145 M144 M154 M190 M283 M263 M
Accumulated depreciation & depletion-199 M-212 M-221 M-234 M-270 M-279 M-290 M-312 M-325 M-342 M
Additional paid in capital195 M207 M216 M229 M240 M258 M270 M283 M311 M325 M
Cash and equivalents135 M59 M82 M104 M67 M59 M64 M131 M41 M46 M
CashCashEquivalentsAndShortTermInvestments135 M59 M82 M104 M67 M59 M64 M131 M41 M46 M
CashEquivalents135 M59 M82 M104 M67 M59 M64 M131 M
Common par5 M5 M5 M5 M5 M5 M5 M5 M5 M5 M
Common stock equity596 M597 M558 M613 M701 M734 M797 M848 M947 M1,068 M
CommonStock5 M5 M5 M5 M5 M5 M5 M5 M5 M5 M
Cost in excess207 M209 M200 M200 M237 M249 M256 M267 M330 M328 M
CurrentAccruedExpenses62 M95 M52 M57 M64 M65 M68 M89 M115 M121 M
CurrentCapitalLeaseObligation800000.0600000.0100000.0100000.0100000.09 M10 M11 M15 M16 M
CurrentDeferredAssets10 M8 M
CurrentDeferredTaxesAssets10 M8 M41 M35 M32 M37 M47 M53 M55 M56 M
CurrentDeferredTaxesLiabilities1 M637000.057 M57 M42 M45 M47 M49 M76 M79 M
Deferred revenues1 M637000.0
DeferredFinancingCosts-200000.0-100000.0
DividendsPayable0.00.0
EmployeeBenefits47 M45 M42 M38 M38 M44 M41 M32 M
Finished goods102 M112 M94 M105 M186 M197 M184 M193 M258 M318 M
Float term debt174 M144 M188 M157 M126 M94 M93 M92 M123 M122 M
GoodwillAndOtherIntangibleAssets356 M369 M341 M334 M368 M384 M387 M400 M579 M559 M
Gross fixed assets (Plant Property & Equipment)408 M422 M411 M430 M486 M486 M492 M521 M584 M606 M
IncomeTaxPayable2 M788000.02 M3 M2 M2 M3 M5 M3 M3 M
Intangibles149 M160 M141 M135 M131 M135 M131 M134 M250 M231 M
Inventories192 M221 M195 M203 M312 M314 M300 M301 M450 M545 M
Invested capital784 M744 M749 M770 M826 M828 M890 M940 M1,160 M1,279 M
LongTermCapitalLeaseObligation190 M178 M221 M191 M226 M207 M18 M21 M33 M33 M
LongTermDebtAndCapitalLeaseObligation174 M144 M188 M157 M126 M94 M111 M113 M123 M122 M
Machinery furniture & equipment260 M274 M273 M290 M321 M319 M320 M336 M340 M348 M
Minority interest8 M9 M9 M9 M3 M2 M2 M2 M2 M3 M
Net fixed assets (net PP&E)209 M210 M190 M196 M216 M207 M201 M209 M259 M264 M
Non-current deferred income taxes55 M46 M33 M40 M31 M29 M28 M26 M28 M30 M
NonCurrentDeferredAssets3 M4 M3 M5 M9 M9 M9 M9 M8 M7 M
NonCurrentDeferredLiabilities96 M104 M33 M40 M31 M29 M28 M26 M28 M30 M
NonCurrentDeferredTaxesAssets3 M4 M3 M5 M9 M9 M9 M9 M8 M7 M
NonCurrentPensionAndOtherPostretirementBenefitPlans47 M45 M42 M38 M38 M44 M41 M32 M
Notes payable75 M
Number of employees6500.06500.06500.06500.06500.06500.06500.06500.06500.06500.0
Other current assets21 M38 M35 M30 M39 M34 M29 M28 M38 M37 M
Other equity adjustments-55 M-108 M-162 M-170 M-149 M-183 M-190 M-205 M
Other fixed assets148 M148 M138 M140 M165 M167 M171 M186 M243 M258 M
Other non-current assets12 M24 M23 M21 M3 M3 M2 M3 M4 M6 M
Other non-current liabilities40 M21 M17 M17 M37 M29 M34 M36 M38 M34 M
Other receivable1,125 M1,298 M1,315 M1,247 M1,662 M2,044 M
OtherCurrentBorrowings15 M34 M33 M34 M101 M112 M22 M3 M98 M127 M
OtherEquityInterest-39 M-56 M-1 M-326000.0216000.0622000.0
Payables60 M72 M60 M67 M82 M79 M86 M101 M167 M142 M
Raw materials72 M89 M82 M80 M110 M99 M98 M87 M167 M197 M
RecievablesAdjustmentsAllowances-4 M-4 M-4 M-4 M
Retained earnings451 M493 M498 M550 M605 M655 M712 M765 M631 M738 M
Short term debt15 M34 M33 M34 M101 M112 M22 M3 M98 M127 M
Total assets1,052 M1,076 M996 M1,040 M1,185 M1,182 M1,195 M1,272 M1,575 M1,694 M
Total current assets472 M470 M438 M484 M589 M580 M567 M619 M725 M858 M
Total current liabilities138 M201 M145 M158 M246 M256 M186 M204 M396 M406 M
Total equity596 M597 M558 M613 M701 M734 M797 M848 M947 M1,068 M
Total liabilities448 M470 M430 M417 M481 M446 M396 M423 M627 M624 M
Total non-current assets580 M606 M558 M556 M596 M602 M600 M621 M850 M836 M
Total non-current liabilities310 M269 M285 M259 M235 M190 M211 M219 M230 M218 M
TotalEquityGrossMinority598 M599 M559 M615 M703 M736 M799 M850 M949 M1,070 M
TotalEquityGrossMinorityInterest598 M599 M559 M615 M703 M736 M799 M850 M949 M1,070 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest1,052 M1,076 M996 M1,040 M1,185 M1,182 M1,195 M1,272 M1,575 M1,694 M
TotalNonCurrentLiabilitiesNetMinorityInteres310 M269 M285 M259 M235 M190 M211 M219 M230 M218 M
TotalTaxPayable2 M788000.02 M3 M2 M2 M3 M5 M3 M3 M
Work in progress18 M19 M18 M19 M17 M19 M18 M21 M25 M30 M
Working capital334 M268 M293 M326 M343 M324 M382 M416 M329 M452 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University