Slide 1: Quarterly Earnings Supplement Q2 2024
Quarterly Earnings Supplement Q2 2024
Slide 2: Total Subscription Revenue Growth
2024 $208.6 $201.1 $191.5 $182.9 2023 $173.3 $165.2 $158.6 $152.4 2022 $145.8 $139.8 $134.1 $127.1 2021 Miscellaneous Revenue $120.4 Total Subscription Revenue Growth $113.3 $106.4 $99.4 2020 $92.5 $89.5 $86.6 $82.6 2019 $77.7 $74.2 Revenue from New Subscription Pets $70.9 $67.4 2018 $63.9 $61.5 $59
Slide 3: Subscription Revenue By Cohort
Subscription Revenue By Cohort 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
Slide 4: Product Offerings
Product Offerings Other Business Subscription Segment Segment Other Subscription Other Subscription Trupanion Core Products Pets Best Products North America North America International Veteran Affairs PetExpert* Service Dog US PHI Direct (Czechia, Slovakia, Belgium, Poland) Program Legacy Worksite F
Slide 5: Estimated Internal Rates of Return (Trupanion Core)
Estimated Internal Rates of Return (Trupanion Core) • 53,100 gross new pets • $72.47 new pet ARPU • 11.6% per pet adjusted operating margin (AOM)* • 71.4 month average subscriber life* • $602 pet lifetime value (LVP)* • $244 pet acquisition cost (PAC); $14.0 million (89%) total PAC spend • 39% Inter
Slide 6: Estimated Internal Rates of Return (Other North American Subscription)
Estimated Internal Rates of Return (Other North American Subscription) • 7,600 gross new pets • $41.44 new pet ARPU • 19.2 month average subscriber life* • Per pet AOM & negative IRR reflect products not at operating scale • $135 PAC; $1.0 million (7%) total PAC spend *Based on data since product la
Slide 7: International Metrics
International Metrics • 3,600 gross new pets • $800K (4%) of total PAC spend • International policies are currently underwritten by third parties and therefore, per pet subscription metrics exclude these policies
Slide 8: Estimated Internal Rates of Return by P&L
Estimated Internal Rates of Return by P&L Q2 2024 Q2 2024 Q2 2024 Q2 2024 Other North Managing General Total Sub Segment Trupanion Core American Products Agent Products Gross new pets 64,300 53,100 7,600 3,600 Quarterly new pet ARPU $68.59 $72.47 $41.44 Not included Quarterly pet acquisition cost $2
Slide 9: Free Cash Flow
Free Cash Flow The following table reflects the reconciliation of cash provided by operating activities to free cash flow (in thousands): Three Months Ended June 30, 2024 2023 Net cash provided by (used in) operating activities $6,855 $(3,405) Purchases of property, equipment, and internal–use softw
Slide 10: Outlook
Outlook Q3 2024 Full Year 2024 Revenue $319M-$324M $1.263B-$1.279B Subscription revenue $217M-$219M $850M-$858M Adjusted operating income $27M-$29M $108M-$115M CAD FX Rate 73% 73%
Slide 11: Q&A
Q&A e > trwpanion Medical insurance for the life of your pet.
Slide 12: Appendix
Appendix trwpanion
Slide 13: Estimated Internal Rates of Return (New Methodology)
Estimated Internal Rates of Return (New Methodology) Q2 2024 Quarterly average revenue per new pet $68.59 Estimated trailing 3-year profit per pet per month (11.5% $7.92 X 68.5 months = $543 (Lifetime value of a pet, including fixed expenses) margin) Year 0 1 2 3 4 5 6 Months* 6 12 12 12 12 12 2.5 6
Slide 14: Estimated Internal Rates of Return (Prior Methodology)
Estimated Internal Rates of Return (Prior Methodology) Year 0 1 2 3 4 5 Months* 6 12 12 12 12 6.2 60.2 Estimated profit per pet per month $7 $7 $7 $7 $7 $7 Estimated profit per pet $45 $90 $90 $90 $90 $46 $450 Capital charge** $(4) $(8) $(8) $(8) $(8) $(4) Quarterly pet acquisition cost (PAC) $(231)
Slide 15: Unit Economics – Single Average Subscription Pet (Prior Methodology)
Unit Economics1 – Single Average Subscription Pet (Prior Methodology) Monthly ARPU $68.64 Paying veterinary invoices (51.20) Variable expenses (providing 24/7 fast service) (6.56) Fixed expenses (G&A + IT) (3.41) Cash generated per month, prior to capital charge $7.47 x 60.2 months2 = $450 LVP, incl
Slide 16: Definitions – New Methodology
Definitions – New Methodology • Average revenue per new pet. Average revenue per new pet is calculated from total premium for all new pets enrolled for the period divided by the total number of new subscription pet months in the period. Total new subscription pet months in a period represents the su
Slide 17: Definitions – Prior Methodology
Definitions – Prior Methodology • Total subscription pets enrolled. Total subscription pets enrolled reflects the number of pets in active memberships at the end of each period presented. We monitor total subscription pets enrolled because it provides an indication of the growth of our subscription