Tools to Study for Class, or to Pass the CPA Exam

The problem: Accounting is a tough subject, and other textbooks, study materials, and live presentations may not be enough for you. A solution: 23 spreadsheets that the toughest accounting topics (categorized by subject). Download the spreadsheets and watch the YouTube video links provided. Work practice problems and add content to the spreadsheets. Improve your course grades, or pass the CPA exam. Details below..

What you’ll receive

23 spreadsheets that explain many of the toughest subjects in accounting, separated by course topic. Each document includes a YouTube video link that uses the spreadsheet to explain concepts. Here are the spreadsheets you’ll download:

Financial accounting and Intermediate accounting

Accounts Receivable: Direct Write-off, Allowance Method

Accruals and Deferrals

Bond Accounting/ Accrued Interest

Bond Accounting/ Bonds purchased at par, discount, premium

Bonds with Detachable Warrants

Capital Budgeting

Cash Budget Rollforward

Depreciation Methods

Dilutive Earnings Per Share

Effective Interest Rate Method: Discount and Premium Bonds

Inventory Valuation Methods

Non-Monetary Exchange With Boot

Percentage Completion Method: Revenue Recognition

Pension Accounting

Segmented Income Statement: Common costs, shared costs

Stock Dividends, Stock Splits, Treasury Stock

Advanced accounting

Consolidations: Calculating the differential

Consolidations: Intercompany Transactions

Deferred Tax Assets, Deferred Tax Liabilities

Intercompany Transfers: Land and Equipment

Cost accounting

Flow of Manufacturing Cost

Variances: Variable overhead and fixed overhead variances

Variances: Spending, efficiency, price variances (for material and labor costs)

Here’s an example spreadsheet:

How to get the spreadsheets: 3 steps

#1- Email me at ken@stltest.net, and ask for the spreadsheets

#2- You’ll receive a link from Hightail, which you can use to download the spreadsheets.

#3- Download each spreadsheet. The link will give you a week or two to complete all of the downloads

Over 2.4 million people have viewed the YouTube channel and watched videos using spreadsheets just like these. Study for your course, or pass the CPA exam. Good luck!

-Ken