Formula

[stumps]

Good day
Like to split interest amount(236 692,92) between two entities as follows :

Days Amount % Calculation
272 8 464 147,66 84,67% 200 602,49


113 1 532 635,76 15,33% 15 090,43
9 996 783,42 215 692,92

236 926,36
Difference = 21 233,44

272 Total Interest = 236 926,36

 

[stumps]

Dates	Days	Unit	Amounts		Interest Calculation
2017-11-17	272	Mimosa	8 464 147,66	=	84,67%	200 602,49
2018-08-16	100,00%
2018-04-25	113	Franschoek	1 532 635,76	=	15,33%	15 090,43
2018-08-16	41,54%
			9 996 783,42
2017-11-17	272	Total Interest	236 926,36		100,00%	215 692,92
2018-08-16

<colgroup><col width="65" span="3" style="width: 65pt;"><col width="75" style="width: 75pt;"><col width="22" style="width: 22pt;"><col width="65" span="2" style="width: 65pt;"></colgroup><tbody>
</tbody>