ReesNet.com — the FINANCIAL CALCULATOR — Calculating the Loan Variables

CALCULATING THE LEVEL PAYMENT

REQUIRED INPUTS — You must supply the following information in order to calculate the Level payment:

(1)

Payment plan

(2)

No. of payments (enter as an integer [whole number], for example, 5.762793 should be entered as 6)

(3)

Loan’s annual rate (for example, 5.762793% should be entered as 5.762793)

(4)

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)

(5)

Initial principal (for example, $1,437,365.29 should be entered as 1437365.29)

(6)

OPTION: enter Balloon amount (for example, $129,362.36 should be entered as 129362.36)

(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.

HOW IT WORKS

 

The Level payment can be derived in the following way. Every loan can be analyzed as an unamortized part that contributes to the development of the Balloon amount, and an amortized part that is derived from the amortizing part of the loan. Hence, we can write:

Loan’s unamortized part = (PV)(Balloon amount)

Loan’s amortized part = (Initial amount) - (Loan’s unamortized part)

Hence, it follows that

Level payment = (LC)(Loan’s amortized part)

When the calculator computes a loan, it displays the amortized and unamortized parts at the bottom of the Calculation & Report Options.

For a full discussion of the functions PV and LC, refer to the articles covered by the Ellwood Factors.