I cannot figure out how this lease payments are calculated. I wonder if there is an excel formula for annuity amortization that gives these numbers. Column 1 is the date, column 2 is the capital repayment , column 3 is interest. This is an odd type amortization , unless it is something naive. Payment are made monthly on a capital of 253000 , 5,625 % yearly interest and 6 year period(72 payments).
Is there anyone to help?
Thanx
Is there anyone to help?
Thanx