Student Materials

Welcome to the Student Materials section.

PRACTICE INTERVIEW QUESTIONS

Before you start . . . please keep in mind that many of your interviews will be behavioral (rather than technical), where the interviewers wish to assess “who you are.” Sometimes they’ll even say, “Tell me a story; anything you’d like,” or, “Tell me a joke.” So, you might want to have a couple of these in mind. Also, don’t be surprised if you are occasionally thrown a curve ball, even if you are interviewing for an accounting or finance position. For instance, take a look at this article that features Google: “How to Ace A Google Interview” (from the Wall Street Journal, 12/24/11).

Below are a wide array of possible questions you may encounter on a job interview for an accounting or finance position.

TAO_InterviewPrepQuestions

TIME VALUE PRACTICE

For academic, professional, and personal purposes, one of the more useful skills is being able to solve time value problems. We provide numerous exercises, from basic to advanced, in an Excel spreadsheet below (AccountingOasis_TimeValueDrills_Excel_HP12c_HP17BII+.xlsx).  We also provide, in a separate spreadsheet, the solutions to all the exercises.

Further, in the spreadsheets, we illustrate keystrokes for two popular business calculators: HP12C Platinum and HP17BII+.

AccountingOasis_TimeValueDrills_Excel_HP12c_HP17BII+.xlsx

AccountingOasis_TimeValueDrills_Excel_HP12c_HP17BII+_SOLUTIONS.xlsx

You might also benefit from the below short video that walks you through setting up a calculator, specifically the HP17BII+.   The steps for the calculator set up are also specified in the spreadsheets above.

Below is a spreadsheet for practicing time value skills on some simple bonds and notes problems.  An accompanying spreadsheet with solutions is also provided.

AccountingOasis_Bonds_Notes_Drills.xlsx

AccountingOasis_Bonds_Notes_Drills_Solutions.xlsx

Below are short videos (named Problem1 . . . . Problem7) that illustrate how to set up  amortization tables in Excel for the 7 problems in the above spreadsheets.

Problem 1:

Problem 2:

Problem 3:

Problem 4:

Problem 5:

Problem 6:

Problem 7:

JOURNAL ENTRY PRACTICE

Fifty + ½ Journal Entries

In the below spreadsheet, we provide space for both conventional journal entries (debits and credits), as well as intuitive journal entries (+ and – in the accounting equation). Suggested solutions are also provided in the corresponding solutions file. Fifty + ½ Journal Entries are intended for beginners, or for those seeking a review.

Some of the journal entries require exposure to relevant topics. Relevant chapters in Fundamental of Financial Accounting & Analysis (aka, The Green Book) are referenced for certain entries where you may need the extra background to do the entry.

AccountingOasis_FiftyandOne-HalfJournalEntries.xlsx

AccountingOasis_FiftyandOne-HalfJournalEntriesSOLUTIONS.xlsx

101 Journal Entries

This document “doubles down” on journal entry practice. The accounting concepts covered are both basic and more advanced. Therefore, in order to do the all of the journal entries, exposure to higher level topics may be necessary. To guide you, references are occasionally made to the relevant chapters in The Green Book. As above, both intuitive and conventional journal entries are used. Suggested solutions are provided in the corresponding solutions file.

AccountingOasis_101JournalEntries.xlsx

AccountingOasis_101JournalEntriesSOLUTIONS.xlsx

Monster Problem

This problem is long and tedious. It is for the “hammerheads” who want a good preparation and review for Intermediate Accounting. The Monster Problem, along with the 101 Journal Entries (above) will serve as a comprehensive review and preparation for higher level courses.

The Monster Problem includes not only journalizing transactions, but also posting the entries, and generating a full set of financial statements. The indirect method is used for the Statement of Cash Flows. Only conventional journal entries are used. Suggested solutions are provided in the corresponding solutions file.

AccountingOasis_MonsterProblem.xlsx

AccountingOasis_MonsterProblemSOLUTIONS.xlsx