Start Now!


Excel Questions

Google Sheet Solutions

Exam Preparation Tools to Assist in Achieve a Passing Score

CAS Exam 5: October 23, 2024 - October 30, 2024

The challenge: Achieving a passing score, as evidenced by the low effective pass ratios, shown below.

CAS Effective Pass Ratios:
  • Spring 2023:      49.5%
  • Fall 2022:          36.8%
  • Spring 2022:     40.6%
  • Fall 2021:           33.6%
  • Spring 2021:     50.9%

  • Comprehensive Study Materials in Spreadsheet Format

    Working questions in Excel is by far the best way to prepare for CAS Exam 5 now administered in Pearson VUE’s computer based testing environment.

    Download approximately 400 past CAS questions in Excel.

    • Work these questions and then work a duplicated set of the same questions.

    • Track your progress by entering the dates you first worked the question and when you did so for a second time.

    • Manage questions by flagging them as incomplete, finished, and needs review

    • Self score your work to gauge what you know and to identify knowledge gaps for additional review

    Access over 1200 solutions to past questions, over 350 Examiner Reports, and Learn How to Develop Full Credit Solutions.

    • Learn by studying instructional answers to fully comprehend the solution process

    • Review Examiner Reports to identify gaps in your knowledge and to sidestep common mistakes

    • Learn how to develop sufficient and efficient solutions to gain full credit, leaving ample time to review your answers on the exam.

    Solutions are view only. To view the Solutions in Google Sheets you must have a Gmail account. If you do not have one, the sign up process is simple.

    Click here to create a gmail account.

    Click the Free Preview button to download sample questions and solutions.

    Question Dashboard

    Section 1

    Each excel spreadsheet for a given chapter contains a dashboard identifying various aspects of past CAS questions.

    When choosing questions to work on, look to:

    • the number of points as a good indicator of the relative difficulty of the question. Begin with questions having a lower point value and then work on higher point level questions.

    • the question type (Q type) identifying whether the question tests purely computational concepts, short answer content, or both computation and short answer concepts.

    Question Dashboard

    Section 2

    Each question is duplicated, allowing you to answer, self-score and record the date you worked the question twice.

    • Doing so is critical to assessing your progress by evaluating the quality of your solutions over time.

    • Flag questions as Finished, Incomplete, or Needs Review to manage what you mastered, what you need to do, and what you need to review again.

    Question Layout

    Each question provides areas to answer, self-score and record the date you worked the question, twice.

    Your confidence and competence are significantly enhanced when you:

    • note areas for improvement in the spreadsheet after solving the question on a first attempt, and then

    • work the same question again, at a future point in time.

    Assess your progress by "toggling" between tabs (e.g. tab (1) and tab 1(2)) to compare your answers in terms of computational efficiency and or the quality of your short answer responses.

    Solutions Layout

    Shown to the right is an example of how we present solutions to past CAS questions.

    Solve 420 questions, study over 1200 solutions, and review the 350+ Examiner's Report comments and you'll be more than competent to answer future questions.

    Unique to out solution format are:
  • Instructional Solutions
  • Sufficient Solutions
  • Examiner’s Report Comments
  • Instructional Solutions

    To write sufficient and efficient solutions, you'll need to be adept at problem solving.

    Our instructional solutions contain the level of detail needed for you to solidify your understanding of the material.

    • To the right is an example of what you can expect to see in our spreadsheets for each past CAS computational type question.

    • Significant time was spent preparing thorough solutions, so that your need for video solutions, or asking an instructor to explain a solution is virtually eliminated.

    Sufficient Solutions

    Your ability to pass the exam will in large part be a function of how well you can succinctly and accurately answer questions.

    Compare the instructional solution above to the sufficient solution to the right.

    You know the material well when you can consistently develop solutions like the one to right on the exam.

    The keys to you developing answers like this begin by:

    • working questions multiple times

    • understanding the level of detail to incorporate in your solutions to multiple step problems, and

    • being mindful of previous examiner’s report commentary when developing your responses.

    Examiner's Reports

    Examiner's report commentary can be lengthy and is extremely beneficial in helping you to answer past and future questions.

    Examiner’s reports assist you in achieving a passing score in several ways:

    • Identifying gaps in your knowledge, so that you can sidestep common mistakes when answering questions a second time.

    • Providing you with insight into what concepts examiner’s were testing, so that you can quickly spot these concepts in future questions.

    • Assisting you with self-scoring. You will accurately measure your progress if you score your first attempt answers fairly, avoid mistakes you previously made in your first attempt, and then re-score your second attempt responses.

    Course curriculum

    1. 1
      • Preparing for Fall 2022 CAS Exam 5

    2. 2
    3. 3
      • Chapter 1 - Introduction - Questions ( in Excel)

      • Chapter 3 - Ratemaking Data - Questions ( in Excel)

      • Chapter 4 - Exposures - Questions ( in Excel)

      • Chapter 5 - Premium - Questions ( in Excel)

      • Chapter 6 - Losses and LAE - Questions ( in Excel)

      • Chapter 7 - Other Expenses and Profit - Questions ( in Excel)

      • Chapter 8 - Overall Indication - Questions ( in Excel)

      • Chapter 9 Questions ( in Excel)

      • ASOP 12 - Risk Classification - Questions (in Excel)

      • Chapter 10 - Multivariate Classification + App F Questions ( in Excel)

      • Chapter 11 - Special Classification - Questions ( in Excel)

      • Chapter 12 - Credibility - Questions ( in Excel)

      • Chapter 13 - Other Considerations - Questions ( in Excel)

      • Chapter 14 - Implementation - Questions ( in Excel)

      • Chapter 15 - Commercial Lines Rating Mechanisms - Questions ( in Excel)

      • Chapter 16 - Claims Made Ratemaking - Questions ( in Excel)

      • Appendix A - Auto Indication - Questions ( in Excel)

      • Appendix B - Homeowners Indication - Questions ( in Excel)

      • Appendix C - Medical Malpractice Indication - Questions ( in Excel)

    4. 4
      • Chapter 1 - Overview - Questions ( in Excel)

    5. 5
      • Chapter 3 - Understanding the Types of Data Used - Questions ( in Excel)

      • Chapter 5 - The Development Triangle - Questions ( in Excel)

      • Chapter 6 - Development Triangle as a Diagnostic Tool - Questions ( in Excel)

    6. 6
      • Chapter 7 - Development Technique - Questions ( in Excel)

      • Chapter 8 - Expected Claims Technique - Questions ( in Excel)

      • Chapter 9 - BF Technique -Questions ( in Excel)

      • Chapter 10 - Cape Cod Technique- Questions ( in Excel)

      • Chapter 11 - Frequency-Severity Techniques- Questions ( in Excel)

      • Chapter 12 - Case O/S Development Technique - Questions ( in Excel)

      • Chapter 13 - Berquist-Sherman Techniques - Questions ( in Excel)

      • Chapter 14 - Recoveries: Salvage & Subrogation and Reinsurance - Questions ( in Excel)

      • Chapter 15 - Evaluation of Techniques- Questions - Part 1 ( in Excel)

      • Chapter 15 - Evaluation of Techniques - Questions - Part 2 ( in Excel)

    7. 7
      • Chapter 16 - Estimating Unpaid Claim Adjustment Expenses - Questions ( in Excel)

      • Chapter 17 - Estimating Unpaid Unallocated Claim Adjustment Expenses - Questions ( in Excel)