Loan Amortization with Increases In Principle

[kafarrell]

I have a loan amortization schedule that I know I am making harder than it needs to be, but I can't figure out how to make it easier. I have an initial loan amount. We pay interest on the loan for the previous month on the 1st, but the principle amount of the loan increases on the 25th of each month. Thanks in advance for any help.

Kimberly

[6StringJazzer]

Loan amortization for typical loans is a one-liner. But when your payment is different every month, and you have principal added back in randomly (arbitrary amounts, and not every month), I know of no better way than what you have.

However, one small simplification you can make is to put the interest rate divided by 365 into one cell. You don't need to repeat it in every row, and you can do that division once instead of in every formula.

See attached.