Dr. Hesham Merdad
King Fahd University of Petroleum and Minerals
College of Industrial Management
Department of Finance & Economics
Computer Applications in Finance – FIN 425 Section(s) 01(02) Course Syllabus – Term (122)
Hesham Jamil Merdad
B.Sc., M.S in Fin, M.S in Fin. Econ., Ph.D. in Fin. Econ.
+ (966) 380 - 7868
and/or by appointment
To set up an appointment with me, please send me an email at least 48 hours before the meeting time. Explain in the email in as much detail as you can about what you would like to discuss
1) learning can be fun 2) theories are taught to be applied in real life 3) the best way to learn is to try
Mode of communication:
I respond very well to emails as long as you follow the following instructions:
o All e-mails must originate from Blackboard email using
the following title format: FIN425-section Name-Subject
(e.g., FIN425-01 Hesham Merdad-question on
homework # 3).
o As a general rule, if I don’t reply to your email in two days, I did not receive it. In that case you need to re-send the e-mail again.
o Blackboard is an official communication platform. It is
your responsibility to watch for announcements and
emails on a daily basis.
Page 1 of 7
Dr. Hesham Merdad
Computer Applications in Finance (Financial Modeling)
FIN 425 (3 credit hours)
Section 01 (CRN 20504)
Section 02 (CRN 24616)
Section 01 UT 8:30 am to 9:45 am, Bld 24 room 236
Section 02 SM 1:10 pm to 2:25 pm, Bld 24 room 236
Financial Analysis with Microsoft Excel
5th edition by Timothy R. Mayes & Todd M. Shank
South Western Publication 2010
Financial calculator such as Taxes Instruments BAII PLUS.1
Good computer skills, analytical and critical thinking skills
This course is an application of computer software in
formulating and analyzing problems in finance.
Thus, encourages the use of sensitivity and “what if” projections in: financial statement analysis, capital
budgeting, cash flow projections, risk analysis, working
capital management, capital structure, financing decision,
leasing, foreign exchange forecasting, valuation of securities, investment analysis and portfolio management, and
applications of quantitative methods in finance.
Also, develops and implements practical financial modeling skills for purposes of financial planning and decision
making. The course is intended to enhance student skills in
the development of various types of spreadsheet-based
1. To reinforce fundamental principles and theories of finance learned in FIN 301 and FIN 302 using excel.
2. Lean and develop spreadsheet-building skills in order to
encourage students to think and truly understand the
problems on which they are working rather than just using
“plug and go” templates.
This course assumes successful completion of FIN 302
This is a compulsory course for Finance major and an elective course for other CIM majors to fulfill the part of the program objectives
It is expected by now that all of you master the usage of the calculator. Thus, in this course, there will be no great emphasis on the calculator because almost all calculations will be done using spreadsheets. However, it is recommended that you bring your calculators with you in every class in case we need to do any calculations. Any calculator that has an IRR function will do and I will post relatively brief, coursespecific manuals for the leading calculators.
Page 2 of 7
Please join StudyMode to read the full document