Business Analysis with Microsoft Excel

Front Cover
Que Publishing, 2002 - Computers - 489 pages

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.

 

What people are saying - Write a review

User ratings

5 stars
3
4 stars
1
3 stars
1
2 stars
0
1 star
0

User Review - Flag as inappropriate

Excellent book very instructive for all those who want to understand how to check business through numbers...

User Review - Flag as inappropriate

98 page onely

Contents

Using the Income Statement
11
Analyzing Contributions and Estimating the Effect of Cross
19
Managing with Accrual Accounting
22
Summary
29
Getting a Current Asset Accounts
40
Getting a Current Asset Balance
48
Valuing Inventories
54
Summary
80
Summary
255
Developing the Excel Model
263
Summary
270
Shortening the Payback Period
279
Creating a Sensitivity Analysis
285
Measuring Profit
294
Using the Goal Seek Function
301
Analyzing Financial Leverage
314

Journals
86
Understanding Ledgers
92
Getting a Current Liabilities Balance
106
Cash Versus
112
Analyzing Cash Flow
122
Summary
129
Using Dollar and Percent Changes
138
CommonSizing by Headcount
147
Analyzing Profitability Ratios
158
Analyzing Liquidity Ratios
168
Financial Planning and Control
173
Creating Pro Forma Financial
176
Moving from the Pro Forma to
185
Forecasting and Projections
191
Excels Charts
206
Summary
223
Performing Acceptance Sampling
244
Standard Deviations
320
Summary
345
Fixed Assets
347
Depreciation
358
Sales and Marketing
362
Revenue Recognition in Theory
366
Recognizing Revenue with the Point
372
Summary
379
Working with External Data Ranges
393
Using Parameterized Web Queries
400
Summary
411
Using Unit Contribution 417 VBA Modules and Subroutines 458
418
Making Assumptions in Contribution
428
Summary
434
Using Contribution Analysis for
449
Appendix A Whats on the Web Site?
457
Copyright

Other editions - View all

Common terms and phrases

About the author (2002)

Conrad Carlberg is president of Network Control Systems, Inc., a software and consulting firm that specializes in the development of quality control and forecasting tools for the health industry. He holds a Ph.D. in statistics from the University of Colorado, and is a multiple recipient of Microsoft's Excel's Most Valuable Professional award.

Bibliographic information