Microsoft Excel for Accounting: The First Course
by

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


Assignment Schedule for Prentice-Hall's Financial Accounting 4e by Harrison & Horngren
Chapter Matching Spreadsheet Assignment
1. Accounting The Basis of Decision Making 1 Income Statement
2 Cost of Goods Sold
3 Financial Statements
4 Income Statement
5 Statement of Owners Equity
2. Processing Accounting Information 6 Double-Entry Accounting
7 Double-Entry Accounting.
8 T-Accounts and Trial Balance
9 Trial Balance and Income Statement
10 Preparation of adjusted trial balance
11 Financial Statements and Related Questions
3. Accrual Accounting and the Financial Statements 12 Post Closing Trial Balance
13 Trial Balance and Worksheet
14 Sales by Product Type
15 Balance Sheet 
16 Financial Ratios
4. Internal Control and Managing Cash 17 Cash Disbursements
18 Cash Budget
19 Cash Budget
20 Bank Reconciliation
21 Cash Budget
5. Receivables and Short-Term Investments 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
6. Merchandise Inventory, Cost of Goods Sold, and Gross Profit 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
7. 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
8. Current Liabilities and Payroll Acctg. 42 Partial Balance Sheet
48 Lease Payment
49 Bond Amortization Schedule
9. Stockholders Equity 44 Weighted Average Number of Shares
      of Stock
45 Financial Ratios
46 Balance Sheet, Financial Ratios, and
     Related Questions
10. Long-Term 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
11. Using the Income Statement 47 Multiple-Step Income Statement
12. Statement of Cash Flows 63 Statement of Cash Flows -- Investing Activities
64 Statement of Cash Flows
13. 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.