9780324270273

Excel Applications for Accounting Principles (with Excel Templates Computer Disk)

by
  • ISBN13:

    9780324270273

  • ISBN10:

    0324270275

  • Edition: CD
  • Format: Paperback
  • Copyright: 7/21/2003
  • Publisher: South-Western College Pub
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $143.00 Save up to $4.29
  • Buy New
    $138.71
    Add to Cart Free Shipping

    CURRENTLY AVAILABLE, USUALLY SHIPS IN 24-48 HOURS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

Intended for any principles, financial, managerial, or computerized accounting course of accounting course where additional coverage of Excel is desired. The book also serves as a stand-alone core text for a computerized accounting course.

Table of Contents

PREFACE v
INSTRUCTIONS FOR SAMPLE PROBLEMS 1(1)
Sample Problem A
SAMPLE PREPROGRAMMED PROBLEM
2(12)
Sample Problem B
SAMPLE WORKSHEET TICKLER
14(4)
Sample Problem C
SAMPLE CHART TICKLER
18(3)
Sample Problem D
SAMPLE MODEL-BUILDING PROBLEM
21(10)
PREPROGRAMMED PROBLEMS
P1 Business Transactions (PTRANS)
31(6)
P2 Service Company Worksheet (F1 WORK)
37(6)
P3 Merchandising Company Worksheet (P2WORK)
43(6)
P4 Merchandising Company Financial Statements (FMERCH)
49(8)
P5 Bank Reconciliation (BANKREC)
57(6)
P6 Aging Accounts Receivable (AGING)
63(4)
P7 Inventory Cost Flow Assumptions (FIFOLIFO)
67(6)
P8 Gross Profit Method (GP)
73(4)
P9 Depreciation (DEPREC)
77(4)
P10 Payroll Register (PR)
81(6)
P11 Bond Pricing and Amortization (BONDS)
87(6)
P12 Statement of Stockholders' Equity (STOCKEQ)
93(4)
P13 Earnings Per Share(EPS)
97(4)
P14 Statement of Cash Flows (CASHFLOW)
101(8)
P15 Ratio Analysis (RATIOA)
109(6)
P16 Manufacturing Accounting (MFG)
115(4)
P17 Job Order Costing (JOB)
119(6)
P18 Cost-Volume-Profit Analysis (CVP)
125(6)
P19 Variable Costing (VARCOST)
131(4)
P20 Activity-Based Costing (ABC)
135(4)
P21 Cash Budgeting (CASHBUD)
139(6)
P22 Master Budget (MASTER)
145(8)
P23 Flexible Budgeting (FLEXBUD)
153(6)
P24 Material and Labor Variances (PRIMEVAR)
159(4)
P25 Segment Income Statement (DEPT)
163(6)
P26 Capital Budgeting (CAPBUD)
169(4)
MODEL-BUILDING PROBLEM CHECKLIST 173(1)
MODEL-BUILDING PROBLEMS
M1 Trial Balance
174(1)
M2 Service Company Financial Statements
175(1)
M3 Cash Receipts Journal
176(1)
M4 Short-Term Investments
177(1)
M5 Perpetual Inventory Record
178(1)
M6 Inventory Valuation: Lower of Cost or Market
179(1)
M7 Lump Sum Purchase
180(1)
M8 Bonds vs. Stock Financing
181(1)
M9 Partnership: Division of Net Income
182(1)
M10 Corporate Income Statement
183(2)
M11 Book Value Per Share
185(1)
M12 Deferred Income Tax
186(1)
M13 Bond Premium and Discount Amortization Schedule
187(1)
M14 Cash Flow from Operating Activities
188(1)
M15 Vertical Analysis
189(2)
M16 Process Costing: FIFO
191(1)
M17 Process Costing: Weighted Average
192(1)
M18 High-Low Points Method
193(1)
M19 Cost-Volume-Profit Analysis
194(1)
M20 Cost-Volume-Profit Analysis (Multiple Products)
195(1)
M21 JIT Cost Savings
196(2)
M22 Cash Budgeting
198(1)
M23 Developing Standard Costs
199(1)
M24 Variance Analysis
200(1)
M25 Flexible Budget for Overhead
201(1)
M26 Segment Contribution to Income
202
MODEL-BUILDING CASES
C1 Financial Statement Preparation 203(3)
C2 Financial Analysis 206(7)
C3 Three-Month Master Budget 213

Rewards Program

Write a Review