######### #########
#########
#########
#########
#########
#########
#########
#########
#########
#########
#########
#########
######### #########
#########
#########
#########
######### #########
Paul Margus, FSA, MAAA


Published Works for Practicing Actuaries:

Table It in Microsoft Excel Society of Actuaries: CompAct Electronic Newsletter, No. 45, Oct 2012).

  • Organize your actuarial data into Microsoft Excel Tables!
  • Spreadsheet Techniques: filtering, sorting, totals.
  • VBA Programming: selective sequential processing.
  • Practical examples of class modules.
  • Data Retrieval using meaningful field names. No more numerical offsets!
  • An accompanying Microsoft Excel Macro-Enabled Workbook demonstrates the concepts.

The Lowly Loss Ratio Society of Actuaries: The Financial Reporter, No. 71, Dec 2007, page 23).

  • Rigorous definition of Loss Ratios on Level Premium plans.
  • How Loss Ratios tie mathematically to Gain/Loss Analysis.
  • What about persistency?
  • The Premium Dollar Pie: Loss Ratios, Expense Ratios, and Profit Margin.

Generalized Frasier Claim Rates under Survivorship Life Insurance Policies Society of Actuaries: North American Actuarial Journal, Vol. 6, No. 2, April 2002, page 76).

  • Advanced probability theory reduced to dollars and cents.
  • Two rude surprises: Lapse Antiselection and Contagion.

Some Observations on Fair Value Accounting (Society of Actuaries: The Financial Reporter, No. 48, Dec 2001, page 5).

  • How to determine the Market Value of Liabilities, using yield curves derived from your company's investment portfolio.
 
 
#########
#########
#########
Search MargusConsulting Site Map © 2009-2013 Paul Margus, FSA, MAAA Validated by HTML Validator (based on Tidy)
#########
######### ######### ######### ######### ######### #########