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)
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...
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 ;)
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.
Frog march this will just increase the number remember that I need to find the monthly repayment...