Annual Percentage Rate
Check out the CUMIPMT function in Help: it calculates the amount of
interest involved in a typical mortgage-type loan. (Caution: you may
be very surprised at the number!) The PMT function will calculate your
monthly payment, just FYI, but it does not include things like taxes
and insurance.
|