Lifelong Learning for a Brighter World

female business professionals looking at a computer screen female business professionals looking at a computer screen

Business Administration

Get down to business.

Grow your career in business and management

BUS 490 - Financial Modelling & Analysis C21

Academic Credit Value:
3 units
Course Delivery Mode:
Online
Hours of Study:
39 hours
Course Prerequisite(s):
N/A
Course Anti-requisite(s):
N/A
Instructor Name:
Jeff O'Leary
Course Dates:
09/13/2021 - 12/12/2021



Required Course Materials:
Excel Modeling in Corporate Finance. Holden, Craig. 5th Edition. Pearson
Optional Course Materials:
N/A
Course Description:
The Financial Modeling course is different from many other courses as you have already studied the theory behind the material in the pre-requisite courses and your objective in this course is to learn how to use Excel to represent those theoretical financial concepts. You will find the text is more of a workbook to assist you in organizing the material and producing spreadsheets that allow “what if” scenarios to assist in decision-making.
Learning Outcomes:
Upon completion of this course, students will:

- Gain a broad understanding of basic modeling techniques
- Improve their Excel modeling skills
- Improve critical thinking skills as to applications of the material
- Learn that Excel provides multiple methods for performing certain analyses
- Gain an appreciation of the errors and dangers that may arise during modeling, and their effects on decision making
- Recognize the most frequently used theories, models and their applications to obtain solutions to financial problems
- Understand the limitations of current theories and practical applications
Course Evaluation

The final grade is calculated based on the following components:

Learning Journal (8):       32%
Assignments (8):              40%
Final Examination:           28%
Total Marks:                    100%

Learning Journal
The goal of this assignment is self reflect on your excel modelling skills as you complete each module of the course.  By reflecting on your progress, you will better understand how you are improving and where you need to refine your skill sets to see further improvement upon the next module.

Assignments
The goal of this assignment is to test your ability to model the assignment question and solution in Excel.  Each assignment is drawn from the textbook and you will be required to attempt each first and then once submitted, a template will be provided that will help you master the appropriate formulas and approach for the particular question(s).

Final Examination
The goal of this assignment is to test your mastery of the Excel concepts as practiced in the prior modules.  A series of questions will be provided, and you will have period of time to answer the questions and submit for feedback.

Course Format:
This course is designed to present the fundamental concepts and theories in business finance and promote the application to the workplace and professional practice. Course activities will include instructor presentations, required readings and experiential learning activities (i.e. case studies, group discussions, projects, etc.).
Assignment Submission:
Course assignments are submitted to the appropriate A2L Assignment folder by the specified due date
Late Coursework:
Late assignments will be subject to a 2% per day late penalty (includes weekends and holidays) for up to seven (7) days. After this date, no assignments will be accepted and a grade of zero (0) will be applied.  Extensions for course work must be approved by the instructor before the due date (see Academic Regulations below), and will be granted for illness or emergencies only. Students may be asked to submit supporting documentation for an extension request. 

Policy & Procedures:

Academic Regulations (Attendance, Coursework, Tests/Exams):
In accordance to McMaster University’s General Academic Regulations, “it is imperative that students make every effort to meet the originally scheduled course requirements and it is a student’s responsibility to write examinations as scheduled.” Therefore, all students are expected to attend and complete the specific course requirements (i.e. attendance, assignments, and tests/exams) listed in the course outline on or by the date specified. Students who need to arrange for coursework accommodation, as a result of medical, personal or family reasons, must contact the course instructor within 48 hours days of the originally scheduled due date. It is the student’s responsibility to contact the Program Manager to discuss accommodations and procedures related to deferred tests and/or examinations within 48 hours days of the originally scheduled test/exam, as per policy. Failure to contact the course instructor, in the case of missed coursework, or the Program Manager, in the case of a missed test/examination, within the specified 48-hour day window will result in a grade of zero (0) on the coursework/exam and no further consideration will be granted.

*Note: Supporting documentation will be required but will not ensure approval of accommodation(s).
Academic Integrity
You are expected to exhibit honesty and use ethical behaviour in all aspects of the learning process. Academic credentials you earn are rooted in principles of honesty and academic integrity. Academic dishonesty is to knowingly act or fail to act in a way that results or could result in unearned academic credit or advantage. This behaviour can result in serious consequences, e.g. the grade of zero on an assignment, loss of credit with a notation on the transcript (notation reads: “Grade of F assigned for academic dishonesty”), and/or suspension or expulsion from the university.

