Business Analysis with Microsoft Excel

Name: Business Analysis with Microsoft Excel
Price: 69.98 USD
Availability: InStock
ISBN: 9780789736642

ISBN-10: 0789736640

ISBN-13: 9780789736642

Edition: 3rd 2007 (Revised)

Authors: Conrad Carlberg, Conrad George Carlberg

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $69.98

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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(R) Excel, Third Edition, provides in-depth information that will streamline your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions: - What's the relationship between my cost of goods sold and my inventory? - How do I get Excel to keep these values up-to-date on my income statement and my balance sheet? - I have to track service quality over time. How can I automate that using Excel charts? - How can I forecast…

Book details

List price: $39.99
Edition: 3rd
Copyright year: 2007
Publisher: Pearson Education
Publication date: 6/19/2007
Binding: Paperback
Pages: 504
Size: 7.00" wide x 8.75" long x 1.25" tall
Weight: 1.782
Language: English



Introduction


Taking It on Faith


About the Platform


How This Book Is Organized


Two Special Skills: Named Ranges and Array Formulas


Assigning Names


Using Array Formulas


Conventions Used in This Book



Analyzing Financial Statements



Working with Income Statements


Keeping Score


Choosing the Right Perspective


Defining Two Purposes for Accounting


Using the Income Statement


Choosing a Reporting Method


Measuring the Operating and Nonoperating Segments


Moving from the General Journal to the Income Statement


Getting the General Journal into Excel


Understanding Absolute, Relative, and Mixed References


Getting the Journal Data to the Ledger


Getting the Ledger Data to the Income Statement


Managing the Financial Analyses with Accrual Accounting


Organizing with Traditional vs. Contribution Approaches


Summary



Balance Sheet: Current Assets


Designing the Balance Sheet


Understanding Balance Sheet Accounts


Understanding Debit and Credit Entries


Getting a Current Asset Cash Balance