Problems with calculating the proper compounding
- From: Jim <jim@xxxxxxxxxxxx>
- Date: Fri, 1 Feb 2008 16:38:21 -0800 (PST)
Hello,
I'm creating a spread*** that automatically determines the payment
amount for a mortgage.
The problem that I'm running into is that when the compounding for the
interest rate is different from that of the payment frequency, I'm not
calculating the equivalent rate correctly.
For example:
J12 = 5.75%
Monthly payments
Amortization = 40
n = 40 * 12 = 480
PV
PMT = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 - (1 + (J1/12) ) ^ (-n))
~~~~~~~~~~~~~~~~~~
(J1/12)
^ = exponent
I do that, and then I input J1 instead of J12.
It calculates it very closely, but I know that I'm doing something
wrong.
Can someone please tell me?
.
- Follow-Ups:
- Re: Problems with calculating the proper compounding
- From: Sylvain Croussette
- Re: Problems with calculating the proper compounding
- From: The World Wide Wade
- Re: Problems with calculating the proper compounding
- Prev by Date: Re: Green Rudin Ch. 3 #26 (quoted inside)
- Next by Date: Re: Proof that real numbers are not countable
- Previous by thread: Proof that real numbers are not countable
- Next by thread: Re: Problems with calculating the proper compounding
- Index(es):