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- To have advanced theoretical and practical knowledge supported by textbooks, application tools and other resources including current information in the field of Accounting and Finance.
2. P02 2- To be able to use advanced theoretical and practical knowledge acquired in the field of Accounting and Finance.
3. P03 3- To be able to interpret and evaluate data, identify problems, analyze and develop solutions based on research and evidence by using advanced knowledge and skills acquired in the field of Accounting and Finance.
4. P04 4- To be able to take responsibility as an individual and a team member in order to solve complex and unpredictable problems in accounting and finance applications.
5. P05 5- To be able to plan and manage activities for the development of employees under the responsibility of a project.
6. P06 6- To be able to determine the learning requirements in the field of Accounting and Finance and to direct their learning.
7. P07 7- To be able to inform people and institutions about issues related to the field of accounting and finance, and to be able to transfer their ideas and solution proposals in writing and orally.
8. P08 8- To be able to use information and communication technologies together with computer software at the European Computer Driving License Advanced Level required by the field of Accounting and Finance.
9. P09 9- To act in accordance with social, scientific, cultural and ethical values in the stages of collecting, interpreting, applying and announcing the results related to the field of accounting and finance.

Po-Lo Matrix