# Portfolio Analysis - Finance mba work

The work is on portfolio/security analysis... The following are the requirements:

The way to do the calculations are as follows: (given by the client's prof)

Return = ( close - open )/open.

2- average =Average( select return cul )

Average can't be by - you have to change the stock

3- Std = StdEV.s ( select return cul)

4- veriance = Var.s( select return Cul)

5- correlation ( don't need for tasi)

RS1 & S2 =CORREL( HPR s1, HPR s2)

6- covariance ( covariance by - is better)

= coveriance.S( Tasi ( Market), S1)

7-beta = Cov Mkt 1 &s1 / veriance mKT ( Tasi)

1- risk free find it from tasi

2- R^ s1 = risk free + beta *( average( Tasi ) -risk free)

Tell us require of return for 3 stocks

3- expected - require = average - require

( Surplus )

Require is R ^ answer

4- % = exp- require * 100

Just take the answer by percentage

7-expected portfoilo = ( average * wight1 )+ ( average * wight2 ) + ( average + wight 3)

8- beta portiofolio = ( beta 1 * wight ) + ( beta 2 * wight ) + ( beta 3 *wight )

9-R^ portfolio = Rf+beta portfolio * ( average tasi - Rf)

Make sure

10- Variance portfolio:

Var= w1^2 * stand^2 + w2^2 * Stand^2 +

W3^2 *stand^2 + 2 * w1*w2 * cov

1&2 + 2 w1 * w3 * cov 1&3 + 2 w2*

W3 * cov 2&3

11- Std portfolio =sq( var portfoilo)

12- exp. req. = expected portfolio- require of portfolio

13- %. = answer *100

Make sure for weight I put it :

Change wight to get better answer in sharp ration

Make sure the total of wight = 1

Skills: Finance

( 93 reviews ) Jeddah, Saudi Arabia

Project ID: #16738909

## 20 freelancers are bidding on average \$122 for this job

charleslimnet

Dear esteemed client, I possess exceptional finance skills and experience. I have successfully completed over 2000 related projects and the responses are positively overwhelming as you can see from my reviews. I hold More

\$180 USD in 3 days
(178 Reviews)
6.8
ACMAuk

I am Chartered Management Accountant from Chartered Institute Of Management Accountant UK and Chartered Global Management Accountant from American Institute of CPAs having 6 years of experience in Portfolio Analysis. More

\$150 USD in 3 days
(163 Reviews)
6.6
hilaloo86

Dear Sir/Madam, I truly believe I am an excellent fit for the task at hand. I hold a Master in Finance from the University of Texas and a Bachelor in Business Administration. In addition to the technical knowledge I More

\$227 USD in 3 days
(42 Reviews)
5.9
\$50 USD in 1 day
(80 Reviews)
5.7
jamalagouram

السلام عليكم I hope that you can give this work

\$55 USD in 5 days
(9 Reviews)
4.5
Krazah

Dear client, I have gone through your project description and everything is quite clear to me. I am a very proficient and experienced MBA holder. I have all it will take to execute this project to your ultimate satisfa More

\$66 USD in 3 days
(29 Reviews)
4.6
jkc2018

Hi there, I can do your job. Please share your full fledged questions. Regards, Jeetendra Chaurasia

\$111 USD in 3 days
(16 Reviews)
4.0
\$30 USD in 3 days
(5 Reviews)
3.3
DRIsaac

I am an excellent writer with longstanding experience writing business-related articles. I am convinced that given my skills and knowledge, I can deliver perfect job on this project.

\$155 USD in 3 days
(4 Reviews)
3.3
salikgondal

I have masters in finance and able to handle this project. Let me assist you in this as per your requirements.

\$250 USD in 5 days
(6 Reviews)
3.4
erengulk

Hi I worked as an equity research analyst for many years and very willing to work with you on this project. Looking forward to hear from you soon.

\$155 USD in 3 days
(1 Review)
2.3
MicroS0FT

Hello, can we discuss more on yourPortfolio Analysis project. I have substantial knowledge in this field and I can deliver a high quality paper to you on time. I work on all the papers personally unlike my competitors More

\$250 USD in 4 days
(0 Reviews)
0.0
sekharnandymba

A proposal has not yet been provided

\$35 USD in 1 day
(0 Reviews)
0.0
\$155 USD in 3 days
(0 Reviews)
0.0
ruslanbalabko

A proposal has not yet been provided

\$111 USD in 3 days
(0 Reviews)
0.0
Shabbiawan

If you hire me it will be a great platform to show case my [login to view URL] [login to view URL] ability and my experience whatever goals i set and I will complete them within an stipulated time. Relevant Skills and Experience I have More

\$155 USD in 3 days
(0 Reviews)
0.0
nezhelskiy

Young finance professional with research-oriented data science background and experience in equity day trading. I worked for an year in a hedge fund valuing public companies. Currently I do my PhD in Finance. So I can More

\$133 USD in 1 day
(0 Reviews)
0.0
Avisheka

MBA Finance from a reputed institute and well versed with all the metrics as mentioned in the project. Can do this project right away for you, if awarded. Let us discuss further further. Regards, Avishek

\$35 USD in 1 day
(0 Reviews)
0.0
jjdewet

A proposal has not yet been provided

\$111 USD in 2 days
(0 Reviews)
0.0
BChang

A proposal has not yet been provided

\$35 USD in 2 days
(0 Reviews)
0.0