Crunch The Numbers - Modeling
Crunch The Numbers - Modeling
Couldn't load pickup availability
**Please allow up to one business day to process digital orders**
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.**
