Archive | Ch 01 Financial statements RSS feed for this section

Join me for an AICPA Faculty Hour webinar on January 29, 2021: CPA Update & Excel Dashboards

Join Vikki Nunn, CPA, CITP, and me on Friday, January 29, from 2-3:30PM ET for a free webcast presented by the AICPA. Vikki and I are part of the CPA Evolution Core Curriculum team and during the first part of this webinar, we’ll provide an update on the status of the CPA Evolution Initiative and […]

Continue reading

New! Constructing an Interactive Excel Dashboard project for introductory financial accounting available

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

New! 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 reading

What information is provided in Chipotle’s basic financial statements?

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 reading

Accounting 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 reading

Create 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 reading

Data analytics project: Gross profit analysis for introductory financial accounting

This blog post contains a data analytics project that is suitable for introductory financial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned early in the course once the concept of gross profit is reviewed. Overview of project This project uses […]

Continue reading

What would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?

Canadian Solar (NASDAQ: CSIQ) and other solar panel manufacturers are facing a shortage of a key raw material used in the production of solar panels, polysilicon. Environmental regulators in China shut down several factories, triggering the shortage. The cost of polysilicon has risen by as much as 35% in the past several months. A kilogram […]

Continue reading

4 videos covering each of Facebook’s condensed and adapted financial statements

Recently, I created some videos about each of the four basic financial statements, using Facebook’s financial statements as the data source for the statements. I condensed and adapted each of Facebook’s financial statements into a shorter, more digestible length for the introductory accounting student. Here are the four videos and the related links: Video topic […]

Continue reading

Create 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 reading