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

Trupanion Inc.

Sector: Financial Services   

Industry: Insurance - Specialty

29.01
 
USD
  
1.07
  
(3.83%)
Optionable: Yes  Market Cap: 1,174 M  90-day average vol: 750,213

Previous close: 27.94  Open: 27.72  Bid: 28.3  Ask: 33.07
52 week range    
18.45   
   36.66
Peers   
WOOF / 
NTIP / 
SBLK / 
Last updated: Thursday 30th May 2024
62
MarketXLS Rank
60
Value
61
Technical
65
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CLS

2 B15.211.83

NTIP

0.03680 B4.72.72

SBLK

0.20042 B10.524.95

WOOF

5 B40.818.52
Financials

TRUP Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles-200000.08 M33 M33 M42 M44 M
Basic EPS from continuing operations-0.05-0.16-0.89-1.1-1.08
Basic EPS total-0.01-0.05-0.16-0.89-1.1-1.08
Basic weighted shares outstanding13 M28 M29 M30 M32 M35 M36 M40 M41 M41 M
Cost of sales26 M30 M31 M39 M-253 M319 M420 M595 M783 M978 M
Depreciation-2 M-3 M-4 M-4 M-4 M6 M7 M12 M11 M12 M
Depreciation unreconciled-2 M-3 M6 M7 M12 M11 M12 M
DepreciationAndAmortization-2 M-3 M-4 M-4 M-4 M6 M7 M12 M11 M12 M
Diluted EPS total-1.64-0.62-0.24-0.05-0.03-0.05-0.16-0.89-1.1-1.08
Diluted normalized net income/share-1.1-1.08
Diluted weighted shares outstanding13 M28 M29 M30 M34 M35 M36 M40 M41 M41 M
Earnings from equity interest1000000.0-352000.0-126000.0-171000.0-253000.0-219000.0
EarningsFromEquityInterestNetOfTax1000000.0-352000.0-126000.0-171000.0-253000.0-219000.0
GainOnSaleOfPPE-111000.0-20000.0-24000.0
GainOnSaleOfSecurity300000.0
GeneralAndAdministrativeExpense14 M16 M15 M17 M18 M18 M22 M32 M39 M60 M
Gross operating profit20 M25 M33 M43 M51 M65 M82 M104 M122 M131 M
Income before tax-21 M-17 M-7 M-2 M-934000.0-2 M-6 M-35 M-44 M-45 M
Income restructuring and M&A-300000.0-500000.0-500000.0-800000.0-1000000.0-1 M
Income taxes-7000.0114000.038000.0-428000.0-7000.0169000.0113000.0310000.0476000.0-342000.0
Interest income73000.075000.0100000.0200000.0900000.02 M600000.0300000.03 M9 M
InterestExpenseNonOperating7 M300000.0218000.0533000.01 M1 M1 M10000.04 M12 M
InterestExpenseOperating-1 M-155000.0-153000.0-333000.0-1 M
MiscOtherSpecialCharges1 M9000.058000.01 M1 M2 M600000.03 M8 M
Net income from total operations-21 M-17 M-7 M-2 M-936000.0-2 M-6 M-36 M-45 M-45 M
NetIncomeCommonStockholders-21 M-17 M-7 M-2 M-936000.0-2 M-6 M-36 M-45 M-45 M
NetIncomeContinuousOperations-21 M-17 M-7 M-2 M-936000.0-2 M-6 M-36 M-45 M-45 M
NetIncomeFromOtherGainsLosses5 M8 M
NetNonOperatingInterestIncomeExpense-7 M-300000.0-218000.0-533000.0-1 M-1 M-1 M-10000.0-4 M-12 M
Normalized income-28 M
Operating income-16 M-17 M-7 M-3 M-1 M-2 M-5 M-35 M-43 M-41 M
Operating income before depreciation (EBITDA)-6 M-14 M-3 M3 M4 M5 M3 M-23 M-29 M-20 M
OperatingExpense-36 M-42 M-40 M-46 M-52 M66 M87 M139 M165 M171 M
Other income net-1 M-9000.0-58000.0-1 M-1 M-1 M-474000.0171000.0-3 M-7 M
OtherGandA14 M16 M15 M17 M18 M18 M22 M32 M39 M60 M
OtherOperatingExpenses-1 M-300000.0-500000.0-116000.09 M-7 M-10 M-17 M-25 M-21 M
OtherWriteOff4 M
PromotionAndAdvertising-3 M-5 M-4 M-5 M-6 M8 M13 M24 M26 M17 M
RentAndLandingFees14 M16 M15 M17 M18 M400000.0200000.0
Research & development expense10 M
ResearchExpense10 M
RestructringAndMnAIncome-300000.0-500000.0-500000.0-800000.0-1000000.0-1 M
Revenue per share-5 M-21000.0-58000.0-200000.08 M33 M33 M42 M44 M
SalariesAndWages-4 M-3 M-3 M-3 M-5 M7 M9 M29 M35 M35 M
Selling Gen & administrative expense26 M31 M30 M36 M43 M54 M70 M111 M129 M138 M
SellingAndMarketingExpense12 M15 M15 M19 M25 M35 M48 M79 M90 M77 M
SellingExpense12 M15 M15 M19 M25 M
Special income/charges300000.0500000.0500000.0800000.01000000.01 M
Total Income available for interest expense (EBIT)-16 M-17 M-7 M-2 M-755000.0-291000.0-4 M-35 M-40 M-33 M
Total common shares outstanding28 M28 M30 M30 M34 M35 M39 M41 M41 M42 M
Total net income-21 M-17 M-7 M-2 M-936000.0-2 M-6 M-36 M-45 M-45 M
Total ordinary shares42 M42 M42 M42 M42 M42 M42 M42 M42 M42 M
Total revenues36 M44 M55 M73 M266 M384 M502 M699 M905 M1,109 M
TotalExpenses-10 M-12 M-9 M-6 M-305 M386 M507 M734 M948 M1,149 M
TotalRevenue116 M147 M188 M243 M304 M384 M502 M699 M905 M1,109 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