Business Analysis with Microsoft Excel,5th Edition

Business Analysis with Microsoft Excel (5th Edition)
Authors: Conrad Carlberg
ISBN-10: 0789759586
ISBN-13: 9780789759580
Edition 版本:‏ 5
Released: 2018-12-31
Print Length 页数: 528 pages
Gain Deeper Insights,Make Smarter Decisions,and Earn More Profits
It’s time to put the full power of Excel quantitative analysis behind your management decisions!
Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master: analyzing statements,planning and controlling company finances,making investment decisions,and managing sales and marketing. Carlberg helps you make the most of Excel’s tools and features in everything from business case development to cash flow analysis.
Becoming an Excel expert has never been easier. You’ll find crystal-clear instructions,real-world examples,insider insights,step-by-step projects,and much more. It’s all complemented by extensive web-based resources,from sample journals and ledgers to business forecasting tools.
Get more insight from income statements and balance sheets
Manage current assets and value inventories
Summarize transactions from journal to balance sheet
Analyze working capital,cash flow,statements,and ratios
Optimize budgeting and planning cycles
Make more accurate and useful forecasts and projections
Measure product or service quality
Plan investments,set decision criteria,and perform sensitivity analyses
Analyze profits,pricing,costs,contributions,and margins
Make better decisions in uncertain conditions
Understand and maximize the value of fixed assets
Efficiently import and export business data
Use Excel and Power BI to analyze data from QuickBooks or other sources
Contents
About the Author
Dedication
We Want to Hear from You!
Reader Services
1 Working with Income Statements
2 Balance Sheet: Current Assets
3 Valuing Inventories for the Balance Sheet
4 Summarizing Transactions: From the Journals to the Balance Sheet
5 Working Capital and Cash Flow Analysis
6 Statement Analysis
7 Ratio Analysis
8 Budgeting and Planning Cycle
9 Forecasting and Projections
10 Measuring Quality
11 Examining a Business Case: Investment
12 Examining Decision Criteria for a Business Case
13 Creating a Sensitivity Analysis for a Business Case
14 Planning Profits
15 Making Investment Decisions Under Uncertain Conditions
16 Fixed Assets
17 Importing Business Data into Excel
18 Exporting Business Data from Excel
19 Using Excel 2016 and Power BI to Analyze QuickBooks Data
20 Analyzing Contributions and Margins
21 Pricing and Costing
Index