It is your responsibility to understand what constitutes academic dishonesty. For information on the various types of academic dishonesty please refer to the Academic Integrity Policy, located at http://www.mcmaster.ca/academicintegrity/

The following illustrates only three forms of academic dishonesty:
  1. Plagiarism, e.g. the submission of work that is not one’s own or for which other credit has been obtained.
  2. Improper collaboration in-group work.
  3. Copying or using unauthorized aids in tests and examinations.
Academic Accommodations:

ACADEMIC ACCOMMODATION OF STUDENTS WITH DISABILITIES

Students with disabilities who require academic accommodation must contact Student Accessibility Services (SAS) at 905-525-9140 ext. 28652 or sas@mcmaster.ca  to make arrangements with a Program Coordinator. For further information, consult McMaster University’s Academic Accommodation of Students with Disabilities policy.

Academic Accommodation for Religious, Indigenous or Spiritual Observances (RISO)

Students requiring academic accommodation based on religious, indigenous or spiritual observances should follow the procedures set out in the RISO policy. Students will need to contact their instructors as soon as possible to make alternative arrangements for classes, assignments, and other coursework. It is the student’s responsibility to contact McMaster Continuing Education to discuss accommodations related to examinations. (if applicable)

On-line Elements:

Conduct Expectations:

As a McMaster student, you have the right to experience, and the responsibility to demonstrate, respectful and dignified interactions within all of our living, learning and working communities. These expectations are described in the Code of Student Rights & Responsibilities (the “Code”). All students share the responsibility of maintaining a positive environment for the academic and personal growth of all McMaster community members, whether in-person or online.

It is essential that students be mindful of their interactions online, as the Code remains in effect in virtual learning environments. The Code applies to any interactions that adversely affect, disrupt, or interfere with reasonable participation in University activities. Student disruptions or behaviours that interfere with university functions on online platforms (e.g. use of Avenue 2 Learn, WebEx or Zoom for delivery), will be taken very seriously and will be investigated. Outcomes may include restriction or removal of the involved students’ access to these platforms.

Copyright and Recording:

Students are advised that lectures, demonstrations, performances, and any other course material provided by an instructor include copyright protected works. The Copyright Act and copyright law protect every original literary, dramatic, musical and artistic work, including lectures by University instructors.

The recording of lectures, tutorials, or other methods of instruction may occur during a course. Recording may be done by either the instructor for the purpose of authorized distribution, or by a student for the purpose of personal study. Students who wish to record sessions need to acquire permission from the instructor. Students should be aware that their voice and/or image may be recorded by others during the class. Please speak with the instructor if this is a concern for you.

Turnitin.com:
Course Changes:

The instructor reserves the right to modify elements of the course and will notify students accordingly.

Extreme Circumstances:

The University reserves the right to change the dates and deadlines for any or all courses in extreme circumstances (e.g., severe weather, labour disruptions, etc.). Changes will be communicated through regular McMaster communication channels, such as McMaster Daily News, A2L and/or McMaster email.

Course Withdrawal Policy:

Policies related to dropping a course and course withdrawals are posted to the Centre for Continuing Education’s program webpage, FAQs & Policies (https://www.mcmastercce.ca/cce-policies#Dropping).

Grading Scale:
Grade Equivalent
Grade Point
Equivalent Percentages
A+ 12 90-100
A 11 85-89
A- 10 80-84
B+ 9 77-79
B 8 73-76
B- 7 70-72
C+ 6 67-69
C 5 63-66
C- 4 60-62
D+ 3 57-59
D 2 53-56
D- 1 50-52
F 0 0-49
Course Schedule:

Module

Evaluations

Single Cash Flow

Read Chapter 1

Weekly Reflection Paper

Assignment #1 Due

Annuity

Read Chapter 2

Weekly Reflection Paper

Assignment #2 Due

NPV Constant Discounting

Read Chapter 3

Weekly Reflection Paper

Assignment #3 Due

Bond Valuation

Read Chapter 7

Weekly Reflection Paper

Assignment #4 Due

Stock Valuation

Read Chapter 9

Weekly Reflection Paper

Assignment #5 Due

Project NPV

Read Chapter 14

Weekly Reflection Paper

Assignment #6 Due

Corporate Financial Planning

Read Chapter 17

Weekly Reflection Paper

Assignment #7 Due

Dupont Ratio Analysis

Read Chapter 18

Weekly Reflection Paper

Assignment #8 Due

 

Final Exam