Tag Archives: transaction analysis

New! Google Sheets data analytics case for introductory accounting available – City of Magicville

This new case is designed to be completed using Google Sheets for an introductory financial accounting class. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the second one I have created that uses Google Sheets as the software (see this […]

Continue reading

Summary of seven data analytics projects for introductory accounting

There has been a lot of interest in the data analytics cases for introductory accounting that have been posted on this blog. I am providing a summary of the seven data analytics cases and related links in the table below to make it more convenient to see, at a glance, what projects are available and […]

Continue reading

New data analytics case for introductory financial accounting available – KAT Insurance!

The demand for business graduates with data analytics skills has exploded, while the tools and techniques are continuing to evolve and change at a rapid pace. Three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) have joined forces to develop a case to introduce data analytics in the introductory financial […]

Continue reading

Recap of all data analytics projects available

Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. (Heads up: I will be posting a new managerial accounting data analytics case within the next week too!) Here goes: Project 1: Transaction analysis for […]

Continue reading

Data analytics project: Transaction analysis for introductory financial accounting using the City of Somerville, MA, online checkbook data set

Data analytics is here! I have been working on some projects for the past few months to be able to incorporate data analytics into the introductory accounting classes. After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as the analytics tool since introductory accounting […]

Continue reading

How will the reservation, purchase agreement, and the delivery of a Model 3 impact Tesla’s financial statements?

Since 2016, Tesla has been accepting reservations for its Model 3 car, which is a mid-size all-electric four-door sedan. The long-range battery Model 3 (310 miles on a single charge) starts at $50,000 while the standard range battery Model 3 (220 miles) starts at $35,000. Production cannot keep up with demand for this model. Tesla […]

Continue reading

Wait! Why is the bank debiting my account to decrease it? Isn’t that backwards?

Debit-credit rules are challenging for students. Students’ exposure to debits-credits when they arrive in introductory accounting may be limited to what they see on their bank statements – and those debits-credits are seemingly backwards. I recorded a short video (2:36 min) to explain why debits and credits seem to be backwards on bank statements. You […]

Continue reading

A video of five example transactions at Cedar Point Amusement Park

For this blog post, I have created a video in which I walk through the journal entries for five hypothetical transactions at Cedar Point Amusement Park. This video is appropriate for the beginning of an introductory financial accounting course. The transactions covered include: Sell admission to the park; purchase merchandise inventory for the gift shop; […]

Continue reading

A step-by-step video on how to construct a journal entry

For this blog post, I have created a video that is a step-by-step guide to constructing a journal entry. The example that I am using in the video to illustrate the journal entry steps is that of Apple selling an iPhone at one of its stores for $1,000 cash. You can view the video (5:35 […]

Continue reading

What is the impact on Netflix’s assets, liabilities, and equity from its new credit line?

In July 2017, Netflix, Inc., (NASDAQ: NFLX) obtained a new credit line for $500 million through five lenders. This credit line means that Netflix will be able to borrow as it needs cash to fund its operations. According to Netflix’s regulatory filing, it plans to use the funds for operations and general corporate needs. The […]

Continue reading