Faculty of Technical Sciences

Subject: Financial Modeling (17.IMS442)

Native organizations units: No data
General information:
 
Category Professional-applicative
Scientific or art field Menadžment i investicije u inženjerstvu
Interdisciplinary Yes
ECTS 5
Educational goal:

Train students for advanced use Excel in financial reporting

Educational outcome:

Students will be able to make a comparative analysis of the balance sheet, generate reports in excel and to make predictions of future business achievements.

Course content:

Introduction to the basic functions of Excel Using ADD / INS model Creating Pivot Table Creating a chart analysis of financial statements in Excel practical example of financial plan-making techniques of the financial statements in Excel

Teaching methods:

Lectures, exercises, consultations.

Literature:
Authors Title Year Publisher Language
Sengupta Chandan Financial Modeling Using Excel and VBA 2004 Wiley & Sons, NY English
Dr Ranko Bojanić Materijal sa predavanja 2013 FTN, Novi Sad Serbian language
Benninga, Simon inancial Modeling 2000 MIT Press, Cambridge English
Knowledge evaluation:
Course activity Pre-examination Obligations Number of points
Lecture attendance Yes Yes 5.00
Written part of the exam - tasks and theory No Yes 70.00
Term paper Yes Yes 20.00
Exercise attendance Yes Yes 5.00
Lecturers:
API Image

prof. dr Bojanić Ranko

Full Professor

Practical classes
API Image

prof. dr Bojanić Ranko

Full Professor

Lectures

Faculty of Technical Sciences

© 2024. Faculty of Technical Sciences.

Contact:

Address: Trg Dositeja Obradovića 6, 21102 Novi Sad

Phone:  (+381) 21 450 810
(+381) 21 6350 413

Fax : (+381) 21 458 133
Emejl: ftndean@uns.ac.rs

© 2024. Faculty of Technical Sciences.