Business Analysis with Microsoft Excel

by Carlberg, Conrad

• ISBN13: 9780789736642
• ISBN10: 0789736640
• Edition: 3rd
• Format: Paperback
• Copyright: 2007-06-19
• Publisher: Que Publishing

Summary

Extensive coverage of Excel's financial capabilities - for small businesses or major corporations!

Author Biography

Conrad Carlbergis president of Network Control Systems, Inc., a software-development and consulting firm that specializes in statistical and database applications. He holds a Ph.D. in statistics and is a many-time recipient of Microsoft’s Most Valuable Professional Award. He lives near San Diego.

Table of Contents

Introduction	p. 1
Taking It on Faith	p. 2
About the Platform	p. 3
How This Book Is Organized	p. 4
Two Special Skills: Named Ranges and Array Formulas	p. 4
Assigning Names	p. 5
Using Array Formulas	p. 6
Conventions Used in This Book	p. 6
Analyzing Financial Statements
Working with Income Statements	p. 11
Keeping Score	p. 11
Choosing the Right Perspective	p. 12
Defining Two Purposes for Accounting	p. 12
Using the Income Statement	p. 13
Choosing a Reporting Method	p. 13
Measuring the Operating and Nonoperating Segments	p. 17
Moving from the General Journal to the Income Statement	p. 18
Getting the General Journal into Excel	p. 18
Understanding Absolute, Relative, and Mixed References	p. 19
Getting the Journal Data to the Ledger	p. 20
Getting the Ledger Data to the Income Statement	p. 23
Managing the Financial Analyses with Accrual Accounting	p. 24
Organizing with Traditional vs. Contribution Approaches	p. 29
Summary	p. 30
Balance Sheet: Current Assets	p. 31
Designing the Balance Sheet	p. 32
Understanding Balance Sheet Accounts	p. 32
Understanding Debit and Credit Entries	p. 33
Getting a Current Asset Cash Balance	p. 34
Table of Contents provided by Publisher. All Rights Reserved.