School of Business Administration
Faculty/Staff Login
Nav Menu

FINC 6363 - 22489 Spring 2014

Course Number FINC 6363 - 22489
Course Title Financial Modeling
Location Cinco Ranch
Prerequisites FINC 6352, which may be taken concurrently
Instructor Dr. Ning
Office
Office Hours Mon 9AM-11AM; 1PM-3PM Virtual Office Hours; Thursday 6:00pm~7:00pm CR & UHVC or by appointment
Phone n/a
Fax
Email ningy@uhv.edu
Faculty Homepage/URL http://www.uhv.edu/bus

Prerequisite Policy

Prerequisites for a course exist because the School of Business Administration faculty have determined that the knowledge, skills, and/or exposure students receive through the prerequisites is critical to their success in the course and their ability to contribute to their fellow students' learning experience. In addition, taking your core courses and concentration or elective courses in a prescribed sequence prepares you to integrate the knowledge and skills you are acquiring properly. Students bear the responsibility for verifying that they have the appropriate prerequisites for their courses. Students who enroll in a course without completing the prerequisites risk being dropped from the class at any time during the semester should their lack of prerequisites come to light. In addition, students who enroll without the prerequisites and as a result find themselves at a disadvantage in meeting course objectives will have no redress with the instructor.

Course Description

This course combines the application of financial theories and concepts, spreadsheet skills and Visual Basic to (i) analyze financial statements, (ii) prepare cash budgets, (iii) prepare financial forecasts, (iv) perform time value of money, stock and bond analysis, (v) perform breakeven and leverage analysis, (vi) make cost of capital and capital budgeting decisions, (vii) perform portfolio analysis, and (viii) apply Visual Basic for financial analysis. 

Financial Modeling is designed to make a connection between textbook finance and the problems of real-world business. It helps MBA students build programs using spreadsheet (i.e., Microsoft Excel) to solve a wide range of real-world financial problems. The course covers the application of spreadsheet skills for financial statements, cash budget, ratio analysis, financial forecasting, break-even and leverage analysis, the time value of money, valuation and rates of return, the cost of capital, capital budgeting, portfolio analysis, and Visual Basic for Application programming. The course is most appropriate for students who have taken introductory accounting and financial management courses. Students consistently say that it is the most useful course they have taken. A sizable number of my former students have landed jobs in large part due to their superior spreadsheet skills (pp. xv, Mayes & Shank, 2009).

Textbook Information

Mayes, T.R. and Shank, T.M., Financial Analysis with Microsoft Excel, 6th (2011) ed., South-Western College Publishing, ISBN 978-1111826246(Required)

Information on Buying Textbooks

The Victoria College Bookstore carries textbooks for all UHV SBA courses.

Students may use the publishing information posted above to order their textbooks from their favorite book vendor. However, before doing so you should find out what your vendor's anticipated shipping time is, and what their return policy is. Also, you should not write in or remove shrinkwrap from any textbook or materials you purchase from any vendor until the first class day in the event that:

  • the vendor supplies you with the wrong edition of your text,
  • the course instructor is forced to make a late change to the required textbooks,
  • you are forced to make a last-minute change to your schedule due to missing prerequisites, or
  • your course is canceled due to low enrollment.

In addition, be aware that, on occasion, certain outside vendors may substitute an international version of a textbook for the version you have requested without notice. International versions of textbooks may be quite different from the editions we require.

AACSB Accreditation Standards

The School of Business Administration is accredited by AACSB International, the hallmark of excellence in management education. AACSB International accreditation represents the highest standard of achievement for business schools worldwide. Institutions that earn accreditation confirm their commitment to quality and continuous improvement through a rigorous and comprehensive peer review. AACSB International accreditation is the hallmark of excellence in management education. AACSB International accreditation adds value to your degree. The AACSB International accreditation standards require you to:

  • Operate with integrity in your dealings with faculty and other students.
  • Engage the learning materials with appropriate attention and dedication. (This standard recognizes the role students play in the creation of high-quality education. You cannot be passive, nor can your participation be superficial.)
  • Maintain your engagement when challenged by difficult learning activities.
  • Contribute to the learning of others. (Regardless of the delivery mode of the program, students should have opportunities to work together on some learning tasks. Students need to acknowledge their responsibilities to their fellow students by actively participating in group learning experiences.)
  • Perform to standards set by faculty.

