Ned
Blogger
Share this content
0
3
1215

Excel spreadsheet, formula help please

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 ?

Replies

Please login or register to join the discussion.

avatar
By ACDWebb
20th Jun 2012 15:41

Try some of the formulae

listed under Financial

For example:

=PMT()

=IPMT()

=PPMT()

Thanks (0)
avatar
By adgj121
20th Jun 2012 17:49

Hi Ned, what version of Excel are you using?

I know in 2010, if you right click on a tab, choose insert, then spreadsheet solutions, there is a loan amortisation template ready for use.

It may be in the 2007 version aswell.

This seesm to fit your criteria

Thanks (0)
avatar
By Ned
Joe Soap
21st Jun 2012 08:42

Hi

I'm using 2010 Excel so will try your suggestions - thanks for the advice.

Thanks (0)