sakelkar

All:

I need excel sheet amortization sheet which works with daily reducing balance. Most of the ones floating around are monthly reducing balance.

Appreciate if someone could share or let me know how to do it in excel.

I tried using PMT function by modifying the formula but it did not work.

Thanks in advance,
Sameer