Forum Discussion

stevefleming1967's avatar
stevefleming1967
Copper Contributor
Sep 09, 2024

Formula for calculating weightings

I currently have a sum of £230,000 which is made up of shares invested by 5 companies at £70,000, £50,000, £45,000, £35,000 and £30,000.  The percentage value of these shares is easy to calculate.  However, if I want to divide the £230,000 between 4 companies based on the current percentages I will get a gap of c 15%.  Is there a formula to split the £230,000 between 4 based on the weightings each has without losing the 15%. Many Thanks

  • stevefleming1967 

    Well, rather than dividing each of the 5 shares by the total of 230K, divide each of the four shares you selected by the sum of these four. four instance:

     

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    stevefleming1967 

    Well, rather than dividing each of the 5 shares by the total of 230K, divide each of the four shares you selected by the sum of these four. four instance:

     

Resources