In: Finance
Required
| Expected Return of BIT PLC=R1 | 18% | |||||||
| Expected Return of DIMO PLC=R2 | 14% | |||||||
| S1=Standard Deviation of BIT PLC | 22.00% | |||||||
| S2=Standard Deviation of DIMO PLC | 20.00% | |||||||
| Variance of BIT PLC=V1=(S1^2) | 484.0 | %% | ||||||
| Variance of Stock DIMO PLC=V2(S2^2) | 400.00 | %% | ||||||
| Correlation | 0.60 | |||||||
| Covariance(1,2)=Correlation*S1*S2 | 264.00 | %% | ||||||
| Investment in BIT PLC=1000*6 | 6000.00 | |||||||
| Investment in DIMO PLC=4000*4 | 16000.00 | |||||||
| Total Investment | 22000.00 | |||||||
| w1=Investment in BIT PLC=6000/22000 | 0.27272727 | |||||||
| w2=Investment in DIMO PLC=16000/22000 | 0.72727273 | |||||||
| Portfolio Return=Rp(Percentage) | ||||||||
| w1*R1+w2*R2=w1*18+w2*14= | 15.09% | |||||||
| Vp=Portfolio Variance=(w1^2)*V1+(w2^2)*V2+2*w1*w2*Cov(1,2) | 352.2975207 | %% | ||||||
| Vp=Portfolio Variance=(w1^2)*484+(w2^2)*400+528*w1*w2= | ||||||||
| Sp=Portfolio Standard Deviation=Square root of Variance=SQRT(Vp) | 18.77% | |||||||
| Rf=Risk free Rate=8% | ||||||||
| PORTFOLIO A Return | 15.09% | |||||||
| PORTFOLIO A Standard Deviation | 18.77% | |||||||
| Risk Free Asset Return | 8.00% | |||||||
| Risk Free Asset Standard Deviation | 0.00% | |||||||
| New Portfolio(P) Return=w1*15.09+w2*8 | ||||||||
| New Portfolio(P) Variance=(w1^2)*(18.77^2) | Covariance=0 | |||||||
| New Portfolio(P) Standard Deviation= Square Root (VariancE=e) | ||||||||
| ALL POSSIBLE PORTFOLIOS | ||||||||
| w1 | w2 | RP=w1*15.09+w2*8 | VP=(w1^2)*352.2975 | SP=Square Root(Vp) | ||||
| Weight of | Weight of | |||||||
| Portfolio A | Risk Free Asset | New Portfolio Return(%) | Portfolio Variance(%%) | Portfolio Standard Deviation | Portfolio Return | |||
| 0 | 1 | 8 | 0.0000 | 0.00% | 8.00% | |||
| 0.1 | 0.9 | 8.709 | 3.5230 | 1.88% | 8.71% | 
![]() ![]()  |