Financial Formulae

[Derek]

I use Exel for calculating loan repayments etc. and I find
the in built formulae to be excelent. However if I need
to calculate a repayment involving more than one advance
payment I need to revert to the "Sharp" Financial
calculator. I've searched the net with no success and I
feel sure that there's either a function or formula out
there that will achieve this for me. I mean, if a dated
pocket computer can do this surely a state of the art
Intel powered machine can do the same?

All suggestions gratefully received

Thanks in advance
Derek

 

[Harlan Grove]

I use Exel for calculating loan repayments etc. and I find
the in built formulae to be excelent. However if I need
to calculate a repayment involving more than one advance
payment I need to revert to the "Sharp" Financial
calculator. I've searched the net with no success and I
feel sure that there's either a function or formula out
there that will achieve this for me. I mean, if a dated
pocket computer can do this surely a state of the art
Intel powered machine can do the same?

What, precisely, do you mean by more than one advance payment? If you mean
payments made prior to the load term, wouldn't they reduce principal? If so,
substract them from principal (PV) in the PMT function. If you mean something
else, provide details.