Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Ford Motor Company logo

Ford Motor Company

Sector: Consumer Cyclical   

Industry: Auto Manufacturers

12.03
 
USD
  
-0.12
  
(-0.99%)
Optionable: Yes  Market Cap: 48,507 M  90-day average vol: 48,437,511

Previous close: 12.15  Open: 12.06  Bid: 12.04  Ask: 12.05
52 week range    
9.63   
   15.42
Peers   
HMC / 
TM / 
GM / 
TSLA / 
NSANY / 
TTM / 
Last updated: Thursday 23rd May 2024
43
MarketXLS Rank
80
Value
7
Technical
42
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

F Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable20,035 M20,272 M21,296 M23,282 M21,520 M20,673 M22,204 M22,349 M25,605 M25,992 M
Accounts receivable11,042 M11,102 M10,599 M11,195 M9,237 M9,993 M11,370 M15,729 M15,601 M
Accrued expenses20,035 M20,272 M21,296 M23,282 M21,520 M20,673 M22,204 M22,349 M25,605 M25,992 M
Accumulated depreciation & depletion-7,385 M-2,049 M-2,130 M-2,292 M-9,385 M-10,493 M-8,774 M-7,318 M-7,674 M-7,690 M
Additional paid in capital21,089 M21,421 M21,630 M21,843 M22,006 M22,165 M22,290 M22,611 M22,832 M23,128 M
AllowanceForLoansAndLeaseLosses351 M911 M643 M590 M626 M
Cash and equivalents10,757 M3,949 M15,905 M18,492 M16,718 M17,504 M25,243 M20,540 M25,134 M24,862 M
CashCashEquivalentsAndShortTermInvestments31,150 M24,853 M38,827 M38,927 M33,951 M34,651 M49,961 M49,593 M44,070 M40,171 M
CashEquivalents10,757 M14,272 M15,905 M18,492 M16,718 M17,504 M25,243 M
Common par1000000.028,643 M29,171 M35,579 M35,972 M40 M40 M40 M41 M41 M
Common stock equity24,399 M57,244 M58,300 M71,116 M71,863 M33,184 M30,689 M48,519 M43,242 M42,773 M
CommonStock1000000.028,643 M29,171 M35,579 M35,972 M40 M40 M40 M41 M41 M
Cost in excess6 M50 M75 M264 M278 M258 M619 M603 M683 M
CurrentCapitalLeaseObligation268 M278 M342 M337 M363 M177 M323 M565 M574 M892 M
CurrentDeferredAssets14,024 M11,509 M
CurrentDeferredRevenue4,675 M3,866 M2,107 M2,095 M2,091 M2,161 M2,349 M2,404 M2,515 M
CurrentDeferredTaxesAssets14,024 M11,509 M18,492 M19,266 M21,930 M23,272 M24,804 M26,795 M
CurrentDeferredTaxesLiabilities570 M11,007 M10,857 M9,947 M9,815 M11,373 M11,885 M12,215 M14,003 M15,980 M
Deferred revenues570 M502 M
DeferredFinancingCosts-1000000.0
DefinedPensionBenefit247 M229 M204 M185 M193 M
DerivativeProductLiabilities181 M248 M344 M312 M306 M376 M535 M1,700 M1,300 M
DividendsPayable-1,954 M-2,386 M-3,381 M-2,595 M
Finished goods5,026 M5,254 M5,943 M6,779 M6,684 M6,384 M6,132 M6,280 M8,083 M9,455 M
Float term debt43,086 M142,970 M1,200 M470 M291 M
Gross fixed assets (Plant Property & Equipment)37,511 M32,212 M34,202 M37,619 M74,682 M76,192 M45,857 M44,457 M44,939 M48,511 M
Intangibles133 M124 M198 M213 M178 M188 M144 M111 M86 M80 M
InterestPayable3,496 M840 M974 M1,057 M5,157 M5,409 M5,051 M4,593 M4,593 M7,613 M
Inventories7,870 M8,319 M8,898 M11,176 M11,220 M10,786 M10,808 M12,065 M14,080 M15,651 M
Invested capital24,805 M143,416 M344,240 M34,890 M74,263 M34,124 M30,981 M48,519 M43,242 M42,773 M
Leases29,119 M29,230 M27,951 M647 M682 M783 M
LongTermCapitalLeaseObligation119,171 M142,970 M154,287 M600 M991 M1,393 M1,505 M2,136 M
LongTermDebtAndCapitalLeaseObligation119,171 M43,086 M142,970 M154,287 M1,200 M470 M291 M
LongTermProvisions44,032 M42,546 M
Minority interest369 M109 M113 M126 M134 M45 M121 M103 M-75 M25 M
Net fixed assets (net PP&E)30,126 M30,163 M32,072 M35,327 M65,297 M65,699 M37,083 M37,139 M37,265 M40,821 M
Non-current deferred income taxes1,967 M502 M691 M815 M597 M490 M538 M1,581 M1,549 M1,005 M
NonCurrentDeferredAssets11,509 M9,705 M10,762 M10,412 M11,863 M12,423 M13,796 M15,552 M16,985 M
NonCurrentDeferredLiabilities502 M691 M815 M597 M490 M538 M1,581 M1,549 M1,005 M
NonCurrentDeferredRevenue3,285 M3,687 M3,829 M3,985 M4,191 M4,559 M4,683 M4,883 M5,051 M
NonCurrentDeferredTaxesAssets22,187 M11,509 M9,705 M10,762 M10,412 M11,863 M12,423 M13,796 M15,552 M16,985 M
NonCurrentNoteReceivables45,554 M49,924 M56,182 M55,544 M53,703 M55,277 M51,256 M49,903 M55,650 M
NonCurrentPensionAndOtherPostretirementBenefitPlans9,543 M10,150 M9,932 M9,423 M9,878 M10,738 M8,658 M5,673 M6,383 M
NotesReceivable81,111 M91,039 M142,456 M160,602 M164,250 M53,651 M42,401 M32,543 M38,720 M46,425 M
Number of employees183000.0183000.0183000.0183000.0183000.0183000.0183000.0183000.0183000.0183000.0
Other current assets6,052 M2,998 M3,368 M3,889 M3,930 M5,722 M3,581 M3,425 M3,877 M3,633 M
Other equity adjustments-20,032 M-6,257 M-7,013 M-6,959 M-7,366 M-7,728 M-8,294 M
Other fixed assets30,126 M30,163 M32,072 M35,327 M36,178 M36,469 M37,083 M37,139 M37,265 M40,821 M
Other non-current assets1,500 M4,795 M5,656 M8,104 M7,929 M10,706 M12,882 M14,942 M11,118 M11,441 M
Other non-current liabilities228 M23,457 M24,395 M24,711 M23,588 M25,324 M28,379 M27,705 M25,497 M28,414 M
Other receivable11,708 M11,284 M484 M156,776 M160,338 M155,900 M127,144 M136,341 M158,057 M176,191 M
OtherCurrentLiabilities-467 M19,108 M19,316 M19,697 M20,556 M23,513 M23,645 M18,686 M21,097 M25,870 M
OtherInventories7,870 M8,319 M8,898 M11,176 M11,220 M10,786 M10,808 M12,065 M14,080 M15,651 M
OtherPayable21,296 M23,282 M21,520 M20,673 M22,204 M
Payables20,035 M20,272 M21,296 M23,282 M21,520 M20,673 M22,204 M22,349 M25,605 M25,992 M
RecievablesAdjustmentsAllowances-373 M-484 M-597 M-589 M-513 M-394 M-282 M-255 M-256 M
Restricted cash18,638 M16,907 M17,741 M25,935 M20,737 M25,340 M25,110 M
Retained earnings4,157 M8,157 M8,621 M14,947 M15,302 M12,592 M9,949 M27,430 M22,415 M21,987 M
Total assets208,615 M246,805 M334,141 M366,888 M366,437 M258,537 M267,261 M257,035 M255,884 M273,310 M
Total current assets151,915 M138,251 M204,651 M225,193 M224,546 M114,047 M116,744 M108,996 M116,476 M121,481 M
Total current liabilities20,605 M39,380 M40,612 M42,979 M42,076 M44,186 M45,849 M90,727 M96,866 M101,531 M
Total equity24,399 M57,244 M58,300 M71,116 M71,863 M33,184 M30,689 M48,519 M43,242 M42,773 M
Total liabilities64,637 M106,425 M208,668 M68,505 M67,461 M70,470 M74,766 M208,413 M212,717 M230,512 M
Total non-current assets56,700 M108,554 M129,490 M141,695 M141,891 M144,490 M150,517 M148,039 M139,408 M151,829 M
Total non-current liabilities44,032 M67,045 M168,056 M25,526 M25,385 M26,284 M28,917 M29,286 M27,046 M29,419 M
TotalEquityGrossMinority24,768 M57,353 M58,413 M71,242 M71,997 M33,229 M30,810 M48,622 M43,167 M42,798 M
TotalEquityGrossMinorityInterest24,768 M57,353 M58,413 M71,242 M71,997 M33,229 M30,810 M48,622 M43,167 M42,798 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest89,405 M163,778 M267,081 M139,747 M139,458 M103,699 M105,576 M257,035 M255,884 M273,310 M
TotalNonCurrentLiabilitiesNetMinorityInteres44,032 M67,045 M168,056 M25,526 M25,385 M26,284 M28,917 M29,286 M27,046 M29,419 M
Treasury stock-848 M-977 M-1,122 M-1,253 M-1,417 M-1,613 M-1,590 M-1,563 M-2,047 M-2,384 M
UnearnedIncome23,217 M13,309 M28,829 M28,235 M29,119 M27,951 M26,361 M22,772 M21,384 M
Work in progress3,859 M4,005 M3,843 M4,397 M4,536 M4,402 M4,676 M5,785 M5,997 M6,196 M
Working capital131,310 M98,871 M164,039 M182,214 M182,470 M69,861 M70,895 M18,269 M19,610 M19,950 M
ltinv3,357 M3,224 M3,304 M3,085 M2,709 M2,519 M4,901 M4,545 M2,798 M5,548 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