On Mar 17, 2:41*pm, joeu2004 wrote:
On Mar 17, 11:28 am, Jagaude wrote:

Based on a date, insert pmt in a cell depending on theintervalthat
was decided.
[....]
I would like to add an additionalpaymentonly every 2 months and
not every months.

Those are two very different requirements, the first being more
general than the second.

If all you want to do is make an additionalpaymentevery 2 months,
and if the additionalpaymentis the same as the monthlypayment(as
in your example), the following might meet your needs.

In the AdditionalPaymentcolumn (starting in E2 and copy down):

=if(E1="", C2, 0)

----- original posting -----

On Mar 17, 11:28*am, Jagaude wrote:



Can anyone help me with this challenge. I have anamortization
schedule calculating mortgages. Everything works fine except that I
would like to add a feature forintervalextra payments. Does anyone
know how to do this?

Based on a date, insert pmt in a cell depending on theintervalthat
was decided.

Ex:

No. Due DatePaymentDue Principal * AdditionalPaymentInterest
Balance

1 03/07/2008 1,270.51 *218.76 * 1,270.51 *1,051.75 *249,083.73
2 04/07/2008 1,270.51 *225.01 * 1,270.51 *1,045.50 *247,588.21
3 05/07/2008 1,270.51 *231.29 * 1,270.51 *1,039.22 *246,086.41
4 06/07/2008 1,270.51 *237.59 * 1,270.51 *1,032.92 *244,578.31
5 07/07/2008 1,270.51 *243.92 * 1,270.51 *1,026.59 *243,063.88
6 08/07/2008 1,270.51 *250.28 * 1,270.51 *1,020.23 *241,543.09
7 09/07/2008 1,270.51 *256.66 * 1,270.51 *1,013.85 *240,015.92
8 10/07/2008 1,270.51 *263.07 * 1,270.51 *1,007.44 *238,482.34

I would like to add an additionalpaymentonly every 2 months and not
every months.

Cheers,

Jagaude- Hide quoted text -

- Show quoted text -

The problem is that the amount of extra pmt is not necessarely the
same as the regular monthly payments. If I have a mortgage, the pmts
are set but if I want to calculate the impact of adding an extra 200$
every 3 months, how do I come up with the formula?