can you please do this in excel and show your formulas and working?

Model 2b: Security Contribution to Risk and Ketum Calculate the contribution of each individual stock in your dynamic portfolio to the portfolio's fully hedged realized risk and return. Both contributions should be displayed in a table and a pie chart, which should update when the user changes portfolio weights and time-periods. Your model should also indicate to the user whether each individual stock over-or under-contributes to portfolio return relative to its contributed risk. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Time Period & 1yr Phior. & & Fully Unhedgod & & & & & & & & \\ \hline Pendtangrk index. & SP500-SPX (US) & & Partindly Hedood & & & & & & & & \\ \hline Index Retum & 0.007576655 & & & & & & & & & & \\ \hline iwetights must equal 1 & & & & & & & & & & & \\ \hline \begin{tabular}{l} Securby 1 . \\ Weiphi of Securth \end{tabular} & V2us & \begin{tabular}{l} Security 2. \\ Weiphe \end{tabular} & NFLX-US & 1 & \begin{tabular}{l} Security 3. \\ Weight \end{tabular} & EAUS & 02 & \begin{tabular}{l} Security 4. \\ Weinhtil \end{tabular} & \begin{tabular}{r} WED-US \\ 02 \end{tabular} & \begin{tabular}{l} Security 5 . \\ Weight \end{tabular} & \begin{tabular}{r} LAC-CA \\ 02] \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Fully Hedged & & & & & & & & & & Portfolio performance \\ \hline Monthly Arithmatic Retum & .0 .021256099 & & 0034216007 & & -0.001397395 & & -0.005366551 & & -0.0045025 & 0.12% \\ \hline Monthly Standard Deviavion & 0,057245711 & & 11.105425207 & & 0,016)7474 & & 0.embeth & & 6,01751642 & 4.50% \\ \hline 99% confistence interval & 0.042566346 & & & & 0.01214615 & & 0.02465717 & & Q.e23e249? & 0.034097781 \\ \hline Monthy Tracking Error & + & * & - & * & & * & + & & . & 0.00029266 \\ \hline Monthly Infomation Ratio & - & + & - & + & & - & & & - & 21.80722147 \\ \hline Monthly LPSD (Downside Risk) & 0.065766338 & & 0.062255017 & & 0.01564305 & & (0.e2)15914 & & e.e2e26788 & 0.035426285 \\ \hline Annual Arithmatic resurn & -0.227258656 & & 4,7515 seds5 & & -0.0.11848 & & -3.2574786 & & -0.1187912 & \\ \hline Annualized standard devision & 0.198303574 & & 0.363817983 & & 0.05658519 & & 0.11497922 & & Q. .06967864 & \\ \hline 99% interval & 0.147454149 & & 0.270527005 & & e. 0420755 & & 0.05541495 & & 0.0451193 & \\ \hline Annualzed Geo. Mean & & & & & & & & & & \\ \hline Annuabized Sortino Rasio & & & & & & & & & & \\ \hline Annualiced Sharpe Ratio & & & & & & & & & & \\ \hline Annualized Treynor Rato & & & & & & & & & & \\ \hline Annual sed Jensen's Apha & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline \end{tabular}