Are you interested in data cleaning and visualization? Do your students use Google Sheets? Want a ready-made project for your class that uses Google Sheets for data cleaning and visualization? I have developed a case that is suitable for introductory accounting that uses just Google Sheets – and I provide step-by-step tutorial videos, making it […]
Continue reading
Archive | Financial accounting RSS feed for this section
A financial statement analysis mini-dashboard for a quick data analytics exercise
April 28, 2022 
2 Comments
Looking for a quick data analytics exercise for financial statement analysis in an introductory accounting class? You can give your students the link for this financial statement analysis dashboard and then ask a series of questions. There is no software for students to install; the dashboard is hosted on Tableau Public and can be accessed […]
Continue readingHow does Amazon’s stock buyback impact its earnings per share and balance sheet?
April 19, 2022 4 Comments
In March 2022, Amazon’s board of directors authorized it to buy back up to $10 billion of its stock. The stock buyback will take place over a multi-year period. Amazon may not buy back the full $10 billion of its stock; the board’s authorization is simply the maximum amount of stock that can be repurchased. […]
Continue readingHow does Nordstrom’s dividend announcement impact its balance sheet?
April 12, 2022 0 Comments
Nordstrom, Inc., is a luxury department store chain headquartered in Seattle, Washington. It was founded in 1901 as a shoe store. It would begin selling clothes more than sixty years later in 1967. Its stock ticker symbol, JWN, represents the initials of Nordstrom’s founder, John W. Nordstrom. Nordstrom had a history of declaring dividends regularly […]
Continue readingHow will Chipotle recognize the costs of Chippy, its tortilla-chip-making robot?
April 5, 2022 2 Comments
Chipotle is currently testing Chippy, a robot that makes tortilla chips. Chippy makes the chips less than perfect so that they appear to be made by a human. Customers are used to finding a chip with a little more salt or a little extra lime, so Chippy is making those subtle variations in the chips. […]
Continue readingHow will the $2 billion bond issuance by the University of Michigan impact its balance sheet?
March 30, 2022 2 Comments
The University of Michigan issued $2 billion in bonds in March 2022. The proceeds from these bonds will be used to finance construction and renovation projects on the campus. $1.2 billion was issued as century bonds, which must be repaid in 100 years. This century bond issuance is the largest century issuance in the higher […]
Continue readingHow does Amazon’s 20-for-1 stock split impact its stockholders’ equity?
March 28, 2022 0 Comments
Amazon announced a 20-for-1 stock split in March 2022. This stock split was its first stock split in over twenty years. On the day that Amazon announced its stock split, one share of its stock was selling for $2,785.58. The stock split will occur at the close of business on June 3, 2022. The stock […]
Continue readingNew! 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 readingWhat costs would the Stellar Pizza robotic pizza restaurant capitalize or expense?
January 11, 2022 2 Comments
Stellar Pizza has a pizza-making robotic machine that was built by three former SpaceX engineers. More than 23 former SpaceX employees work at Stellar Pizza. The pizza-making robot can produce a pizza every 45 seconds. A pizza can be customized, baked, and topped in less than five minutes by the robotic machine. Stellar Pizza will […]
Continue readingHow will Texas Instruments account for the cost of its new semiconductor wafer plant?
December 7, 2021 0 Comments
Texas Instruments Inc. (NASDAQ:TXN) is expanding its chip manufacturing capacity. It announced recently that it will begin construction in 2022 on its new plant for manufacturing 300-millimeter semiconductor wafers. Semiconductor wafers are used in a variety of products, particularly in industrial and automotive electronics. Texas Instruments (TI) acquired the land for the plant in 2021. […]
Continue reading
Accounting in the Headlines 