Relative Content

Tag Archive for excelvbaamortization

Amortization Tables in Excel Using VBA

I make a lot of amortization tables for prepayments and unearned revenues every month. I calculate the amortization on a daily basis and alloctae the proper amount for each month at the end of the month.