Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Stock Average Calculator

    Uploaded by

    Suprabhat Seal
    The document summarizes an investment made in shares over time. It shows that originally 30 shares were purchased at an average price of Rs. 1342.80. Now 50 additional shares are being purchased at Rs. 1200 per share. The final average price of all 80 shares after this additional investment will be Rs. 1253.55.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Stock Average Calculator

    Uploaded by

    Suprabhat Seal
    49 views5 pages
    The document summarizes an investment made in shares over time. It shows that originally 30 shares were purchased at an average price of Rs. 1342.80. Now 50 additional shares are being purchased at Rs. 1200 per share. The final average price of all 80 shares after this additional investment will be Rs. 1253.55.

    Original Title

    stock average calculator

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document summarizes an investment made in shares over time. It shows that originally 30 shares were purchased at an average price of Rs. 1342.80. Now 50 additional shares are being purchased at Rs. 1200 per share. The final average price of all 80 shares after this additional investment will be Rs. 1253.55.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    49 views5 pages

    Stock Average Calculator

    Uploaded by

    Suprabhat Seal
    The document summarizes an investment made in shares over time. It shows that originally 30 shares were purchased at an average price of Rs. 1342.80. Now 50 additional shares are being purchased at Rs. 1200 per share. The final average price of all 80 shares after this additional investment will be Rs. 1253.55.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Old Avg. Price ₹ 1,342.

    80
    Present Investment
    Shares 30
    Current Price ₹ 1,200.00
    Investment proposed
    Shares 50
    Total
    Final Avg. Price ₹ 1,253.55
    ₹ 40,284.00

    ₹ 60,000.00

    ₹ 100,284.00
    INDEX 1007
    CMP SHARES MKT CAP WEIGHT POINTS
    RELIANCE 996 10000000 9960000000 0.08629590928 86.29591
    TCS 1697 15000000 25455000000 0.22054843079 220.5484
    HDFC 1885 12345506 23271278810 0.20162812901 201.6281
    HDFCBANK 966 17839843 17233288338 0.14931348263 149.3135
    BAJAJFIN 3678 1000000 3678000000 0.03186710385 31.8671
    HINDUNILVR 1950 18763549 36588920550 0.31701547875 317.0155

    116186487698 115416826630
    SALARY EMI PPF EXPENSES BALANCE
    Apr-20 70000 15200 12500 20000 22300
    May-20 70000 15200 12500 20000 22300
    Jun-20 70000 15200 12500 20000 22300
    Jul-20 70000 15200 12500 20000 22300
    Aug-20 70000 15200 12500 20000 22300
    Sep-20 70000 15200 12500 20000 22300
    Oct-20 70000 15200 12500 20000 22300
    Nov-20 70000 15200 12500 20000 22300
    Dec-20 70000 15200 12500 20000 22300
    Jan-21 70000 15200 12500 20000 22300
    Feb-21 70000 15200 12500 20000 22300
    Mar-21 70000 15200 12500 20000 22300
    TOTAL 840000 182400 150000 240000 267600
    450000
    717600
    250000
    467600 60000 100000 627600
    2700 1 2700
    2754 1 2754 1.02
    2809.08 1 2809.08 Avg Price ₹ 3,017.72
    2865.262 1 2865.262 return 10.110%
    2922.567 1 2922.567
    2981.018 1 2981.018
    3040.639 1 3040.639
    3101.451 1 3101.451
    3163.48 1 3163.48
    3226.75 1 3226.75
    3291.285 1 3291.285
    3357.111 1 3357.111
    12

    You might also like