This hands-on workbook introduces you to the power of spread-sheets with more than 50 problems that also reinforce the principles of accounting.Each true-to-life problem applies formula-development and model-building skills used in a variety of accounting applications,with an emphasis on what-if analysis.

PREFACE

INSTRUCTIONS FOR SAMPLE PROBLEMS

Sample Problem A

SAMPLE PREPROGRAMMED PROBLEM

Sample Problem B

SAMPLE WORKSHEET TICKLER

Sample Problem C

SAMPLE CHART TICKLER

Sample Problem D

SAMPLE MODEL-BUILDING PROBLEM

PREPROGRAMMED PROBLEMS

 P1 Business Transactions (PTRANS)

 P2 Service Company Worksheet (F1WORK)

 P3 Merchandising Company Worksheet (P2WORK)

 P4 Merchandising Company Financial Statements (FMERCH)

 P5 Bank Reconciliation (BANKREC)

 P6 Aging Accounts Receivable (AGING)

 P7 Inventory Cost FIowAssumptions (FIFOLIFO)

 P8 Gross Profit Method (GP)

 P9 Depreciation (DEPREC)

 P10 Payroll Register (PR)

 P11 Bond Pricing and Amortization (BONDS)

 P12 Statement of Stockholders'Equity (STOCKEQ)

 P13 Earnings Per Share (EPS)

 P14 Statement of Cash Flows (CASHFLOW)

 P15 Ratio Analysis (RATIOA)

 P16 Manufacturing Accounting (MFG)

 P17 Job Order Costing (JOB)

 P18 Cost-Volume-Profit Analysis (CVP)

 P19 Variable Costing (VARCOST)

 P20 Activity-Based Costing (ABC)

 P21 Cash Budgeting (CASHBUD)

 P22 Master Budget (MASTER)

 P23 Flexible Budgeting (FLEXBUD)

 P24 Material and Labor Variances (PRIMEVAR)

 P25 Segment Income Statement (DEPT)

 P26 Capital Budgeting (CAPBUD)

MODEL-BUILDING PROBLEM CHECKLIST

MODEL-BUILDING PROBLEMS

 M1 Trial Balance

 M2 Service Company Financial Statements

 M3 Cash Receipts Journal

 M4 Short-Term Investments

 M5 Perpetual Inventory Record

 M6 Inventory Valuation: Lower of Cost or Market

 M7 Lump Sum Purchase

 M8 Bonds vs, Stock Financing

 M9 Partnership: Division of Net Income

 M10 Corporate Income Statement

 M11 Book Value Per Share

 M12 Deferred Income Tax

 M13 Bond Premium and Discount Amortization Schedule

 M14 Cash Flow fromOperating Activities

 M15 Vertical Analysis

 M16 Process Costing: FIFO

 M17 Process Costing: Weighted Average

 M18 High-Low Points Method

 M19 Cost-Volume-Profit Analysis

 M20 Cost-Volume-Profit Analysis (Multiple Products)

 M21 JIT Cost Savings

 M22 Cash Budgeting

 M23 Developing Standard Costs

 M24 Variance Analysis

 M25 Flexible Budget for Overhead

 M26 Segment Contribution to Income

MODEL-BUILDING CASES

 C1 Financial Statement Preparation

 C2 Financial Analysis

 C3 Three-Month Master Budget