Day 3 - Integrated Financial Model Standards

Day 3 - Integrated Financial Model Standards

Participants begin with basic keyboard drills and shortcuts, and then rapidly progress to efficient formula construction and basic modeling and checking techniques. Although simple, the sample company contains the basic parts common to all projection models. Participants complete a basic projection model and stress test their assumptions. Interest income and expense are added and the resulting circularity is solved with iterations. Finally, the model is documented and integrity checked.

Key topics:

• Basic keyboard shortcuts
• Excel settings for efficiency
• Key modeling formulas and structures
• Standards for good models
• Income statement construction
• Balance sheet and cash flow statement construction
• Introduction to checking methodology
• Audit trails
• Incorporation of interest income and expense
• Circularity and iteration
• Ratios and summary