COMPUTER APPLICATIONS FOR FINANCE

Course Description

The course briefly introduces the popular spreadsheet software Microsoft Excel. It allows users to create rich, stylized spreadsheets to store, organize, sort, calculate, and graph data. The focus of the course is designed to help students use concepts learned in other courses in a spreadsheet environment. Furthermore, course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modelling or new starters for spreadsheet programming. Especially topics covered include basics of spreadsheet programming, graphing and scheduling, financial and statistical functions, Goal Seek and Solver add-in functionality. The course finally will focus on the efficient usage of date functions.

COMPUTER APPLICATIONS FOR FINANCE

Evaluation Tools (Active Term)

Course outcomes

No course outcomes have been defined yet.

Course Syllabus

Reference Books & Course Materials

1. 01 Benninga, S., & Mofkadi, T. (2018). Principles of Finance with Excel (3rd Edition). Oxford University Press.

Learning Outcomes

1. L01 Demonstrate proficiency in Excel by starting the application, creating, saving, and organizing files in new folders; understanding the difference between relative and absolute cell references; formatting numerical data; creating charts and graphs; and effectively implementing mathematical, conditional, text, and statistical functions. SOLO 4
2. L02 Differentiate and Implement Data Tables (One dimensional vs Two Dimensional Datatables), Goal Seek and Solver SOLO 4
3. L03 Differentiate and Implement time value of money functions(PV, FV, Rate, SUM and Goal Seek) SOLO 4
4. L04 Differentiate and Implement Capital Budgeting functions (IRR, MIRR, PMT, RANK, NPV and IF) SOLO 4
5. L05 Differentiate and Implement Loan amortization basics and Excel functions such as PMT, PV, NPV, IPMT and PPMT SOLO 4

Program Outcomes

1. P01 1. Gained the necessary skills to learn and adopt a spirit of continuous learning in their professional life.
2. P02 2. Developed various skills by working independently via specific learned techniques that both triggered individual efforts and encouraged collaborative work.
3. P03 3. Acquired the essential knowledge and skills to apply key theories, models and applications within the global business context.
4. P04 4. Adopted and applied critical and strategic thinking together with research capabilities for efficient and effective business decisions.
5. P05 5. Utilized and managed ethically information technologies required for contemporary business world.
6. P06 6. Been equipped with conceptual and analytical skills necessary for team work within global organizations.
7. P07 7. Displayed their learnt communication skills that are required to effectively interact in a cross cultural and diverse international work environment.
8. P08 8. Applied their acquired knowledge within the changing work environment.
9. P09 9. Developed an understanding of ethical perspectives and social responsibilities to be used at work and in personal life.

Po-Lo Matrix