Business analysis : Microsoft Excel 2010
ANSWER KEY BUSINESS QUESTIONS CONTROL COMPANY FINANCES FORECAST SALES PREPARE BUSINESS CASES MAKE BETTER INVESTMENT DECISIONS IMPROVE QUALITY USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS Using real-world examples, Carlberg helps you put Excel’s features and f...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
Que
2010
|
| Edición: | 1st edition |
| Colección: | MrExcel library Business analysis
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628876506719 |
Tabla de Contenidos:
- Cover
- Contents
- Introduction
- Taking It on Faith
- Renamed and Improved Functions in Excel 2010
- Compatibility
- Consistency
- How This Book Is Organized
- Two Special Skills: Named Ranges and Array Formulas
- Assigning Names
- Using Array Formulas
- Conventions Used in This Book
- PART I: ANALYZING FINANCIAL STATEMENTS
- 1 Working with Income Statements
- Keeping Score
- Using the Income Statement
- Moving from the General Journal to the Income Statement
- Managing the Financial Analyses with Accrual Accounting
- Organizing with Traditional Versus Contribution Approaches
- 2 Balance Sheet: Current Assets
- Designing the Balance Sheet
- Getting a Current Asset Cash Balance
- Getting a Current Asset Accounts Receivable Balance
- Getting a Prepaid Expenses Balance
- Getting a Current Asset Balance
- 3 Valuing Inventories for the Balance Sheet
- Understanding Perpetual and Periodic Inventory Systems
- Valuing Inventories
- Comparing the Four Valuation Methods
- Handling Purchase Discounts
- Calculating Turns Ratios
- 4 Summarizing Transactions: From the Journals to the Balance Sheet
- Understanding Journals
- Excel Tables and Dynamic Range Names
- Understanding Ledgers
- Getting a Current Liabilities Balance
- 5 Working Capital and Cash Flow Analysis
- Matching Costs and Revenues
- Broadening the Definition: Cash Versus Working Capital
- Analyzing Cash Flow
- 6 Statement Analysis
- Understanding a Report by Means of Common-Sizing
- Using Dollar and Percent Changes in Statement Analysis
- Common-Sizing and Comparative Analyses in Other Applications
- Common-Sizing for Variance Analysis
- Common-Sizing by Headcount
- 7 Ratio Analysis
- Interpreting Industry Averages and Trends
- Comparing Ratios Within Industries
- Analyzing Profitability Ratios
- Analyzing Leverage Ratios.
- Analyzing Liquidity Ratios
- Analyzing Activity Ratios
- PART II: FINANCIAL PLANNING AND CONTROL
- 8 Budgeting and Planning Cycle
- Creating Pro Forma Financial Statements
- Using Excel to Manage the Analysis
- Moving from the Pro Forma to the Budget
- 9 Forecasting and Projections
- Making Sure You Have a Useful Baseline
- Moving Average Forecasts
- Forecasting with Excel's Regression Functions
- Forecasting with Excel's Smoothing Functions
- Using the Box-Jenkins ARIMA Approach: When Excel's Built-In Functions Won't Do
- 10 Measuring Quality
- Monitoring Quality Through Statistical Process Control
- Performing Acceptance Sampling
- Using Worksheet Functions for Quality Control
- Sampling Units from a Nonfinite Population
- PART III: INVESTMENT DECISIONS
- 11 Examining a Business Case: Investment
- Developing a Business Case
- Developing the Excel Model
- 12 Examining Decision Criteria for a Business Case
- Understanding Payback Periods
- Understanding Future Value, Present Value, and Net Present Value
- 13 Creating a Sensitivity Analysis for a Business Case
- Reviewing the Business Case
- Managing Scenarios
- Measuring Profit
- Varying the Discount Rate Input
- Using the Goal Seek Tool
- 14 Planning Profits
- Understanding the Effects of Leverage
- Analyzing Operating Leverage
- Analyzing Financial Leverage
- 15 Making Investment Decisions Under Uncertain Conditions
- Using Standard Deviations
- Understanding Confidence Intervals
- Using Regression Analysis in Decision Making
- 16 Fixed Assets
- Determining Original Cost
- Depreciating Assets
- PART IV: SALES AND MARKETING
- 17 Importing Business Data into Excel
- Creating and Using ODBC Queries
- Working with External Data Ranges
- Creating and Using Web Queries
- Using Parameterized Web Queries
- 18 Exporting Business Data from Excel.
- Using VBA to Update an External Database
- Editing the Record's Values
- Using With Blocks
- Adding New Records to the Recordset
- Choosing to Use ADO
- 19 Analyzing Contributions and Margins
- Calculating the Contribution Margin
- Using Unit Contribution
- Finding the Break-Even Point
- Making Assumptions in Contribution Analysis
- Determining Sales Mix
- 20 Pricing and Costing
- Using Absorption and Contribution Costing
- Using Contribution Analysis for New Products
- Estimating the Effect of Cross-Elasticity
- Glossary.
