Microsoft Excel for Accounting: The First Course
by

Dr. Katherine T. Smith
Dr. L. Murphy Smith
Dr. Lawrence C. Smith, Jr.


Assignment Schedule for Any First Course Text
Subject Area Matching Spreadsheet Assignment
Accounting and the
Business Environment
1 Income Statement
2 Cost of Goods Sold
3 Financial Statements
4 Income Statement
5 Statement of Owners Equity
Recording Business Transactions 6 Double-Entry Accounting
7 Double-Entry Accounting.
8 T-Accounts and Trial Balance
9 Trial Balance and Income Statement
Measuring Business Income:
The Adjusting Process
10 Preparation of adjusted trial balance
11 Financial Statements and Related Questions
Completing the Accounting Cycle 12 Post Closing Trial Balance
13 Trial Balance and Worksheet
Merchandising Operations and 
the Accounting Cycle
14 Sales by Product Type
15 Balance Sheet 
16 Financial Ratios
Accounting Information Systems 17 Cash Disbursements
Internal Control and Managing Cash 18 Cash Budget
19 Cash Budget
20 Bank Reconciliation
21 Cash Budget
Accounts and Notes Receivable 22 Bad Debt Expense
23 Bad Debt Expense
24 Aging Sales Invoices
25 Aging Sales Invoices
26 Aging Sales Invoices
27 Statement of Cash Flows
Accounting for Merchandise Inventory 28 Cost of Merchandise
29 Cost of Merchandise
30 Tracking Inventory Quantity
31 Product Cost Schedule
32 Income Statement
33 Perpetual Inventory Record
34 Income Statement, Balance Sheet,
     & Statement of Cash Flows
Plant Assets, Intangibles Assets,
and Related Expenses
35 Straight Line Depreciation
36 Straight Line Depreciation
37 Sum-of-the-Years-Digits Deprec. 
38 Units-of-Production Depreciation
39 Joint Cost Allocation
40 Joint Cost Allocation
41 Allocation of Costs in Lump-Sum Purchase
Current Liabilities and Payroll Acctg. 42 Partial Balance Sheet
Accounting for Partnerships 43 Summary of Liquidation Transactions
Corporate Organization, Paid-In
Capital, and the Balance Sheet
44 Weighted Average Number of Shares
      of Stock
45 Financial Ratios
46 Balance Sheet, Financial Ratios, and
     Related Questions
Retained Earnings, Treasury Stock,
and Income Statement
47 Multiple-Step Income Statement
Long-Term Liabilities  48 Lease Payment
49 Bond Amortization Schedule
Accounting for Investments and
International Operations
50 Interest Earned
51 Future Value of a Single Deposit
52 Foreign Currency Translation Using Current Rate Method
53 Foreign Currency Translation Using Current Rate Method
54 Foreign Currency Translation Using Current Rate Method
55 Foreign Currency Translation Using Current Rate Method
56 Foreign Currency Translation Using Temporal Rate Method
57 Foreign Currency Translation Using Temporal Rate Method
58 Economic Impact of Import Quota
59 Economic Impact of Import Quota
60 Economic Impact of a Tariff
61 Economic Impact of a Tariff
62 Economic Impact of a Tariff
Statement of Cash Flows 63 Statement of Cash Flows -- Investing Activities
64 Statement of Cash Flows
Financial Statement Analysis 65 Financial Ratios
66 Financial Ratios
67 Common Size Balance Sheets
68 Common Size Balance Sheets
69 Horizontal Analysis of Income Statement
Links:
Back to Starting Page
Prentice-Hall
Microsoft Corporation
Web Search Engines
Quotations on Ethics (cool quotes & movie clips)
The Bottom Line is Betrayal


Contact the Webmaster with comments or suggestions for improving this page.


This page is always under construction.