The Ford Motor Company (NYSE: F) is selling an electric version of its F-150 pickup truck, the F-150 Lightning electric truck. Ford cannot keep up with demand; it has taken orders for its entire 2022 production capacity and has closed orders for the 2022 model. Ford has not yet begun taking reservations for the 2023 […]
Continue reading
Archive | Ch 05 Receivables and revenues RSS feed for this section
New! Beginning Data Cleaning (ETL) & Analytics Project for Excel: KAT Concession Supply
March 25, 2022 
0 Comments
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 readingHow 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 reading
Accounting in the Headlines 