Who should attend
Non-finance business professionals, individuals and company teams in entry-level finance-related jobs.
About the course
This program serves as an introduction to financial modeling using Excel. Participants learn how to create financial models that solve a variety of applied situations. In an online, hands-on setting, the program provides the skills to apply financial concepts and spreadsheet tools for effective decision making.
The course is designed so participants with varied backgrounds can succeed, including those who do not have a finance-related degree. For companies and their teams, this course can be modified for group work as well. The program can be completed in 12 weeks or sooner as the assignments are self-paced. There are weekly deadlines to submit spreadsheets using the e-Learning Commons platform.
- Financial Statements and Ratio
- Time Value of Money
- Project Decision Rules
- Capital Budgeting
- Historical Risk and Return
- Portfolio Basics with Pricing Model
- Portfolios with Many Assets
- Bond Valuation, Yield to Maturity, Duration, and Convexity
- Equity Valuation
- Weighted Average Cost of Capital
- Financial Forecasting
- DCF Valuation Model
- LBO Valuation Model
- Option Payoffs
- Black-Scholes Option Pricing Model
- Excel Features (Data Tables, Goal Seek, Solver, Conditional Formatting, and Pivot Tables)
Dr. Pope works with participants to develop an understanding of finance and how it impacts decisions they face daily in the workplace. Education PhD, Business Economics, Indiana University, 2000 MSIE, Industrial Engineering, Georgia Tech, 1994 BIE, Industrial Engineering, Georgia Tech, 1993 ...
Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.
We are happy to help you find a suitable online alternative.