Business Analysis with Microsoft® Excel, Second Edition

Table of contents

1. Copyright
2. About the Author
3. Acknowledgments
4. Tell Us What You Think!
5. Introduction
6. Financial Statements and Statement Analysis
   1. Working with Income Statements
      1. Keeping Score
      2. Using the Income Statement
      3. Moving from the General Journal to the Income Statement
      4. Managing with Accrual Accounting
      5. Organizing with Traditional Versus Contribution Approaches
      6. Summary
   2. Balance Sheet: Current Assets
      1. Designing the Balance Sheet
      2. Getting a Current Asset Cash Balance
      3. Getting a Current Asset Accounts Receivable Balance
      4. Getting a Prepaid Expenses Balance
      5. Getting a Current Asset Balance
      6. Summary
   3. Valuing Inventories for the Balance Sheet
      1. Valuing Inventories
      2. Using Perpetual and Periodic Inventory Systems
      3. Summary
   4. Summarizing Transactions: From the Journals to the Balance Sheet
      1. Understanding Journals
      2. Understanding Ledgers
      3. Getting a Current Liabilities Balance
      4. Summary
   5. Working Capital and Cash Flow Analysis
      1. Matching Costs and Revenues
      2. Broadening the Definition: Cash Versus Working Capital
      3. Analyzing Cash Flow
      4. Summary
   6. Statement Analysis
      1. Understanding a Report by Means of Common-Sizing
      2. Using Dollar and Percent Changes in Statement Analysis
      3. Common-Sizing for Variance Analysis
      4. Common-Sizing by Headcount
      5. Summary
   7. Ratio Analysis
      1. Interpreting Industry Averages and Trends
      2. Analyzing Profitability Ratios
      3. Analyzing Leverage Ratios
      4. Analyzing Liquidity Ratios
      5. Analyzing Activity Ratios
      6. Summary
7. Financial Planning and Control
   1. Budgeting and Planning Cycle
      1. Creating Pro Forma Financial Statements
      2. Moving from the Pro Forma to the Budget
      3. Summary
   2. Forecasting and Projections
      1. Making Sure You Have a Useful Baseline
      2. Moving Average Forecasts
      3. Forecasting with Excel's Regression Functions
      4. Forecasting with Excel's Smoothing Functions
      5. Using the Box-Jenkins ARIMA Approach: When Excel's Built-In Functions Won't Do
      6. Summary
   3. Measuring Quality
      1. Monitoring Through Statistical Process Control
      2. Performing Acceptance Sampling
      3. Using Worksheet Functions for Quality Control
      4. Summary
8. Investment Decisions
   1. Examining a Business Case: Investment
      1. Developing a Business Case
      2. Developing the Excel Model
      3. Summary
   2. Examining Decision Criteria for Business Case Analysis
      1. Understanding Payback Periods
      2. Understanding Future Value, Present Value, and Net Present Value
      3. Shortening the Payback Period
      4. Summary
   3. Creating a Sensitivity Analysis for a Business Case
      1. Managing Scenarios
      2. Measuring Profit
      3. Varying the Discount Rate Input
      4. Using the Goal Seek Function
      5. Summary
   4. Planning Profits
      1. Analyzing Operating Leverage
      2. Analyzing Financial Leverage
      3. Summary
   5. Making Investment Decisions Under Uncertain Conditions
      1. Standard Deviations
      2. Understanding Confidence Intervals
      3. Using Regression Analysis in Decision Making
      4. Summary
   6. Fixed Assets
      1. Determining Original Cost
      2. Depreciating Assets
      3. Summary
9. Sales and Marketing
   1. Revenue Recognition and Income Determination
      1. Revenue Recognition in Theory
      2. The Earning Process
      3. Recognizing Revenue at Completion of Production
      4. Recognizing Revenue with the Point of Sale Method
      5. Recognizing Revenue During the Cash Collection Process
      6. Recognizing Revenue in Different Industries
      7. Understanding the Impact of Revenue Recognition Methods
      8. Summary
   2. Importing Business Data into Excel
      1. Creating and Using ODBC Queries
      2. Working with External Data Ranges
      3. Creating and Using Web Queries
      4. Using Parameterized Web Queries
      5. Updating the Database from Excel
      6. Summary
   3. Analyzing Contributions and Margins
      1. Calculating the Contribution Margin
      2. Using Unit Contribution
      3. Finding the Break-Even Point
      4. Making Assumptions in Contribution Analysis
      5. Determining Sales Mix
      6. Analyzing Segment Margin
      7. Summary
   4. Pricing and Costing
      1. Using Absorption and Contribution Costing
      2. Using Contribution Analysis for New Products
      3. Estimating the Effect of Cross-Elasticity
      4. Summary
10. What's on the Web Site?
    1. VBA Modules and Subroutines
11. Glossary
12. Index