REQUIRED INPUTS — You must supply the following information in order to calculate the Loan’s annual rate:
|
(1) |
Payment plan |
|
(2) |
No. of payments (enter as an integer [whole number], for example, 5.762793 should be entered as 6) |
|
(3) |
Closing date (this will be used if you use Report Options — Loan report to generate an amortization schedule) (remember to enter dates in the format MM/DD/YYYY) |
|
(4) |
Initial principal (for example, $1,437,365.29 should be entered as 1437365.29) |
|
(5) |
OPTION: enter Balloon amount (for example, $129,362.36 should be entered as 129362.36) |
|
(6) |
Level payment (for example, $37,429.31 should be entered as 37429.31) |
|
(7) |
OPTION: specify Payments/deposits at: in the Calculation & Report Options (the calculator will automatically use the option it sees displayed, so if you want to change it, do so) |
NOTE - When you press the button, the Ellwood Factors are automatically updated using the information you supplied. The field to the right of the Ellwood Factors title will tell you that the source of the factors is L & A, which stands for Loans and Annuities.
THE SOLUTION IS DEVELOPED THROUGH NUMERICAL ANALYSIS - The loan’s annual rate is derived using the following procedure:
Start with an estimate of Loan’s annual rate (SAY r0 = 0.000000001), and compare the PVr (the present value of the Balloon amount for the current estimate of r) PLUS PVAr (the present value of the Level payment) with the target Initial principal and Balloon amount. If these disagree, use a straight-line approximation to find the next estimate of r. Repeat the process until convergence to the target Initial principal and Balloon amount.
For a full discussion of the functions PV and PVA, refer to the articles covered by the Ellwood Factors.