Course Objectives

As a result of this course, students will:

  1. Comprehend basic and advanced spreadsheet building skills.
  2. Apply spreadsheet skills to analyze financial statements, cash budget, financial ratio analysis, financial forecasting, break-even and leverage analysis issues.
  3. Calculate time value of money, rate, and uneven cash flow using the spreadsheet.
  4. Use spreadsheet skills to value stocks, bonds, portfolios, and cost of capital.
  5. Use spreadsheet skills to perform capital budgeting analysis.
  6. Perform sensitivity analysis, scenario analysis, and Monte Carlo simulation of capital budgeting results in spreadsheet.
  7. Understand Basic Visual Basic for Application (VBA) programming.

Course Evaluation Process

Grading Scale:

Your letter grade is determined using the grade distribution that follows. You can calculate your percentage grade at any time in the semester by dividing the points you have accrued by the total points available up to that point. This percentage is then matched to a letter grade.

A 90% or higher
B 80 to 89%
C 70 to 79%
D 60 to 69%
F Less than 60%

Course Assessments:

CLASS PARTICIPATION100 points
QUIZZES AND HOMEWORK200 points
INDIVIUAL MIDTERM PROJECT200 points
TEAM FINAL PROJECT200 points
FINAL EXAM300 points

CLASS PARTICIPATION

Attendance with preparation is expected. Absences without instructors permission will result in loss of points in this category. Arriving late and leaving early without notice may be counted as half absence. Students who must leave early because of emergency or acceptable reasons are expected to notify the instructor at the earliest time possible. Students are expected to participate in various class discussions and activities in a constructive manner, so each students contribution to the class will be evaluated regularly. Learning objectives 1 through 7

QUIZZES AND HOMEWORK

Regular quizzes and homework is very important for this course. As the best learning process, class quizzes and homework will help you understand contents of each chapter much better. The instructor will assign quizzes and homework for the selected chapters covered in this course. Full participation of quizzes and homework is strongly encouraged (extra credit will be given). Learning objectives 1 through 7

INDIVIUAL MIDTERM PROJECT

Students are required to complete an individual midterm project. You are required to use the financial modeling skills to solve some financial problems assigned by the instructor in the middle of the class. You will receive a separate set of instructions for the project. Learning objectives 1 through 7

TEAM FINAL PROJECT

Topic: Use Financial Modeling to solve a real-world financial/business problem Financial Modeling course is designed to make a connection between textbook finance and the problems of real-world business. It helps MBA students to build spreadsheet programs and solve a wide range of real-world financial problems. In this team final project, you and your team members are required to employ the financial knowledge and modeling skills learned from this class to identify and solve a real-world financial/business problem. You will receive a separate set of instructions for the project. Learning objectives 1 through 7

FINAL EXAM

The final exam is comprehensive. It will cover all contents which the instructor discussed in class. The exam will consist of multiple-choice questions, essay questions and problems. Learning objectives 1 through 7

Reading Assessments

Your capacity to contribute to class discussions is directly related to your commitment to completing all reading assignments by the dates listed on the course schedule. Class participation grades will reflect both the quantity and the quality of your participation.

Makeup Exams

Make-up exams will only be given at the discretion of the instructor. Students are strongly cautioned to notify the instructor immediately if legitimate and insurmountable obstacles prevent them from participating in a scheduled exam session.

Late Assignments

The due dates for all assignments will be strictly followed. Late assignments may or may not be accepted at the instructor’s discretion; should the instructor accept a late assignment, he or she may reduce the grade of the assignment the equivalent of one (1) letter grade for each day the assignment is late.

Attendance Policy

