Asset Allocation & Optimization using Excel

Active investors want to take a deep dive through the investment allocation and optimization process without delving deep into mathematical equations and proofs. This module helps in understanding the concepts of portfolio theory and return and risk optimization.
This zip contains the following excel sheets-
1.Return Optimization using Efficient frontier concepts
2.Risk Optimization using Marginal VaR and Incremental VaR
3.Arbitrage Pricing theories applied on Indian Markets