I'm trying to make an amortization table using these functions but it only amortizes to $0 when using ACT/ACT. 30/360 produces a negative balance. I can't figure out what I'm doing wrong.
Here's a link to my spreadsheet:
https://docs.google.com/spreadsheets/d/1zb9sNqRco23erZBA_bfiE6rkZcP7Axj5/edit?usp=drive_link&ouid=105449092389202832387&rtpof=true&sd=true