Regular fixed payments by the due date, you will have to fill out an accurate If you would like to calculate an outstanding loan balance but have not made This is from Mortgage Backed Securities by William W Barlett and was sent to N = number of months over which loan is amortized = L x 12.L = length, the length (in years) of the loan, or at least the length over.I = the annual interest rate (from 1 to 100 percent).So that no additional interest has accrued. T of N fixed payments in a timely basis (i.e. The following formula will calculate your remaining balance if you have made The Vest Pocket Real Estate Advisor by Martin Miles (Prentice Hall). Walo found the answer to the actual formula in the book: I didn't know the answer and in myĬalculators I find it by doing a binary search over the payment formula above. Many people have asked me how to find N (number of payments) given the This formula previously was not explicit enough!! The 1/q factor in there was to convert the number of periods into years. If you haveįinding the Number of Periods given a Payment, Interest and Loan Amount Internet are NOT programmers and still want to calculate their mortgages! So this page was dedicated more to the latter. Programmers will see how this makes a trivial little loop to code, but I have found that many people now surfing on the Step 4: Set P equal to Q and go back to Step 1: You thusly loop around until the value Q (and hence P) Step 3: Calculate Q = P - C, this is the new balance of Your monthly interest, so it is the amount of principal you pay for that month I will tell you the simple steps :Ĭalculate H = P x J, this is your current monthly interestĬalculate C = M - H, this is your monthly payment minus To calculate the amortization table you need to do some iteration So now you should be able to calculate the monthly payment, M. The one-liner for a program would be (adjust for your favorite language): Sorry, for the long way of explaining it, but I just wanted to be clear for everybody. Then multiply the result times J and then times P. Take the inverse of that (if you have a 1/X button on your calculator push that). So to calculate it, you would first calculate 1 + J then take that to the -N (minus N) power, subtract that from the number 1. (it does not appear too clearly on some browsers) Okay now for the big monthly payment ( M) formula, it is: N = number of months over which loan is.J = monthly interest in decimal form = I / (12 x 100). The following assumes a typical conventional loan where the interest is compounded monthly.įirst I will define two more variables to
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |