|
I recorded this video to discuss how differences in depreciation expense for GAAP vs. the depreciation deduction on the tax return can lead to deferred tax liabilities. These differences arise from…
|
|
In this video, I work with a student who is having problems with duplicate observations in SAS. I use SQL to investigate the source of the problem.
|
|
Sloan 1996 Tutorial part 2, replicating the main return tests. Note, this code does not merge delisting returns or calculate the Mishkin test, or calculate alphas. The SAS code used in the tutorial…
|
|
-- This tutorial shows how you can use SQLite Studio using data exported from Mint.com, -- a personal financial planning tool that aggregates financial data from various accounts. -- I include as…
|
|
This tutorial goes over the tutorial in this Google Doc: https://docs.google.com/document/d/1H3wChEZ72VySg6Ub4E-_u5hfHfTbqeUF9Hh7JR5hh3Y/edit?usp=sharing. Note this is an older version of the…
|
|
This tutorial introduces two additional ways to interact with SQLite Studio -- using a browser extension (Chrome or Firefox), and using a command line, text-based terminal. Any text or database…
|
|
This tutorial shows how to write SQL queries in SQLite Studio. This tutorial shows how tables can be created using SQL commands and how data can be inserted using SQL commands. See the…
|
|
This tutorial shows how to install SQLite Studio on Windows and Mac computers and demonstrates how to create a database. See the attachments tab for a link to download the database created in the…
|
|
Clip from Fall 2020, Session 5. This video reviews an accounting cycle problem, Yoshida Gardens, recording all transactions and creating the financial statements including the statement of cash…
|
|
This tutorial shows how to install SQLite Studio and demonstrates how to create a database and write queries. See the attachments tab for a link to download the database created in the video, the…
|
|
DirectEdgar is a software package that allows you to extract information for SEC filings. This video demonstrates how to install it and update the license files by connecting to the DirectEdgar…
|
|
Illustration of statistics based on an analysis of the self-reported height of students and other data. This second tutorial shows how to calculate a standard error and how to compare averages of…
|
|
This tutorial discusses the design of a database that tracks customer orders. Here is a link to a document that discusses the design of the database (click to view). See the attachments for a copy…
|
|
Illustration of statistics based on an analysis of the self-reported height of students and other data. Recorded fall 2020. This document contains the analysis I completed (click to view the google…
|
|
Discussion of financial statement analysis, DuPont Framework, Textbook's ROA calculation, financial leverage, Home Depot (negative overall equity due to repurchase activity) You can view Home…
|
|
Clip of slides from introductory session of ACCT 5202 from spring 2020. Overview of financial reporting, illustration of how accounting works.
|