Gener8.xlm 1.2 for Microsoft Excel versions 4 and 5 Generate Great Amortization Schedules This Microsoft Excel macro application will generate great fixed rate and variable rate loan schedules. It allows for variable interest rates and extra principal payments. For "variable rate loans, it can project a worst-case interest rate change based on the loan's" maximum rate and maximum increase per adjustment period. It allows all components of the monthly payment (insurance, taxes, etc...) to be changed at any point in the loan." The amortization schedules show annual totals for interest and principal paid and show graphically how the interest and principal vary over the life of the loan. Generated spreadsheets are complete and functional but not customizable without the password provided through registration ($10). How to use Gener8.xlm: Gener8.xlm is a Microsoft Excel macro that runs automatically when opened by Excel. Gener8.xlm can also be re-started during the same Excel session by pressing Ctrl-Shift-A. When you start Gener8.xlm, you will see an introductory screen. Select "Generate a Schedule" to go on to the input screen. The input screen is used to provide basic information about the loan (length, rate, etc...). Please note that you can not enter any data into the variable rate related fields unless you select the variable rate option. When you have all fields completed and select "OK" the macro will generate a loan schedule and a graph based on the information provided. Gener8.xlm is functional in it distributed shareware form. If you would like to have greater control over the spreadsheets that it generates, you will need to register the product. There are 3 levels of registration available: Level 1: $10.00 You will receive the password and instructions for unprotecting the generated spreadsheets. If you are going to generate a few schedules but still need to change their appearance, this is the best way to go. Level 2: $20.00 You will receive the commercial (non- shareware) version of this product. The commercial version generates unprotected spreadsheets and does not have an opening shareware notice. For this level of registration the macro source code is still password protected. If you are going to generate a lot of schedules and the format of the schedules closely matches your business needs, this is the best way to go. Level 3: $50.00 You will receive the commercial (non- shareware) version of this product without password protection on the macro itself. This will allow you to have complete control over how the spreadsheets are generated. You will be able to modify the macro source code to customize the generated spreadsheets for your business. If you need to generate a lot of schedules and you need them customized for your business, this is the best way to go. To register this product, send the appropriate registration amount to: Ohio Star Software Gener8.xlm 1.2 Registration 8919 Deep Forest Ln. Centerville, OH 45458 For faster service with level 1 registrations, mail the $10.00 check to the address below and send us an e-mail message saying "the check is in the mail for Gener8 1.2". We will reply to your e-mail with the password and instructions to unprotect the generated schedules and wait for your check to arrive. E-Mail Addresses: Compuserve ID: 70412,2455 Internet: 70412.2455@Compuserve.COM Complete the information below and print this page Gener8.xlm 1.2 Registration Information Name: Address: City: State: Zip: Please mark the registration level Level 1: $10.00 Password to unprotect generated spreadsheets Level 2: $20.00 Generate unprotected spreadsheets Level 3: $50.00 Source code for Gener8.xlm application macro If level 2 or 3, please circle diskette size preferred: 3 1/2 5 1/4