Higher Ed. and Vocational >> Business and Economics >> Operations Management and Decision Sciences >> Statistics


Business Analysis with Microsoft Excel, 3/e

Business Analysis with Microsoft Excel, 3/e

Author(s):
  • Conrad Carlberg
    • Author: Conrad Carlberg
    • ISBN:9788131721858
    • Price: Rs. 450.00
    • Pages:504
    • Imprint:Que Press
    • Binding:Paperback
    • Status:Available


    Free Shipping by VRVBookshop
    Ratings:

    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, Third Edition, provides in-depth information that will streamline your use of the tools within Excel.

    Table of Content

    I. Analyzing Financial Statements
    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
    II. Financial Planning and Control
    1. Budgeting and Planning Cycle
    2. Forecasting and Projections
    3. Measuring Quality
    III. Investment Decisions
    1. Examining a Business Case: Investment
    2. Examining Decision Criteria for a Business Case
    3. Creating a Sensitivity Analysis for a Business Case
    4. Planning Profits
    5. Making Investment Decisions Under Uncertain Conditions
    6. Fixed Assets
    IV. Sales and Marketing
    1. Revenue Recognition and Income Determination
    2. Importing Business Data into Excel
    3. Analyzing Contributions and Margins
    4. Pricing and Costing

    Salient Features

    • Helps users analyze financial statements, income statements, balance sheets and cash flows
    • Shows how built-in functions can help measure product quality
    • Focuses on business cases and pro formulas that can be applied by the user immediately