Forum Discussion
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
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:
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:
- Thank you so much, that's very helpful.
