Excel spreadsheet, formula help please

Posted by Ned PM | on Wed, 20/06/2012 - 14:47 801 3 comments | report

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 ?

Comments

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

Try some of the formulae

ACDWebb | Wed, 20/06/2012 - 15:41

Hi Ned, what version of Excel

adgj121 | Wed, 20/06/2012 - 17:49

Hi

Ned | Thu, 21/06/2012 - 08:42