Scribd
Upload
66 views14 pages

Weekly Investment Portfolio Simulation

The document describes an investment simulation tracking the performance of various stocks over 7 weeks. It lists the initial investments made in 8 companies and the number of shares purchased. It then provides weekly updates on share prices and values the total portfolio at the end of each week based on the number of shares held and current prices. No transactions are recorded in weeks 4-7. The purpose is to simulate stock market investments over time and calculate portfolio returns.

Uploaded by

Dhruv Ratan Dey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
66 views14 pages

Weekly Investment Portfolio Simulation

The document describes an investment simulation tracking the performance of various stocks over 7 weeks. It lists the initial investments made in 8 companies and the number of shares purchased. It then provides weekly updates on share prices and values the total portfolio at the end of each week based on the number of shares held and current prices. No transactions are recorded in weeks 4-7. The purpose is to simulate stock market investments over time and calculate portfolio returns.

Uploaded by

Dhruv Ratan Dey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

INVESTMENT SIMULATION

#REF! #REF! No. of shares bought/sold

Sold Bought #REF!


Initial Investments
TCS 0 30
RELIANCE INDUSTRIES
LIMITED 0 50
ASIAN PAINTS 0 50
JSW STELL 0 50
MARUTI SUZUKI 0 85
HUL 0 20
ITC 0 30
Infosys 0 32

During First Week


TCS 30
RELIANCE INDUSTRIES
LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 20
ITC 30
Infosys 32

During 2nd Week

TCS 30
RELIANCE INDUSTRIES
LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 15 5
ITC 30
Infosys 32

During 3rd Week


TCS 30
RELIANCE INDUSTRIES
LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 5
ITC 30
Infosys 32
During 4th Week

During 5th Week

During 6th Week

During 7th Week


Price per Amount Paid Amount received Reasons/assumptions for
share for purchase on sale purchase/sale
0 0
3048 #REF! 91440

2077.4 #REF! 103870


1956 #REF! 97800
296 #REF! 14800
7191.5 #REF! 611277.5
2124.6 #REF! 42492
186.65 #REF! 5599.5
999.3 #REF! 31977.6
0 0
0 0
2374.1 71223 0

2315 115750 0
2035.95 101797.5 0
285.3 14265 0
7193.6 611456 0
2159 43180 0
184 5520 0
945.7 30262.4 0
0 0
0 0
0 0
2457 73710 0

2303.6 115180 0
2037 101850 0
288.1 14405 0
6956.75 591323.75 0
2099 10495 31485
179.5 5385 0
1003.4 32108.8 0
0 0
0 0
2417.75 72532.5 0

2198.95 109947.5 0
1924.7 96235 0
267 13350 0
6488 551480 0
2072 10360 0
171.75 5152.5 0
1006.6 32211.2 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Source of information
PORTFOLIO VALUE
*Insert rows if required

Initial Portfolio as on 4th Sept.


2020

Company* No. of Shares held


TCS 30
RELIANCE INDUSTRIES LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 20
ITC 30
Infosys 32
Add Cash Balance at the end of week, if
any
Value of Portfolio

At the End of 1st week [Closing NSE


price on 11th Sep. 2020]

Company No. of Shares held


TCS 30
RELIANCE INDUSTRIES LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 20
ITC 30
Infosys 32
Add Cash Balance at the end of week, if
any

Value of Portfolio

At the End of 2nd week [Closing


NSE price on 18th Sep. 2020}

Company No. of Shares held


TCS 30
RELIANCE INDUSTRIES LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 5
ITC 30
Infosys 32
Add Cash Balance at the end of week, if
any

Value of Portfolio

At the End of 3rd week [Closing


NSE price on 25th Sep. 2020]

Company No. of Shares held


TCS 30
RELIANCE INDUSTRIES LIMITED 50
ASIAN PAINTS 50
JSW STELL 50
MARUTI SUZUKI 85
HUL 5
ITC 30
Infosys 32
Add Cash Balance at the end of week, if
any

Value of Portfolio

At the End of 4th week [Closing


NSE price on 25th Sep. 2020]

Company No. of Shares held

Add Cash Balance at the end of week, if


any

Value of Portfolio

At the End of 5th week [Closing


NSE price on 1st Oct. 2020]
Company No. of Shares held

Add Cash Balance at the end of week, if


any

Value of Portfolio

At the End of 6th week [Closing


NSE price on 9th Oct. 2020]

Company No. of Shares held

Add Cash Balance at the end of week, if


any

Value of Portfolio

At the End of 7th week [Closing


NSE price on 16th Oct. 2020]

Company No. of Shares held

Add Cash Balance at the end of week, if


any

Value of Portfolio
Current Price per share Current Value
3048 91440
2077.4 103870
1956 97800
296 14800
7191.5 611277.5
2124.6 42492
186.65 5599.5
999.3 31977.6

743.4
1000000

Current Price per share Current Value


2374.1 71223
2315 115750
2035.95 101797.5
285.3 14265
7193.6 611456
2159 43180
184 5520
945.7 30262.4

Annualised Portfolio
993453.9 Return %

Current Price per share Current Value


2457 73710
2303.6 115180
2037 101850
288.1 14405
6956.75 591323.75
2099 10495
179.5 5385
1003.4 32108.8

55542.45
Annualised Portfolio
1000000 Return %

Current Price per share Current Value


2417.75 72532.5
2198.95 109947.5
1924.7 96235
267 13350
6488 551480
2072 10360
171.75 5152.5
1006.6 32211.2

108731.3
Annualised Portfolio
1000000 Return %

Current Price per share Current Value

Annualised Portfolio
0 Return %
Current Price per share Current Value

Annualised Portfolio
0 Return %

Current Price per share Current Value

Annualised Portfolio
0 Return %

Current Price per share Current Value

Annualised Portfolio
0 Return %
-34.0397
34.26402

You might also like