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 readingNew! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available
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
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 readingAccounting Case Template tool available to build an introductory financial accounting case assignment
Again, as we start a new semester, I wanted to point out the availability of a tool that may be of use in teaching introductory financial accounting. The Accounting Case Template (ACT) is a web tool I designed that allows instructors to quickly build an introductory financial accounting case assignment. A variety of options are provided from […]
Continue readingCreate Customized Financial Accounting Case Assignments with the Accounting Case Template
Again, as we start the fall semester, I wanted to point out the availability of a tool that may be of use in teaching introductory financial accounting. The Accounting Case Template (ACT) is a web tool I designed that allows instructors to quickly build an introductory financial accounting case assignment. A variety of options are provided from […]
Continue readingA recap of the Excel data analytics project blog posts
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. Here goes: Project 1: Transaction analysis for Introductory financial accounting using the City of Somerville, MA, online checkbook data set (link) Project 2: Budgeting and […]
Continue readingHow 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 readingCreate Customized Financial Accounting Case Assignments with the Accounting Case Template
The Accounting Case Template (ACT) is a web tool I designed that allows instructors to quickly build an introductory financial accounting case assignment. A variety of options are provided from which the instructor can choose, allowing the instructor to quickly build a case assignment customized for his/her specific course. It takes about two minutes to […]
Continue readingDoes Tesla sell its cars FOB destination or FOB shipping point?
The following quote is from a recent Tesla news release (“Tesla Q3 2017 Vehicle Deliveries and Production,” October 2, 2017): “In addition to Q3 deliveries, about 4,820 Model S and X vehicles were in transit to customers at the end of the quarter. These will be counted as deliveries in Q4 2017.” (Note: “Q3” refers […]
Continue readingHow does John Deere account for the loans it makes to farmers for the purchase of tractors and crop supplies?
Deere & Company (NYSE: DE), otherwise known as John Deere, builds tractors and other farm equipment. For the past several years, it has been difficult for farmers to get bank loans for planting crops and for purchasing large, expensive farm equipment. Deere has stepped in to fill the gap in agricultural financing – Deere makes […]
Continue reading