can you check my financial calculations?

For Visa (V) 7. Rate of Return B-views was used to calculate the sum of the dividend yield and capital gain. 6. Corering Historic Rate Premium The historic rate premium is used to determine whether a atock is underpriced or overpriced. RWYIT=RWz+HRP Where, HRP=HRwyTHRmTtal Therefore, Rworr=8.837% The expected return for Walmart is 8.837% and its historical risk premium is 9.837%. This means that the historical risk premium is higher than the expected retum and therefore, the company is overpriced. It is advised investors sell their atock in the compeny. Dividend Yield for V(DYv)=400 Dividend Yield for V(DYv)=.75% Capital Gain for V(CGV)=[VV(1)}V(1)1200 Capital Gain for V(CGV)=3.263% Rate of Retum (RV)= Dividend Yield for V(DYV)+ Capital Gain for V(CGv) Rate of Return (RV)=2.066+3.263=5.329% 8. Estimating Beta (Market Risk () ) The approximate beta () is determined through the rate of return of Johnson and Johnson (Ro) and the return of the market (RDja) DJA-DJRA(1)RDJAA=RDjA=8.872%Rv=4.246%Rv=v+vRwv+tv=1.072+0.590v=0.590DJMA=1 Dependent Variable: RWMT Method: Least Squares Date: 010/19/23 Time: 17:06 Sample (adjusted): Adjusted from January 1990 to August 2022 Included observations: 392 after adjustments 3. Expected Rate of Return Using CAPM equation E(RWMT)=RRF+WMT[E(RDJLA)RRF] Where, RRF=5.07%,E(RDJA)=8.545%,WNT=0.651 E(RWMT)=8.837% P=7,888.341P=88.816% 15. RVRP RVRP=E88.8162265.07(RP)PRRP 7. RVRp=0.243 Conclusion almart and Visa present interesting analysis of quantitative data that suggests that the two mpanies have been currently overpriced, thus, the need for investors to sell their stocks. Rate of Return E-views was used to calculate the sum of the dividend yield and capital gain. DividendYieldforWMT(DYWMT)=wMT400DividendYieldforWMT(DYWMT)=1.41% (WMT-WMT(-1)) Capital Gain for WMT (CGWMT)= WMT (1)1200 Capital Gain for WMT (CGWMT)=0.2 billion Rate of Return (RWMT)= Dividend Yield for WMT (DYWMT)+ Capital Gain for WMT (CGWMT) Rate of Return (RWMT)=1.890+6.947=8.837% Where,T=0.20Krwouc=12.6633.3(10.20)+87.3377.12=6.552% 11. Dividend Policy Batimating (lambda) will provide the dividend policy. Lambda()=0.30408 Obtaining the Pairwise Granger Causality tests, we reject the null kypothesis since FStatistic (1.8977) is greater than the probability (0.1513). Dependent Variable: RV Method: Least Squares Date: 10/19/23 Time: 17:12 Sample (adjuated): 100MMn 2021M09 Included observations: 381 after adjustments Kvs=E(Rv)=7.120% 12. Covering Historic Rate Premium The historic rate premium is used to determine whether a stock is underpriced or overpriced. Rv=RRF+HRP Where, HRP = HR vHR mimbill HRP=12.23.3=8.90% Therefore, Rv=5.329%+8.90% Rv=14.22% The expected return for Visa is 5.329% and its historical risk premium is 14.22%. This means that the historical risk premium is higher than the expected return and therefore, the company is overpriced It is advised investors sell their stock in the company. 13. Expected Return of Portfolio Expected Return for Visa (E(RV)): Initially stated as 5.329% Expected Return for Walmart (E(RWMT)): Calculated using CAPM as 7.332% Weighting of each stock: 50%WWMT=WV=50% (Equal weighting) The expected return of the portfolio (E(RP)) is calculated as the weighted average of the expected returns of Visa and Johnson \& Johnson. (7.120%)+(7.332%)=7.226%E(RP)=(7.120%)+(7.332%)=7.226% 2. Estimating Beta The approximate beta () is determined through the rate of return of WMT (RWMT) and the return of the market (RDJIA) RDJIA=DJIA(1)DJIADJIA(1)1200RDJIA=DJIA(1)DJIADJIA(1)1200RDJIA=8.545%RWMT=0.651.%RWMT=WMT+WMTRmt+tWMT=3.274+0.651WMT=0.651DJIA=1 14. Portfolio Variance This is calculated as PPP2PP=P2=(21)27453.257+(21)27846.302+2(21)(21)(88.693)(0.265)86.443=7,888.341=7,888.341=88.816% 5. RVRP RVRP=E2265.0788.816 4. Weighted Average Cost of Capital (WACC) KWACC=WdKd(1T)+WsKs+WpKpLongterminterest1Calculatingthecostofdebt(Kd)=-longtermdebt=DKWMTD=6.751%KWMTS=E(RWMT)=6.751% The value line, V=D+S will be used to estimate the weight. V=52.907+425=477.907billion 5. Dividend Policy Batimating (lambda) will provide the dividend policy. Lambda()=0.6254 Obtaining the Pairwise Granger Causality tests, we accept the wull hypothesis since the probability (0.5396) is greater than the F-Statistic (0.6179)