Prev: calcuate bond yields
Next: How do you calculate rate of return on monthly cash flows
From: ExcelMonkey on 15 Feb 2005 12:04
Sorry I figured it out. Use a interest rate of zero!


>-----Original Message-----
>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
>
>
>.
>
From: Ron Rosenfeld on 15 Feb 2005 13:57
On Tue, 15 Feb 2005 09:04:58 -0800, "ExcelMonkey"
<anonymous(a)discussions.microsoft.com> wrote:

>Sorry I figured it out. Use a interest rate of zero!
>
>
>>-----Original Message-----
>>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
>>
>>
>>.
>>

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


--ron
From: Harlan Grove on 15 Feb 2005 14:39
ExcelMonkey wrote...
>Sorry I figured it out. Use a interest rate of zero!
>
>>-----Original Message-----
>>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.

Yes, but can you then determine what the total loan payments would be
including interest?

 | 
Pages: 1
Prev: calcuate bond yields
Next: How do you calculate rate of return on monthly cash flows