In this new case, students build an interactive Excel dashboard to analyze sales transactions. Students will view tutorial videos for each of the five sections in the project and will use their dashboard to answer the case questions. The case will take students, on average, 60 – 90 minutes to complete. The Teaching Notes for […]
Continue reading
Archive by Author
New! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available
January 12, 2021 
5 Comments
This new case has students use a prebuilt interactive Excel dashboard to analyze sales transactions. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, on average, 15 – 20 minutes […]
Continue readingNew! Google Sheets data analytics case for introductory accounting available – City of Magicville
January 11, 2021 2 Comments
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 readingWhat information is provided in Chipotle’s basic financial statements?
January 4, 2021 2 Comments
Chipotle Mexican Grill, Inc. (NYSE: CGM) is a publicly held corporation with more than $5 billion in assets. To follow are Chipotle’s four basic financial statements for its most recent year, the year ending December 31, 2019. Please note that all statements have been adapted and condensed for educational use and should not be used […]
Continue readingHow does Kellogg’s dividend announcement impact its financial statements?
November 9, 2020 2 Comments
On October 23, 2020, the Kellogg Company (brands include Kellogg’s, Pringles, Eggo, Cheez-It, and many others) made the following dividend announcement: Kellogg Company (NYSE: K) today announced that its Board of Directors declared a dividend of $0.57 per share on the common stock of the Company, payable on December 15, 2020, to shareowners of record […]
Continue readingNew! Google Sheets data analytics case for introductory financial accounting available – Kent Cabinet Hardware
November 4, 2020 0 Comments
This new case is designed to be completed using Google Sheets. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the first one I have created that uses Google Sheets as the software. Read on for details…. Data set background This […]
Continue readingWhat are the relevant costs for AMC’s decision to offer to rent its theatres for $99?
November 2, 2020 0 Comments
The pandemic has greatly impacted movie theater operations. Some theater locations have been forced to close. Major film releases have been delayed or moved to a streaming platform. Moviegoers have been reluctant to share indoor space with strangers. All those factors have contributed to a challenging year for movie theaters. In response to the pandemic, […]
Continue readingHow would the length of the Bespoken Spirits operating cycle compare to the length of the Jack Daniel Distillery operating cycle?
October 26, 2020 0 Comments
Whiskey is an alcoholic beverage that takes, on average, three to fifteen years to mature before it is ready for consumption. Typically, whiskey matures in oak barrels – that process helps to give each whiskey type its unique aroma, color, and taste. The Jack Daniel Distillery, for example, ages its Jack Daniel’s whiskeys in oak […]
Continue readingAICPA webinar on how to introduce data analytics in your course when your students have Chromebooks
October 21, 2020 3 Comments
Join Kimberly Swanson Church, PhD, Missouri State University, and me as we walk through how to introduce data analytics in your introductory accounting courses using Google Sheets in an AICPA webinar on Wednesday, November 4, 2020, from 4 – 5 pm Eastern. The discussion will include what data analytics is, the impact of analytics on […]
Continue readingHow will the change in Chipotle’s sales mix due to the pandemic impact Chipotle’s profits?
October 19, 2020 0 Comments
Digital sales for Chipotle Mexican Grill Inc. (NYSE: CMG) grew 216.3% in the second quarter of 2020, accounting for 60.7% of sales for the quarter, as the effect of the pandemic for the entire quarter sent customers to online options rather than dining in. Many digital customers opted for delivery, viewing it as a safer […]
Continue reading