Excel Help - I solved it

[Afflict]

I need some help in excel, I want to calculate the following and none of the forumalas I apply work

Anyway I have a project that I am trying to finish that needs to be able to calculate the re payment on a loan

Now what I have is the following example,

$5000-00
15%
5 years
repayment = $117.48

Anybody know how I would get to that repayment answer in excel?

The function in excel is (pmt)

[Tuomas]

Why use excel when you learn to calculate that in school. I just did. Though I hate maths, sorry, I don't want to be your excel, that sucks. Oh, and sorry, I don't know how excel works...

EDIT: Had to post this though, don't really know why...

[Afflict]

Well post me the formula that you get that on cause mine arent working...

Its driving me nuts and yeah I hated maths too the bad part is thats 4 years ago!

So guess how much of that I can remember 

[FrogMarch]

Well, say the '$5000.00' is in cell A1, you could do this, with each line representing a row.

$5000.00
=A1*1.15
=B1*1.15
=C1*1.15
=D1*1.15
=E1*1.15

The bit in bold is the answer. It's not the best way to do it, but it'd work, I think. You could always move the parts you don't want to see to cells off-screen somewhere...


  _______________________________________________________________

Oops, misread it, sorry. Um, in that case, I'm afraid I have no idea. I used to know, but it's been at least two years since I did that in Maths, so it's gone. Sorry.

[Afflict]

Frog march this will just increase the number remember that I need to find the monthly repayment...