Skip to product information
1 of 2

Crunch the Numbers

Crunch The Numbers - Modeling

  • Description
  • What does the book include?
  • Description
  • A lightweight A5-sized hardcopy book, describing the fundamentals of accounting, working examples and practical application. This book has 80 pages. We do not charge tax on this product.

  • What does the book include?
  • Introduction

    • What is a fully integrated model?
    • Steps in creating a model
    • How to use this reference guide

    Modeling Basics

    • Excel 2003 - accessing the menu with the keyboard
    • Excel 2007/2010 - accessing the ribbon with the keyboard
    • Other essential keyboard shortcuts
    • Writing a cross sheet formula with the keyboard
    • Modeling formulae
    • Cell comments

    Setting Up the Model Template

    • Setting up the template for a single sheet model
    • Setting up the template for a multi-sheet model
    • Matrix integrity
    • Cell formats - Excel 2003
    • Cell formats - Excel 2007/2010

    Input Historical Numbers

    • Inputting income statement historical numbers
    • Inputting balance sheet historical numbers

    Calculating Ratios and Building Assumptions

    • Calculating ratios
    • Building assumptions

    Projecting the Income Statement

    • Sales/revenue
    • Cost of sales (COGS)
    • Depreciation
    • Gross profit
    • SG&A
    • Amortization
    • Operating profit
    • Non-recurring items
    • Interest income and expense
    • Profit before taxes
    • Tax
    • Net income
    • Shareholder information

    Projecting the Balance Sheet

    • Sales driven accounts
    • Net fixed assets (net PP&E)
    • Intangibles
    • Retained earnings
    • Treasury stock
    • Common stock and additional paid in capital
    • Debt

    Balancing the Balance Sheet

    • Balance check
    • Cash flow statement
    • Excess cash / revolver
    • Adding the revolver line to the debt schedule

    Interest Income and Interest Expense

    • Methods of interest calculation
    • Calculating interest expense
    • Calculating interest income
    • Linking interest into the income statement

          Version
          Regular price $17.00 USD
          Regular price Sale price $17.00 USD
          Sale Register Interest
          Shipping calculated at checkout.

          Shipping

          Hardcopy books will require an additional shipping cost, this will be worked out in checkout.

          All order will be shipped via Royal Mail or UPS.

          Tracking will be made avaliable.

          How to access digital content

          Digital books will be made available within 24 hours of purchase. You'll receive an email with your digital access code.

          Contact form