Tag Archives: teaching accounting

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

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

7 Excel projects for your managerial accounting course

Ready or not, welcome to the fall semester! I thought I would repost this information as you are getting ready to kick off the new semester. If you teach managerial accounting, you may want to look at Dr. Karen Braun’s Excel projects for managerial accounting. She has created seven Excel projects on various topics in […]

Continue reading

When would AMC Theatres recognize revenue from its AMC Stubs A-List subscription service?

AMC Entertainment Holdings, Inc. (NYSE: AMC), also known as AMC Theatres, recently announced a $19.95 per month subscription service, AMC Stubs A-List, to compete with MoviePass. With the A-List program, subscribers can see up to three movies per week with few restrictions. The minimum commitment is three months, after which time the subscriber can cancel […]

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

Data analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set

As promised in my data analytics introductory financial accounting project blog post, here is the second data analytics project I have developed. This one covers budgeting and performance evaluation in introductory managerial accounting. Background After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as […]

Continue reading

Data analytics project: Transaction analysis for introductory financial accounting using the City of Somerville, MA, online checkbook data set

Data analytics is here! I have been working on some projects for the past few months to be able to incorporate data analytics into the introductory accounting classes. After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as the analytics tool since introductory accounting […]

Continue reading

How will Dropbox’s upcoming initial public offering of its stock impact its balance sheet?

Dropbox, Inc. has filed an SEC report, indicating that it plans to raise $500 million through its Initial Public Offering (IPO) sometime in 2018. It will be issuing common stock.  Dropbox was started in 2007 and is designed to allow people to have their files anywhere they are. There are over 500 million registered Dropbox […]

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

Will the costs of converting UPS trucks from diesel to electric be capitalized or expensed?

UPS is working with the New York State Energy Research and Development Authority to develop new technology that will allow UPS to convert its diesel-fueled delivery trucks to electric-fueled. UPS hopes to have a working model of the converted delivery truck ready sometime in 2018. The plan is to convert 1,500 of the company’s delivery […]

Continue reading