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