Financial Modeling 330

Learning Outcomes:

Upon successful completion of this course, students are expected to be able to analyze financial and business data to identify patterns or cycles; rearrange and combine data to formulate forecasting models; formulate and interpret the output of optimization models for planning using Excel add-ins; formulate Monte Carlo simulations for business and interpret the output for profit planning using Excel add-ins; conduct internet searches for financial modeling software; appraise the software and report with recommendations for its application in a specified business situation.

Topics:

This course provides opportunities for students to learn to use the features of Excel and develop skills in spreadsheet design and spreadsheet add-in tools to solve capacity problems. The course also teaches vides opportunities for students to learn to use budget scenarios, develop simulations of cash flow for revenues and expenses, capital investment cash flow planning, formulas and functions, forms, simulations, forecasting, importing data, and OLE (Object Linking & Embedding).

Prerequisite: AC318 – Financial Accounting I