Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

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

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

HMC Income Statement

Annual
Invalid dateMar-12Mar-13Mar-14Mar-18Mar-19Mar-20Mar-21Mar-22Mar-23
AcquiredInProcessRnD707,067 M
Basic EPS from continuing operations590.79345.99260.13380.75
Basic EPS total117.34203.71318.54590.79345.99260.13380.75384.02
Basic weighted shares outstanding1,802 M1,802 M1,802 M1,793 M1,764 M1,752 M1,727 M1,696 M
Cost of sales-5,919,633 M-7,345,162 M-8,761,083 M12,000,581 M12,580,949 M11,851,659 M10,439,689 M11,567,923 M13,576,133 M
Depreciation-554,867 M-590,469 M-794,720 M-73,410 M-62,203 M-73,105 M
Depreciation unreconciled-1,454,116 M-1,468,685 M-1,461,403 M-1,425,118 M-1,596,876 M
DepreciationAndAmortization-554,867 M-590,469 M-794,720 M-1,454,116 M-1,468,685 M-1,461,403 M-1,425,118 M-1,596,876 M
Diluted EPS total1.431.472.29590.79345.99260.13380.75384.02
Diluted weighted shares outstanding147,890 M249,761 M250,702 M1,793 M1,764 M1,752 M1,727 M1,696 M
Dividends paid per share60.072.079.0
Earnings from equity interest100,406 M82,723 M132,471 M1,306,980 M228,827 M164,203 M272,734 M202,512 M768,861 M
EarningsFromEquityInterestNetOfTax100,406 M82,723 M132,471 M1,306,980 M228,827 M164,203 M272,734 M202,512 M768,861 M
GainOnSaleOfBusiness864,160 M838,526 M832,511 M1,073,662 M1,067,321 M
GainOnSaleOfPPE610,316 M
GainOnSaleOfSecurity80,453 M101,917 M1,059,337 M657,425 M
GeneralAndAdministrativeExpense-34,079 M-32,728 M-34,953 M1,775,151 M1,774,393 M1,641,590 M1,331,728 M1,326,485 M1,669,908 M
Gross operating profit2,028,462 M2,532,785 M3,081,368 M3,360,565 M3,307,668 M3,079,350 M2,730,830 M2,984,773 M3,331,592 M
ImpairmentOfCapitalAssets-12,104 M-4,773 M-3,301 M
Income before tax257,403 M488,891 M728,940 M2,174,310 M1,589,691 M789,918 M1,571,478 M1,777,257 M1,530,981 M
Income taxes135,735 M178,976 M252,662 M-13,666 M303,089 M279,986 M218,609 M309,489 M162,256 M
Interest income33,461 M25,742 M24,026 M41,191 M48,618 M49,412 M19,805 M25,627 M73,071 M
InterestExpenseNonOperating10,378 M12,157 M12,703 M12,970 M13,217 M24,689 M13,877 M16,867 M36,112 M
InterestExpenseOperating-97,788 M-86,989 M-82,796 M
MinorityInterests-10,592 M-25,489 M-34,642 M69,302 M65,970 M54,186 M38,019 M53,634 M65,893 M
MiscOtherSpecialCharges2,956 M-69,504 M-32,664 M
Net income from total operations211,482 M367,149 M574,107 M2,257,278 M1,352,572 M564,118 M1,390,888 M1,521,402 M1,434,618 M
NetIncomeCommonStockholders211,482 M367,149 M574,107 M2,257,278 M1,352,572 M564,118 M1,390,888 M1,521,402 M1,434,618 M
NetIncomeContinuousOperations211,482 M367,149 M574,107 M2,257,278 M1,352,572 M564,118 M1,390,888 M1,521,402 M1,434,618 M
NetIncomeDiscontinuousOperations13,032 M10,059 M20,410 M
NetNonOperatingInterestIncomeExpense23,083 M13,585 M11,323 M33,772 M24,178 M-7,922 M-18,889 M-3,554 M-18,649 M
Operating income231,364 M544,810 M750,281 M833,558 M726,370 M633,637 M660,208 M871,232 M780,769 M
Operating income before depreciation (EBITDA)515,098 M749,595 M1,101,165 M2,900,373 M2,324,603 M1,514,484 M2,209,594 M2,405,187 M2,288,723 M
OperatingExpense1,797,098 M1,987,975 M2,331,087 M2,527,007 M2,581,298 M2,445,713 M2,070,622 M2,113,541 M2,550,823 M
Other income net-103,362 M-13,219 M-99,807 M-1,306,980 M-839,143 M-164,203 M-930,159 M-202,512 M-768,861 M
OtherGandA-34,079 M-32,728 M-34,953 M1,775,151 M1,774,393 M1,641,590 M1,331,728 M1,326,485 M1,669,908 M
OtherOperatingExpenses-2,910 M
PromotionAndAdvertising-195,284 M-254,016 M-297,514 M
ProvisionForGainLossOnDisposal13,032 M10,059 M20,410 M
RealizedCapitalGain657,425 M
RentAndLandingFees-34,079 M-32,728 M-34,953 M
Research & development expense519,818 M560,270 M634,130 M751,856 M806,905 M804,123 M738,894 M787,056 M880,915 M
ResearchExpense519,818 M560,270 M634,130 M751,856 M806,905 M804,123 M738,894 M787,056 M880,915 M
SalariesAndWages-1,576,012 M-1,634,785 M-1,605,553 M-1,470,748 M-1,635,515 M
Selling Gen & administrative expense1,277,280 M1,427,705 M1,696,957 M1,775,151 M1,774,393 M1,641,590 M1,331,728 M1,326,485 M1,669,908 M
SellingAndMarketingExpense1,277,280 M1,427,705 M1,696,957 M
SellingExpense1,277,280 M1,427,705 M1,696,957 M
Special income/charges12,104 M4,773 M3,301 M67,768 M32,565 M37,752 M28,420 M707,067 M8,400 M
Total Income available for interest expense (EBIT)169,993 M414,059 M658,847 M2,187,280 M1,602,908 M814,607 M1,585,355 M1,794,124 M1,567,093 M
Total common shares outstanding1,802 M1,802 M1,802 M1,778 M1,760 M1,781 M1,797 M
Total net income211,482 M367,149 M574,107 M2,257,278 M1,352,572 M564,118 M1,390,888 M1,521,402 M1,434,618 M
Total ordinary shares1,811 M1,811 M1,811 M1,811 M1,811 M1,811 M1,811 M1,811 M1,811 M
Total revenues7,948,095 M9,877,947 M11,842,451 M15,361,146 M15,888,617 M14,931,009 M13,170,519 M14,552,696 M16,907,725 M
TotalExpenses-4,122,535 M-5,357,187 M-6,429,996 M14,527,588 M15,162,247 M14,297,372 M12,510,311 M13,681,464 M16,126,956 M
TotalRevenue7,948,095 M9,877,947 M11,842,451 M15,361,146 M15,888,617 M14,931,009 M13,170,519 M14,552,696 M16,907,725 M
WriteDown-67,768 M-32,565 M-37,752 M-28,420 M-8,400 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