Crunch The Numbers - Modeling

A lightweight A5-sized hardcopy book, describing essential modeling techniques and processes from the ground up. Applicable to both Excel 2003 and 2007/2010 versions. This book has 80 pages. We do not charge tax on this product.

US$20.99

A lightweight A5-sized hardcopy book, describing essential modeling techniques and processes from the ground up. Applicable to both Excel 2003 and 2007/2010 versions. This book has 80 pages. We do not charge tax on this product.

This book includes:

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

What books complement this one?