ExcelBanter - Amortization schedule and missed payments

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Amortization schedule and missed payments (https://www.excelbanter.com/excel-discussion-misc-queries/170682-amortization-schedule-missed-payments.html)

Geo

Amortization schedule and missed payments

How can I add daily interest to my schedule, rather than only monthly. The
purpose is to add daily interest to late payments.

Fred Smith

Amortization schedule and missed payments

Your interest calculation would be: Balance * # days * int rate / 365

--
Regards,
Fred

"Geo" wrote in message
...
How can I add daily interest to my schedule, rather than only monthly. The
purpose is to add daily interest to late payments.

All times are GMT +1. The time now is 09:06 AM.