PPMT formula that generates equal payments

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

Does anyone know if its possible to get equal payments out
of the PPMT formula. That is, its set up to generate an
annuity repyament profile. I am wondering if I can set it
up with inputs that will generate equal principal
payments. If not I will use an If Statement to do it.

Thanks
 
Sorry I figured it out. Use a interest rate of zero!
Click to expand...

Or just divide PV/NPER (Loan amount divided by the number of periods in the
loan).


--ron
 
ExcelMonkey wrote...
Sorry I figured it out. Use a interest rate of zero!
Click to expand...

Yes, but can you then determine what the total loan payments would be
including interest?
 
You must log in or register to reply here.

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

Similar Threads

PPMT function replacement 1
PPMT Function Repost 12
Loan Principal Payments 1
PPMT & IPMT 3
financial function 1
Help to create amortization schedule 0
pPMT malfunction 1
PPMT Function with varies interest rate 1

Back
Top