Cut and paste interest expense, debt schedule macro

[fr3shjiv3]

Hi All,

I am having a little trouble creating a macro in my financial statement that should do this.

1. Paste calculated interest into applied interest
2. Add claims to additions/repayments
3. Paste new calculated interest into applied interest
4. Add claims to additions/repayments on top of the old additions/repayments
5. Paste new calculated interest into applied interest
6. Stop when delta is <0.01
7. Move on to the next year and repeat.
7. Move on to the next year and repeat until all years are done.

This is similar to iterations but I am looking to "break the circular reference" by somehow creating this macro.

I've attached the excel sheet. I appreciate any help I can get.