Just posted this project on the other blog I co-author, Accounting Is Analytics. I am really excited about this project – it introduces accounting students to basic data cleaning and analytics concepts using Excel. Read on for how to request this first beginning level project that uses Excel for data cleaning and analytics. A key […]
Continue reading
Archive | Ch 05 Receivables and revenues RSS feed for this section
How will the issuance of common stock affect Casper’s current and debt ratios?
November 9, 2021 
0 Comments
Casper Sleep Inc. (NYSE: CSPR) is a mattress company launched in 2014 that has a unique direct-to-consumer business model. It sells its mattresses online and retail showrooms. Its mattresses are made from a variety of foams and have been popular with consumers. In November 2021, Casper announced that it is seeking to raise $50 million […]
Continue readingNew! Constructing an Interactive Excel Dashboard project for introductory financial accounting available
January 13, 2021 0 Comments
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
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 readingAccounting Case Template tool available to build an introductory financial accounting case assignment
January 3, 2019 3 Comments
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 reading10-K, Ch 01 Financial statements, Ch 02 Transaction analysis, Ch 03 Accrual income, Ch 04 Internal control and cash, Ch 05 Receivables and revenues, Ch 06 Inventory & COGS, Ch 07 PP&E and Intangibles, Ch 08 Current liabilities, Ch 09 Long-term liabilities, Ch 10 Stockholders' equity, Ch 11 Statement of cash flows, Ch 12 Financial statement analysis, Financial accounting
Create Customized Financial Accounting Case Assignments with the Accounting Case Template
August 20, 2018 3 Comments
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 readingCh 01 Financial statements, Ch 02 Transaction analysis, Ch 03 Accrual income, Ch 04 Internal control and cash, Ch 05 Receivables and revenues, Ch 06 Inventory & COGS, Ch 07 PP&E and Intangibles, Ch 08 Current liabilities, Ch 09 Long-term liabilities, Ch 10 Stockholders' equity, Ch 11 Statement of cash flows, Ch 12 Financial statement analysis, Financial accounting
A recap of the Excel data analytics project blog posts
August 19, 2018 0 Comments
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?
February 6, 2018 2 Comments
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
January 10, 2018 1 Comment
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 reading10-K, Ch 01 Financial statements, Ch 02 Transaction analysis, Ch 03 Accrual income, Ch 04 Internal control and cash, Ch 05 Receivables and revenues, Ch 06 Inventory & COGS, Ch 07 PP&E and Intangibles, Ch 08 Current liabilities, Ch 09 Long-term liabilities, Ch 10 Stockholders' equity, Ch 11 Statement of cash flows, Ch 12 Financial statement analysis, Financial accounting
Accounting in the Headlines 