ABSTRACT
This case simulates analyses students are likely to conduct early in their careers. The case includes scenarios for two different hypothetical clients and reinforces the theory of revenue and expense recognition while requiring students to utilize Excel for analytics. The case is geared toward upper-level undergraduate accounting students, in which they will analyze transaction data containing misapplications of GAAP, reconcile general ledger account balances, and recommend adjusting journal entries while building Microsoft Excel skills. Work relating to the first client serves as refresher, both in using Excel and to fundamental financial accounting principles. The requirements for the second client build on those skills and offer more advanced conceptual challenges, require students to reference the Accounting Standards Codification, and use more complex Excel functions. Key Excel functionality covered in this practical application includes DATE (YEAR, MONTH, DAY), IF, IFS, ISNUMBER, SEARCH, ROUND, SUM, SUMIF, SUMIFS, and VLOOKUP.
Data Availability: Data available upon request.
