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 PO1: Engaged in insightful thinking leading to self-learning and lifelong learning.
2. P02 PO2: Established a general knowledge of economics sufficient to work independently through specific learned techniques generated via individual efforts and study.
3. P03 PO3: Reached the required knowledge and skills to understand social, economic and legal issues both within national, international and global contexts and apply theoretical knowledge of economics to practice.
4. P04 PO4: Adopted the ability to critically evaluate, analyze and interpret information gathered through the use of related statistical software programs to suggest creative solutions for economic problems and make relevant economic decisions.
5. P05 PO5: Been aware of gathering and analyzing data through the application of appropriate technological tools in an ethical and safe manner in order to generate economic decisions and policy suggestions.
6. P06 PO6: Been equipped with conceptual and analytical skills essential for team-working and collaborations for economic decision making for a variety of economic concepts in national and global environment.
7. P07 PO7: Endowed with both oral and written communication skills within the economic field to effectively study and work in an international environment
8. P08 PO8: Been able to transfer theoretical knowledge to real life economic environment: to generate policies for microeconomic and macroeconomic problems faced by individuals, firms and governments at national, international and global context.
9. P09 PO9: Developed an ability to apply economic analysis to everyday problems in real world through the development of ethical perspectives and social responsibilities at work and in personal life.

Po-Lo Matrix