Excel amortization formula

nkol

New member
Joined
May 31, 2016
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    22.9 KB · Views: 17
While pics are nice to look at, they are impossible to work with. Please post a sample sheet - Thx
 
Pecoflyer,

See the attached worksheet. The Table uses Excel's Financial functions for amortization. But if you are "au fait" with mortgage finance mathematics, you can just as well build the table using basic worksheet functions.

HTH
 
Amortization Table

OOps! forgot the attachment
 

Attachments

  • AmortTable.xlsx
    18.5 KB · Views: 8
Very sorry, Pecoflyer. Just an oversight. I meant to address Nkol, the originator of the query.
 
Back
Top