RELIABLE AUTO INSURANCE: AUDITING PREMIUMS USING EXCEL

Authors

  • Nicole R. McCoy North Carolina A&T State University
  • Aisha G. Meeks Morehouse College

Keywords:

accounting, auditing

Abstract

Sydney Alston, an experienced staff auditor at MinorMars LLP, is upcoming up for promotion to senior auditor.  After finishing his assigned audit procedures on the Reliable Auto Insurance engagement, Sydney is asked by his audit manager to performed some simple data analytics regarding Reliable’s earned and unearned premium figures.  Sydney received the data file, performed the preliminary data clean-up of the premium data, and recalculates earned premium.  Once completes these audit step, Sydney realized his observations and audit conclusion may not aligned with his audit manger’s expectations.  Sydney needs to evaluate the effects of his observations in context the overall audit engagement, established audit strategy and professional responsibilities.

Downloads

Published

2024-01-27

Issue

Section

Cases