LOGIN   |   ORDER NOW   |   FREE TRIAL  
Wall St. Training Course Descriptions
Sample Video Clips   
INSURANCE FINANCIAL MODELING Package: $750 (Save 25%)
Insurance-specific financial modeling and analysis with insurance primer (more)
Overview of Courses
Insurance companies, similar to banks, play by a different set of accounting rules in which the normal approach of building financial models don't apply (such as revenue growth, COGS and SG&A, % of revenue, BS and days outstanding working capital). When it comes to balance sheet based companies, it’s a whole other world out there, so strap in and get ready! But don’t worry, we'll take it easy with a detailed insurance industry primer and overview to familiarize ourselves with the new terminology and then tee you up methodically to before diving into the complex stuff.
Insurance Industry Primer ($250)

Course Goals & Overview:
Balance sheet based companies, such as insurance companies, play by different rules and methodologies based on the unique nature of their business. Focus is placed on our Insurance Industry primer which dives deep into an insurance company’s unique financial statement terminology and drivers. Distinguish between P&C (Property & Casulaty) and L&H (Life & Health) insurance companies. Comprehend all the major players along the insurance spectrum from retail to wholesale brokers, to MGAs and MGUs and captive carriers and much more. Understand the different types of insurance, reinsurance and their financial statement impact. On the Income Statement, differentiate between the different types of premiums (direct, ceded, net, written, earned); comprehend loss triangles and the main differences between statutory vs GAAP accounting. On the Balance Sheet, understand key assets line items (premiums receivable, reinsurance recoverable, prepaid reinsurance premiums) as well as the liabilities (loss & lae reserve, unearned premium reserve). Understand insurance valuation parameters: key insurance multiples (PE, book value, premium/surplus).

