91-857: Introduction to Financial Modeling and Analysis
Prerequisites: 90-804, Financial Analysis for Managers. Ability to use standard spreadsheet software, and basic knowledge of accounting and finance.While some business owners who appear on the cover of business magazinesclaim they make decisions purely on instinct, most managers go through amethodical process of assessing their options. This course offers theparticipants a series of modeling techniques and frameworks to assist inmaking and supporting business decisions.The format of the course is to introduce or review financial issues such asvaluation, pricing, product and service attribute planning, capitalbudgeting and forecasting. The next step is to use spreadsheet techniquesto build flexible models. The flexibility of the models allows managers toperform sensitivity analysis and quickly evaluate their options. The classsessions will include exercises and implementation of the techniques. Outof class assignments will ask students to evaluate a business situation andmake and support their decision based on their analysis.Because of the hands-on nature of the course, many sessions will be held inthe computer lab. It is assumed that participants have a general knowledgeof finance and accounting as well as a basic knowledge of Excel. The coursewill cover implementing some of the advanced tools available in Excel.
| A3 | M | 05:30 pm - 08:20 pm | HBH A100 | Pastor |