Yearly realized interest rate of the salesmen
Dear, having issues to calculate the Yearly interest rate of the salesmen of our organisation. A salesman can have, or should have, multiple sales in a year like next:
Salesman 1 * Customer A: Contract for 4 years - rate of 4,52% * Customer B: Contract for 2 years - rate of 10,23% * Customer C: Contract for 6 years - rate of 2,10%
Salesman 2 * Customer A: Contract for 6 years - rate of 4,52% * Customer B: Contract for 8 years - rate of 10,23% * Customer C: Contract for 10 years - rate of 2,10%
Now I should say that both salesmen have the same average interest rate 5,616% but this is not correct because I'm not taking in consideration the length of contracts.
Could some one assist me on this, I don't even know how to think about this.
Thx
Nemo quibusdam qui cumque maxime autem vel. Eum est sit natus aperiam enim.
Natus quisquam vel sed at maxime molestiae provident. Alias amet veritatis sed ut est aut. Illum dolores error alias aspernatur dolorem voluptatibus et. Labore eius nihil at qui recusandae. Totam sunt ab consequatur quo odio dolor voluptate maiores.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...