Crunch The Numbers - Modeling

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

**Training The Street acquired AMT Training in 2021. We have merged AMT's products into one store, to increase our content offering. This is sold as an AMT Training product.**