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



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







Analyst Estimates

Financial Health





StockDividendMarket Cap (B)PEPrice ($)

GNW Income Statement

AgencyFees909 M906 M978 M826 M
AgencyFeesAndCommissions909 M906 M978 M826 M12 M
AmortizationOfDeferredAcquisitionCosts498 M435 M348 M
Basic EPS from continuing operations-7.84-2.9-1.624.930.471.581.793.532.420.32
Basic EPS total-7.84-2.9-1.624.930.471.581.793.532.420.32
Basic weighted shares outstanding496 M497 M498 M499 M500 M503 M505 M507 M505 M469 M
CededPremiums1,135 M1,146 M1,577 M1,216 M1,227 M1,204 M1,170 M1,533 M1,118 M1,117 M
CommissionRevenue12 M
Depreciation-966 M-498 M-435 M-348 M441 M326 M264 M
Diluted EPS total-2.82-0.42-0.51.65-0.011.561.773.482.380.32
Diluted normalized net income/share-2.82-0.42-0.51.65-0.011.561.773.482.380.32
Diluted weighted shares outstanding496 M497 M498 M501 M500 M510 M512 M515 M511 M475 M
FeesAndCommissions909 M906 M978 M826 M795 M12 M
GainsLossOnDisposalOfDiscontinuedOperations157 M-407 M-29 M-9 M230 M11 M-486 M27 M
GeneralAndAdministrativeExpense1,138 M1,309 M1,273 M1,022 M943 M
GrossPremiumsWritten4,700 M4,579 M12,529 M4,004 M3,994 M4,826 M4,565 M4,139 M4,351 M4,282 M
ImpairmentOfCapitalAssets849 M5 M
Income before tax-1,299 M-15 M320 M729 M137 M714 M928 M1,181 M1,365 M303 M
Income restructuring and M&A-2 M-8 M-22 M-2 M-2 M4 M3 M34 M2 M4 M
Income taxes-94 M-9 M358 M-207 M70 M195 M230 M263 M319 M104 M
IncreaseDecreaseInNetUnearnedPremiumReserves936 M
Interest expense-433 M-419 M-337 M-284 M-256 M239 M195 M160 M106 M118 M
InterestIncome3,142 M3,138 M3,159 M3,200 M3,121 M
MinorityInterests-196 M-202 M110 M619 M-178 M-187 M-34 M-41 M-130 M-123 M
Net income from total operations-1,266 M-691 M290 M1,811 M110 M343 M178 M904 M916 M76 M
NetIncomeCommonStockholders-1,266 M-691 M290 M1,811 M110 M1,225 M1,104 M904 M916 M76 M
NetIncomeContinuousOperations-1,266 M-691 M290 M1,811 M110 M343 M178 M904 M916 M76 M
NetIncomeDiscontinuousOperations157 M-407 M-29 M-9 M230 M11 M-486 M27 M
NetIncomeExtraordinary-67 M927 M
NetInvestmentIncome3,107 M3,015 M3,343 M3,736 M3,103 M3,270 M3,719 M3,693 M3,434 M2,619 M
NetPremiumsWritten-4,700 M-4,579 M-12,529 M-4,004 M-3,994 M-4,826 M-4,565 M-4,139 M-4,351 M-4,282 M
NetRealizedGainLossOnInvestments-35 M-123 M184 M536 M-18 M50 M492 M323 M-2 M23 M
Operating income-463 M-63 M752 M1,000 M128 M1,596 M1,854 M1,935 M1,913 M831 M
Other income net9 M28 M118 M6 M-13 M1000000.05 M35 M-55 M
Other special charges-8 M
OtherGandA1,138 M1,309 M1,273 M1,022 M943 M
PolicyAcquisitionExpense-385 M-448 M-481 M-342 M-276 M377 M437 M379 M-12 M-7 M
PolicyFees826 M795 M
PolicyholderBenefitsCeded69 M
PolicyholderInterest737 M720 M696 M646 M611 M577 M549 M508 M504 M503 M
Revenue per share-454 M-170 M-155 M-240 M-202 M89 M42 M44 M52 M46 M
SalariesAndWages-28 M-16 M-32 M-42 M-35 M27 M39 M40 M37 M49 M
Selling Gen & administrative expense1,138 M1,309 M1,273 M1,022 M943 M962 M935 M1,223 M1,285 M942 M
Special income/charges849 M-8 M-22 M-2 M-2 M4 M3 M34 M-6 M4 M
Total common shares outstanding497 M498 M498 M499 M501 M505 M506 M507 M493 M443 M
Total net income-1,266 M-691 M290 M1,811 M110 M343 M178 M904 M916 M76 M
Total ordinary shares438 M438 M438 M438 M438 M438 M438 M438 M438 M438 M
Total revenues4,700 M4,579 M4,160 M4,004 M3,994 M8,096 M8,284 M7,832 M7,495 M7,488 M
TotalExpenses10,028 M8,563 M8,049 M7,566 M7,764 M-7,382 M-7,356 M-6,651 M-6,130 M-7,185 M
TotalPremiumsEarned4,700 M4,579 M12,529 M4,004 M3,994 M4,826 M4,565 M4,139 M4,351 M4,282 M
TotalRevenue4,700 M4,579 M4,160 M4,004 M3,994 M8,096 M8,284 M7,832 M7,495 M7,488 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


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.


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