Financial Modeling Introduction in Excel

If you have not done much financial modeling, then this is where you should start.
We begin with basic keyboard drills, and then rapidly progress to efficient formula construction and modeling best practice. We introduce basic checking techniques and stress the importance of integrity checking. We begin with a simplified projection, and then start projecting a company. Although simple, the sample company contains the basic parts common to all projection models.
We complete a basic projection, stress test it, and then add a revolver account. Finally we will add interest income and expense and deal with the resulting circularity. We finish with documentation and more integrity checking.

• Basic keyboard shortcuts
• Excel settings for efficiency
• Key modeling formulas and structures
• Simple 3-statement projections
• Standards for good models
• Income statement construction
• Audit trails
• Introduction to checking methodology
• Balance sheet and cash flow statement construction
• Circularity and iteration
• Ratios and summary