View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Here's a good one!

Chris,

It's likely that nobody will open your attachment.

Use

=PMT()

to calculate the payment, then use

=IPMT()

to calculate the interest, and for the principal, subtract the two.

HTH,
Bernie
MS Excel MVP


"Chris Berry" wrote in message
...

I am trying to split loan payments between principal and interest among
various sources, however due to rounding the total principal and
interest exceeds the total payment. What is the easiest way to adjust
either the largest principal or interest field based on which type is
over. I am attaching a file that contains all the formulas and such.

I've been around and around with this and just when I think I have it,
I get a circular error message or something equally as tiresome

Any help anyone can give me will be greatly apprecated.

For instance, there is both principle and interest being calculated
based on deferral, match, discretionary, etc... depending on how the
loan was withdrawn from the account originally.

I thought maybe using an if with a max might work, but it won't
calculate. It says I still have a circular reference.


+-------------------------------------------------------------------+
|Filename: Forum Assistance.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5024 |
+-------------------------------------------------------------------+

--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=561084