Home
About WST Self-Study
About Wall St. Training
Why Choose Us
Client List
Courses & Programs
Video Learning Platform
Free Video Clips!
WST Certification
Corporate Training
University Training
WST Resources
Contact
|
To download a PDF version of these detailed course descriptions, please click here.
|
|
|
|
|
|
Wall St. Training Course Descriptions
|
|
|
|
|
|
|
|
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.
| |
|
|
|
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!
|
|
|
|
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!
|
|
|
|
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
|
|
|
|
|
|
|