According to the UHV Student Handbook, students are expected to be diligent in their studies and regular in class attendance. A student whose absences are determined by the instructor to be excessive shall be dropped prior to the last day to drop a course or withdraw from UHV with a grade of W or F. For students enrolled in online courses, "absence" connotes a failure to engage in class participation activities on a weekly basis. If an unforeseen crisis (including family emergencies, professional obligations, and technical difficulties) prevents you from fulfilling your course obligations, you are responsible for alerting your instructor to the reason for and anticipate duration of your absence.

Teaching and Learning Partnership

Teaching and learning is a partnership between faculty and students. I will fulfill my partnership obligations by serving as advisor, consultant, mentor and purveyor of general comments and clarifications of difficult or confusing concepts. To this end, I will respond to questions within 72 hours.  You will fulfill your partnership obligations by being a fully participative, responsive, helping, and working team member of the class.  You should check your UHV email frequently and respond to faculty in a timely fashion. Good business and professional etiquette is expected. No derogatory comments should be made. You may certainly disagree with others in class discussions, and you may state your disagreement (if you choose to); however, please do so in a polite manner.

Homework, take-home exams, case assignments and bulletin board participation all play an important role in your education in this course. They are an essential part of the learning process in that they require the synthesis and extension of concepts. They also help both the student and the instructor to evaluate one’s progress in mastering the material. Past experience indicates that generally the course material cannot be adequately mastered without active involvement on your part.

Discussion of homework assignments with others who are also struggling with them can be highly beneficial and is encouraged. Most real-life problems are solved through team efforts, and it is important to learn how to solve problems cooperatively. The interaction with others working on the same problem often reveals different approaches to common difficulties.

Academic Honesty

Each student is responsible for maintaining high standards of academic honesty and ethical behavior. In order that each student understands what is (or is not) acceptable behavior, the following guidelines are offered.

  • Discussion of assignments with other students and members of the faculty is both permitted and encouraged as a constructive educational practice.
  • Students are expected to write their exams, quizzes and papers on their own, based on their individual level of progress with the material.
  • Copying of another’s work and representing it as one’s own work is a serious academic offense, and will be treated as such.
  • Students are encouraged to review materials other than those required for the course in preparing assignments, but should always properly cite any sources used in assignment preparation.

UHV’s Student Handbook contains a detailed description of the university’s Academic Honesty Policy. In addition, tutors at the Academic Center (see section below) are available to assist you in providing proper citations for your source materials.

Disabled Student Policy

The University of Houston System complies with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, pertaining to the provision of reasonable academic adjustments/auxiliary aids for students with a disability. In accordance with Section 504 and ADA guidelines, each University within the System strives to provide reasonable academic adjustments/auxiliary aids to students who request and require them. If you believe that you have a disability requiring academic adjustments/auxiliary aids, please contact your University’s student disability services center. University of Houston–Victoria, Office of Disability Services, 3007 N. Ben Wilson St., Suite 133-B University West, Victoria, TX 77901. Office phone – 361-570-4287; E-mail worleyc@uhv.edu; Website - www.uhv.edu/DisabilityServices

Student Absences on Religious Holidays

Per Texas state law, students will be excused from attending class and other required activities, including examinations, for the observance of a religious holy day, including travel for that purpose. A student whose absence is excused on these grounds will be allowed to take an examination or complete an assignment within one (1) week of the excused absence.

Sexual Harassment

Students who feel they are the victims of sexual harassment may contact the Associate Vice President for Student Affairs at 361-570-4290 and/or the Director of Human Resources/Affirmative Action at 361-570-4800.

Grievance Procedures

Students who have non-academic grievances or complaints may contact Student Services at 361-485-4409.

Student Success Center Services

The Student Success Center offers writing assistance to all UHV students in the form of paper reviews by peer tutors. Tutors will aid students in looking more critically at their own writing to examine issues such as organization, structure, and development of ideas. To submit a document for online tutoring, or to schedule an appointment for face-to-face tutoring, please visit the Student Success Center online http://uhv.mywconline.com/. For more information about the Student Success Center and its library of online resources, visit the Center's Web site at http://www.uhv.edu/ac or stop by Suite 129 (University West in Victoria).