Financial Modeling

[pic]

University of Cincinnati

College of Business

COURSE NUMBER: Fin 4041 TERM/YEAR: Spring 2013-14

COURSE TITLE: Financial Modeling

CLASS MEETS: Tuesday, Thursday, 3:30-4:50

Room 107, Lindner Hall

INSTRUCTOR: Professor Michael Neugent

TEXT: Recommended (not required) Corporate Financial Statement Analysis with Excel, Francis Clauss

OFFICE: 416 Lindner Hall

PHONE: (513)-556-7085

EMAIL: michael.neugent@uc.edu

OFFICE HOURS: By appointment

TEACHING PHILOSOPHY:

I believe in challenging my students to the highest standards of performance by providing them every resource that they might need.

COURSE DESCRIPTION:

This course is a very hand’s on course, designed to enable students to build skills useful in business and utilize financial models in Excel. In the course will explore forecasting, data analysis, valuation methodologies, present value and future value, NPV, amortization schedules, bond valuation, and the translation of finance formulas to excel. This is a very hands on class so class attendance and participation is a significant part of your grade. The course will pull material from multiple disciplines, especially accounting.

COURSE RESPONSIBILITIES:

My expectation is that each student will come to class prepared and is willing to participate. There will be plenty of opportunities for you to voice your opinions and ideas and I strongly encourage participation from students, otherwise the course would be very boring. You should treat our classes as a regular day in the work place

COURSE OBJECTIVES:

o To understand how to utilize Excel to create Time Value of Money, Valuation, Capital Structure, Capital Budgeting, Financial Planning, International Finance, and Options and Corporate Finance evaluations.

o To understand how to evaluate the output of the above evaluations utilizing Excel.

ATTENDANCE

Attendance will be checked regularly during the semester. You are...