CramDown Amortization By Ted Chambers The Mortgage Data Input section accepts data from the user and calculates an unknown when three of the required values are present. Data required (Balance, Terms, APR(Annual Percentage Rate), and Payment). After entering Balance, Terms, and apr the payment is calculated and placed in the payment field. You may use this value or change it. However, this value is usually correct. The displayed value is not rounded and is used in calculations even though the display is after moving the cursor off the field. This is true for other calculated fields. Use the up and down arrow keys to edit input fields. Moving the cursor off a field is the same as pressing enter. Except for two fields located under the separator bar. To calculate any field make sure three other fields contain data. Set desired field to zero, move cursor down and back up with arrow keys. If values are amortizable a new value will be displayed. Rolling the cursor over with the up arrow key will also cause the field set to zero to be calculated and displayed. If more than one input field is blank no calculation takes place. If an error is encountered during the calculation a window will pop up, lower right side, and remind you to enter different values. Minimum value for Terms is 12 and maximum is 360. Enter APR as a percentage. If annual percentage rate is 9.5% or 10% enter 9.5 or 10. Do not enter the decimal value. Principals: Enter number of principals you wish to prepay each month. CramDown will calculate the following month(s) principal and add it to this months payment. This process is carried out for life of the loan. The result is displayed in Amortization 2 window. A normal Amortization is displayed in Amortization 1 window. Of course the principals you elect to pay are in addition to a normal monthly payment. Monthly Amount: Decide on an amount you wish to pay in addition to the regular payment. I think you will be surprised at how much $200.00 extra a month saves in interest. The two selections below the separator bar are invocations. Pressing enter without first supplying a value will produce two identical amortization schedules. Two reach the Monthly Amount field use the down arrow key. If you want to go the long way you may use the up arrow key. Both up and down arrow keys roll over. Values listed below were used to test this program. Larger values should work but, have not been confirmed. Balance: 1,250,000.00 Apr: 10.25% Terms 360 Payment 11,201.27 If this savings plan is used, check with your mortgagee to see if your mortgage has a prepayment penalty. There usually is none after five years. Displaying results After calculations are completed two schedules appear on screen showing twelve months at a time. Press space bar to cycle through entire schedule. A window below each schedule displays information about the schedule above it. The windows provide a quick summary, and how much money was saved by opting to use the Amortization two payment plan. Printing schedules Pressing space bar at end of schedule brings up a print menu. Pressing escape when an amortization schedule is displayed will also display a print menu. This menu provides 5 ways to print. 1) Amortization 1 This option prints a normal amortization. A window will open asking if you want a summary header printed. This is the information in the totals windows. 2) Amortization 2 This option prints amortization 2. This schedule reflects savings. 3) With Payment This option is useful if you opt to pay additional principals. Payment increases each month under this plan. 4) Both 1 & 2 This option prints both schedules. Amortization one on the left and Amortization two on the right. Printing stops when amortization two ends. Use print option one for a complete amortization 1. Saves paper. 5) Header only This option prints information contained in totals windows. This program is share ware. If you enjoy the use of this program please feel free to register your copy. A modest fee of $15.00 will do it. Any suggestions on how to improve this program will be appreciated. Registered users will receive the next update when it is available. When you register please specify 3.5" or 5 1/4 disk format for the update. Send registration fee to TED CHAMBERS PO BOX 12762 JACKSON MS 39236 Disclaimer I am not responsible for monies saved or lost with this program.