I've been trying to figure this out for awhile and finally found the answer. I wanted to create a single cell where I could see the balance of an amount after a certain number of payments. I found a lot of guides for loan amortization, but I didn't want to create an amortization table. It seems like the best formula is this one.
But a typical Excel formula looks like this: