This course will provide students with an introduction to effectively using Excel to solve many common problems that arise in finance. The course will provide students with an overview of what is involved in creating an effective financial model. Students will then apply these financial modeling guidelines to a variety of financial problems. The student will gain an insight into how to more effectively use Excel to analyze some common financial problems. In addition the student will learn how through effective financial modeling solutions to financial problems, can be tested to see how sensitive the solution is to the assumptions made in the model. As well, the student will learn how to present clearly and effectively the results of their financial modeling analysis. The student may be given an introduction to Visual Basic and how it can add to the effectiveness of financial modeling with Excel. Lect: 3 hrs. Prerequisite: FIN 300 Course Weight: 1.00 Billing Units: 1
