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
Tag Archives: teaching accounting
Create Customized Financial Accounting Case Assignments with the Accounting Case Template
August 20, 2018 
3 Comments
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
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 reading7 Excel projects for your managerial accounting course
August 19, 2018 0 Comments
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 readingWhen would AMC Theatres recognize revenue from its AMC Stubs A-List subscription service?
August 14, 2018 0 Comments
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 readingData analytics project: Gross profit analysis for introductory financial accounting
August 3, 2018 4 Comments
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 readingData analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set
May 10, 2018 4 Comments
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 readingData analytics project: Transaction analysis for introductory financial accounting using the City of Somerville, MA, online checkbook data set
May 4, 2018 4 Comments
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 readingHow will Dropbox’s upcoming initial public offering of its stock impact its balance sheet?
March 27, 2018 2 Comments
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 readingWhat would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?
March 23, 2018 0 Comments
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 readingWill the costs of converting UPS trucks from diesel to electric be capitalized or expensed?
March 20, 2018 0 Comments
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