FINANCIAL MODELING IN EXCEL

Prerequisites & course information

Requisites: ACCT I S 100 or 300 Course Designation: Core GenEd - Mathematics & Quantitative Reasoning Repeatable for Credit: No Last Taught: Fall 2026 Learning Outcomes: 1. Navigate and utilize the Excel interface, including optimal settings for financial modeling Audience: Undergraduate 2. Utilize Excel keyboard shortcuts most common to financial modeling Audience: Undergraduate 3. Understand and utilize best practices to build a financial model that is error-free, well-structured and user-friendly Audience: Undergraduate 4. Understand and utilize best practices related to error prevention while modeling Audience: Undergraduate 5. Construct an integrated income statement, balance sheet and cash flow statement Audience: Undergraduate 6. Incorporate circular references via interest expense and interest income, and manage them with a “circuit breaker” Audience: Undergraduate 7. Construct a three-statement integrated financial model with a cash sweep and waterfall debt schedule Audience: Undergraduate 8. Build a model from scratch using corporate historical financial statements as a starting point Audience: Undergraduate 9. Understand various approaches to developing a top-line forecast Audience: Undergraduate 10. Apply error checking and correction techniques to completed model to ensure accuracy Audience: Undergraduate Learning Outcomes: 1. Navigate and utilize the Excel interface, including optimal settings for financial modeling Audience: Undergraduate 2. Utilize Excel keyboard shortcuts most common to financial modeling Audience: Undergraduate 3. Understand and utilize best practices to build a financial model that is error-free, well-structured and user-friendly Audience: Undergraduate 4. Understand and utilize best practices related to error prevention while modeling Audience: Undergraduate 5. Construct an integrated income statement, balance sheet and cash flow statement Audience: Undergraduate 6. Incorporate circular references via interest expense and interest income, and manage them with a “circuit breaker” Audience: Undergraduate 7. Construct a three-statement integrated financial model with a cash sweep and waterfall debt schedule Audience: Undergraduate 8. Build a model from scratch using corporate historical financial statements as a starting point Audience: Undergraduate 9. Understand various approaches to developing a top-line forecast Audience: Undergraduate 10. Apply error checking and correction techniques to completed model to ensure accuracy Audience: Undergraduate