Business Analysis with Microsoft Excel, 2/e

Take control of the bottom line using expert techniques and Excel's powerful financial capabilities! Whether you own a small business or work for a large corporation; whether you are looking for help making financial and business decisions -- this book is for you. Business Analysis with Microsoft Excel, Second Edition provides in-depth information that will maximize your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions.

Table of Contents

Introduction

I. FINANCIAL STATEMENTS AND STATEMENT ANALYSIS.

1. Income Statements.
2. Balance Sheet: Current Asset Management.
3. Valuing Inventories for the Balance Sheet.
4. Balance Sheet: Liabilities and Owner's Equity.
5. Working Capital and Cash Flow Analysis.
6. Statement Analysis.
7. Ratio Analysis.

II. FINANCIAL PLANNING AND CONTROL

8. Budgeting and Planning Cycle.
9. Forecasting and Projections.
10. Measuring Quality.

III. INVESTMENT DICISIONS.

11. Examining a Business Case: Investment.
12. Examining Decision Criteria for Business Analysis.
13. Creating a Sensitivity Analysis for a Business Case.
14. Planning Profits.
15. Investment Decisions Under Certainty.
16. Fixed Assets.

IV. SALES AND MARKETING.

17. Sales and Marketing Analysis.
18. Recognition.
19. The Business Planner.
20. Contribution and Margin Analysis.
21. Pricing and Costing.
What's on the CD-ROM.