Report Supriya.docx

  • Uploaded by: Poudel Narayan
  • 0
  • 0
  • December 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Report Supriya.docx as PDF for free.

More details

  • Words: 1,150
  • Pages: 5
Q) Suppose you have Rs. 10,00,000 to invest in stock market. Form different portfolio individually (You need to purchase at least 10 stocks that are traded in Nepal Stock Exchange for forming a portfolio). You are required to compute daily return on each stock included in your portfolio. Also compare your average portfolio return with NEPSE average return for your study period. •

Note while calculating daily return use 7 daystrading price. (Use SPSS or Excel program as per your convenience).



Prepare a report and submit.



Solution: First of all, let’s calculate average 7 day return from NEPSE index. S.N.

1 2 3 4 5 6 7 8

Date

31-Mar-19 28-Mar-19 27-Mar-19 26-Mar-19 25-Mar-19 24-Mar-19 21-Mar-19 19-Mar-19

NEPSE Value (in Rs)

HPR (in %)

1,143.59 1,143.10 1,142.61 1,140.72 1,138.67 1,134.80 1,140.60 1,147.15 Total HPR Average HPR

-0.042848 -0.042866 -0.165411 -0.179711 -0.33987 0.511103 0.574259 0.314657 0.044951

Therefore, the 7-day average NEPSE index return is 0.044951%. Note: Formula for HPR is, Holding Period Return (HPR) = (Final value of NEPSE index- Initial Value of NEPSE index)/ Initial Value of NEPSE index*100%

Now, we need to calculate the return from our portfolio. We have Rs. 10 lacs which we need to invest in 10 different listed companies in NEPSE. Our investment portfolio is given below: S.N.

Security Name Nepal Doorsanchar Comapany Limited

Symbol

2

Nepal Investment Bank Limited

NIB

3

Nabil Bank Limited

NABIL

4

Nepal Life Insurance Co. Ltd.

NLIC

5

Standard Chartered Bank Limited

SCB

6

Everest Bank Limited

EBL

7

Himalayan Bank Limited

HBL

8

NIC Asia Bank Ltd.

NICA

9

Nepal SBI Bank Limited

SBI

10

NMB Bank Limited

NMB

1

NTC

Total

Invested amount (Rs)

100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00

1,000,000.00

Weights

0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1

1

The portfolio return is calculated as below:

S.N.

Date

Security Name

Symbol

31-Mar-19

Nepal Doorsanchar Comapany Limited

NTC

2

31-Mar-19

Nepal Investment Bank Limited

NIB

3

31-Mar-19

Nabil Bank Limited

NABIL

4

31-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

31-Mar-19

Standard Chartered Bank Limited

SCB

6

31-Mar-19

Everest Bank Limited

EBL

7

31-Mar-19

Himalayan Bank Limited

HBL

8

31-Mar-19

NIC Asia Bank Ltd.

NICA

9

31-Mar-19

Nepal SBI Bank Limited

SBI

10

31-Mar-19

NMB Bank Limited

NMB

S.N.

Date

1

Security Name

Symbol

1

28-Mar-19

Nepal Doorsanchar Comapany Limited

NTC

2

28-Mar-19

Nepal Investment Bank Limited

NIB

3

28-Mar-19

Nabil Bank Limited

NABIL

4

28-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

28-Mar-19

Standard Chartered Bank Limited

SCB

6

28-Mar-19

Everest Bank Limited

EBL

7

28-Mar-19

Himalayan Bank Limited

HBL

8

28-Mar-19

NIC Asia Bank Ltd.

NICA

9

28-Mar-19

Nepal SBI Bank Limited

SBI

10

28-Mar-19

NMB Bank Limited

NMB

S.N.

Date

Security Name

Symbol

1

27-Mar-19

Nepal Doorsanchar Comapany Limited

NTC

2

27-Mar-19

Nepal Investment Bank Limited

NIB

3

27-Mar-19

Nabil Bank Limited

NABIL

4

27-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

27-Mar-19

Standard Chartered Bank Limited

SCB

6

27-Mar-19

Everest Bank Limited

EBL

7

27-Mar-19

Himalayan Bank Limited

HBL

8

27-Mar-19

NIC Asia Bank Ltd.

NICA

9

27-Mar-19

Nepal SBI Bank Limited

SBI

10

27-Mar-19

NMB Bank Limited

NMB

Closing Price in (Rs)

HPR(in %)

Portfolio Return (in %)

HPR(in %)

Portfolio Return (in %)

687 528 712 1093 565 561 458 400 387 328 Closing Price in (Rs)

685 530 714 1099 568 558 460 398 391 327 Closing Price in (Rs)

-0.291121 0.15791228 0.3787879 0.2808989 0.5489478 0.5309735 -0.534759 0.4366812 -0.5 1.0335917 -0.304878 HPR(in %)

Portfolio Return (in %)

680 -0.729927 0.41321749 528 -0.377358 709 -0.70028 1095 -0.363967 570 0.3521127 556 -0.358423 455 -1.086957 398 0 390 -0.255754 325 -0.611621

S.N.

Date

Security Name

Symbol

1

26-Mar-19

Nepal Doorsanchar Comapany Limited

NTC

2

26-Mar-19

