ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate loan balances when payments are missed? (https://www.excelbanter.com/excel-worksheet-functions/87435-how-do-i-calculate-loan-balances-when-payments-missed.html)

Barnacle Bill

How do I calculate loan balances when payments are missed?
 
I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.

Miguel Zapico

How do I calculate loan balances when payments are missed?
 
You can search office online. This is one set of results with the term "loan"
http://office.microsoft.com/en-us/re...=TC&Query=loan

"Barnacle Bill" wrote:

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.


Barnacle Bill

How do I calculate loan balances when payments are missed?
 
I need to restate my request. I need a template for a loan amortization
schedule that will allow manual entry of the payment date and amount (if any)
when the actual date of payment or payment amount is DIFFERENT than the
schedule provides. If a payment is made three months late, for example, the
program would recalculate the additional interest and add it to the loan
balance. Sorry for the inconvenience!
"Barnacle Bill" wrote:

I would like to have a template for a Loan Amortization Schedule that would
allow manual entry of the payment date and amount (if any). The program would
recalculate the balance accordingly.



All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com