Question: How do I solve this exercise in excel? Principal Component Analysis (PCA) is a stable and good way of calculating VaR on a portfolio using
How do I solve this exercise in excel?

Principal Component Analysis (PCA) is a stable and good way of calculating VaR on a portfolio using a model building approach There has been several attempts to estimate factors for a PCA analysis. The well known model, for a long period of time, below can be used Factor loadings Factor scores Question 2.3 What is the 99%10 day VaR for the portfolio using all three factors estimated in the PCA model Would you use all the factors in reality
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
