|Course Number||FINC 6363 - 22489|
|Course Title||Financial Modeling|
|Prerequisites||FINC 6352, which may be taken concurrently|
|Office Hours||Mon 9AM-11AM; 1PM-3PM Virtual Office Hours; Thursday 6:00pm~7:00pm CR & UHVC or by appointment|
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.
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).
Mayes, T.R. and Shank, T.M., Financial Analysis with Microsoft Excel, 6th (2011) ed., South-Western College Publishing, ISBN 978-1111826246(Required)
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:
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.
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:
As a result of this course, students will:
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%|
|CLASS PARTICIPATION||100 points|
|QUIZZES AND HOMEWORK||200 points|
|INDIVIUAL MIDTERM PROJECT||200 points|
|TEAM FINAL PROJECT||200 points|
|FINAL EXAM||300 points|
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
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
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
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
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
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.
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.
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.
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 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.
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.
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.
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 email@example.com; Website - www.uhv.edu/DisabilityServices
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.
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.
Students who have non-academic grievances or complaints may contact Student Services at 361-485-4409.
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).