Repeating Formula + Multi Formula tool - Amortization Schedule

[wonka1234]

Hi,

Current output:

Payment is wrong after the first row.  As payment is calculated on the Open Bal before it gets Updated in the next tool.

Its almost like I need a payment formula to update at the same time the multi formula OPEN bal is updated. 

Expected:

REM BAL AMORT	OPEN BAL	PAYMENT	# of INT Days	INTEREST	PRINCIPAL	PRE-PAY	LIQUIDATION	TOTAL CF	CLOSE BAL
78	49,226,066	(663,932)	31	(64,989)	(598,942)	(68,196)	(353,309)	(1,085,437)	48,205,619
77	48,205,619	(658,193)	30	(61,589)	(596,604)	(66,768)	(345,912)	(1,070,874)	47,196,334
76	47,196,334	(652,476)	31	(62,310)	(590,167)	(65,362)	(338,625)	(1,056,464)	46,202,180

The issue is that Payment gets calculated before OPEN BAL.

OPEN BAL then REcalculated

Then Payment needs to be recalculated on the new OPEN BAL.

formulas:

Open Bal:

How can I loop this? I cant keep just adding these two actions and keep repeating this to get accurate results:

[tushar_portal]

Hi, Can you please share the solution. I have somehow the similar problem.