Deskripsi

Jon Mjolhus is an associate professor/senior lecturer at University of South-Eastern Norway. He received his master’s degree in business administration from Norwegian School of Economics, (NHH), with a major in finance from Stockholm School of Econom- ics. He also holds master’s degrees in financial economics from Norwegian Business School (BI) and in real estate management from KTH Royal Institute of Technology in Stockholm. Financial modelling is a “real life” and practical course. Although some theory will be explained, students are expected to have a basic understanding of finance (i.e. completed an introductory course in finance) before signing up for this course. This course offers students the possibility of mastering finance using the powerful spreadsheet program Excel. We look at the financial for- mulas embedded in the Excel program problem solving in finance and build some formulas ourselves. The students will learn how to use Excel for portfolio optimization, valuation of financial instruments and risk management.