Using Excel to learn financial and managerial accounting topics

 

140x140

THE ACCOUNTING
CYCLE

The accounting equation, core financial statements, debits and credits, general journal, general ledger, trial balance, adjusting entries, retained earnings, and reversing entries.

140x140

CURRENT
ASSETS

Cost of goods sold, income statements, inventory, freight costs, cash, cash equivalents, bank reconciliation, trading securities, accounts receivable, notes receivable, FIFO, LIFO, weighted-averages.

140x140

LONG-TERM
ASSETS

Long-term investments, debt security investments, the equity method, consolidation, property, plant, and equipment, depreciation methods, asset disposal, asset exchange, and intangible assets.

 

140x140

LIABILITIES
AND EQUITIES

Current liabilities, contingent liabilities, payroll, long-term obligations, present and future value, bonds payable, debt analysis, effective-interest amortization, corporate organization, treasury stock, and common and preferred stock.

140x140

USING ACCOUNTING
INFORMATION

Other comprehensive income, earnings per share, foreign exchange, profit and equity ratios, statement of cash flows, direct and indirect approach to cash flows, and cash flow worksheets.

140x140

MANAGERIAL AND COST
ACCOUNTING

Managerial accounting, scehdule of cost of goods manufactured, product and period costs, cost-volume-profit analysis, break-even point, job costing systems, overhead, process costing, cost per equivalent unit and activity-based costing.

 

140x140

BUDGETING AND DECISION MAKING

Budgets, sales budget, flexible budgets, standard costs, variance calculations, overhead, labor and material variances, variable costing, absorption costing, segment reporting, capital expenditure decisions, compound interest, and present and future value.

 

 

Illustrative entries

Examples of general journal entries for numerous commonly used sample transactions.

Entries »

Account types

Typical financial statement accounts with debit/credit rules and disclosure conventions.

Accounts »

Time value of money

Present value and future value tables for lump sum, ordinary annuity, and annuity due.

Time value »

 

MyExceLab.com provides direct links to a series of excel spreadsheets that cover most topics routinely covered in introductory financial accounting and managerial accounting courses. Each spreadsheet is unique and based upon a specific learning goal. The intrinsic methodology of each sheet is based on one of three approaches: problem solver, calculation robot, or generalized illustration. In each case, you will enter data/and or solutions, and receive interactive feedback, solutions, and instruction.

These MyExceLab spreadsheets were developed by Professor Larry Walther, and are additionally linked to his online textbook at principlesofaccounting.com. Feel free to refer to that website for additional reading and video material that can be used to facilitate your understanding of each topic.