need help making an amortization schedule

M

~Mike Hollywood

Hi,
I tried to amortize my mortgage and was unable to get it to work right.
I used this formula that I found in Excel's help screens:

PMT(rate,nper,pv,fv,type)

and I entered these values in it:
=PMT((6%/365)*30,360,128000,0,0)*-1

It expresses: $767 for the mortage amt.

Is this the right way to go about this?

Thanks,

Mike

ps: if anyone can point me to a templete
that would be much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top