View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default PMT: Daily interest compounding; monthly payment

PS....

I wrote:
It would be nice if you shared __all__ the factual information that you have.
What is the payment amount determined by the bank?


Actually, more than that:

1. The amount of regular payments.
2. The number of regular payments (excluding the last payment, if irregular).
3. At least one of the following (and preferably both, to double-check):
a. The amount of the last payment.
b. The total amount of all payments.
4. Any information that the lender provided about the daily interest rate.