Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Magna International Inc. logo

Magna International Inc.

Sector: Consumer Cyclical   

Industry: Auto Parts

49.12
 
USD
  
0.42
  
(0.86%)
Optionable: Yes  Market Cap: 14,277 M  90-day average vol: 1,482,105

Previous close: 48.7  Open: 48.8  Bid: 48.37  Ask: 50.88
52 week range    
46.71   
   65.27
Peers   
VC / 
DAN / 
JCI / 
ALV / 
AXL / 
BWA / 
LEA / 
F / 
STRT / 
Last updated: Monday 29th April 2024
48
MarketXLS Rank
80
Value
15
Technical
50
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

MGA Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""213 M236 M762 M367 M1,299 M331 M370 M729 M938 M1,729 M
Accounts payable4,765 M4,746 M5,430 M6,283 M6,094 M5,628 M6,266 M6,465 M6,999 M7,842 M
Accounts receivable5,316 M5,439 M6,165 M6,695 M6,548 M5,927 M6,394 M6,307 M6,791 M7,881 M
Accrued expenses6,899 M7,040 M7,933 M8,876 M8,597 M8,198 M9,373 M9,672 M10,060 M11,505 M
Accumulated depreciation & depletion-7,520 M-6,986 M-7,523 M-8,645 M-8,735 M-9,740 M-11,646 M-11,979 M-12,006 M-12,810 M
Additional paid in capital83 M107 M105 M119 M120 M127 M128 M102 M111 M125 M
Building & improvements1,653 M1,659 M1,942 M2,232 M2,205 M2,413 M2,709 M2,719 M2,740 M3,014 M
Cash and equivalents1,249 M2,863 M974 M726 M684 M1,276 M3,268 M2,948 M1,234 M1,198 M
CashCashEquivalentsAndShortTermInvestments1,249 M2,863 M974 M726 M684 M1,276 M3,268 M2,948 M1,234 M1,198 M
CashEquivalents1,058 M2,572 M498 M234 M314 M724 M1,987 M1,984 M720 M502 M
CommercialPaper615 M250 M1,063 M
Common par3,979 M3,942 M3,796 M3,617 M3,380 M3,198 M3,271 M3,403 M3,299 M3,354 M
Common stock equity8,659 M8,966 M9,768 M11,210 M10,701 M10,831 M11,370 M11,836 M10,935 M11,884 M
CommonStock3,979 M3,942 M3,796 M3,617 M3,380 M3,198 M3,271 M3,403 M3,299 M3,354 M
Cost in excess1,337 M1,344 M1,923 M2,099 M1,979 M1,976 M2,095 M2,122 M2,031 M2,767 M
CurrentAccruedExpenses2,134 M2,172 M2,407 M2,575 M2,503 M2,553 M3,069 M3,007 M2,968 M3,538 M
CurrentCapitalLeaseObligation225 M241 M274 M276 M399 M
CurrentDeferredAssets186 M
CurrentDeferredTaxesAssets186 M
CurrentDeferredTaxesLiabilities21 M
Deferred revenues21 M
DefinedPensionBenefit13 M17 M21 M23 M18 M22 M4 M41 M41 M
DerivativeProductLiabilities80 M152 M61 M17 M40 M8 M5 M31 M8 M
EmployeeBenefits559 M504 M667 M670 M597 M677 M729 M700 M583 M628 M
FinancialAssets8 M5 M6 M46 M9 M24 M16 M215 M26 M
Finished goods338 M311 M327 M433 M408 M425 M470 M506 M537 M569 M
Float term debt812 M2,327 M2,394 M3,195 M3,084 M3,062 M3,973 M3,538 M2,847 M4,175 M
GoodwillAndOtherIntangibleAssets1,477 M1,513 M2,544 M2,749 M2,539 M2,460 M2,576 M2,615 M2,031 M3,643 M
Gross fixed assets (Plant Property & Equipment)12,922 M12,934 M14,545 M16,821 M16,830 M19,811 M22,027 M21,972 M20,179 M22,428 M
IncomeTaxPayable122 M96 M18 M17 M38 M200 M93 M125 M
Intangibles140 M169 M621 M650 M560 M484 M481 M493 M452 M876 M
Inventories2,525 M2,564 M2,804 M3,542 M3,403 M3,304 M3,444 M3,969 M4,180 M4,606 M
Invested capital9,471 M11,293 M12,162 M14,405 M13,785 M13,893 M15,343 M15,374 M13,782 M16,059 M
Land & improvements266 M259 M254 M269 M229 M219 M195 M198 M181 M188 M
LineOfCredit33 M25 M8 M9 M35 M
LongTermCapitalLeaseObligation24 M19 M16 M15 M16 M1,623 M1,661 M1,414 M1,288 M1,319 M
LongTermDebtAndCapitalLeaseObligation836 M2,346 M2,410 M3,210 M3,100 M4,685 M5,634 M4,952 M4,135 M5,494 M
LongTermProvisions26 M26 M28 M34 M33 M34 M39 M37 M
Machinery furniture & equipment11,003 M11,016 M12,349 M14,320 M14,396 M15,368 M17,217 M17,355 M17,258 M19,226 M
Minority interest14 M151 M451 M502 M458 M300 M350 M389 M400 M393 M
Net fixed assets (net PP&E)5,402 M5,948 M7,022 M8,176 M8,095 M10,071 M10,381 M9,993 M8,173 M9,618 M
NetOtherUnrealizedGainLoss-1,114 M-898 M
Non-current deferred income taxes92 M132 M293 M322 M401 M419 M452 M440 M312 M184 M
NonCurrentAccountsReceivable85 M87 M229 M204 M198 M217 M209 M184 M
NonCurrentDeferredAssets463 M547 M688 M970 M1,041 M991 M372 M421 M491 M621 M
NonCurrentDeferredLiabilities96 M135 M305 M357 M507 M493 M504 M567 M519 M407 M
NonCurrentDeferredRevenue4 M3 M12 M35 M106 M74 M52 M127 M207 M223 M
NonCurrentDeferredTaxesAssets220 M271 M268 M238 M300 M308 M372 M421 M491 M621 M
NonCurrentPensionAndOtherPostretirementBenefitPlans35 M37 M
Number of employees161000.0161000.0161000.0161000.0161000.0161000.0161000.0161000.0161000.0161000.0
Other equity adjustments-558 M-1,470 M-1,451 M-600 M-1,175 M-1,090 M-733 M-900 M-1,114 M-898 M
Other fixed assets1,811 M1,906 M1,700 M
Other non-current assets385 M27 M43 M21 M22 M50 M734 M726 M2,426 M2,742 M
Other non-current liabilities298 M-1000000.037 M57 M52 M40 M
OtherCurrentBorrowings184 M211 M139 M108 M201 M106 M129 M455 M8 M511 M
OtherCurrentLiabilities514 M408 M
OtherInventories1,108 M1,164 M1,206 M1,524 M1,382 M1,339 M1,408 M1,465 M1,576 M1,726 M
Payables4,765 M4,868 M5,526 M6,301 M6,094 M5,645 M6,304 M6,665 M7,092 M7,967 M
Prepaid expenses150 M278 M220 M237 M193 M238 M260 M278 M320 M352 M
Raw materials846 M843 M1,007 M1,254 M1,282 M1,201 M1,226 M1,598 M1,640 M1,861 M
Retained earnings5,155 M6,387 M7,318 M8,074 M8,376 M8,596 M8,704 M9,231 M8,639 M9,303 M
Short term debt213 M236 M762 M367 M1,299 M106 M129 M455 M662 M1,330 M
TaxesReceivable13 M57 M
Total assets18,074 M19,687 M22,566 M25,468 M25,945 M25,790 M28,605 M29,086 M27,337 M32,255 M
Total current assets9,862 M11,144 M10,163 M11,200 M11,834 M10,745 M13,366 M13,502 M12,525 M14,037 M
Total current liabilities7,626 M7,276 M8,695 M9,243 M10,304 M8,529 M9,743 M10,401 M10,998 M13,234 M
Total equity8,659 M8,966 M9,768 M11,210 M10,701 M10,831 M11,370 M11,836 M10,935 M11,884 M
Total liabilities9,401 M10,570 M12,347 M13,756 M14,786 M14,659 M16,885 M16,861 M16,454 M19,978 M
Total non-current assets8,212 M8,543 M12,403 M14,268 M14,111 M15,045 M15,239 M15,584 M14,812 M18,218 M
Total non-current liabilities1,775 M3,294 M3,652 M4,513 M4,482 M6,130 M7,142 M6,460 M5,456 M6,744 M
TotalEquityGrossMinority8,673 M9,117 M10,219 M11,712 M11,159 M11,131 M11,720 M12,225 M11,335 M12,277 M
TotalEquityGrossMinorityInterest8,673 M9,117 M10,219 M11,712 M11,159 M11,131 M11,720 M12,225 M11,335 M12,277 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest18,074 M19,687 M22,566 M25,468 M25,945 M25,790 M28,605 M29,086 M27,789 M32,255 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,775 M3,294 M3,652 M4,513 M4,482 M6,130 M7,142 M6,460 M5,456 M6,744 M
TotalTaxPayable122 M96 M18 M17 M38 M200 M93 M125 M
UnrealizedGainLoss-1,114 M-898 M
Work in progress233 M246 M264 M331 M331 M339 M340 M400 M427 M450 M
Working capital2,236 M3,868 M1,468 M1,957 M1,530 M2,216 M3,623 M3,101 M1,527 M803 M
ltinv379 M399 M1,850 M2,079 M2,189 M1,210 M947 M1,389 M1,429 M1,273 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