Look at the PMT function, it will explain how to use, to get what you owe the
bank, look into the PV and FV of the function.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Lutrinh" wrote:

Hi, can anyone tell me which fonction should I use to calculate a loan of
100,000$ with an interest Rate of =5.15% (0.4291) for 25 years (300) and pmt
= -593.36.

Question: after 12 payments How much do I still own the bank? The answers is
$97982.46 by using my calculator but I don't know which fonction do I need to
use in Microsoft Excel .

Could anyone help Me!

Regards

Lutrinh