The alternative risk measures in Excel

The paper examines the alternative risk measures and portfolio selection with alternative risk measures. The paper follows from student's activities in the subject of financial modeling, precisely in the modern portfolio theory. As many weaknesses of Markowitz mean-variance model have been noti...

Full description

Saved in:
Bibliographic Details
Main Authors: Aljinović, Zdravka, Marasović, Branka, Vidović, Jelena
Format: Conference Proceeding
Language:English
Subjects:
Application software
Concrete
Finance
Financial management
Mathematical model
Portfolios
Reactive power
Risk analysis
Risk management
Student activities
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The paper examines the alternative risk measures and portfolio selection with alternative risk measures. The paper follows from student's activities in the subject of financial modeling, precisely in the modern portfolio theory. As many weaknesses of Markowitz mean-variance model have been noticed, primarily in the sense that variance isn't appropriate risk measure when distribution of stock returns isn't normal, the alternative risk measures have to be introduced. The problem is how to present relatively complex portfolio optimization models with alternative risk measures to students' population and to teach them how to realize those models using Excel. In this paper, the alternative risk measures which attracted significant attention of financial managers last years together with Excel's formulations of analytical expressions are introduced. The presented risk measures are lower-semi variance, lower semi-absolute deviation, Value at Risk (VaR) and Conditional Value at Risk (CVaR). That is followed by construction of models for portfolio selection based on different risk measures together with Excel solutions. All theoretical settings are accompanied with illustrative examples.