Adjusting for Bonus/splits…1 min read

Mi Users,

If your stock goes in for a Bonus/Split adjustment, update your sheets like this :

Say you hold 1000 shares of XYZ at 50 rs per share

Now say you get a Bonus 1 shares for every 2 held

Go to your sheet and update your qty to 1000*(2+1)/2 = 1500

and your purchase price to Total amount of original purchase divided by total shares: 1500

Your sheet will work perfectly with the Current market price hereon

Related posts

May 31, 2021 by Weekend Investing
April 23, 2018 by Weekend Investing

Practical insights for wealth creation

Join the thousands of regular readers of our weekly newsletter and other updates delivered to your inbox and never miss on our articles.

Thank you. You will hear from us soon.

Mail Sent Failed !

    vector
    guest
    0 Comments
    Inline Feedbacks
    View all comments
    Nishitha K
    Nishitha K
    5 years ago

    Do you expect with any of portfolio Same.

    Can we know the name of Same.

    R

    Nishith

    >

    Suresh Kumar
    Suresh Kumar
    5 years ago

    Any stock which has declared bonus or split in Mi25 portfolio?

    On Tue, Jan 23, 2018 at 9:57 AM, WeekendInvesting.com wrote:

    > WeekendInvesting.com posted: “Mi Users, If your stock goes in for a > Bonus/Split adjustment, update your sheets like this : Say you hold 1000 > shares of XYZ at 50 rs per share Now say you get a Bonus 2 shares for every > 1 held Go to your sheet and update your qty to 1000*(2+1) = 3000” >