Excel spreadsheet, formula help please | AccountingWEB

Excel spreadsheet, formula help please

I would like to create an excel spreadsheet where I have the following 3 variables - loan amount, loan term(months) and interest rate. I want the spreadsheet to tell me what the monthly payment will be and the split between capital & interest. Does anyone know is this is possible ?

There are 3 comments. Login or register to view them.

Try some of the formulae

ACDWebb |
ACDWebb's picture

Hi Ned, what version of Excel

adgj121 |
adgj121's picture


Ned |