Course Sections:
Insurance Industry Overview

  • Types of Insurance: Property & Casualty vs Life & Health
  • Insurance industry players and their functions, roles and value-add
  • Modern insurance industry structure
  • Reinsurance and retrocession: types (quota-share vs. XOL) and their impact on financials

    Insurance Financial Statement Terminology & Drivers
  • IS: Premiums: Direct vs Ceded vs. Net and Written vs. Earned vs. UEPR
  • IS: Losses Incurred and LAE Incurred (ALAE vs ULAE) and Commissions vs. DAC
  • Statutory vs GAAP Net Income – main differences
  • BS Assets: Premiums Receivable, Reinsurance Recoverable, Prepaid Reinsurance Premiums
  • BS Liabilities: Loss & LAE Reserve, Unearned Premium Reserve
  • Valuation Parameters: key insurance multiples (PE, Book Value, Premium/Surplus)

    Prerequisites:
  • Accounting & Financial Statements Integration
  • Corporate Valuation Methodologies
  • Basic Financial Modeling

    Video Length / Estimated Total Course Time:
    2.5 hours / 4 hours

    Individual Course Price:
  • $250
  • Click here to register now!

  • Basic Insurance Company Financial Modeling ($250)

    Course Goals & Overview:
    Build a basic, streamlined insurance company financial model that builds upon the insurance financial statements terminology in our Insurance Industry Primer course. Before diving deep into the complex nuances of our Advanced Insurance Company Financial Model, really solidify your understanding of the major items on an insurance company’s Income Statement and Balance Sheet. Take the time to further immerse yourself with understanding insurance.

    Learning Objectives:

  • Project written and earned premiums and unearned premium reserve
  • Calculate Loss & LAE and reserves based on a simple two-year incurred/paid logic
  • Construct basic Income Statement, distinguishing between Underwriting Income and GAAP
  • Construct simplified Balance Sheet – does not incorporate all major GAAP “grossed up” line items
  • Utilize short cash flow sweep to balance the mini-model
  • Perform quick Statutory Adjustment from GAAP financials

    Prerequisites:
  • Accounting & Financial Statements Integration
  • Corporate Valuation Methodologies
  • Basic Financial Modeling
  • Insurance Industry Primer

    Video Length / Estimated Total Course Time:
    1.5 hours / 3 hours

    Individual Course Price:
  • $250
  • Click here to register now!

  • Advanced Insurance Company Financial Modeling ($750)

    Course Goals & Overview:
    Build a fully integrated, scalable, new insurance company model including detailed build-up by line of business from Gross Written Premiums to Net Premiums down to Underwriting Income. Consolidate the lines of business performance into a GAAP Income Statement with statutory adjustments. Integrate income statement projections with a self-balancing balance sheet, an automated cash flow statement and the balancing cash flow sweep schedule. Learning objectives include: build an integrated set of financials, including LOB, income statement, balance sheet & cash flow; project direct, ceded and net premiums and underwriting income based on assumed loss triangles; consolidate multiple lines of businesses, calculate GAAP and Stat Net Income with Tax Schedule; project self-balancing balance sheet including items such as premiums receivable and recoverables

    Course Sections:
    Line of Business Breakdown:

  • Project gross written and earned premiums, from direct down to ceded and net
  • Incorporate fundamentals drivers of premiums including premiums growth and rate changes
  • Calculate unearned premium reserve and flow that back into larger financial model
  • Calculate Loss & LAE and reserves – construct critical paid and reserve loss triangles based on payout patterns and different “tail” assumptions
  • Estimate ceded quota share and XOL amounts, which results in the “grossed up” Balance Sheet
  • Generate net premiums, losses, commission expense and underwriting income
  • Consolidate multiple lines of business into Consolidating Income Statement

    Income Statement:
  • Calculate all revenue items including various top-line premiums and investment income
  • Calculate total expenses including underwriting expenses and other relevant expenses
  • Tax schedule to properly adjust for deferred acquisition costs (DAC) and any NOLs
  • Adjust from GAAP Net Income to estimated Statutory Net Income

    Balance Sheet:
  • Project cash & invested assets balances, which is the ultimate balancer for insurance companies
  • Project premiums receivable, reinsurance recoverables and other relevant insurance assets
  • Derive loss reserves, unearned premium reserves, and other relevant insurance liabilities
  • Learn how to cast a proper GAAP Balance Sheet based on these "grossed up" balances
  • Project shareholders’ equity account including APIC, retained earnings, etc

    Cash Flow Statement and Sweep:
  • Calculate CFO (including working capital), CFI and CFF
  • Build cash flow sweep to capture any shortfalls / build-up in cash to balance the entire model
  • Build interest schedule to fully integrate the model
  • What are circular references, why should they be avoided and how to get around circular references

    Internal Rate of Return (IRR):
  • Project returns to financial sponsor / investor based on financial model

    Prerequisites:
  • Accounting & Financial Statements Integration
  • Corporate Valuation Methodologies
  • Basic Financial Modeling
  • Insurance Industry Primer
  • Basic Insurance Company Financial Modeling

    Video Length / Estimated Total Course Time:
    5 hours / 9 hours

    Individual Course Price:
  • $750
  • Click here to register now!

  •     Real Estate Development Modeling

     Jump to:
     Core Modules
  • Accounting Bootcamp
  • Package 1: Basic & Fundamental Concepts
  • Package 2: Core Fundamental Concepts
  • Package 3: Advanced Financial Modeling
  • Package 4: Valuation Modeling Topics
  • Package 5: Merger Modeling Topics
  • Package 6: Leveraged Buyouts (LBOs)
  • Technical Applications - Excel
  • Overview of Financial Mkts & Exhibits

  •  Advanced & Industry Modules
  • Private Company Valuation
  • Super-Complex M&A LBO Modeling
  • Distressed Modeling
  • Bank Financial Modeling
  • Insurance Financial Modeling
  • Real Estate Development Modeling
  • REIT Financial Modeling
  • Buy-Side Series




  • 68 South Service Road, Suite 100, Melville, NY 11747 USA
    Office: +1 (212) 537-6631     Toll-Free: +1 (877) 837-9755    Fax: +1 (212) 656-1221
    Email: Click here to contact us

    © Wall St. Training. All rights reserved.