Nepal Investment Bank Limited

NIB

3

26-Mar-19

Nabil Bank Limited

NABIL

4

26-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

26-Mar-19

Standard Chartered Bank Limited

SCB

6

26-Mar-19

Everest Bank Limited

EBL

7

26-Mar-19

Himalayan Bank Limited

HBL

8

26-Mar-19

NIC Asia Bank Ltd.

NICA

9

26-Mar-19

Nepal SBI Bank Limited

SBI

10

26-Mar-19

NMB Bank Limited

NMB

S.N.

Date

Security Name

Symbol

1

25-Mar-19

Nepal Doorsanchar Comapany Limited

2

25-Mar-19

Nepal Investment Bank Limited

NIB

3

25-Mar-19

Nabil Bank Limited

NABIL

4

25-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

25-Mar-19

Standard Chartered Bank Limited

SCB

6

25-Mar-19

Everest Bank Limited

EBL

7

25-Mar-19

Himalayan Bank Limited

HBL

8

25-Mar-19

NIC Asia Bank Ltd.

NICA

9

25-Mar-19

Nepal SBI Bank Limited

SBI

10

25-Mar-19

NMB Bank Limited

NMB

S.N.

Date

Security Name

NTC

Symbol

1

24-Mar-19

Nepal Doorsanchar Comapany Limited

2

24-Mar-19

Nepal Investment Bank Limited

NIB

3

24-Mar-19

Nabil Bank Limited

NABIL

4

24-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

24-Mar-19

Standard Chartered Bank Limited

SCB

6

24-Mar-19

Everest Bank Limited

EBL

7

24-Mar-19

Himalayan Bank Limited

HBL

8

24-Mar-19

NIC Asia Bank Ltd.

NICA

9

24-Mar-19

Nepal SBI Bank Limited

SBI

10

24-Mar-19

NMB Bank Limited

NMB

NTC

Closing Price in (Rs)

HPR(in %)

Portfolio Return (in %)

680 0 0.01542525 527 -0.189394 712 0.4231312 1087 -0.730594 564 -1.052632 555 -0.179856 461 1.3186813 398 0 391 0.2564103 325 0 Closing Price in (Rs)

674 530 712 1083 568 553 459 398 395 322 Closing Price in (Rs)

678 530 712 1072 558 555 460 396 385 318

HPR(in %)

Portfolio Return (in %)

-0.882353 0.06091913 0.56926 0 -0.367985 0.7092199 -0.36036 -0.433839 0 1.0230179 -0.923077 HPR(in %)

Portfolio Return (in %)

0.5934718 0.58796543 0 0 -1.015697 -1.760563 0.3616637 0.2178649 -0.502513 -2.531646 -1.242236

S.N.

Date

Security Name

Symbol

1

21-Mar-19

Nepal Doorsanchar Comapany Limited

NTC

2

21-Mar-19

Nepal Investment Bank Limited

NIB

3

21-Mar-19

Nabil Bank Limited

NABIL

4

21-Mar-19

Nepal Life Insurance Co. Ltd.

NLIC

5

21-Mar-19

Standard Chartered Bank Limited

SCB

6

21-Mar-19

Everest Bank Limited

EBL

7

21-Mar-19

Himalayan Bank Limited

HBL

8

21-Mar-19

NIC Asia Bank Ltd.

NICA

9

21-Mar-19

Nepal SBI Bank Limited

SBI

10

21-Mar-19

NMB Bank Limited

NMB

S.N.

Date

1 2 3 4 5 6 7 8 9 10

19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19 19-Mar19

Security Name

Symbol

Closing Price in (Rs)

677 530 710 1073 571 552 462 395 392 321 Closing Price in (Rs)

Portfolio Return (in %)

HPR(in %)

-0.147493 0 -0.280899 0.0932836 2.3297491 -0.540541 0.4347826 -0.252525 1.8181818 0.9433962

0.4501604

Portfolio Return (in %)

HPR(in %)

Nepal Doorsanchar Comapany Limited

NTC

673

Nepal Investment Bank Limited

NIB

535 0.9433962

Nabil Bank Limited

NABIL

723 1.8309859

Nepal Life Insurance Co. Ltd.

NLIC

1097 2.2367195

Standard Chartered Bank Limited

SCB

577 1.0507881

Everest Bank Limited

EBL

548

Himalayan Bank Limited

HBL

465 0.6493506

NIC Asia Bank Ltd.

NICA

399 1.0126582

Nepal SBI Bank Limited

SBI

392

NMB Bank Limited

NMB

-0.590842 0.67199454

-0.724638

0

322 0.3115265 Total Portfolio 0.20253993 Average Portfolio Return 0.02893428

Therefore, the 7-day average portfolio return is 0.02893428 % which is lesser than 7-day average NEPSE index return which is 0.044951%.

Related Documents

Report
April 2020 26
Report
July 2020 18
Report
June 2020 21
Report
November 2019 42
Report
May 2020 25

More Documents from ""

Assignment.docx
December 2019 14
Report Supriya.docx
December 2019 13
Scholarship-form-science.doc
December 2019 10
Suchana.docx
December 2019 12
Foreign Trade Policy
May 2020 25
Brm Introduction And Methods
December 2019 29