Home

Pelton`s Financial Software complete manual

1. 8 15 84 10 00 5 2500 9 15 84 135 75 1 10 7 01 85 5 5000 7 15 85 140 00 1 10 01 88 39 Se a Ceea aa eaa esos a a S A aaa e r a ene he ee BALANCE 7 621 62 lt Esc gt A gt CALCULATE MATRIX REPORT SAVE RECALL EXIT CLEAR In this example the investor opened a savings account with 10 on 8 15 84 The annual interest rate was 5 25 Notice that this is a one time deposit Next he deposited 135 75 every 15th of the month starting in month 9 and that went on for 10 months This is a RECURring deposit On 7 1 85 the interest rate changed from 5 25 to 5 5 Starting on 7 15 85 through 9 15 88 he deposited 140 00 the 15th of each month RECUR 1 The ENDING DATE of 10 01 88 overrides the 39 month DURATION here so I could have entered 50 instead of 39 the program knows when to terminate the savings scenario During the data entry I were in MATRIX mode so when I finished data entry I pressed lt Esc gt which brought us back to the menu line Then to get the BALANCE I simply pressed C or highlighted CALCULAT and pressed lt Enter gt Magically the BALANCE appeared as shown above Gl 11 7 The Matrix C
2. ll see the words N the program goe ob number client you an a j 6 1 You num a Entering the Op may enter a jobn ber 909 Type m h a Job Number s back to the beginn name tional Job Number umber to exit DO YOU WANT A PRINTOUT ing and number of copies or hit lt Enter gt you may just hit carriage return but ERLY which is every appropriate choice gt for MONTHI typical LY gt your schedule will be generated At the bottom of the schedule Y N For a Y the Below If you respond with the program asks for user put in job Page 37 Would you like to give this report a job number e to exit or press lt Enter gt for no job number gt 909 6 12 Entering the Optional Client s Name and Address Next you may enter your name and address or your friend s or client s The computer pulled the name and address shown below from the disk You are asked if you wish to keep it on put in a new name and address The name and address are stored to help you save time and energy when processing multiple m schedules for the same party Type E to exit Client Enter client name address etc press lt Enter gt for no name etc Stephen J Foss 21 Hodgkins Drive Ipswich MA 01938 If you want the same client type k or type n for a new client K KEEP or N NE
3. est Are CL Entering the Number of Months Refer to section 11 6 you must have placed a 1 in the R In 11 6 I have 10 you sure Y N For a recurring deposit situation ECUR column OS for one line item These DURATIONS are the number of months you explicitly See section 11 15 therefore Page 64 EAR command is highlighted empties out the Use this command when you want to start EXIT command is highlighted exits you into Pressing Y will exit you see section 11 5 you must have a and 39 MOS for 11 15 Entering the Ending Date Refer to section 11 6 In most cases the ENDING DATE is automatically calculated i e if you leave it out But if you enter an ENDING DATE it will override the DURATION entry 11 16 More Examples Available Upon Request Call or write Pelton Computer Consultants for the availability of more MGM examples Chapter 12 DA TABLE OF CONTENTS BY SECTION NUMBER 12 1 Vhat is the DA Program and What Does It Do 12 2 Features E23 How the Program Works 12 4 The Main DA Screen 12 5 The Bottom Line Menus and Request Lines 12 6 How to Exit the Program 12 7 Starting a New File 12 8 Recalling Your Work From an Already Saved File 12 9 Saving Your Work 12 10 The Edit Window 12 11 Reports 12 12 A Sample of a Payoff Date Report PAcal3 A Sample of a Full Report 12 1 What is the DA Program and What Doe
4. 3 Hee r m N Zw m a OY OV OV OV OV OF OV OV OV OV OY OD OY OV peri 6 1 What is the PAYMENTS Program and What Does it Do This program is used to print out range and spreads to the screen or to your printer You are asked for a starting interest rate which forms a spread in increments of 0 5 across the top and you are asked for a starting value of another quantity which is spread in appropriate increments down the left hand column In between is a checkerboard of values around which your eye may peruse so that you may hone in on a value close to what is desired Then you will have defined a starting point since you ll know the rate from the top row and the value from the left hand column There are five menu choices for ranges and spreads See the Main Menu section below You can request ranges and spreads for amounts financed vs interest rates loan payments affordable principal amounts growth pay ments and distribution amounts Only after you use this program a few times will you be able to s its beauty It s like a new powerful language Use it to find approximate or ballpark financing variables quickly by looking over a topology of related numbers As an example PAYMENTS is a simple program that anybody using or needing loan payments should find useful Using the LOAN PAYMENTS choice from the Main Menu the program requests the principal interest rate
5. 1 21 The Popup Calculator Pressing the lt F3 gt function key from the Main Menu will pop up the calendar Now you re ready to use it Notice your Num Lock light came on this will enable you to use the numeric keypad If you want to add a list of numbers say enter the number then press on the keypad or regular typing section then a number then and so When you are done and want a total press lt Enter gt or Then the calculator will request you to do A nother calc ulation or Q uit You can also press lt F4 gt or lt Esc gt to quit Page 8 1 22 The Other Programs Menu Selection As of v1 7 there are two more menus the Other and More programs menus Rather than keep reprogramming the main menu program I decided to provide for future growth early on by building these additional menus Also the choices on the menus are not cast in stone and will probably vary a bit in future major versions Other Financial Programs Debt Analysis Program DA Profit Share Calculation Retire with Mutual Funds Fund Account Rate of Return Loan Management System G1 Money Growth Matrix MGM reserved for future reserved for future Second Menu Other Prgms Exit back to Main Menu Helper Fl Mort calc F2 DOS shell F3 Calendar F4 Calculator FOOD BWNE 1 23 The More Programs Menu Selection Here is what the More menu looks like as of vl 7 More Financial
6. The last request allows direction of the output file to the printer or to a text file that may be imported into a word processor The Example s Output File Printout to a File The exact output to file for example 15 6 is shown below Notice the per centages at the end MUTUAL FUND ACCOUNT RATE OF RETURN 03 10 1993 TITLE m T Pie 13 42 13 Sample Session INITIAL account balance or initial investment gt 4 000 00 Total PURCHASES of shares made during period gt 1 000 00 Total amount of REDEMPTIONS during period gt 1 250 00 Total amount of DISTRIBUTIONS received gt 75 00 CURRENT VALUE of account at end of period gt 6 675 00 Number of MONTHS period account was HELD gt 9 Total percent profit gt 19 51 Annualized percent profit gt 14 63 Chapter 16 Regular Mortgage vs Mortgage with Points OY OV OV OV OY YHA OBN LO t TABLE OF CONTENTS BY SECTION NUMBER Vhat is the Regular Mortgage vs Mortgage with Points Program and Vhat Does it Do Features Exiting the Program Running the Program Inputting the Data Printing to Printer or File Exampl Ls Vhat is the Regular Mortgage vs Mortgage with Points Program and What Does it Do This program presents a comparison of a regular mortgage loan level payments to the same loan with points and closing costs presumably at a di
7. Entering the Pri ncipal h 10 000 00 Type Esc gt to exit Principal 6 8 Next was Entering the Int put in the inte Interest rate Enter yearly intere 6 9 Next business loans are co compounded monthly lt Enter gt or M Type fn an Compounding Period The interest rate was given as a yearly rate the lender may calculate payments QUART tering the Compounding decide what compounding erest Rate rest rate rat st rate gt 10 75 Frequency frequency quarterly monthly Esc gt to exit mpounded To use Or 5s h the program asks how much was borrowed Don t use commas or dollar signs Or Enter principal amount financed gt 10000 per year charged a yearly percentag of In th Page 36 Enter any amount up to Below th ntered user LOSTIR you will be working with xampl Type below the user to exit Pr h B Some Most regular consumer loans are APR three months for exampl Please make th below lt Enter gt OR M compounding period is MONTHLY D DAILY W JEEKLY 2 EVERY TWO WEEKS T TWICE MONTHLY Q QUARTERLY S SEMI ANNUALLY A ANNUALLY Enter a letter on left or just hit lt Enter 6 10 Displaying a Schedule Next by the magic of computer programming on the screen S the schedule abov
8. 2 the first Days between payments is 03 12 1994 9 158 49 Days between payments is 04 15 1994 8 242 80 Days between payments is 05 10 1994 7 359 94 TO OUO O WO WOO OO 9 1 This program WAP WNE What is Featu The Th Th Th Th ooo o What is disbursement sum by interest alone res ain Menu Growth Main oney Growth oney Growth oney Disbu the FINANCI is broken Chapter 9 TABLE 7 OF CONT ENTS FINANC Cl BY SECTION NUMB ER the FINANCE a Menu rsement Men h Pi Program Money growth in and growth disbursement is the depletion by time or withdrawal FINANCE wi 11 figure out an starting sum or en Program with Deposits amp Interest Interest only into two m and What Does it Do Menu Menu u and What Does it Do ajor sections money growth itself consists of two parts growth of a of a sum by interest and deposits Money withdrawal of an interest bearing sum over y quantity principal rate term deposit ding balance as long as five of these six and money Page 56 m quantities are known As you can see FINANCE is a very powerful program and can greatly assist you in financial planning 9 2 Features The program offers you the following features fe Full glorious attractive color sc
9. as often as any changes are mad The backup up the live data base only Make your backup share year and date It wouldn t hurt to make two backups copies of all reports which will be used for safely fields that have changed e g salary rank mploy ntries accordingly 13 14 Exiting the Program Pressing lt ESCAPE gt and sometimes E ticular inquiry sequence or completely exit you from the program program see section 17 backs and label it with the profit Get some hard and store them reference Then for the next profit sharing season just modify the employee and then add and delete or e will either back you out of that par depending on the context you are within Chapter 14 Retire With Mutual Funds TABLE OF CONTENTS BY SECTION NUMBER 14 1 Vhat is the Retire With Mutual Funds Program RMF and What s it Do 14 2 Features 14 3 Future Enhancements 14 4 Exiting the Program 14 5 Printing to Screen Printer or File 14 6 A Complete Example 14 7 The Example s Output File Printout to a File 14 1 What is the Retire With Mutual Funds Program RMF and What s it Do Suppose you have an extra 250 per month to either pay against the principal of your home mortgage or to invest in mutual funds towards your retirement What should you do Th doubtedly answer your question once and for all to 50 mortgages or loa e
10. 49 00 61 61 s99 00 14 14 56 70 00 450 6 45 411 411 45 ITIR 373 45 333 333 45 293 293 45 253 293 45 212 212 45 170 170 Templeton Visa Massasoit M C 00 83 00 83 83 25 00 07 07 66 00 73 79 46 00 25 25 84 09 09 222 00 30 30 58 675 L2 58 629 629 11 582 982 58 5994 5303 77 58 487 487 89 58 438 1 438 1 5 8 388 1 388 1 58 3377 wk 33 ek 00 32 00 32 80 00 44 44 00 21 21 00 y WWWW WWW WW Ww y y y FPO OANANA UB WNE Page 70 Payment 45 00 58 00 End Bal 127 89 285 34 NOVEMBER 1992 Beg Bal 12789 285 34 Fin Chg 1 94 D Payment 45 00 58 00 End Bal 84 83 232 54 DECEMBER 1992 Beg Bal 84 83 232 54 Fin Chg 1329 4 24 Payment 45 00 58 00 End Bal 41 11 178 79 JANUARY 1993 Beg Bal 41 11 178 79 Fin Chg 0 62 3 26 Payment 41 74 58 00 End Bal Paid 00 124 05 FEBRUARY 1993 Beg Bal 124 05 Fin Chg 2 26 Payment 58 00 End Bal 68 31 ARCH 1993 Beg Bal 68 31 Fin Chg Le25 Payment 58 00 End Bal 11 56 APRIL 1993 Beg Bal 11 56 Fin Chg 0 21 Payment PDI End Bal Paid 00 Chapter 13 Profit Share Calculation Program TABLE OF CONTENTS BY SECTION NUMBER What
11. Below I have a summary for the twice monthly loan type NOTE if you are working with loan type 5 a conventional loan and you wish to change an item such as rate principal or term the conventional given payment amount the amount of principal payback see section 5 11 is not changed automatically you are responsible for that amount Also you may return to the Main G5 Menu Page 32 enter a number to change that particular item or press lt Enter gt to get to the Output Menu discussed below S C H E DAU a A SUMMARY 1 Job number none 2 Client name Steve Foss 3 Address 21 Hodgkins Drive 4 Address Ipswich MA 01938 6 Principal 1 000 00 ae Rate 12 0000 per year 8 Term 1 yr or 24 pmts O Payment 44 32 TOTAL Interest 63 71 Total Payback 1 063 71 10 Loan type 2 Reg dir red twice mo pmts Ti First date 01 30 1991 12 Second day 15 13 Balloon Non 14 Compounding Twice monthly change item M main menu or hit lt Enter gt for output gt 5 17 The Output Menu Here I s the Output Menu which gets displayed from the Schedule Summary page s above You have many nice choices Try a few Pressing lt Enter gt will immediately return you to the Schedule Summary display OU PUT M eal zZ G Summary Report Loan Schedule Output Find Last Payment Only Summary of Yearly Totals R
12. Below are shown the questions queries that you will be presented with The figures reflect th xample stated in section 1 m Enter your TITLE for the report if you desire one otherwis just hit lt Enter gt gt Enter BEGINNING BALANCE initial amount quite often zero if the amount is zero then just hit lt Enter gt gt 1000 T Enter ENDING BALANCE how much you will end up with this is the final amount or your goal which should be greater than the BEGINNING BALANCE gt 15000 ter ANNUAL INTEREST RATE gt 6 15 ti ie If you want Monthly savings as is common then just press lt Enter gt or Quarterly hit Q or Weekly hit W or Daily hit D or Yearly hit Y For example if you choose W for Weekly your report will show Weekly savings deposits Enter COMPOUNDING PI Gl RIOD lt Enter gt M Q W D Y gt lt Enter gt Enter TOTAL NUMBER OF YEARS gt 4 Enter ADDITIONAL MONTHS gt 6 PERIODIC SAVINGS AMOUNT 220 57 Want a SCHEDULE Y N E exit S start over 4 6 Displaying a Schedule Pausing or Escaping Next by the magic of computer programming your schedule will be generated on the screen It s possible to pause the display
13. Enter nominal rate gt 12 Enter term in years gt 1 Enter term add l months gt 0 Enter nominal monthly pmt gt 888 49 When the program prompted for customer number we typed in 1 without the quotes Also the nominal monthly payment was automatically calculated for you You may accept this payment or change it 8 10 The Main Menu Shown below is the point and shoot main menu Just move your cursor using the arrow keys to highlight the desired choice and press lt ENTER gt or press the corresponding number or letter the first screen to be shown to the user when bringing up the program OMAATHADAARBWNE MAIN M Make a Payment Report Modify a Payment Open a New Data Open an Old Data h Receipt D B stands for Already Made Base Base Configure Program Parameters Ba to Find a Loan s Backup a D B Exit Program lance Floppy Disk Page 53 data base This is to a D B Use the Open a New Data Base to open a brand new data base for the first time The Old Data Base choice is for an already created data base Data bases are controlled by the customer number The rest of the main menu items are self explanatory 8 11 Making a Brand New Data Base Data Base Header From section 8 10 we saw that we use Open a New Data Base to open a brand new data base
14. Generator The little program is just a random number generator and it does not keep a statistical history of numbers drawn throughout time There are four types of games for which a set of random numbers may be generated S section 15 4 for the main screen to see the games 1 43 What reserved for future Means This menu choice will be occupied by a financial program in a future re lease of Pelton s Financial Software Why keep programming the main menu driver when I could program it for future growth now v1 7 1 44 Disclaimer In no event will the author be liable for any damages including any lost profits lost savings or other incidental or consequential loss or damages arising out of the use of or the inability to use this program even if the author has been advised of the possibility of such damages The author makes no warranties either express or implied respecting the software its quality performance merchantability or fitness for any particular purpose 1 45 Copyright Infringement This program is protected under the copyright laws of the U S This pro gram is not public domain it is sold for a fee This program may not be sold nor copied and sold for profit or under a value added scheme to increase the value of a computer system etc or under a new name ECS because the author reserves all copyright law rights Any person or company interested in purchasing or licensing the rights to thi
15. The program offers you the following features Full glorious attractive color screens or black amp white mono Fast point and shoot menus Fancy reports to screen or printer Super fast calculation of individual profit shares Pause or guit during report output EBasy to understand queries questions you don t need financial training to use this program Escape or quit at any time This program aids you in solving serious financial calculation problems Fast loading The program is well thought out people who use it like it Fast execution Continuous dedicated support by the author Excellent documentation This program will increase your productivity and give you a true sense of accomplishment Information is where you need it les Included With This Release PROFIT COM The computer program itself PROFITSH DAT The real live data file initially empty PSSAMPLE DAT The sample practice data file 30 records tended Audience for the PROFIT SHARE Program T share program was created for the small or medium sized firm ds a way to easily calculat ach employee s share of the profit company s contribution and some information about each employ e Sample and Real Data Bases two data bases that come with your PROFIT program One is the real data base PROFIT DAT the other is a sample or practice PSSAMPLE DAT with which you may experiment with all the features ogram Upon program start you are a
16. 10 3 The Main Menu 10 4 The Bottom Line Menu 10 5 Add aUtoadd Change Print Find Sort Help eXchange Insert Remove lt Esc gt 10 6 Other Commands 10 7 Pressing H for help 10 8 Exiting the Program 10 1 What is the THINGS TO DO Program and What Does it Do THINGS TO DO is a program originally written for us to help us with our development work It became so good that I wanted to offer it to my clients and customers You may have many lists of things to do for ex ample lists of prospects appointments repairmen phone numbers action items for work projects events leading up to a closing lists of parts to buy for repairing your house or remodeling grocery lists lists of friends Page 59 and their telephone numbers party supplies or any list limited only by your imagination You ll need THINGS TO DO The computer program THINGS TO DO manages all of your lists and is very easy to use To run this program on your IBM PC or compatible just type the word THINGS and the Main Menu immediately appears You may choose the last used list a new list to be created or an old list Suppose you choose a new list The program asks you for the list s name Then you can add new items Other features include change a section of or a whole item find a string in an item sort all items print all items remove an item insert an item before another exchange the places of two
17. 4 above Below are shown some typical show syntaxes show 25 36 show all show 49 end In the first example I displayed line items which are the same as pay ment numbers 25 through 36 which would be the third year of a monthly loan The second example is obvious I displayed every payment number Finally in the third example I displayed items 49 through the last one 7 7 Schedule Printing PRINT To print a schedule use the PRINT command Use HELP PRINT for the exact syntax which is just about the same as that of SHOW 7 8 G7 VARI LOAN Example 1 I have included fiv xamples in this manual as opposed to discussing the commands individually in great detail For the exact command syntax of a command just type HELP XXXXX where XXXXX is the command or just type HELP for a listing of all commands Your client said he borrowed 4 500 at 8 25 percent supposedly for 9 months The payment schedule was rather casual as he paid the following 510 00 525 00 400 00 475 00 375 00 Page 40 and the most recent 6th payment 515 00 Ascertain your client s financial status and document the proper schedule of payments for this loan Use G7 VARI LOAN by choosing it from the main menu The program starts to run and the command prompt appears Choose an environment as loan 1 Then set the principal amount borrowed the rate and the term as follows loan 1 prin
18. CF2 TNG TNG Order Form Customer Feedback Form Pelton s Financial Software Features User Manual Upgrade release history Vendor related text file More Information Installation Program Main Menu Control File do n Second Mailbox G5Loan Program Part of the G5SLoan Part of the G5SLoan Part of the G5SLoan Part of the G5SLoan Program Part of the G5SLoan Program Debt Analysis Program Sample DA data file Finance Program Payments Program G7 VARI LOAN Program Part of the G7 VARI LOAN Program G7 VARI LOAN help file section IRA Calc Program MGM Money Growth Matrix Sample MGM data file Things To Do Program Sample Things To Do file Another sample Things To Do file ot corrupt this Program Program Program Program Page 4 LSTFL T9G The Things To Do control file PR CO The Profit Share Calc Program PROFITSH DAT The Profit Share Live Data File PSSAMPLE DAT The Profit Share Sample Data File RMF EXE Retire With Mutual Funds Program FARR EXE Fund Account Rate of Return Program LO CO The Lottery Generator Program FILE ID DIZ Description in Zip program description CD ROM TXT Stub file so you can t write to read only medium G1 EXE The Loan Management System G1 Program G1 CTL LMS Gl Control File 1 G1 LMS Example Data Base TIMER CO The Timer Tone Generato
19. Calculator enter 4 of 5 quantities press lt F1l gt to calculate TIELE Principal 90000 Annual Rate Ted Years 25 Add 1 Months 0 Payment Press lt Esc gt lt F10 gt to exit 1 19 The DOS Shell Sometimes you may want to temporarily jump out of Pelton s Financial Pro grams and go to DOS but you don t want to actually and formally exit the program Choose lt F2 gt and the following screen appears along with the DOS prompt e g C PELTON gt below as you are temporarily in DOS but PFP is still loaded Now you can do regular everyday DOS things like DIR COPY TYPE something etc or you may even run your word processor When you are finished in the DOS world type EXIT to go immediately back into PFP DON T RERUN PFP by typing GO because you may run out of memory because PFP is al ready loaded and waiting for your return via the EXIT command 1 20 The Popup Calendar Pressing the lt F3 gt function key from the Main Menu will pop up the calendar This calendar is a nifty feature You can look up the exact day people were born When the calendar appears pressing the up or down arrow will change the month pressing the lt PgUp gt or lt PgDn gt key will change the year pressing the lt End gt key will bring you to December of the year you re in pressing the lt Home gt key will bring you back to this month finally pressing lt F3 gt or lt Esc gt will guit the calendar
20. DA presents you with a flow of debt i e you can watch the debt accounts get paid off over time months The program shows the status of all accounts at any one month When you get done analyzing you can save the data for a later session see Saving below At a later session you can recall this work and modify the beginning balances to reflect changes and then re analyze the debt structure Two types of very attractive reports are available see Re ports below 12 4 The Main DA Screen Shown here is an example of the main DA screen with one of the accounts from th xample below Notice the account name New World Visa 100 its finance charge rate 15 9 the beginning balance 400 00 and the regular month Page 66 ly payment 75 00 The main bottom line menu is shown below this screen 4 C 1990 1992 DEBT ANALYSIS by Pelton Computer Consultants v 1 2 New World Visa 100 15 9 Begin Balance 400 00 Begin Balance Finance Charges Finance Charges Payment 75 00 Payment Ending Balance Ending Balance Se a ant ee om A YY Begin Balance Begin Balance Finance Charges Finance Charges Payment Payment Ending Balance Ending Balance Begin Balance Begin Balance Finance Charges Finance Charges Payment Payment Ending
21. EXIT EXPAND FILE FV GET GO HEAD HELP HISTORY I LOAN N PREVIOUS PAYMENT PMT PRIN PRINT PV RATE REBUILD RECALL RESET SAVE SHOW SKEL STATUS STORE SUBTRACT SUMMARY TAIL TERI TREE UNBALLOON UP USE YEAR 7 4 The HELP Command The HELP command can be used at any time help or help something at any prompt Help info is called up by typing In th xample below I call up help for the SHOW command after entering loan environment 1 Page 39 command gt loan 1 loan 1 gt help show SHOW used for SHOW a line item or range of lines of results Format of SHOW SHOW SHOW all SHOW 1 2 SHOW end SHOW SHOW year 4 SHOW yr Example s of SHOW SHOW 5 SHOW 1 5 SHOW all SHOW 12 end SHOW 12 SHOW year 3 SHOW year 1 SHOW yr 5 loan 1 gt By simply typing help without a qualifying command you ll be put into help space and get a listing of all the commands At that time you may type a command and get the help info for it 7 5 Exiting the Program Pressing lt Esc gt or E or e will either back you out of that particular inquiry sequence or completely exit you from the program depending on the context you are within You will be asked the Are you sure Y N confirmation question 7 6 Displaying SHOWing a Schedule To display a schedule use the SHOW command Use HELP SHOW for the exact syntax see section 7
22. Money Growth Matrix oney growth calculations are easy but MGM gives you a quick mechanism to enter some simple data and produce an answer MGM presents you with a grid on which you enter a starting amount a rate a date and a recurring or nonrecurring deposit amount You can enter more than one line of this type of information Then you simply press a button to get the ending balance to your money growth problem 1 36 The DA Debt Analysis Program DA gives you a quick and easy method for analyzing a person s total debt from one to six interest charging accounts like MasterCard Visa first and second mortgages and so on All the user has to do is enter the ac count names APR interest rate beginning balances nominal monthly pay ments and the start off month and year and the DA program will produce a schedule of when these accounts will be paid off The calculations are only an approximation since interest is charged on a monthly basis not daily but you ll find it a great program to get a strong handle on a person s debt status and how it can be resolved The user can single step through each month to check the debt status or he she can press C for a continuous cranking through and automatic display the months flash by of the debt status by month The continuous action is not only fun but can produce powerful information about a person s debt Two types of printed report can be produced A debt payoff date summary with financ
23. Retire With Mutual F ns and 50 mutual fund the complet xample in have loans and savings program will monitor th year An annuity range added in future version 14 2 Features section 14 6 below But basically unds financial program will un The program will accept up or Savings accounts See a person may S accounts moving along e financials of such f and spread s the contemporaneously and this or each month or for each Payments program will be Page 75 fe Full glorious attractive color screens or black amp white mono O eaningful reports to screen printer or file o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time o This program aids you in solving serious financial calculation financial planning problems fe Fast loading fast execution o The program is well thought out people who use it like it o Continuous dedicated support by the author O Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 14 3 Future Enhancements An annuity range and spread s the Payments program will be added in future version So after the calculation if there is a positive amount in the Equity column the user will be able to press a key
24. Since you were in loan environment 2 move up to 1 and display the last 10 line items as Page 48 loan 2 gt up loan 1 gt tail PMT ENDBAL PRIN PMT INT PMT CURR PMT CURR RATE 172 Tit5 L15 24 1 335 54 106 35 1 441 89 10 2500 173 9 768 30 1 346 95 94 94 1 441 89 10 2500 174 8 409 84 1 358 45 83 44 1 441 89 10 2500 L75 OIII 1 370 06 71 83 1 441 89 10 2500 176 5 658 03 1 381 76 60 13 1 441 89 10 2500 177 4 264 47 17293456 48 33 1 441 89 10 2500 178 2 859 00 1 405 46 36 43 1 441 89 10 2500 179 1 441 53 1 417 47 24 42 1 441 89 10 2500 180 00 1 441 53 12 31 1 453 85 10 2500 Again the first loan looks good also see line 180 above so you can compare them loan 1 gt compare And the results display immediately as Comparison LOAN 1 DIFF LOAN 2 Total number of payments made 180 180 360 Original number of payments 180 180 360 Annual interest rate 5 5000 3 3750 8 8750 Total principal paid off 115 000 00 115 000 00 Average payment per period 1 319 48 245 99 1 073 48 Last payment made 1 453 85 419 97 1 033 88 Total interest paid 122 505 59 148 948 89 271 454 48 Total amount paid 237 505 59 148 948 89 386 454 48 Ratio of interest to principal 106 53 236 05 Ratio of interest to total amt 51 58 70 24 Let s discuss these results First of all loan 1 has half as many pay ments but the cash flow is greater the average monthly payment is 246 higher Loan 1 is
25. account The Money Growth with Deposits amp Interest Menu Page 57 MONEY GROWTH MENU DEPOSITS amp INTEREST Growth is by INTEREST gained on the account balance AND by additional PRINCIPAL payments Deposits to the account in the following 1 Find END BALANCE given BEGIN AMOUNT RATE TERM DEPOSIT 2 Find BEGIN AMOUNT given RATE TERM DEPOSIT END BALANCE 3 Find RATE given TERM DEPOSIT END BALANCE BEGIN AMOUNT 4 Find TERM given DEPOSIT END BALANCE BEGIN AMOUNT RATE 5 Find DEPOSIT given END BALANCE BEGIN AMOUNT RATE TER Payments against debt acco A Find solution to A B Account h Exit and go bac k to Main Menu Enter 1 5 A o ti ie unt A made into interest bearing account payments from A into Above is shown the Money Growth Menu Deposits amp Interest to solve money growth problems that involve growth by interest earned on accoun presen Pelton course from Mr month to Mr A The en An A resents borrowed money being paid back to the is interest bearing B at 12 p Bra deposits t E difference of more than 2 249 while that of th is 33 5 9 6 The Money Growth MON per ann is 222 44 he paymen In EY GROWTH MENU For example um for 5
26. also more complex to administrate loan 2 is steadier only 3 interest rate changes You could lower the term of loan 2 con siderably if you were to put a few dollars to a few hundred dollars extra per month against the principal see our booklet on home mortgages en titled Understanding Your Home Mortgage Loan and How to Pay if Off This extra principal payment would be at our own discretion i e if you had more money some months you d pay more and so on Because loan 2 is less complex than loan 1 and because you can control the term by making extra payments there may be no particular advantage to loan 1 except that the interest amount paid in loan 1 is much less than in loan 2 The borrower must decide between long term goals and short term cash flow Page 49 As a matter of fact let s continue the discussion of loan 2 by adding some extra principal payment per month as follows loan 1 gt loan 2 loan 2 gt add 94 00 to pmt all loan 2 gt go loan 2 gt tail What you did here was to move to loan environment 2 you could have also said down to move down to loan environment 2 and then add an extra 94 00 payment towards principal Then you processed the loan GO and displayed the last 10 line items tail which looks like PMT ENDBAL PRIN PMT INT PMT CURR PMT CURR RATE 232 8 256 39 7 091 88 84 72 176 60 0 8750 233 7 154 62 1 101 78 74 82 176
27. any financial analysis the explanation of your find ings From any environment loan 1 loan 2 or command you can enter the compare command compare If you forget to complete the processing of the loan in either environment 1 or 2 the compare output would tell you so and you could go back and do so GO Let s assume however that you have fully processed loans Here is the output from the comparison Comparison LOAN 1 DIFF LOAN 2 Total number of payments made 48 48 Original number of payments 48 48 Annual interest rate 4 9000 5 6000 10 5000 Total principal paid off 4 900 00 1100 00 3 800 00 Average payment per period 12463 15733 IT 3U Last payment made 112 T9 E5432 96 88 Total interest paid 505 80 364 17 869 98 Total amount paid 5 405 80 735 82 4 669 98 Ratio of interest to principal 10 32 SLO 22 89 Ratio of interest to total amt 9 36 9 3 271 18 63 Let s discuss the above comparison chart Both loans have the same term 48 months Loan 1 has a lower interest rate but how does that affect your client The total principal borrowed in loan 1 is significantly higher by 1 100 In our opinion this is a strong point because you are using OPM or Other Peoples Money Why should our lady use her own money for the small increment of only 15 32 loan 1 per month more in payment Next consider the total interest paid back This amount is an expense it s the cost of borrowi
28. by pressing a key like the space bar and then press it again to continue You can quit by pres Sing the lt Esc gt key S the schedule above At the bottom of the schedule you ll see the words DO YOU WANT A PRINTOUT Y N If you respond with an N the program goes back to the beginning For a Y the program prints a schedule Page 25 4 7 Entering the Actual Payment and the Date of the First Payment If you have chosen to display or print a schedule the program asks for the actual payment to be used and an optional first payment date like this Enter PAYMENT you wish hit lt Enter gt for amount above gt lt Enter gt Enter date of first payment mmddyy gt 010189 The payment amount doesn t necessarily have to be the amount that the pro gram calculated it can be your choice Of course the arithmetic will work out better if you choose the default value Also it s always more professional to include a date if at all possible 4 8 Schedule Printing If you elect to print a schedule the program will request the screen or printer If you choose the printer press the lt Esc gt key to stop the printing or the lt Space gt key to pause lt Esc gt to cancel lt Space gt to pause FUTURE AMOUNT PROGRAM PRINTING Chapter 5 G5SLOAN TABLE OF CONTENTS BY SECTION NUMBER What is the G5LOAN Program and What Does it Do Features Th
29. gt 1 800 00 Closing costs gt 2 500 00 Down payment gt 5 000 00 Principal borrowed gt 89 300 00 Annual interest rate gt 6 75 Term yrs gt 500 Monthly pmt calc gt 790 23 Monthly pmt used gt 790 23 PAID BACK OVER TERM Total principal gt 89 300 00 Total interest gt 52 939 59 Page 84 i p ratio 62 4 59 3 74 82 more interest her May be a better loan less interest The regular mortgage loan without the points and closing costs results in the payment of more interest over th term shown Here we ran the same problem for the third time but this time we paid an extra 27 00 against the principal on the regular left side loan ona monthly basis Look at how much interest we saved by signing up for the points loan 74 82 But the points loan costs us 4 300 up front which money the bank gobbled up and said Thank You Thank You Chapter 17 Lottery Generator TABLE OF CONTENTS BY SECTION NUMBER Cest Vhat is the Lottery Generator and what does it do Lie2 Features TAS Exiting the program 17 4 Answering the Questions Sh i The Lottery s 17 6 Printing the Lottery s 17 1 What is the Lottery Generator and What Does it Do The little program is just a random number generator and it does not keep a statistical history of numbers drawn throughout time There are fou
30. gt 790 00 0 00 00 00 00 H9 00 23 23 PAID BACK OVER TERM Total principal gt Total interest gt i p ratio 66 9 85 000 56 832 3 893 38 more interest her The regular mortgage loan term shown 00 97 Page 83 PAID BACK OVER TERM Total principal gt 89 300 00 Total interest gt 52 939 59 59 3 May be a better loan less interest without the points and closing costs results in the payment of more interest over th Notice that this time the higher interest side left costs only 3 893 38 more in interest than the points loan right side You ll save 3 893 38 in interest over the loan s life is it worth it Probably not because your money is more useful now than One more time consider this later because of inflation but it will cost you 4 300 up front So Regular Mortgage vs Mortgage with Points and Closing Costs 05 20 1994 REGULAR MORTGAG Selling price gt Down payment gt Principal borrowed gt Annual interest rate gt Term yrs gt Monthly pmt calc gt Monthly pmt used gt PAID BACK OVER TERM Total principal gt Total interest Vv Gl 90 000 5 000 85 000 00 15 787 815 85 000 53 014 00 00 00 00 96 00 00 40 WITH POINTS AND CLOSING COSTS Selling price gt 90 000 00 Points gt 2 0 Amount
31. gt rate 8 875 loan 2 gt term 360 loan 2 gt pmt 903 24 loan 2 gt go loan 2 gt change rate 13 24 to 9 875 loan 2 gt change rate 25 end to 10 875 loan 2 gt change pmt 13 24 to 992 56 loan 2 gt change pmt 25 end to 1082 60 loan 2 gt go Next run G7 VARI LOAN from the programs main menu When you get the command prompt recall your file and rebuild it command gt recall karen Jork saved as KAREN recalled Vish to rebuild this loan Y N Y Echo on Y N Y Watch the loan get rebuilt by G7 Now although you re basically finished before you do a comparison you want to check on the last payment of each loan Since you re at the loan 2 prompt type loan 2 gt tail and you get PMT ENDBAL PRIN PMT INT PMT CURR PMT CURR RATE 352 8 272 68 998 58 84 02 082 60 0 8750 353 7 265 06 007 63 74 97 082 60 10 8750 354 6 248 29 016 76 65 84 082 60 10 8750 359 Ir 222 32 7025 97 56 63 082 60 0 8750 356 4 187 05 7035 27 47 33 082 60 0 8750 35 7 3 142 39 044 65 31 95 082 60 0 8750 358 2 088 27 7 054 12 28 48 082 60 0 8750 359 1 024 60 063 68 18 92 082 60 10 8750 360 00 1 024 60 9529 1 033 88 10 8750 You did really get 360 payments with the last payment close to the others So this loan looks very normalized i e you didn t expect to see the term shortened to say 342 payments via a mistake by the loan designers Then you want to check on the first loan scenario
32. is the PROFIT SHARE Program and What Does it Do Features Files Included With This Release Intended Audience for the Profit Share Program The Sample and Real Data Bases The Main Menu The Employee List Maintenance Menu Adding New Data Records Adding or Changing the Company Contribution 0 Calculating the Actual Profit Share 13 11 1312 13 13 13 14 ibe eee Wh The PROFI amount ca profit of salary t the profi as a sen states wh program months of t32 Fe 0 o o 0 o o o o o o o o o o o 13 3 Fi 13 4 In The PROFI which nee given the Al a Th There are live or data base of the pr to work w Page 71 The Report Generator The Backup Program Administrating Your Data Files Exiting the Program at is the PROFIT SHARE Program and What Does it Do T SHARE program using a small employee data base and an initial lled the company contribution quickly calculates the share of ach employ based on a weighted average of fiv mploy fields ime with company based on anniversary date hours worked during t sharing year an arbitrary factor from 1 to 5 which may be used iority factor and the participation flag YES or NO which ether or not this employee participates in this profit sharing The calculation takes only a second or two which may save weeks or hand calculation work atures
33. mortgage interest rate gt 8 5 Enter nominal monthly mortgage payment gt 275 00 Individual Mutual Fund Savings Account Information MF Savings 2 Enter mutual fund beginning balance gt 5000 00 Enter annual mutual fund interest rate gt 10 Enter nominal monthly mutual fund payment gt 100 MF Savings 2 Enter mutual fund beginning balance gt 5000 00 Enter annual mutual fund interest rate gt 10 Enter nominal monthly mutual fund payment gt 100 Then the program asks you how much detail you want to see You can see monthly summaries or just yearly summaries For finer detail do you wish to show each month Y N y Then where do you want you output to be disposed S screen P printer F fil Finally you are asked to put in a title for this set of finances so that it won t get confused with another Title gt For Mr amp Mrs Planner 14 7 The Example s Output File Printout to a File The exact output to file for example 14 6 is shown below Notice the end ing amounts section at the end Page 77 Retire With MUTUAL FUNDS ANALYSIS For Mr amp Mrs Planner 03 04 1993 Page 1 Start Amounts Mortgages Loans Funds Savings Total Equity 6 000 00 8 500 00 2 500 00 Balances Year Mo 1 1 5 10 83 8 820 83 3 110 00 1 2 5 419 44 9 144 34 3 724 90 3 5 125 81 9 470 54 4 344 74 4 4 829 91 9 799 46 4 969 55 1 5 4 531 73 10 435
34. of accomplishment o Information is where you need it O O O 000000 0 6 3 The Main Menu PAYMENTS PROGRA SEL ECTION GUID Gl 1 AMOUNT FINANCED vs INTEREST RATE You enter a starting interest rate and a starting amount financed You ll get a payment spread 2 LOAN PAYMENTS gt You enter an amount financed and an interest rate You get the monthly payments for terms over 1 30 years 3 AFFORDABLE PRINCIPAL gt You enter a starting interest rate and your lowest starting payment You ll get an affordability matrix 4 GROWTH PAYMENTS gt Enter payment and rate for growth chart 5 DISBURSEMENT PAYMENTS gt Enter withdrawal and rate for a chart Enter 1 5 or E gt Page 35 6 4 The Schedule The following schedule is your goal How do you read it Well first of all the borrower borrowed 10 000 at 10 75 He then wanted to know how long it would take to pay off the loan for different scenarios i e different amount of time term He told the computer program that he wanted monthly payments So looking at the schedule for 882 65 per month the loan will be paid off in 1 year Notice the M near the upper right hand corner of the report This M stands for monthly payments Similarly if he wants to repay the loan in 5 years then he knows right away that the m
35. problems What program _ Likes Dislikes Features wanted Problems bugs what program Want us to program or customize something special for you What Remarks This form does not imply free programming services nor is it an offer to perform services It is for information purposes only Fax form 24 hours to 978 356 7621 or mail completed Customer Feedback Form to Stephen J Foss 21 Hodgkins Drive IPSWICH MA 01938 1630 USA FPO MONAHAN OB WNE AANnDAOAARBWNEF CO MB NMN EH MH O Manual for PELTON S FINANCIAL SOFTWARE TABLE OF CONTENTS BY CHAPTER NUMBER Introduction and Selection Guide Distributions IRA Calculator Future Amount G5 Loan Payments G7 Variable Loan reserved Finance Things to Do oney Growth Matrix MGM Debt Analysis DA Profit Share Program Retire with Mutual Funds Fund Account Rate of Return Regular Mortgage vs Mortgage w Points Loan Management System G1 Lottery Generator AAYADUNBPWNHFOWO OAD RUNE Chapter 1 Introduction and Selection Guide TABLE OF CONTENTS BY SECTION NUMBER Welcome to Pelton s Financial Software PFS Registration Fee Information and Addresses e m The Problem Example Book Installing Pelton s Financial Software Dos and Windows left blank left blank Files Included With This Release Registration Procedures and Fee Hardware Requirem
36. save weeks or months of hand calculation work Although this financial calculation pro I ve decided to include it in vl 7 be gram was first released around 1989 cause I personally consider it to b to be lost by itself an xcellent program and it just seemed 1 40 The Regular Mortgage vs Points Mortgage Program This program presents a comparison of a regular mortgage loan level pay ments to the same loan with points and closing costs presumably at a dif ferent annual interest rate With this program you can answer the question of whether or not you should spend the extra money for points and closing costs up front in order to save mone y via less interest in the long run over the term S th xample in section 16 7 you may be surprised This is a much needed program for anybody getting a mortgage loan or refi nancing Page 14 1 41 The Loan Management System Gl The LMS program calculates number of days between payments and then calcu lates the simple interest actual or actuarial interest that accrued between these two dates Some firms use this type of loan as compared with direct reduction level payments type loan when lending money Reports can be printed to the screen printer or file The program offers quick balance lookups saving and editing payment information a convenient backup procedure and a convenient setup procedure 1 42 The Lottery
37. the Loan Calculator whereas entries 2 4 call upon other guides menus Entry 5 immediately brings you back to the programs Main Menu Loan Selection Guide lis ortgage Loans Installment Loans etc 2 Complex Loans comparison of loans etc 3 Exit back to Main Selection Guide Figure 1 3 Figure 1 3 shows the Loan Selection menu which appeared on the screen when you choose Work with Loans from the top level Here entry 1 calls upon G5SLOAN and entry 2 calls upon G7 VARI LOAN S the table of contents to locate examples of these powerful financial programs Growth Selection Guide Figure out a Deposit amount only Calc quantities for Interest only Calc quantities for Deposits amp Int Calculate an IRA s Ending Balance Exit back to Selection Guide OB WDNR Figure 1 4 Figure 1 4 shows the Growth Selector which appears when Money Growth is chosen from the top level Entry 1 of the Growth Selector calls up the FUTURE AMOUNT program entries 2 and 3 thread into the appropriate level of the FINANCE program and entry 4 brings up the IRA program T Page 10 Disbursement Selection Guide 1 Figure out a Withdrawal amount only 2 Calc quantities when Withdrawals Int 3 Exit back to Selection Guide Figure 1 5 Figure 1 5 shows the Disbursement Selector which appears when Money Disbursement is chosen from the top l
38. the previous page 10 7 Pressing H for Help When you press H you ll immediately get this help screen and menu Press any letter on the left side and you ll get help for that subject When you are finished viewing your help screen just press any key to go back to this menu To return to your list simply press lt Enter gt HELP MENU A gt Add a new item CG SRS Change an item E gt Exit the program F gt Find something in an item H gt Help this segment I gt Insert an item before another one Be soo gt Print all items on your printer R gt Remove an item S gt Sort your list U gt aUto add items to your list X gt eXchange one item for another lt Enter gt gt To go back to your list of things Choose an Item a c e f h i p r S u x gt 10 8 Exiting the Program Pressing lt Esc gt and sometimes E or e will either back you out of that par ticular inquiry sequence or completely exit you from the program depending on the context you are within Chapter 11 MGM TABLE OF CONTENTS BY SECTION NUMBER What is the MGM Program and What Does it Do Features The Bottom Line Menu The Matrix Screen Recurring and Non Recurring Deposits An E Th Th Th Th Th atrix Command Calculate Command Report Command Recall Command Save Command The Print Command The Exit Command ntering the Number of Mon
39. the shares Choos 5 from the employee list maintenance menu This massive calculation takes only a second or so for the computer where by hand it could take weeks or months ales pelle The Report Generator The report generator menu is presented to you after choosing 3 from the main menu The six types of sorted reports are shown below REPORT GENERATION MENU ling Print SHARE LIST by ID 2s Print SHARE LIST by LAST NAME Bre Print SHARE LIST by START DATE 4 Print SHARE LIST by SALARY Gu Print SHARE LIST by PROFIT SHARE 6 Print SHARE LIST by SOCIAL SEC 7 Exit this menu Your Choice E exit gt T312 The Backup Program For your convenience a data backup program has been included in the PROFIT program Choos 4 from the main menu to run it The live data base PROFIT DAT is the one that gets backed up You may choose which diskette drive to use See below for a sample session BACKUP DATA COPYING DATA h PLEASE WAIT BACKUP FINIS 13 13 Administrating As previously mentioned you have two data base fil You should back up your live data base DATA BACKUP PROGRA Page 74 TO WHICH DISKETTE DRIVE A B A FILE TO DISKETTE DRIVE A A MOMENT HED Your Data Files les a sample PSSAMPLE DAT and a live one PROFIT DAT
40. there 1 2 or 3 days between Tuesday and Thursday on which loan interest is accrued Consider that Tues day s accrued interest is paid on Tuesday s payment So interest is accrued for Wednesday and Thursday and paid on Thursday s payment so the answer here is 2 If in terest is accrued on Wednesday only the answer is 1 Ve think the correct answer is 2 Enter 1 2 or 3 lt ESc Exit gt gt 2 How many days in one year 360 365 gt 365 Jant to print days between payments on report Y N gt Y Enter floppy backup disk drive A B gt A These parameters are self explanatory The first parameter defines how you wish to count the number of days between dates 8 8 Customer Numbers and Filenames When opening a new loan the user is requested a customer number This num ber can be up to eight characters long The data is saved using this cus tomer number as part of the data file name 8 9 A Sample Data Base Below is shown a sample data base which appears on your installation disks The customer number is 1 the descriptive name is Steve Foss and the rest of the data is self explanatory We retrieved this data using Open an Old Data Base from the main menu The sample or header looks like this OPENING AN OLD DATA BASE Enter unique customer number gt 1 Enter loan description name gt Steve Foss Enter loan opening date gt 01 10 1994 Enter amount borrowed gt 10000
41. years terest Only Men zal an W Mr t balance while making recurring deposits may be solved for as long as the other four are known ts a rather esoteric solution finder B Account is a Savings scenario in wh B side suppose A s prescribed payment WA Notice that any qu Also B Account ich the tr A bo account which B Use this menu antity enu ned by rep EOE 000 per r B this m as coi A side rrows 10 Us G INTE ST Instead of paying 222 44 directly to t into a savings account which bears 6 per year ding balance is 15 596 05 instead of the traditional 13 347 00 The traditional interest to principal e A B Account method is 56 0 ONLY oT a ratio A sum of money is initially deposited in an interest bearing account and grows over time by INTEREST ONLY as in a savings bank account 1 Find END BALANCE given BEGIN AMOUNT RATE TER 2 Find BEGIN AMOUNT given RATE TERM END BALANCE 3 Find RATE given TERM END BALANCE BEGIN AMOUNT 4 Find TERM given END BALANCE BEGIN AMOUNT RATE E Exit and go back to Main Menu Enter 1 4 or E gt Page 58 Above is shown the Money Growth Interest Only Menu Use this menu to solve money growth problems tha
42. you have a mono monitor being driven from a color card you can force the program to display in black amp white by typing GO B Similarly you may force the program into color with GO C To print out a registration form do GO R To print out a Customer Feedback Form do this GO F Page 5 The main programs menu which I will mention often will appear quickly Then from this menu you can make your choice of which program to run I built in a powerful advanced feature called the Selection Guide to make it very easy to use the Financial Software This Selection Guide actually guides you to the correct program by asking a few simple questions about the type of problem you wish to solve More on the Selection Guide below 1 12 Command Line Qualifiers Here s a summary of the command line qualifiers you type these after you type GO e g GO R here the qualifier is R REG FORM prints out a registration form abbrev R F prints out a customer feedback form abbrev F BLACK forces black amp white operation abbrev B COLOR forces color for color monitors may not look to good on monochrome monitors abbrev C NO_CURTAIN suppresses closing curtain at program s end abbrev NO_CUR USE_EXPLODE uses exploding boxes instead of regular boxes abbrev USE EXP 1 13 Using Disk Caching At Pelton Computer I have been using disk caching software for m
43. your choice 12 11 Reports There are two quality and informative reports available the full report and the payoff date report Before printing a report you ll be requested for a title line which will show up on your report heading This title not only makes your report look a more professional but helps you label it for which client or project it s for See the next two sections for detailed informa tion on these reports 12 12 A Sample of a Payoff Date Report Below is shown a sample of the payoff date report type The account names are listed down the left side then major financial data then the paid off month and year below the heading Grand totals are given too As an extra financial ratios are given These ratios help the interested persons under stand the seriousness of the debt e g the higher the first ratio the more money was wasted on finance charges The second ratio kind of indicates how much over the top the debtor went Notice that the payoff data exactly mat ches that of the full report below The screen display is exactly the same as the printed report Notice the title For Mr John Q Debtor in the upper left hand corner of the heading For Mr John Q Debtor DEBT ANALYSIS REPORT 06 30 1992 Page 1 Payoff Date Report Beg Bal Fin Chg New World Visa 100 400 00 17 70 Paid off AUGUST 1992 Massasoit M C 450 00 41 74 Paid off JANUARY 1993 Templeton Visa 675 00 90 77
44. 13 57599 39 1 6 4 231 26 10 465 55 6 234 29 1 7 3 928 47 10 802 77 6 874 29 8 3 623 35 11 142 79 7 519 44 1 9 3 315 88 11 485 65 8 169 77 1 10 3 006 03 11 831 36 8 825 33 L l 2 693 79 12 179 95 9 486 16 des TZ 2 379 15 12 531 45 10 152431 2 1 2 062 07 12 885 88 10 823 81 2 2 1 742 55 13 243 26 11 500 72 2 3 1 420 55 13 603 62 12 183 07 2 4 1 259 50 13 966 99 12 707 49 2 5 1 208 67 14 333 38 13 124 71 2 6 1 157 27 14 702 82 13 545 56 2 7 1 105 29 1 57 075 35 13 970 06 2 8 170527472 15 450 98 14 398 26 2 9 999 56 15 829 73 14 830 17 2 0 945 81 16 211 65 15 265 84 2 11 891 45 16 596 75 T57 T0530 212 836 48 16 985 05 16 148 57 3 E 780 89 17 376 59 16 595 lt 71 3 2 724 67 17 771 40 17 046 73 3 3 667 83 18 169 49 17 501 67 3 4 610 34 18 570 91 17 960 57 3 5 552 20 18 975 66 18 423 46 3 6 493 42 19 383 79 18 890 38 3 7 433 97 19 795 33 19 361 36 3 8 373 85 20 210 29 19 836 44 3 9 313 06 20 628 71 20 315 65 3 10 251 58 21 050 61 20 799 03 3 Li 189 41 21 476 03 21 286 63 3 12 126 54 21 905 00 21 778 46 4 1 62 96 227 Bibs DA 22 274 58 4 2 22 773 69 22 773 69 4 3 23 21334 1 23 213 s47 4 4 23 656 92 23 656 92 4 5 24 104 06 24 104 06 4 6 24 554 92 24 554 92 4 7 25 009 55 25 009 55 Page 78 4 8 25 467 96 25 467 96 4 9 25 930 19 25 930 19 4 10 26 396 28 26 396 28 4 11 26 866 25 26 866 25 4 12 27 340 13 27 340 13 Ending Amounts Mortgages Loans Funds Savings Total Equity 0 00 27 340 13 27 340 13 Chapter 15 Fund Account R
45. 4500 rate 8 25 term 9 Next request a calculation for the appropriate payment by typing get pmt you could also type a as short hand for get pmt get pmt payment DLs 35 This looks good so let s set the payment amount as follows pmt pmt This line set the payment amount to the amount calculated 517 35 Next you must process the loan so that you ll have line items or payments to work with How many line items will there be after the above loan head ing information is processed Nine because there are 9 payments one for each of the 9 months for which the amount was borrowed You execute processing with go You could have used the shorthand notation for processing also Now you re in a position to actually look at some results There are thr ways to quickly look over the processed loan namely head tail and summary Shorthand for head tail and summary are h t and sum respectively At this time look over the first 10 only 9 will appear line items payments by typing head Notice that all 9 payments are neatly shown Head shows the first 9 pay ments or line items similarly tail shows you the last 9 Summary shows you the first 3 and last 3 Try summary Page 41 summary Summary is great for long loans Now you re ready to make some changes according to the real life payment schedule Keep the list of actual pay ments handy and type the
46. 60 10 8750 234 6 042 86 1 111 76 64 84 1 176 60 10 8750 235 4 921 02 7 121 84 54 76 176 60 0 8750 236 3 789 02 132 00 44 60 176 60 10 8750 237 2 646 75 1 142 26 34 34 1 176 60 10 8750 238 1 494 14 p26 23 99 176 60 0 8750 239 331 08 1 163 06 13 54 1 176 60 10 8750 240 00 331 08 3 00 334 08 10 8750 Notice that the last payment is number 240 That s 20 years So for another 94 00 per month you knocked 10 years off the life of the loan Then just to be complete you ran another comparison see below which shows you the 240 periods of loan 2 You also see a 157 average differ ence in monthly payment amount The interested reader may wish to try to modify loan 2 further to reduce the number of payments line items to 180 and the run another loan comparison Comparison LOAN 1 DIFF LOAN 2 Total number of payments made 180 60 240 Original number of payments 180 180 360 Annual interest rate 5 5000 3 3750 8 8750 Total principal paid off 115 000 00 115 000 00 Average payment per period 14311433 157 75 1 159 62 Last payment made L 161356 827 48 334 08 Total interest paid 122 125 75 41 182 93 163 308 68 Total amount paid 2347 GOS TS 41 182 93 278 308 68 Ratio of interest to principal 106 20 142 01 Ratio of interest to total amt 51 50 58 68 7 12 Example 5 Finding the Future Value of a Present Amount Page 50 What will 1 000 be worth in 24 months at an interest rate of 9 1509 Do the following Choose G
47. 7 from the main programs menu and you will get the command prompt command gt Then type pv 1000 i 9 1509 n 24 get fv The future value will readily appear as 1 200 7 13 More Examples Available Upon Request Call or write Pelton Computer Consultants for the availability of more G7 VARI LOAN examples Chapter 8 Loan Management System Program TABLE OF CONTENTS BY SECTION NUMBER What is the Loan Management System Program and What Does it Do Features Files Included With This Release Intended Audience for the Loan Management System Exiting the Program Backing Up Your Data File The Program Configuration Section Customer Numbers and Filenames A Sample Data Base The Main Menu Making a Brand New Data Base Data Base Header Changing the Data Base Header Adding New Data Records Payments or Receipts Changing a Data Record Finding a Loan s Present Balance The Report Generator FPO OAONAA UB WNE eae ey Yop po DOB WNEF CO o OOO OWA A CO OO OO CO OO oe What is the Loan Management System Program and What Does it Do The LMS program differs from usual loan programs because it calculates the number of days between payments and then calculates the simple interest actual or actuarial interest that accrued between these two dates Some firms use this type of loan as compared with direct reduction level payments type loan when
48. 8 Grand Total Contributions Made 5 550 00 Final Balance 6 439 28 Would you 3 5 Exiting the Program Pressing lt ing on the previous q Esc gt and sometimes ticular inquiry sequen context you typed 9000 instead of 90000 lt F1 gt to go back to quantity m 3 6 The Abbreviated Schedul Total Number of YEAR 1995 GRAND TOTALS 3 7 The Full Schedule Total Number of YEAR E or e will either back you out of that par ce or completely exit you from the program depend are within Pressing the lt F1 gt key will repeat the uestion Suppose you made a mistake on the principal amount you then at the interest rate inquiry just press the principal amount inquiry and enter the correct EPOSITS INTEREST BALANCE 100 00 36 08 1 136 08 100 00 100 17 24330 25 100 00 168 03 3 604 28 100 00 239 12 4 944 00 100 00 315 46 6 359 46 50 00 29 82 6 439 28 7950 00 889 28 6 439 28 EPOSITS INTEREST BALANCE 100 00 41 100 41 50 00 n92 150 92 550 00 1 85 702 78 50 00 3 34 TOOee LL 50 00 3 46 809 57 50 00 3 84 863 41 7 AUG 1989 8 SEP 1989 9 OCT 1989 10 NOV 1989 11 DEC 1989 Totals for year 1989 12 JAN 1990 13 FEB 1990 52 MAY 1993 53 JUN 1993 54 JUL 1993 55 AUG 1993 56 SEP 1993 57 OCT 1993 58 NOV 1993 59 DEC 1993 Totals for year 1994 60 JAN 19 95 Totals fo
49. B program will immed iately calculate the withdrawal amount for you This withdrawal amount is the amount of money that you may take out of your interest bearing account so that your money decreases to the ending balance over the term Calculat ing the withdrawal amount to reach the ending balance is not trivial be cause not only are you concerned about the withdrawal amount itself but you must take into consideration that the account is interest bearing DISTRIB is a very simple program that can immediately solve a not so simple prob lem A perfect account xample of a use of DISTRIB is the distributions from a closed IRA An elderly man has saved 57 000 in an IRA and wishes to withdraw a certain amount per month The interest rate is 6 25 He plans for 15 years worth of withdrawals and wants to leave 1 500 in the account Find the monthly withdrawal amount Using DISTRIB the answer is 483 68 2 2 Features O O O O O Or O O OOTO OJO O z The program offers you the following features Full glorious attractive color screens or black amp white mono Fancy reports to screen or printer Different compounding frequencies Can pause or quit during report output EBasy to understand queries questions you don t need financial training to use this program User can escape or quit at any time This program aids you in solving serious financial c
50. Balance Ending Balance Total Int Total Pmt Total End Bal 12 5 nu 1 EH mb i e Recall old file start New file The Bottom Line Menus and Request Lines Here I have the bottom line menus that appear throughout the program The ers in parentheses to the left are just a reference in this discussion s the main menu that comes up when the program is first run 2 is the next menu after recalling or starting a new file 3 is the menu seen after user has run the problem 4 is the request to run Demo lt Esc gt to quit nter the name of your file to recall 5 is the request for the report type where pressing F gets you a Fu wh 1 ie ll report and P a Pay off date report see below 6 is the print request where pressing S displays your data to the screen and P to the printer 7 is a customer number request 8 title gets printed on the printed reports Recall old file start lt F5 gt Zoom R for Report Report Start cal Enter filename to recall New file r is the titl un Demo lt Enter gt to cont M for Menu culation over or press lt Enter gt Menu Payoff date or Full report F Printer or Screen S Enter customer number gt _ lt request The lt Esc gt to quit lt Esc gt to quit Esc gt to quit Page 67 8 Title gt 12 6 How to Exit the Program From a
51. For the example shown in section 16 7 the exact output file is shown 16 7 Exampl i A person wishes to get a mortgage loan The selling price for the parcel is 90 000 and the person has a 5 000 down payment ready A regular 15 year mortgage loan is available at 7 50 per annum the bank pays the closing costs Another loan is available at a reduced rate of 6 75 for 15 years but requires 2 0 points up front with closing costs estimated to be 2 500 Which loan should the person sign up for Run the program and enter the appropriate values for selling price down payment rate term points and closing costs Then calculate You ll get a screen like this Regular Mortgage vs Mortgage with Points and Closing Costs 05 20 1994 REGULAR MORTGAG Gl WITH POINTS AND CLOSING COSTS Selling price gt 90 000 00 Selling price gt 90 000 00 Points gt 2 0 Amount gt 1 800 00 Closing costs gt 2 500 00 Down payment gt 5 000 00 Down payment gt 5 000 00 Principal borrowed gt 85 000 00 Principal borrowed gt 89 300 00 Annual interest rate gt 7 50 Annual interest rate gt 6 50 Term yrs gt 15 00 Term yrs gt 15 00 Monthly pmt calc gt 787 96 Monthly pmt calc gt 777 90 Monthly pmt used PAID BACK OVE Total principal Total interest i p ratio R TERM 66 9 gt gt gt 787 85 000 56 832 6 111 31 mor interest her The re
52. NCE which 1 000 ENDING BALANCE which ends at 15 000 and PRINCIPAL ch is the deposit amount calculated 220 57 Also you added a for the first deposit date of 01 01 89 it was actually entered Remember interest is always being gained too T BEGINNING PRINCIPAL PERIODIC ENDING TOTAL E BALANCE ADDED INT GAIN BALANCE PAID IN 9 1 000 00 220 57 5 13 L72250 225 70 9 1 225 70 220 57 6 28 1 452 55 226 85 9 1 452 55 220 57 7 44 1 680 56 228 01 9 1 680 56 ZA DT 8 61 1 909 74 229 18 9 1 909 74 220 57 9 79 2 140 10 230 36 3 137535 29 220 57 69 37 13 825 23 289 94 3 13 825 23 220 57 70 85 14 116 65 291 42 3 14 116 65 220 57 72 35 14 409 57 292 92 3 14 409 57 220 57 73 85 14 703 99 294 42 3 14 703 99 220 65 1s 3 0 15 000 00 296 01 WANT A PRINTOUT Y N 4 4 Exiting the Program Pressing lt Esc gt and sometimes E or e will either back you out of that par ticular inquiry sequence or completely exit you from the program depending on the context you are within Pressing lt F10 gt will immediately exit you from the program Pressing the lt F1 gt key will repeat the previous question Sup pose you made a mistake on the rate you typed 6 6 instead of 6 2 then at the compounding frequency query just press lt F1 gt to go back to the interest rate query and enter the correct quantity 6 2 4 5 Entering the Data Answering the Queries
53. OUNDING PERIOD lt Enter gt M Q W D Y gt lt Enter gt Enter TOTAL NUMBER OF YEARS gt 15 Enter ADDITIONAL MONTHS gt lt Enter gt PERIODIC WITHDRAWAL AMOUNT 483 68 Want a SCHEDULE Y N E exit S start over 2 6 Displaying a Schedule Pausing or Escaping Next by the magic of computer programming TELS and th sing the lt Esc gt key you ll see respond with an N th on the screen the space bar schedule possible to en press it your schedule will be generated pause the display by pressing a key like again to continue You can quit by pres program prints a schedule 2ail If yo Entering the Actual Payment u have chosen to display or print a schedule S the schedule abov At the bottom of the the words DO YOU WANT A PRINTOUT Y N If you e program goes back to the beginning For a Y the and the Date of the First Payment the program asks for the actual payment to be used and an optional first payment date like this Page 19 Enter PAYMENT you wish hit lt Enter gt for amount above gt lt Enter gt Enter date of first payment mmddyy gt 010189 The payment amount doesn t necessarily have to be the amount that the pro gram calculated it can be your choice Of course the arithmetic will work out better if you choose the default v
54. Paid off APRIL 1993 Totals 1 525 00 150 21 150 21 Grand Total Paid Out 1 675 21 All accounts to be paid off on or by APRIL 1993 The ratio of Total Finance Charges paid to Principal borrowed is 9 8 The ratio of the Total Paid back Principal Fin Chgs to Principal borrowed is 109 8 12 13 A Sample of a Full Report Below is shown a sample of the full report type The account names are listed up down up down across the top right below the heading and then each month s data is printed in a columnar fashion below the account names Page 69 Notice that the payoff data matches exactly that of the payoff date report n display is very simi above The heading appears on each pag lar to the printed report For Mr John Q Debtor Th scr J zj EBT ANALYSIS REPORT Page 1 Se 06 30 1992 New World Visa ARCH 1992 Beg Bal 400 Fin Chg Payment TESS End Bal 330 APRIL 1992 Beg Bal 330 Fin Chg 4 Payment Tos End Bal 20I AY 1992 Beg Bal 299 Fin Chg 3 Payment 75 End Bal 188 JUNE 1992 Beg Bal 188 Fin Chg 2 Payment 75 End Bal 115 JULY 1992 Beg Bal PES Fin Chg 1 Payment Toy End Bal 42 AUGUST 1992 Beg Bal 42 Fin Chg 0 Payment 42 End Bal Paid SEPTEMBER 1992 Beg Bal Fin Chg Payment End Bal OCTOBER 1992 Beg Bal Fin Chg 100 00 30 00 30 68 00 12 12
55. Programs 1 Lottery Generator 2 reserved for future 3 reserved for future 4 reserved for future 5 reserved for future Helper 6 reserved for future F1 Mort calc 7 reserved for future F2 DOS shell 8 reserved for future F3 Calendar 9 reserved for future F4 Calculator E Exit back to Main Menu 1 24 The Selection Guide As previously mentioned I have added a powerful tool to the main pro grams menu This tool is the Selection Guide If you are not totally familiar with each financial program use the Selection Guide to select th appropriate program and starting place The Selection Guide makes it as easy and as straightforward as possible for you to get your solution After you have chosen the Selection Guide from the main programs menu you will see the top level of the Selection Guide Fig 1 2 Page 9 Selection Guide Top Level Calc a Loan Payment etc Vork with Loans oney Growth oney Disbursement Exit back to Main Menu Oe WN ER Figure 1 2 The top level of the guide presents you with five choices calculate a loan payment or a rate term or principal provided three of the four are guantities are known calculate and print a loan schedule standard installment bimonthly biweekly calculate all money growth quantities with schedules and calculate all money disbursement quantities with schedules Entry number 1 threads into
56. Rate Payment pmt s 1 Ba OS 903 24 1 12 2 Sea 992 56 13 24 8 10 875 1082 60 25 end The second loan is less complex than the first Actually it was fairly easy to compare these two loan scenarios using G7 VARI LOAN The first thing to do is to use a standard word processor to makeup a G7 procedure file which you call KAREN G7 It is important to use ASCII output from your word processor which is sometimes called an editor by computer program mers so if you use Word Perfect or Wordstar or a similar product make sure the output is in the ASCII format Using an editor makes it easy to write repeating lines and make quick changes etc When you finish the file shown below save it and exit the editor PC WRITE was used in this example T command gt loan 1 loan 1 gt prin 115000 loan 1 gt rate 5 5 loan 1 gt term 180 loan 1 gt loan 1 gt pmt pmt loan 1 gt loan 1 gt change rate 13 24 to 7 25 loan 1 gt change rate 25 36 to 9 55 loan 1 gt change rate 37 48 to 12 75 loan 1 gt change rate 49 60 to 14 80 loan 1 gt change rate 61 72 to 15 75 loan 1 gt change rate 73 180 to 10 25 loan 1 gt change pmt 13 24 to 1010 12 loan 1 gt change pmt 25 36 to 1085 88 loan 1 gt change pmt 37 48 to 1167 32 loan 1 gt change pmt 49 60 to 1254 87 loan 1 gt change pmt 61 72 to 1348 99 Page 47 loan 1 gt change pmt 73 end to 1441 89 loan 1 gt loan 1 gt loan 2 loan 2 gt prin 115000 loan 2
57. The item number was generated automat ically At the Enter payment date line the previous payment date was shown to you for your convenience Also the present balance was shown at the top right This present balance will help you find the exact payoff if a client wants to completely payoff the loan now This is a great feature and helps get the correct date recorded and minimize data entry errors The same thing happens in the Enter payment amount line In this example we entered a comment in the comment line which appears in the report 8 14 Changing a Data Record What happens if you discover that there s an error in a payment Easy You can edit a data record payment record Choos 3 from the menu The same screen as for adding a new payment record appears for changing one You will be prompted for the customer number and for the item number So for example if we were to edit the item shown in section 8 13 we would enter 6 as the item number and proceed to change the payment amount payment date or comment 8 15 Finding a Loan s Present Balance We added this feature so the user could quickly and simply look up a loan s balance Choos 7 from the main menu You will be prompted for the customer number as usual Immediately the description and balance are shown The other way to get a loan s balance is to run a report either to the screen printer or file As a matter of fact i
58. W ON T K N Stephen J Foss 21 Hodgkins Drive Ipswich MA 01938 6 13 Number of Copies The programs asks how many The user said 1 m Could type E to exit How Many Copies gt 6 14 Schedule Printing Finally the schedule begins printing Press the lt Esc gt key to stop the printing The bottom line tells you for whom the report is being printed and how many copies Report now printing hit lt Esc gt to stop Stephen J Foss 1 Chapter 7 G7 VARI LOAN TABLE OF CONTENTS BY SECTION NUMBER What is the G7 VARI LOAN Program and What Does it Do Features The Commands The HELP Command Exiting the Program Displaying SHOWing a Schedule Schedule Printing PRINT sn YY YY I UD OBPWNE Page 38 7 8 G7 VARI LOAN Example 1 7 9 G7 VARI LOAN Example 2 TLO G7 VARI LOAN Example 3 7 11 G7 VARI LOAN Example 4 TEZ Example 5 Finding the Future Value of a Present Amount TL3 ore Examples Available Upon Request 7 1 What is the G7 VARI LOAN Program and What Does it Do With this Pelton s Financial Software you can analyze one or two different complex loans in which the interest rates or payment amounts may vary from payment to payment Secondly you can quickly compare the two loans via the side by side analysis summary With G7 VARI LOAN you can change any rate or payment am
59. a mistake on the rate Exiting the Program m h B O Page 18 r e will either back you out of that par exit you from the program depending Pressing lt F10 gt will immediately exit you from repeat the previous question Sup you typed 6 6 instead of 6 2 then at the compounding frequency query just press lt F1 gt to go back to the interest rate query and 245 Entering the Data Below are shown the questions nter th correct quantity 6 2 Answering the Queries queries that you will be presented with The figures refl or En ju ter your Enter Enter ENDING TITLE st hit lt Enter gt gt ct th EGINNING BALANCE BALANCE xample stat for the report initial th d Lf Zend ha zal ter ANNUAL INT gt 6 25 ER EST RATE If you want Monthly distributions how much you will end up with is amount should be less than the it may be zero d in section 1 if you desire one otherwis amount gt 57000 Pa a BEGINNING BALANC t lt Enter gt gt 1500 as is common then just hit lt Enter gt or Quarterly hit Q or Weekly hit W or Daily hit D or Yearly hit Y For example if you choose W for Weekly your report will show Weekly distributions Enter COMP
60. alculation problems Fast loading The program is well thought out people who use it like it Fast execution Continuous dedicated support by the author Excellent documentation This program will increase your productivity and give you a true sense of accomplishment Information is where you need it 2 3 The Schedule Below is shown the first few and last few entries of a typical schedule using the example of section 1 above Notice the BEGINNING BALANCE which starts at 57 000 the ENDING BALANCE which ends at 1 500 and PRINCIPAL VI THDRAWN which is the withdrawal amount calculated 483 68 Also I added a dummy date for the first withdrawal date of 01 01 89 it was actu ally entered as 010189 Remember interest is always being gained too PMT WITHDRAWAL DATE 1 017 89 2 01 89 3 01 89 4 01 89 5 01 89 Oe WBN EF 177 9 01 03 178 10 01 03 179 11 01 03 180 12 01 03 BEGINNING BALANCE 56 436 66 PRINCIPAL WITHDRAWN rg ERIODIC INT GAIN ENDING BALANCE 56 246 92 TOTAL PAID OUT WANT A PRINTOUT Y N this section intentionally left blank page 17 left intentionally blank Pressing lt Esc gt and sometimes ticular inquiry sequence or completely on the context you are within Pressing the lt F1 gt key will the program pose you made
61. alue Also it s always more professional to include a date if at all possible 2 8 Schedule Printing If you elect to print a schedule the program will request the screen or printer If you choose the printer press the lt Esc gt key to stop the printing or the lt Space gt key to pause lt Esc gt to cancel lt Space gt to pause DISTRIBUTIONS PROGRAM PRINTING Chapter 3 IRA CALC TABLE OF CONTENTS BY SECTION NUMBER What is the IRA CALC Program and What Does it Do Features The Questions the Program Will be Asking You The Summary Exiting the Program The Abbreviated Schedul The Full Schedule WWWW WW WwW HWUHDOBWNE 3 1 What is the IRA CALC Program and What Does it Do IRA CALC is a computer program that calculates the ending balance for a money growth financial problem like that of an individual retirement account The program accepts an initial amount when you open the account say a recurring monthly amount and a recurring yearly amount with the associated deposit dates A summary of information an abbreviated schedule and a full schedule can be printed or displayed The IRA CALC program solves many growth problems not just IRA s Compounded daily interest is used in the calculations As an example consider an IRA with interest rate 5 5 an initial deposit of 100 on Feb 2 1989 a recurring monthly deposi
62. and compound ing frequency and prints out the periodic payment monthly quarterly etc needed to payoff amortize the loan in 1 year 2 years 3 4 5 up Page 34 to 30 years From this report a borrower may find for example how much the monthly payment is to payoff his loan in 5 10 15 or 20 years Some borrowers look at the 30 year monthly payment and the 20 year payment and find the difference they would have to pay monthly in additional principal in order to payoff the loan in only 20 years This whole process can be done with the PAYMENTS program in only a few keystrokes This is only one example PAYMENTS can do much more See section 6 3 below 6 2 Features The program offers you the following features fe Full glorious attractive color screens or black amp white mono 0 Fancy reports to screen or printer o Different compounding frequencies o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program Escape or quit at any time Client s name and address block is saved for convenience This program aids you in solving serious financial calculation problems Get help at the press of a key Fast loading The program is well thought out people who use it like it Fast execution Continuous dedicated support by the author Excellent documentation This program will increase your productivity and give you a true sense
63. and get a monthly withdrawal amount for a range of interest rates and a range of term in years 14 4 Exiting the Program Pressing the lt Esc gt key will bring you back to the previous question Press ing lt F10 gt will quit fast 14 5 Printing to Screen Printer or File The program allows you to send your output to one of three places screen printer or file The output to file file created is pure text and for the example shown in section 14 6 this exact file is shown in section 14 7 14 6 A Complete Example The Retire With Mutual Funds program flow so to speak is shown below First it starts out with the number of years in your retirement plan Entering Number of Years Enter number of years in your retirement plan 1 70 gt 4 Next it requests the number of loans and the number of savings accounts Entering Number of Items Enter number of mortgages loans being paid 0 9 gt 2 Enter number of mutual funds savings accts considered 0 9 2 Then each financial info for each individual item is entered loans first the savings accounts Page 76 Individual Mortgage Loan Information Mortgage Loan 1 Enter total remaining principal to pay off gt 2000 Enter annual mortgage interest rate gt 13 5 Enter nominal monthly mortgage payment gt 65 00 Mortgage Loan 2 Enter total remaining principal to pay off gt 4000 00 Enter annual
64. any years Disk caching software is available from your Shareware dealer This caching software allows the computer to load a program from memory more than fifty times faster than from disk The caching scheme tells the operating system to look in cache memory before it looks at the disk for a program or data assuming theoretically that you will use 20 of your programs 80 of the time Pelton s Financial Software is a good candidate for disk caching as it would appear to load almost instantaneously 1 14 Planning Your Problem Solving Strategy The first step in strategy planning is to define your goal define your target What are you looking for Is it an ending balance a payment amount an interest rate or a Starting amount sometimes called a beginning amount or lump sum The second step is to write down the information you are given to work with and make sure it is complete For a simple example suppose your goal is to find the monthly payment of a mortgage loan You are given the amount financed usually called the principal the annual interest rate and the term In this case your information is complete If it weren t Pelton s Financial Software would inform you so Once you have gathered all your information the programs will ask you the correct questions in a logical order Page 6 For more complex problems which are solved in parts break the problem into parts and ascertain
65. aoe O mes es es OC 195 We wi Mail P 24 h REGISTRATION FORM for Pelton s Financial Software PELTON COMPUTER CONSULTANTS Stephen J Foss 21 Hodgkins Drive Ipswich MA 01938 1630 Tel Voice 978 356 0571 Today s Date 20 Name Company Address City State Zip Country Day telephone X FREE info about Pelton s Financial Calculation Services and Printed Schedules Financial Software Problem Example Book Site Licenses Programming Services The Big Information Kit many pages of printouts and sample reports 00 plus Shipping Handling s amp h 4 00 domestic US unless otherwise stated Canada amp Mexico 7 00 overseas 15 00 Check COMPUT nclosed include s amp h payable to PELTON Please send me a PayPal Invoice you can pay with a credit card when you receive this invoice 11 send you an email with the software in an attachment completed registration form with TOTAL of fees IN U S DOLLARS to ELTON COMPUTER 21 Hodgkins Drive IPSWICH MA 01938 1630 U S A our fax for MC VISA orders at 978 356 7621 Note After we receive your fax we will send you a PayPal Invoice CUSTOMER FEEDBACK FORM for Pelton s Financial Software Name Company Address Telephone Computer type description processor memory H D monitor etc Likes dislikes features wanted
66. ate of Return TABLE OF CONTENTS BY SECTION NUMB Ba R Vhat is the Fund Account Rate of Return Program and What s it Do Features Future Enhancements Exiting the Program Printing to Screen Printer or File A Complete Example The Example s Output File Printout to a File annnnn wo J O3 PWN EF TSL What is the Fund Account Rate of Return Program and What s it Do A broker fund accountant or fund manager has clients who hold accounts with him or her These clients make fund purchases of shares of a mutual fund for example redemptions like withdrawals receive growth on funds and reinvest it and may receive distributions shareholders dividends from certain companies which are part of the funds group of investments The fund accountant wishes to calculate the annualized rate of return over a year or maybe over several months The Fund Account Rate of Return program will calculate this rate of return This rate of return is just that a simple rate of return all transactions in the fund took place in the past it s not really the internal rate of return IRR as some may call it because IRR is a calculation based on a series of future payments or amounts of money like savings The discount rate where these payments make the net present value NPV calculation zero is called the IRR Ina future version of Pelton s Financial Software I plan to have an IRR
67. calcu lation program This financial program is very useful L532 Features fe Full glorious attractive color screens or black amp white mono O eaningful reports to screen printer or file o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time o This program aids you in solving serious financial calculation financial planning problems esp for brokers and account managers fe Fast loading fast execution o The program is well thought out people who use it like it o Continuous dedicated support by the author O Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it T53 Future Enhancements Page 79 In a subsequent version the purchases think of deposits will be accounted for more according to time by months or exact date because these purchases should not be considered over a whole year or over a whole period as one under consideration and therefore will affect less than a year or a whole period 15 4 Exiting the Program Pressing the lt Esc gt key will bring you back to ing lt F10 gt will quit fast TSS Printing to Screen Printer or File The program allows you to send your output to lump sum A pu
68. cated support by the author Excellent documentation This program will increase your productivity and give you a true sense of accomplishment Information is where you need it Keeps you organized by keeping your lists organized It s very easy to update the computer list from a paper list This program was designed with you in mind OO 707 10 O 0 TO 20 0 OO Or OO O02 0 O O70 O20 oo0o0o Page 60 10 3 The Main Menu THINGS TO DO AIN MENU 1 USE LAST USED LIST 2 RECALL OLD LIST 3 CREATE A NEW LIST 4 REMOVE AN EXISTING LIST 5 EXIT PROGRA 10 4 The bottom line menu When you finally enter into a list from the Main Menu your list will be displayed and the 24th line menu will appear as shown below A add C chang E exit F find H help I insert F10 quit P print R remove S sort U auto add X xchange TOSS Add aUtoadd Change Print Find Sort Help eXchange Insert Remove lt Esc gt Here s what the commands mean and how they work what how what it does and how it works Add press A adds one new item from a request line to the list aUtoadd press U adds more than one item on an ongoing basis to the present list After adding the item you get re turned to the request line aUtoadd is more com fortable to use for entering a long list of items Press lt Esc gt to quit aUtoadd Change press C Changes a section o
69. e Main Menu The CALCULATOR The Schedule Maker The Company Name Data Base xiting the Program tering the Principal tering the Interest Rate tering the Compounding Frequency tering the Payment Amount for Conventional Loans tering the second day for Twice Monthly Type Loans tering Pertinent Other Data tering the Optional Job Number tering the Optional Client s Name and Address Schedule Summary The Output Menu Displaying a Schedule Schedule Printing a 3 FPO MONAHAN UB WNE BS OmMDAIADUABFWNEF CO 5 oooqo do Ppp Bo ies HEP Ae eee e aaaea Ti OT O A O T A A O G T a a O wo pe E pe E E ES e H F T R 5 1 What is the G5LOAN Program and What Does it Do This loan program is not just another run of the mill loan scheduler G5LOAN will print out loan schedules for your documentation loan summary information summary by years of interest and principal paid and last pay ment The loan calculator will calculate the payment principal rate or term if you know three out of four of these quantities Your G5LOAN pro gram will also calculate the add on interest amount for installment loans as well as show you the current rebate and the current payoff How many times Page 26 have you had to call your bank and ask for this information Suppose you have a 3 000 loan The interest rate is 13 5 Compounding is monthly and the term is 42 mont
70. e can be more than one winner The CFF s are greatly appreciated by the software authors The actual CFF is the file FEEDBACK TXT on disk 1 26 Reporting a Problem With the Software Using a CFF Computer programs are always being enhanced with features or expanded in some way Even though extensive care to detail and extensive testing have taken place during the development of software before it gets to the user occasionally a bug will surface As you attempt to use the program therefore perhaps something doesn t quite work correctly or quite work the way you expect If a bug should appear please file a Customer Feedback Form so that the programmer will be aware of it To report a problem just write down your name address phone number in case I want to contact you about the problem and type of computer accord ing to the CFF form which program you have trouble with and a description of the problem Page 11 1 27 The Seventeen Pelton s Financial Software These are the 17 programs listed within the programs menus PAYMENTS G5SLOAN FINANCE IRA DISTRIBUTIONS FUTURE AMOUNT G7 VARI LOAN MGM DEBT ANALYSIS PROFIT SHARE RETIRE WITH MUTUAL FUNDS FUND ACCOUNT RATE OF RETURN REGULAR MORTGAGE vs POINTS MORTGAG LOAN MANAGEMENT SYSTEM G1 LOTTERY mi E Gl Cl Z Gl There are two undoc
71. ebt structure You should find the process of recalling and saving your work pretty simple and convenient 12 9 Saving Your Work Upon performing and orderly exit the program will request you to save your work i e if you have made any changes If you answer Y to save then the program will ask for a file name if you haven t previously saved it or re called it but if you have the filename will appear as the default Then it will ask you for a customer number which can be anything Finally you will be notified if the file is to be replaced or not If you choose to replace it all your work will be saved under the chosen file name If not the changes won t be saved Be careful when replacing or not replacing you wouldn t want to have worked for a long time and then inadvertently lose all your changes 12 10 The Edit Window The edit window screen is shown below From a bottom line menu press th lt F5 gt key to pop up this window From it you may modify parameters shown below and further analyze the debtor s situation To remove the edit win dow simply press lt F5 gt again or lt Esc gt You ll find the data entry associ ated with the edit window straightforward and unconfusing EDIT WINDOW Edit Menu 1 Modify an Account name 2 Modify an Interest rate APR 3 Modify a Beginning balance 4 Modify a Payment amount 5 Modify starting Month year Enter
72. ely solve a not so simple problem Suppose a can get an her monthl 220 5 4 2 Featu o o 0 0 0 o 0 o o 0 o o o o 4 3 The S Below is s using th lady wishes to save up to 15 000 over 4 years and 6 months She interest rate of 6 15 She ll start with 1 000 What would y deposit amount be to reach her goal Using FUTURE the answer is T res The program offers you the following features Full glorious attractive color screens or black amp white mono Fancy reports to screen or printer Different compounding frequencies Pause or quit during report output Easy to understand queries questions you don t need financial training to use this program Escape or quit at any time This program aids you in solving serious financial calculation problems Fast loading The program is well thought out people who use it like it Fast execution Continuous dedicated support by the author Excellent documentation This program will increase your productivity and give you a true sense of accomplishment Information is where you need it chedule hown the first few and last few entries of a typical schedule starts at ADDED whi dummy date as 010189 PMT DEPOSI DAT 1 1 01 0 2 2 01 0 3 3 01 0 4 4 01 0 5 5 01 0 50 2 01 1 opi 3 01 1 52 4 01 1 53 570171 54 6 01 1 xample of section 1 above Notice the BEGINNING BALA
73. ents Intended Audience for Pelton s Financial Software Quick Run How to Run the Main Program Command Line Qualifiers Using Disk Caching Planning Your Problem Solving Strategy The Pelton s Financial Software Main Menu left blank The Helper Box Function Keys The Mortgage Calculator The DOS Shell The Popup Calendar The Popup Calculator The Other Programs Menu Selection Page 1 Page 2 123 The More Programs Menu Selection 1 24 The Selection Guide 1 325 Pelton s Name Address Telephone Number Order Form and Customer Feedback Form CFF 1 426 Reporting a Problem With the Programs Using a CFF 1 27 The Seventeen Pelton s Financial Software 1 28 The PAYMENTS Program 129 The GSLOAN Program 1 30 The FINANCE Program en al The IRA Program 1 32 The DISTRIBUTIONS Program 1 33 The FUTURE AMOUNT Program 1 34 The G7 VARI LOAN Program 12 35 The MGM Money Growth Matrix 1 36 The DA Debt Analysis Program 1 37 The Retire With Mutual Funds Program L238 The Fund Account Rate of Return 1 39 The Profit Share Program 1 40 The Reg Mortgage vs Points Mortgage Program 1 41 The Loan Management System G1 1 42 The Lottery Generator 1 43 What reserved for future Means 1 44 Disclaimer 1 45 Copyright Infringement 1 1 Welcome to Pelton s Financial Software PFS Pelton s Financial Software abbrev PFS is a c
74. eople who say it s the best they ve seen and used O Fast execution o Continuous dedicated support by the author O Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it The Main Menu is Shown Below MAIN FUNCTION M zal N U Loan Calculator for Monthly Mortgage Quantities Use this section to find the payment principal rate or term of a standard monthly mortgage if you know three out of four of these quantities Loan Schedules Professional Looking Reports Use this section to explore mor xotic loan types and loan information like last payment loan sum maries yearly interest amp principal summaries and print the best professional looking loan schedules Edit Your Company s Name to Appear on Printed Reports Page 27 Use this section to add edit your own company s name E Exit the program go back to Financial Programs Menu zal v Enter 1 2 3 or There are thr parts to the GSLOAN program The CALCULATOR the Sched ule maker and the company name data base 5 4 The CALCULATOR The CALCULATOR s first screen is shown below Principal Enter principal amount financed gt 1 000 00 Interest rate Enter yearly interest rate gt 12 Term Number of years gt 1 Additional number of months gt 0 Years 1 Months 0 Weeks 0 Given payment amount Ente
75. evel Entry 1 of the Disbursement Guide calls up the DISTRIBUTIONS program and entry 2 threads into the appropriate level of the FINANCE program If you know basically what kind of financial problem you have to solve the Selection Guide will help lead you there in the quickest way even if you have never used Pelton s Financial Software before 1 25 Pelton s Name Address Telephone Number Order Form and Customer Feedback Form CFF You ll notice an entry on the Main Menu marked P for Info on Pelton If you move the slide bar down to this level and press lt Enter gt or P you will be prompted to press I or F Information or a Customer Feedback Form respectively Use the Customer Feedback Form to report any problems bugs new ideas enhancements likes or dislikes If you choose I Pelton s name address and telephone number will appear immediately in a box on the center of the screen The menu program will also ask you if you wish to print this information on your printer You may answer yes Y no N or exit E If you choose to print an Order Form will be printed Pressing the lt Esc gt key always exits or backs you out of the present context throughout the programs If you choose F a User Feed back Form will be printed Interactively you may type GO R to get a print out of the registration form Over a year the best CFF is chosen and its author is awarded a prize Ther
76. f an item or the whole item You tell the program which item and the change Exit press E or lt Esc gt You leave the present context Program quits from ain Menu if you press lt Esc gt or E Find press F The program finds a string embedded in an item It tells you the item or s Help press H Brings up the help menu See section 10 7 below Insert press I Inserts an item before another item in your list You tell the program which item Print press P Prints your list on the printer Remove press R Deletes an item You tell it th Sort press S Sorts the whole list in alphabetical order Be careful not to sort if you have prioritized your items at entry time or using Insert or eXchange eXchange press X Exchanges two items You tell it the two item s 10 6 Other Commands There are thr other commands lt Enter gt up arrow and down arrow When you are displaying your list on the screen you will see 17 items per screen So if you have 59 items in your list of things to do then there will be 3 screens full 17 items each and one last screen with 5 items for a total of 4 screens Pressing lt Enter gt moves the display to the next screen Like Page 61 wise the down arrow key moves the display to the next page worth of items The up arrow key moves your display to
77. f for some reason the two methods result in two different balances you should run the report in doing so the correct balance will appear and be updated Then the two methods will match FINDING PRESENT BALANC Enter unique customer number gt 1 EA Customer name Steve Foss Loan s present balance is 5 417 48 Press a key 8 16 The Report Generator Below is shown a sample report The customer number is 1 Output went to a file which has a default name of G1 PRN After you generate an output file you may print it send it or import it into a word processor Notice how the Days between payments is always shown since we chose that as an option in the configuration section Also notice that item 2 has a comment line attached There are five items shown Enter unique customer number gt 1 Output to Screen Printer or File F Enter unique customer number gt 1 Customer number 1 el Opening Date Amount borrowed Daily rate Nominal payment Desc Steve Rate Term in years Add 1l term in months us EGINNING BALANCE 01 10 10 000 00 12 00 0 000328767 888 49 Page 55 Foss 1994 1 years 0 months PRINCIPAL AMOUNT ENDING BALANCE I 1 01 10 1994 Amount borrowed Days between payments is This 02 12 1994 is item 10 000 00 33
78. fferent annual interest rate With this program you can answer points in the a much T62 the question of whether or not you should spend the extra money for and closing costs up front in order to save money via less interest long run over the term S th xample in section 16 7 This is needed program for anybody getting a mortgage loan or refinancing Features Page 81 0 Full glorious attractive color screens or black amp white mono 0 eaningful reports on screen or to printer or file o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time o This program aids you in solving serious financial calculation financial planning problems esp for brokers and account managers O Fast loading fast execution o The program is well thought out people who use it like it o Continuous dedicated support by the author oO Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 6253 Exiting the Program Pressing the lt Esc gt or lt F10 gt key during data entry will exit the program Pressing Q at the 25th line menu will also exit the program 16 6 Printing to Printer or File The program allows you to send your output to one of two places printer or file The output to file file created POI PRN is pure text
79. following change pmt 1 to 510 change pmt 2 to 525 change pmt 3 to 400 change pmt 4 to 475 change pmt 5 to 375 change pmt 6 to 515 go Don t forget the go because that will reprocess the loan with the new payment information Then type head to see the first 9 payments head The whole loan has been successfully reconstructed Notice the last pay ment is higher than usual as expected at 831 84 Your assignment is almost complete Save your work and print out the documentation assigning a name to the file e g jsmith After typing save the program will request a name for the file and you should type jsmith as the program will acknowledge your entry Finally request a printout of all line items by entering print all save nter filename jsmith work saved under jsmith print all Now the vital statistics of the loan are in black and white The last thing to do is to exit the program as follows exit Are you sure y n y and then you are brought back to the programs main menu 7 9 G7 VARI LOAN Example 2 Upon reviewing the previous loan you found out that the client actually paid 555 on payment number 6 and 550 on payment number 2 he made a mistake when he reported his payments to you Your job is to fix the loan pro duce documentation and save your work for later use First call up G7 VARI LOAN from the programs main menu From the command prompt you RECALL Pa
80. for the first tim The Open an Old Data Base choice is for an already created data base See section 8 9 S12 Changing the Data Base Header A data base refers to a customer or client becaus ach customer has his own data base unless a customer has more than one loan active A data base is administrated by the customer number When a new data base is added see section 8 11 that particular data is called the header s section 8 9 You may make changes to an already created data base i e make changes to the header by choosing Open an Old Data Base from the menu You ll be prompted for the customer number You ll be able to tell if you 8 13 Once the payments re in the correct Adding New Dat data base by looking at the description or name line a Records you ve opened th Menu c Payments or Receipts new data base you ll be ready to start data entry for 1 is hoic Make a Payment Rece W to a D B ipt We made making a payment very simple as there was no reason to complicate this Here s an example of making a payment A Comment gt This payment was hand DDING A LOAN PAYM Enter unique cust Enter p Enter payment amount ENT RECEIPT omer number gt 1 pres Item number gt 6 ayment date gt 06 13 1994 prev gt 985 prev delivered bal 6445 43 date 05 10 1994 pmt 975 Page 54 The customer number was again 1
81. ge 42 the previously named file jsmith as follows command gt recall jsmith Jork saved as JSMITH recalled Jish to rebuild this loan Y N Y Echo on Y N Y G7 successfully recalled the file jsmith and then asked you if you wish to rebuild it You answered Y otherwise you would not be able to do any work on this client s loan information Then G7 asked you if you wanted to watch it being rebuilt You said yes and this is what you saw rebuilding 1 LOAN 1 2 PRIN 4500 3 RATE 8 25 4 TERM 9 5 GET PMT payment 527 35 6 PMT PMT 7 payment 517735 8 GO 9 HEAD 10 CHAN PMT 1 TO 510 11 CHAN PMT 2 TO 525 12 CHAN PMT 3 TO 400 T3 CHAN PMT 4 TO 475 14 CHAN PMT 5 TO 375 15 CHAN PMT 6 TO 515 16 GO 17 H done loan 1 gt And you are left with the loan 1 environment prompt The rebuild oper ation printed line numbers for your reference Notice that on line 16 the loan actually got processed for you GO Now you have to modify it to suit your new information So you enter change pmt 6 to 555 change pmt 2 to 550 Notice the at the end This means GO or process Then you can see your results by entering tail which prints the last 10 lines out to th lines in all PMT OmMDANIADAKFPWNE anyway END BAL 4 020 3 498 3IpL22s 2 669 2 312 1 773 1 268 759 94 58 10 45 35 19 56 00 Next you requested a summa
82. gram Escape or quit at any time This program aids you in solving serious financial calculation mono Continuous dedicated support by the author Excellent documentation ll increase your productivity and give you a true lishment Information is where you need it sessions to from disk files people who use it like it Recurring Deposits column named or a 1 only ECUR 0 ONCE MATRIX REPORT SAVE RECALL EXIT CLEAR 1 RECUR ENDING DURATION RATE ONCE DATE YRS MOS WKS DAYS 4 4 4 4 4 pee Sese a ee eerie ae ceed cee ees eae eae a cave ara aan aed waate Been ae Sat See ee sess a ies ee eee lee Roe ae nels xasve commen N baal ceed mee Seen nee ean pues accu acc ac ab sae Gace PEnESpEE Ba e ea e 4 4 4 4 4 4 MATRIX REPORT SAVE RECALL EXIT CLEAR This column may If the deposit amount is a one time deposit enter a blank or a 0 in the column place more than once deposit so put a DN in say on a monthly basis the column then i th If the deposit takes t s called a recurring in section 11 6 xampl Page 63 11 6 An Example DEPOSIT DEPOSIT 1 RECUR ENDING DURATION DATE AMOUNT RATE O ONCE DATE YRS MOS WKS DAYS
83. gular mortgage loan costs term shown th The payments used ar regular loan 6 111 31 more closing costs would be better up front points amount plus closing costs loans except that the points loan has a 6 75 rate life like Regular Mortgage vs REGULAR MORTGAG Selling price Down payment Principal borrowed Annual interest rate Term yrs Monthly pmt calc Monthly pmt used on the left On first thought it seems that the loan with points and but don t forget that you had to have 4 300 Mortgage with Points and Closing Costs Gl sam 96 00 97 Monthly pmt PAID results in the payment of mor Page 82 as the calculated ones used gt 777 90 BACK OVER TERM Total principal gt 89 300 00 Total interest gt 50 721 66 56 8 This is a better loan less interest without the points and closing interest over th respectively The results in higher interest paid over the term 90 000 5 000 85 000 50 TS 787 787 00 00 00 00 96 96 Next consider the same two which is more real 05 20 199 4 WITH POINTS AND CLOSING COSTS Selling price gt 90 000 Points gt 2 Amount gt 1 800 Closing costs gt 2 500 Down payment gt 57 000 Principal borrowed gt 89 300 Annual interest rate gt 6 Term yrs gt 152 Monthly pmt calc gt 790 Monthly pmt used
84. hs The loan calculator immediately calculates the pay ment as 90 03 per month and the add on interest as 781 26 bringing the total payback sometimes called the deferred payment price to 3 781 26 With G5SLOAN you are able to calculate and document six types of loans Ds Ds 2 3 1 Regular direct reduction with level monthly payments 2 Regular direct reduction with twice monthly payments 3 Regular direct reduction with payments every 2 weeks 4 Add on interest installments according to the rule of 78 s 5 Conventional old fashioned payments decrease with time 6 Direct reduction using different compounding periods Features The program offers you the following features fe Full glorious attractive color screens or black amp white mono O Put your own name company name amp address in the report headings and this info is saved to be used over and can be changed 0 Professional reports to screen or printer O Client s name and address block is saved for convenience o Different compounding frequencies o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time fe This program aids you in solving serious financial calculation problems 0 Fast loading o The program is well thought out people who use it like it We ve gotten many unsolicited letters from p
85. ial ratios finance charges to principal and total paid back to principal and a full length schedule Quantities can be changed stored and recalled by filename A customer number can be included Later versions will allow customer address info and more features Still later versions are planned to have twelve accounts instead of six Page 13 1 37 The Retire With Mutual Funds Program What is the Retire With Mutual Funds Program RMF and What s it Do Suppose you have an extra 250 per month to either pay against the principal of your home mortgage or to invest in mutual funds towards your retirement What should you do The Retire With Mutual Funds financial program will un doubtedly answer your question once and for all The program will accept up to 50 mortgages or loans and 50 mutual funds or savings accounts See the complet xample in section 14 6 below But basically a person may have loans and savings accounts moving along contemporaneously and this program will monitor the financials of such for each month or for each year An annuity range and spread added in future version S 1 38 The Fund Account Rate of Return A broker fund accountant or fund manager has clients who hold accounts with him or her These clients make fund purchases of shares of a mutual fund for example redemptions like withdrawals receive growth on funds the Payments p
86. items and help THINGS TO DO is a program for everybody executives lawyers accountants computer people church people doctors property managers clerks secre taries homemakers anybody who keeps an organized list at home or at the office or anywhere there s an IBM PC or compatible computer One of our clients kept a list of items needed to remodel his family room One THINGS TO DO user made up a list for her dinner party I have found that secre taries love it and use it all the time This program comes in full color or black and white THINGS TO DO is a quick and easy computer program that you may use to manage many lists of items 10 2 Features The program offers you the following features Full glorious attractive color screens or black amp white mono Change a section of or a whole item Add up to 3000 items per list Autoadd feature for adding many items per session Can automatically enter last list used with one keystroke Start new lists or use old ones Find a string in an item Sort all items alphabetically Print all items on printer Remove an item Insert an item before another Exchange the places of two items Pause or quit during printing Easy to understand menu on the bottom of your screen Escape or quit at any time This program aids you in being organized Get help at the press of a key Fast loading The program is well thought out people who use it like it Fast execution Continuous dedi
87. lending money Reports can be printed to the screen printer or file The program offers quick balance lookups saving and editing payment information a convenient backup procedure and a con venient setup procedure 8 2 Features The program offers you the following features fe Full glorious attractive color screens or black amp white mono 0 Fast point and shoot menu fe Fancy report to screen or printer 0 Super fast calculation of days between payments and interest Page 51 payment o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time o This program aids you in solving serious financial calculation problems 0 Fast loading O The program is well thought out people who use it like it O Fast execution o Continuous dedicated support by the author 0 Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 8 3 Files Included With This Release G1 EXE The computer program itself G1 CTL The data file for setup don t delete this 1 G1 A sample data file 8 4 Intended Audience for the Loan Management System The LMS program was created for the firm which has need for calculating and saving loan information and payments of a customer or client The LMS pro g
88. mbers look the same maybe as being not really random 15 20 21 28 32 38 a 10 27 39 40 41 15 19 23 28 33 35 9 25 27 30 31 34 9 11 14 27 34 35 17 6 Printing the Lottery s As the last query the program asks for a printout If no is chosen any other key besides Y and E or lt Esc gt the user is brought back to the main program s screen see sec 17 4 If the user taps E or lt Esc gt the program quits Y prints the results Want a printout Y Yes Any Other Key No E Exit gt end of on disk manual
89. mple book Check out our Problem Example book It contains over 70 pages of real life financial examples solved in great detail using Pelton s Financial Software You ll be pleasantly surprised when you uncover this whole world of computer aided financial calculations 1 lt 4 DOS INSTALLATION To install Pelton s Financial Software on your computer s hard disk k in drive A and type A INSTALL comp put the dis through the hard disk DELet lation program your files from a bulletin board In this case do the following program W where the XX ete installation process NOTE Page 3 Installing Pelton s Financial Software Dos and Windows simply The INSTALL program walks you WELL If you install to a the fil called CD ROM TXT after installation The instal W INSTALL EX E shoul stands for th d delete this file for you If you got BBS you may not have the installation cd md TEMP2 cd TEMP2 PFPxXx EXE INSTALL current version which is a number like 22 The preferred installation directory is PELTON 1 7 Files Included With This Release ER ES DOC DOC DOC DOC DOC DOC h E EXE SAMPLI FI PA G7 G7 G7 IR MG SAMPLI ES 7 SAMPLI THINGS EXE CTI
90. ng money and expenses should be minimized This money is actually wasted and the lady gets nothing for it except the priv ilege of borrowing The total interest paid back between loans is signif icantly different This difference is a major reason to go with loan 1 and advise your client that loan 1 may be in her better interest Also the total amount paid back is more in loan 1 because the lady borrowed more The ratios also immediately display the attractiveness of loan 1 These interest ratios are half that of loan 2 The lady should take loan 1 This comparison chart of the G7 VARI LOAN program has really helped her 7 11 G7 VARI LOAN Example 4 A lady wants to get a mortgage loan on a new house She went to two professional mortgage companies and was offered graduated financing from both firms Can you compare these two loan scenarios using Pelton s Financial Programs The first company offered a loan with a 15 year term 180 payments with Page 46 the rate and payments varying over the first 6 years as follows Year Interest Rate Payment pmt s 1 5 500 939 65 1 12 2 7 250 1010 12 13 24 3 9 550 1085 88 25 36 4 12750 1167 32 37 48 5 14 800 1254 87 49 60 6 P54 750 1348 99 61 72 7 10 250 1441 89 72 end The second company offered a loan with a 30 year term 360 payments with the rate and payments varying over the first 3 years as follows Year Interest
91. nt is is the amount you first deposited when you opened your account ter Initial Deposit Amount 100 ter Initial Deposit Date MMDDYY 02 01 89 onthly Contribution Amount is is the recurring monthly amount you plan to put into your IRA every month If zero just hit lt Enter gt or enter 0 ter Monthly Contribution Amount 50 onthly Contribution Date is is the date of your FIRST monthly contribution The day of e month will be used in the calculations ter Monthly Contribution Date MMDDYY 03 25 89 Yearly Contribution Amount If you plan to make a yearly contribution perhaps at tax time put amount here If zero just hit lt Enter gt or enter 0 fn EN ter Yearly Contribution Amount 500 Yearly Contribution Date Th used in the calculations En EN is is the date of your YEARLY recurring contribution It will be ter Yearly Contribution Date MMDDYY 04 15 89 Skip in between displays and show a summary report S skip to summary N no Tr 4 The Summary Summary Statistics Total Number of Periods 60 Page 21 Annual Interest Rate 5 5000 Daily Interest Rate 000150685 Initial Deposit Amount 100 00 Initial Deposit Date 02 01 89 Regular Monthly Contribution 50 00 Regular Monthly Contribution Date 03 25 89 Regular Yearly Contribution 500 00 Regular Yearly Contribution Date 04 15 89 Grand Total Interest Gained 889 2
92. nter gt OR M compounding period is MONTHLY typical DAILY JEEKLY RY TWO WEEKS VICE MONTHLY UARTERLY FMI ANNUALLY NNUALLY ll S PMNOHNZY ll I PunOH ter a letter on left or just hit lt Enter gt for MONTHLY gt Cd BY 5 11 Entering the Payment Amount for Conventional Loans Loan type 5 is the conventional loan type This type of loan is very old fashioned but very straightforward For example suppose you borrow 100 from a friend for 10 months You say Look I ll pay you 10 per mo until the loan is paid off He says Yeah but I also want 12 percent annual interest OK So the monthly principal repayment is always Page 30 10 and on top of that you add the interest So the first payment is 11 90 remaining balance the second payment is 10 90 80 balance The monthly payment total of interest and principal varies each month This is a conventional loan So when using Pelton s Financial Software to schedule out a conventional loan you MUST state the monthly payment towards principal but you get help The G5 program chooses a minimum amount for you An example follows Principal Enter principal amount financed gt 1 000 00 Interest rate Enter yearly interest rate gt 12 Term Number of years gt 1 Additional number of months gt 0 Years 1 Months 0 Weeks 0 Given payment amount Enter
93. ny of the bottom line menus simply tap the lt Esc gt key for an orderly exit from the program If you have unsaved and or changed data the program will request you to save it For a high speed exit tap the lt F10 gt function key This action will exit you out quickly and not ask you to save anything so be careful not to lose any work you ve worked on for a long time 12 7 Starting a New File Once you have launched the program from the main Pelton menu you immediately come into DA s main bottom line menu To start a new file i e begin a new project so to speak just press N You will be lead into data entry via the edit window explained below and in the How the Program Works sec tion When you exit orderly you ll be requested to save the data with a filename max 8 characters and a customer number 12 8 Recalling Your Work From an Already Saved File From the main bottom line menu simply press R to recall your previously worked on file or project You ll immediately be requested for a filename A future version of DA will have a popup window with your filenames dis played but for now you must be able to remember your filename Perhaps you could name your files the same as the customer numbers up to 8 characters The file gets recalled and displayed and the program brings you up to the next bottom line menu from which you may run the financial projection or modify values lt F5 gt thus analyzing the d
94. ogram depend ing on the context you are within Pressing the lt F1 gt key will repeat the previous question Suppose you made a mistake on the principal amount you typed 9000 instead of 90000 then at the interest rate inquiry just press lt F1 gt to go back to the principal amount inquiry and enter the correct quantity 5 8 Entering the Principal Here the program asks how much was borrowed Enter any amount up to 99 999 999 99 Don t use dollar signs but if you enter commas the program expunges them Below the user entered 10 000 00 Type E to exit Principal Enter principal amount financed gt 10000 5 9 Entering the Interest Rate Next put in the interest rate per year In th xample below the user m was charged a yearly percentage rate of 10 75 Type E to exit Interest rate Enter yearly interest rate gt 10 75 5 10 Entering the Compounding Frequency Next decide what compounding frequency you will be working with Some business loans are compounded quarterly Most regular consumer loans are compounded monthly To use monthly you may just hit carriage return lt Enter gt or M Type E or lt Esc gt to exit Compounding Period The interest rate was given as a yearly rate APR but the lender may calculate payments QUARTERLY which is every three months for example Please make the appropriate choice below lt E
95. ollection of computer programs driven by a fancy menu part of which is the Selection Guide The programs solve many time value financial problems encountered in business See sections 1 30 to 1 42 below The Selection Guide guides the new or inexperienced Pelton user to the appropriate financial program to make it easy to get a quick and accurate answer S sections 1 15 and 1 27 below The software is fully functional as you receive it Nothing has been held back from you on the non registered copies Pelton s Financial Software straight from your Shareware vendor have all the features and extensions as registered packages but registrants i e software users who have registered get many more benefits See section 1 3 below The words program financial program and program all have the same mean ing throughout this manual which denotes an individual program See sec tion 1 30 below 1 2 The Registration Fee information and addresses The fee for this program is 195 00 plus s amp h You may also print out a Customer Feedback Form CFF You can get the CFF form from the command line GO F I thank you in advance The author conceived designed programmed and perfected the computer programs of Pelton Computer Consultants is Steve Foss B S M S Physics M S E E M B A The email address is steve MeTonto com The Website is www MeTonto com 1 3 The Problem Exa
96. ommand Pressing M or lt Enter gt when the MATRIX command is highlighted brings you into the MATRIX build environment 11 8 The Calculate Command Pressing C or lt Enter gt when the CALCULATE command is highlighted starts the matrix calculation which results in the final balance displayed in the lower right hand corner This balance is your goal F 11 9 The Report Command Pressing P or lt Enter gt when the REPORT command is highlighted prints a report complete with all calculations and final balance 11 10 The Recall Command Pressing R or lt Enter gt when the RECALL command is highlighted loads an MGM file into the matrix Don t enter a file extension see section 11 11 11 11 The Save Command Pressing S or lt Enter gt when the SAVE command is highlighted stores the MGM matrix to a disk file You will be prompted for a file name You do not have to nor should you use a file extension e g TXT or DOC because MGM appends its own extension to the filename s end 11 12 The Pressing L matrix and over 11 13 The CLI EAR Command or lt Enter gt zeroes out h Pressing HOP lt Enter gt when th the data Exit Command when th the confi from the rm G 11 14 DURATION en another lin want that line item to recur ation requ program try e item
97. onthly payment will be 216 18 02 05 88 PAYMENTS Scope Program by PELTON Ver 1 3 4 29 PM YEARS PAYMENT YEARS PAYMENT 1 882 65 16 109 321 2 464 92 17 106792 3 326221 18 104 86 4 257 25 19 103 08 5 216 18 20 101 53 6 89 07 21 100 17 7 169 92 22 98 98 8 55 74 23 97 94 9 44 88 24 97 02 10 36 34 25 96 21 11 129 48 26 95 50 12 123 88 27 94 86 13 19 25 28 94 30 14 115 337 29 93 80 15 112 10 30 93 235 DO YOU WANT A PRINTOUT Y N 6 5 The Questions the Program Will be Asking You The program will request the principal amount rate compounding period deposit amount withdrawal amount optional payment amount starting date optional job number client name and number of copies The program won t request all these quantities at once rather only certain ones depending on the menu choice and type of range and spread desired 6 6 Exiting the Program Pressing lt Esc gt and sometimes E or e will either back you out of that par ticular inquiry sequence or completely exit you from the program depend ing on the context you are within Pressing the lt F1 gt key will repeat the previous question Suppose you made a mistake on the principal amount you typed 9000 instead of 90000 then at the interest rate inquiry just press lt F1 gt to go back to the principal amount inquiry and enter the correct quantity 6 7 Here 99 999 999 99
98. or an installment loan G5LOAN is very practical professional straightforward and easy to use 1 30 The FINANCE Program This program is broken into two major sections money growth and money disbursement Money growth in itself consists of two parts growth of a sum by interest alone and growth of a sum by interest and deposits Money disbursement is the depletion by withdrawal of an interest bearing sum over time FINANCE will figure out any quantity principal rate term deposit or withdrawal starting sum or ending balance as long as five of these six quantities are known As you can see FINANCE is a very powerful program and can greatly assist you in financial planning 1 31 The IRA Program This one is a special program because it can calculate an ending balance of a complex IRA which is an interest bearing savings account into which an initial deposit a recurring monthly deposit and a recurring yearly deposit are made The initial monthly or yearly deposit may be zero but not all three of course as long as the date of the first deposit ever made has been signified A summary sheet a yearly summary or a complete schedul may be printed after calculation Page 12 1 32 The DISTRIBUTIONS Program This program is actually a subset of the all inclusive FINANCE program Given a starting balance interest rate term and an ending balance which must be le
99. ount list the first three or last three payments or show a summary first 3 and last 3 You can also expand or shrink balloon a loan and you can save and recall your work The compare feature clearly helps you to decide which loan is better for you L features as you wi other helpful G7 VARI LOAN has many ll see later 7 2 Features The program offers you the following features fe Full glorious attractive color screens or black amp white mono 0 Fancy reports to screen or printer o Pause or quit during report output 0 Easy to change data and rerun the program o Escape or quit at any time o Client s name and address block is saved for convenience o This program aids you in solving serious financial calculation problems 0 Get help at the press of a key 0 Fast loading 0 Can save and recall sessions to from a disk file O The program is well thought out people who use it like it O Fast execution o Continuous dedicated support by the author O Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 7 3 The Commands The commands are shown similar to the actual top level help screen below 1 2 ADD BALLOON BEGBAL CALC CHANGE CLEAR CES CMD COMMENT COMPARE DOWN
100. payment amount if given by the lender if no amount is given enter zero 0 or hit lt Enter gt gt 83 33 Conventional Payment must be equal or greater than 83 33 NOTE chose the requested minimum for the monthly principal payment 83 33 Also see section 5 16 for another important comment 5 12 Entering the second day for Twice Monthly Type Loans Suppose you choose the twice monthly type loan type 2 see 5 1 Well there must be a second day on which the second payment of that month will be made You are allowed to choose this day as a number e g 15 or the program will choose it for you Below is an example Try using this option once or twice it s easy Second payment DAY for twice monthly payments Enter second payment DAY for month use format DD e g 25 for the 25th If first payment were made on the 10th second to be made on 25th For automatic date generation enter 0 then hit lt Enter gt gt 15 5 13 Entering Pertinent Other Data Some other important questions may come up during your G5 session They are Balloon payment number Enter balloon payment number if no balloon is wanted then enter zero 0 or hit lt Enter gt gt 0 Page 31 Payment dates Enter first payment date of loan use this format MMDDYYYY For no date enter 0 Then hit lt Enter gt gt 01 30 1991 Comments Do you wish to include any comments on
101. r Program undocumented RCA EXE The Revolving Checking Account undocumented RCA RCA The RCA Control File RCA DAT The RCA Default Data File NOT A DO NOT delete any of these files because the programs won t run 1 8 Registration Procedures and Fee Please fill out the registration form see above or print one out from the program can do GO R or simply go to the website and download the program from the store www MeTonto com 1 9 Hardware Requirements You ll need an decent PC computer not available for Mac this space left blank 1 10 Intended Audience For Pelton s Financial Software Anyone who needs financial information reports quantities and answers or schedules or documentation about the time value of money Some of the reg istrants I have include financial planners doctors investment firms ac counting firms law firms movie makers and retirees 1 11 Quick Run How to Run the Main Program At the DOS prompt type GO This automatically runs the program in either color mode or mono mode black amp white according to the equipment you have hooked up The program actually checks your computer s configuration and sets the color accordingly Sometimes as in the case of a laptop computer the screen is actually mono but the video board is CGA Color Graphics Adapter In this case the program senses a color configuration and the mono screen washes out some colors Therefore if
102. r payment amount if given by the lender if no amount is given enter zero 0 or hit lt Enter gt gt 0 00 NOTE in the above case I chose 0 for the GIVEN payment since I want G5 to calculate the exact payment amount for us GSLOAN Monthly Mortgage Calculator This is the second screen of the CALCULATOR Principal 1 000 00 Rate 12 0000 per year Compounding is Monthly Term 1 year or 12 pmts Payment 88 85 Page 28 For Monthly Mortgages Total Interest 66 19 Principal paid in 1 000 00 Total Payback 1 066 19 Monthly lease factor is 0889 NOTE if you have entered the CALCULATOR from Calc loan pmt from the Selection Guide then you may only exit back to the Selection Guide hence you ll get this bottom line E exit or lt Enter gt continue gt But if you entered the CALCULATOR from the G5 Main Menu which threaded from the Work with Loans entry of the Selection Guide then you ll wind up with this bottom line from which you may immediately enter the sched ule maker section of G5 go back to the Main G5 Menu or exit back to the Selection Guide M main menu S do a schedule E exit or lt Enter gt continue gt Don t let yourself be confused about this program flow just trying it is the best way to learn and you ll find that it is not really confusing 5 5 The Schedule Maker If you choose 2 from the G5 Main Men
103. r types of games for which a set of random numbers may be generated S section 17 4 for the main screen to see the games I7 2 Features O Output to screen or printer 0 Can generate numbers for four games o User can escape or quit at any time fe Fast loading O Fast execution o Continuous dedicated support by the author O Excellent documentation E3 Exiting the Program To exit the program at any time just press E or lt Esc gt and you ll be immediately brought back to the financial programs menu 17 4 Answering the Questions Below is shown the first screen and its four choices games This screen is self explanatory Below the user picked game A A Pick 6 numbers from range of 1 42 MEGABUCKS B Pick 6 numbers from range of 1 49 MASS MILLIONS Page 85 C Pick 4 numbers from range of 1 10 DAILY NUMBERS D Pick 5 numbers from range of 1 35 MASS CASH A B C D E Exit gt A The second query is as follows The program asks the user how many tickets sets of random numbers to generate The user chose 5 below The output is shown in the next section How many tickets do you wish Up to 20 Press lt Enter gt for 1 E Exit gt 5 Bley area The Lottery s Here are the five tickets produced and displayed on the computer s screen They are sorted in ascending numerical order so sometimes the nu
104. r year 1995 GRAND TOTALS Chapter 5000 s 4 TABLE OF CONTENTS Features The Schedule Exiting the Program Displaying a Schedule Entering the Actual Paym Schedule Printing RHE PHS HHP A AANnDAOFWNE 4 1 What is the FUTURE Program Given a starting balance interest rate must be greater than the starting balance the FUTURE iately calculate the deposit amount for you Vhat is the FUTURE Program 00 889 Future Amount BY S ECTION NUMBE and What Does it D Pausing or ent and the Date of the First Payment Entering the Data Answering the Queries Escaping and What Does it Do term and an m 28 Page 22 IT Ts 971 1 026 1 080 1 136 1 191 1 246 57 8 13s 5 890 SFIO 6 045 6 123 6 201 6 280 6 359 6 439 44 50 76 13 15 74 17 88 01 46 28 ending balance which program will This deposit amount is th amount of money that you must deposit into your interest bearing accoun that your money grows to the en term ding balance over th deposit amount to reach a goal of savings is not obvious because not on are you concerned about the deposit amount itself but you must take in Calcul immed e t so lating the ly to considerat Page 23 m ion that the account is interest bearing FUTURE is a very sim ple program that can immediat
105. ram calculates the number of days between payments and then calculates the simple interest actual or actuarial interest that accrued between thes two dates Some firms use this type of loan when lending money Reports can be printed to the screen printer or file 3 5 Exiting the Program Pressing lt ESCAPE gt and sometimes E or e will either back you out of that par ticular inquiry sequence or completely exit you from the program depending on the context you are within 8 6 Backing Up Your Data File For your convenience a data backup program has been included in the pro gram Choos 8 or press F from the main menu to run it The program asks you for the customer number which is related to the filename The floppy disk drive is defined in the configuration section See below for a sample session BACKUP TO FLOPPY DISK Enter unique customer number gt 1 Vill backup customer 1 to floppy drive A Press a key to continue with the backup done In the above sample session the customer number was 1 and the program backed up the data file to floppy disk in drive A Page 52 8 7 The Program Configuration Section Below is shown the configuration screen PROGRAM SETUP PARAMETERS How do you want to count days between dates Suppose a debtor makes a payment on a loan on a Tuesday and then makes another payment on the Thursday of the same week Are
106. rchase for example may be mad near th nd of the period the profit of the account for the previous question Press one of three places screen printer or file The output to file file cr example shown in section 15 6 this exact file L56 A Complete Example The Fund Account Rate of Return program flow ated is pure text and for the is shown in section 15 7 so to speak is shown below The user entered the amounts to the right of the gt symbol Notice that the first request is for a title in order to avoid confusion The rest of the requests are self explanatory FUND ACCOUNT RAT T OF RETURN Press E to Exit at any query m Enter session TITLE gt Sample Session T ral nter INITIAL account balance or initial ral Money is WITHDRAWN after redemption of part Enter CURRENT VAI Percent Profit 19 51 Annualized 15 63 investment gt 4000 nter total PURCHASES of shares made during period gt 1000 of a fund Enter total amount of redemptions during period gt 1250 DISTRIBUTIONS are RECEIVED sometimes instead of being reinvested Enter total amount of distributions received gt 75 UE of account at end of period gt 6675 Enter number of MONTHS period account was HELD gt 9 Press C to continue P print to printer F print to file lt F10 gt to quit n Lp h Page 80
107. reens or black amp white mono 0 Fancy reports to screen or printer o Different compounding frequencies o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program o Escape or quit at any time o Client s name and address block is saved for convenience o This program aids you in solving serious financial calculation problems 0 Fast loading o The program is well thought out people who use it like it O Fast execution o Continuous dedicated support by the author O Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 9 3 The Main Menu FINANCE PROGRAM MAIN MENU T T Iz ONEY GROWTH 2 ONEY DISBURSEMENT 3 EXIT PROGRAM Above is an example of the Main Menu The program is divided into two per spectives Money Growth and Money Disbursement 9 4 The Growth Main Menu GROWTH MAIN MENU 1 MONEY GROWTH DEPOSITS INTEREST 2 MONEY GROWTH INTEREST ONLY 3 RETURN TO MENU Above is shown the Growth Main Menu From this menu you may choose to analyze and find unknown quantities when your growth scenario is by interest as in a savings account with a one time initial deposit or by inter only est pl 955 7 lus a constantly recurring deposit into a savings
108. rogram will be and reinvest it and may receive distributions shareholders dividends from certain companies which are part of the funds group of investments The fund accountant wishes to calculate the annualized rate of return over a year or maybe over several months will calculate this rate of return The T Fund Account Rate of Return program his rate of return is just that a simple rate of return all transactions in the fund took place in the past It s not really the internal ra te of return IRR as some may call it because IRR is a calculation based on a series of future payments or amounts of money like savings The make the net present value NPV cal dis cul count rate where these payments ation zero is called the IRR 1 39 The Profit Share Program m The PROFIT SHARE program using a small amount called the company contributi on employee data base and an initial quickly calculates the share of profit of each employ based on a weighted average of fiv mploy fields salary time with company based on anniversary date hours worked during the profit sharing year an arbitrary factor from 1 to 5 which may be used as a seniority factor and the participation flag YES or NO which states whether or not this employee participates in this profit sharing program The calculation takes only a second or two which may
109. rs you the following features Full glorious attractive color screens or black amp white mono Fancy reports to screen or printer Pause or guit during report output Easy to change data and rerun the program Escape or quit at any time This program aids you in solving serious financial calculation problems involving debt accounts and when they re paid off Fast loading fast execution Can save and recall sessions and data to from disk files The program is well thought out people who use it like it Continuous dedicated support by the author Excellent documentation This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it 000000 000000 12 3 How to Program Works You bring up the program from the main Pelton s Financial Software menu and you either choose to recall a file see Recalling below you ve worked on before start a new project s New File below so to speak or to step through a DA demo If you recall a file its data gets displayed and you can then work through the flow of debt payoff or you can modify some parameters see Edit Window below and analyze the debtor s situation If you start off making a new file you will be asked for the number of accounts to build the accounts names beginning balances finance charge rates APR nominal monthly payments and the debt structure s starting month and starting year
110. ry and here s what you got PMT N CO END BAL 4 020 3 498 37122 1 268 TO 94 s98 63 19 s96 00 screen her Here s what you got PRIN PMT INT PMT CURR PMT 479 06 30 94 510 00 92236 27 64 550 00 375 95 24 05 400 00 453 53 21 47 475 00 356 65 18 35 375 00 539 410 15 90 555 00 505 16 L219 517 35 508 63 8 72 5177 35 159 56 S22 764 78 summary PRIN PMT INT PMT CURR PMT 479 06 30 94 510 00 522 36 27 64 550 00 375 95 24 05 400 00 505 16 L249 517735 508 63 8 72 517739 759 56 5 22 764 78 Again you only have 9 lines in your loan scenario months but the summary is very useful when you have many lines say 240 or so Then finally 7 10 G7 VARI LOAN you save your work save nter filenam jsmith work saved under jsmith print all Example 3 Page 43 you only have 9 CURR RATE 8 2500 8 2500 8 2500 8 2500 8 2500 8 2500 8 2500 8 2500 8 2500 CURR RATE 8 2500 8 2500 8 2500 8 2500 8 2500 8 2500 because the term is 9 A lady wishes to purchase a car but she would like some guidance with her She can purchase the car for the full price of 4900 financing options and get a 4 9 interest rate over 48 months back and get 10 5 financing for 48 months to do Let s use G7 VARI LOAN Page 44 or she can take 1 100 cash Can you help her decid From the programs main menu choose G7 what Vari Loan and en
111. s employee maybe he or she doesn t want to be included or can t be included in profit sharing then type in N or n Also HOURS can stand for hours worked per profit sharing season calendar or fiscal year or whatever The data base holds a maximum of 500 entries as of this version ADDING A DATA RECORD r EMPLOY E ID 100 200 109 PARTICIPANT Y N YI El n SOCIAL SECURITY 332 36 9911 DEPARTMENT HEALTH ED LAST NAM T BINDER Page 73 FIRST NAME Gl MARCIA W START DATE 02 10 83 FACTOR 1 5 1 HOURS 2 001 00 ANNUAL SALARY 26 500 00 PROFIT SHARE 736 66 Gl L349 Adding or Changing the Company Contribution To create or change you company contribution amount choos 2 from the main menu see section 11 The company contribution is the amount of money that the company is willing to divide among all participants in the profit shar ing program The maximum amount is 10 Million An example is shown below ENTER COMPANY PROFIT SHARING CONTRIBUTION Company Contribution gt 7 500 00 Contribution Date gt 12 32 87 Press S to save data any other key for no save 13 10 Calculating the Actual Profit Share After you make any employ changes or if you should change the company contribution amount you must recalculate
112. s it Do DA gives you a quick and easy method for analyzing a person s total debt from one to six interest charging accounts like MasterCharge Visa first and second count names ments mortgages APR inte r and so on rest rate and the start off month and schedule of when these accounts will an approximation since interest is charged on a monthly basis All the user has to do is enter the ac year L be paid off beginning balances nominal monthly pay and the DA program will produce a The calculations are only not daily Page 65 but you ll find it a great program to get a strong handle on a person s debt status and how it can be resolved The user can single step through each month to check the debt status or he she can press C for a continuous cranking through and automatic display the months flash by of the debt status by month The continuous action is not only fun but can produce powerful information about a person s debt Two types of printed report can be produced A debt payoff date summary with financial ratios finance charges to principal and total paid back to principal and a full length schedule Quantities can be changed stored and recalled by filename A customer number can be included Later versions will allow customer address info and more features Still later versions are planned to have twelve accounts instead of six 12 2 Features The program offe
113. s program should contact the author 1 45 Copyright Infringement This program is protected under the copyright laws of the U S This pro gram is not public domain it is released to the Shareware distribution channel as Shareware Users and Shareware vendors may copy it freely and distribute it This program may not be sold nor copied and sold for profit or under a value added scheme to increase the value of a computer system etc or under a new name etc because the author reserves all copyright law rights The author has the reasonable intent of hoping for new registrants obtained from the Shareware distribution channel but does not want the program to be stolen by any person or company Any person or company interested in purchasing or licensing the rights to this program should contact the author Chapter 2 Distributions TABLE OF CONTENTS BY SECTION NUMBER 2al Vhat is the DISTRIB Program and What Does it Do 2 2 Features 23 The Schedule 2 4 Exiting the Program 29 Entering the Data Answering the Queries 2 6 Displaying a Schedule Pausing or Escaping aad Entering the Actual Payment and the Date of the First Payment 2 8 Schedule Printing 2 1 What is the DISTRIB Program and What Does it Do Given a starting balance interest rate term and an ending balance which must be smaller than the starting balance the DISTRI
114. sked which data base you want ath Page 72 DO YOU WANT TO USE THE SAMPLE DATA BASE T OR THE LIVE ONE S L gt Be careful not to practice with the real data See section 13 13 below 13 6 The Main Menu Shown below is the point and shoot main menu Just move your cursor using the arrow keys to highlight the desired choice and press lt ENTER gt T PROFIT SHARE PROGRAM IAIN MENU Employee List Maintenance amp Calc Set Company P S Contribution Reports Generator Backup Data Exit To DOS Owe UwWUNEEe Laat The Employee List Maintenance Menu Shown below is the employee list maintenance menu Notice selection 5 th recalculate selection Choos 5 to recalculate and balance the finances If the company contribution os zero the recalculate choice won t recalcu late T EMPLOYEE LIST MAINTENANCE MENU Look at an Employee Add an Employee ake a Change to an Employee Remove an Employee Permanently Recalculate the Profit Share Reports Generator Exit this menu to main menu UD OBWNE 13 8 Adding New Data Records To add new employee data choos 2 from the list employee maintenance menu Shown below is a sample session If you want the employee to partake of a profit share then type in Y or y in the participant field If you want to disqualify thi
115. ss than the starting balance the DISTRIBUTIONS program will immediately calculate the withdrawal amount for you This withdrawal amount is the amount of money that you may withdraw from your interest bearing starting sum to reach the ending balance over the term 1 33 The FUTURE AMOUNT Program This program is also a subset of the all inclusive FINANCE program Given a starting balance interest rate term and an ending balance which must be greater than the starting balance the FUTURE AMOUNT program will immedi ately calculate the deposit amount for you This deposit amount is the amount of money that you must deposit into your interest bearing account so that your money grows to the ending balance over the term 1 34 The G7 VARI LOAN Program With this Pelton s Financial Program you can analyze one or two different complex loans in which the interest rates or payment amounts may vary from payment to payment Secondly you can quickly compare the two loans via the side by side analysis summary With G7 VARI LOAN you can change any rate or payment amount list the first three or last three payments or show a sum mary first 3 and last 3 You can also expand or shrink balloon a loan and you can save and recall your work The compare feature clearly helps you to decide which loan is better for you G7 VARI LOAN has many other helpful features as you will see later 1 35 The MGM
116. t involve growth by interest only as if one made a one time only deposit into a savings account Notice that any quan tity may be solved for as long as the other four are known 9 7 The Money Disbursement Menu ONEY DISBURSEMENT MENU A fund has an initial amount of money in it and thus gains interest Disbursements or out payments are amounts taken from the fund while it still gains interest The fund may be totally depleted to zero amount or not Find BEGIN AMOUNT given END BALANCE RATE TERM WITHDRAWAL Find END BALANCE given RATE TERM WITHDRAWAL BEGIN AMOUNT Find RATE given TERM WITHDRAWAL BEGIN AMOUNT END BALANC Find TERM given WITHDRAWAL BEGIN AMOUNT END BALANCE RATE Find WITHDRAWAL given BEGIN AMOUNT END BALANCE RATE TER Exit and go back to Main Menu p3 7 Aor wn E Vv Enter 1 5 or E Gl Above is shown the Money Disbursement Menu Use this section of the FINANC program when you have a sum of money that you want distributed periodically Notice that if you know four of five quantities you may solve for the un known Chapter 10 THINGS TO DO TABLE OF CONTENTS BY SECTION NUMBER 10 1 What is the THINGS TO DO Program and What Does it Do 10 2 Features
117. t of 50 which first starts on Mar 25 1989 and a recurring yearly deposit of 500 which starts on Apr 15 1989 The IRA program calculated the final balance as 6 439 28 n 3 2 Features The program offers you the following features O Full glorious attractive color screens or black amp white mono fe Fancy reports to screen or printer o Accepts three type of financial data initial deposit amount monthly deposit amount and yearly deposit amount o Pause or quit during report output o Easy to understand queries questions you don t need financial training to use this program 33 m 5 ti e Th m EN Th th n zal Page 20 o Escape or quit at any time 0 Easy to change data and rerun the program o This program aids you in solving serious financial calculation problems 0 Fast loading o The program is well thought out people who use it like it o Continuous dedicated support by the author oO Excellent documentation o This program will increase your productivity and give you a true sense of accomplishment o Information is where you need it The Questions the Program Will be Asking You Below is shown a typical session of the IRA CALC program ter Annual Interest Rate e g 7 5 E exit gt 5 5 ter Total Number of Years gt 5 ter Additional Number of Months gt 0 5 Years and 0 Months for 60 Total periods itial Deposit Amou
118. ter the loan 1 environment from the command prompt as follows command gt loan 1 loan 1 gt Now you re ready to enter the information about the first loan as follows wow Remember th sh payment by entering schedule by typing At this time you cou head tail or W problem From the loan 1 environment prompt about the second part entry of information Then determin you can use the prin 4900 rate 4 9 term 48 payment pmt pmt 112 63 owed you the r pmt pmt P the W itt LUS commended payment and you chose that you had to process the loan which is required to calcul build a late the line items ld actually see what you produced if you were to type But summary let s move on to the loan 2 calc the principal after cash back enter gt wy second part of your loan 2 to permit in the loan 2 environment function to do a quick calculation for us to 4900 1100 is easy but there are times when you have tougher arithmetic and calc will come in handy loan 2 gt cal answer 3 c 4900 1100 800 Then you enter your loan information as follows 38 10 48 prin rate term payment pmt pmt Again use th 00 A 97 30 recommended payment amount and process the loan into a Page 45 schedule as usual Now you re just about done except for the most important part of
119. ths ntering the Ending Date ore Examples Available Upon Request AO OAD BWNE 4 4 Bop epepEy NOP WNEF CO 0000000 m m Ld What is the MGM Program Money growth cal enter some simpl on which your money growth VT 2 Tisa 11 4 LAD Features O Full glorious fe fe O O fe problems O Fast loading fe Can 0 The program is well oO Fast execution O oO 0 This program wil sense of accomp O The Bottom Line Menu lt Esc gt A gt CALCULATE lculations are easy le data and produce an answer you enter a starting amount nonrecurring deposit amount of information problem save and recall a rate and What Does it Do but MGM gives you a quick mechanism to MGM presents you with a grid a date Page 62 and a recurring or You can enter more than one line of this type The Matrix Screen DEPOSIT DEPOSIT DATE AMOUNT A hE a a tee ES tits aes lt Esc gt A gt CALCULAT Recurring and Non The Matrix screen has a contain a gU or a blank Ez thought out 1 R or black amp white Then you simply press a button to get the ending balance to The program offers you the following features attractive color screens Fancy reports to screen or printer Pause or guit during report output Easy to change data and rerun the pro
120. to DOS or your system level menu if you have one or your presentation manager if that s what you re using Notice the real time clock in the upper right hand corner of your screen It was added for your convenience The clock images your computer s time so if the time is incor rect reset it from your PC 1 17 The Helper Box Function Keys You ll notice there s a Helper box on the front screen This box contains some useful and powerful helper functions press the function keys on top of your keyboard which are explained in the sections below Helper Fl Mort Calc F2 DOS Shell F3 Calendar F4 Calculator Page 7 1 18 The Mortgage Calculator Below is shown an example of the mortgage calculator popup It comes al ready set up to find a monthly payment Modify the principal or rate or term and tap lt Fl gt The cursor tries to stay at the last quantity you modified so you can try try try again For example modify the prin cipal tap lt F1 gt look at the payment Then modify the principal tap lt F1 gt look at the payment And so on With a little practice you ll become an expert at it Press lt Esc gt or lt F10 gt to exit The information is saved to the mailbox unless you chose NO MAILBOX as a program qualifier when you launched GO EXE see section 1 12 I added this feature to make Pelton s Financial Software quicker and easier to use Quick Mortgage
121. u you ll get right into the schedule maker section You DO NOT have to get into the CALCULATOR first For complex type loans every two weeks bimonthly etc start here with the schedule maker Also if you don t know a quantity leave it blank G5 will find an answer for you NOTE G5 unfortunately is not a mind reader nor soothsayer so it can t synthesize a loan as a loan expert human you can give it only one unknown at a time I e you know the principal amount borrowed the yearly rate the payment amount but not the term in this case you re OK G5 will solve for the term So you must know three out of four of the following principal amount borrowed annual rate term and payment amount NOTE most commonly people know the principal rate and term and wish to find the payment amount 5 6 The Company Name Data Base Choosing 3 from G5 s Main Menu puts you into the company name address block data base Entering your name company name and address here will allow you to print this info out on your professional G5 reports and schedules Your clients will be impressed Section 5 15 shows how the client s name and address ar ntered and the company name and address action is very similar 5 7 Exiting the Program Pressing lt Esc gt and sometimes E or e will either back you out of that par Page 29 ticular inquiry sequence or completely exit you from the pr
122. umented programs the Revolving Checking or Credit pro gram RCA and the Timer TIMER program To run the RCA program exit from the main programs menu i e back to Dos and type RCA Similarly to run the timer program type TIMER from Dos Cl 1 28 The PAYMENTS Program This program is used to print out range and spreads to the screen or to your printer You are asked for a starting interest rate which forms a spread in increments of 0 5 across the top and you are asked for a starting value of another quantity which is spread in appropriate increments down the left hand column In between is a checkerboard of values around which your eye may peruse so that you may hone in on a value close to what is desired Then you will have defined a starting point since you ll know the rate from the top row and the value from the left hand column 1 29 The GSLOAN Program The G5SLOAN program creates documentation for standard mortgage loans installment loans with rebates calculated according to the Rule of 78 s bimonthly loans biweekly loans loans with different compounding periods or conventional loans where the payment varies according to the remaining amount financed plus a fixed sum You may modify the payment amount or state a balloon payment number G5LOAN also comes with a loan calculator with which you may figure out a payment rate term or amount financed given three out of four It also displays the add on interest f
123. un the Same Job Over Again Return to the Main Menu Exit AnoR WN EH l lt Enter gt To Go Back to Display Info Screen Your Choice 1 6 or zal v 5 18 Displaying a Schedule After all data is entered the program brings you to a summary screen from which each entry may be further changed by choosing the corresponding num ber When all data is correct you may proceed to the next menu the output menu from which you may display or print a schedule last payment summary Page 33 or yearly totals of interest and principal paid If you selected printed output the program will request a job number any arbitrary number 5 19 Schedule Printing If you elect to print a schedule the program will request the screen or printer If you choose the printer press the lt Esc gt key to stop the printing or the lt Space gt key to pause Report now printing hit lt Esc gt to stop Stephen J Foss 23 Chapter 6 Payments TABLE OF CONTENTS BY SECTION NUMBER What is the PAYMENTS Program and What Does it Do Features The Main Menu The Schedule he Questions the Program Will Be Asking You xiting the Program tering the Principal tering the Interest Rate tering the Compounding Frequency LO Displaying a Schedule tering the Optional Job Number tering the Optional Client s Name and Address mber of Copies 14 Schedule Printing AANnDAOAABWNE
124. what information you need for each part In this type of problem the solution of one part is the required information for the next part The more organized you are th asier complex financial prob lems will be to solve Don t be hesitant or don t ponder too much over getting your feet wet with the programs One always gets a nice feeling after buying into an application program if the program works well and the user really gets the job done With Pelton s Financial Software you will get the answer Besides you ll wind up with a good sense of satisfaction after getting results a feeling that you ve accomplished something 1 15 The Pelton s Financial Software Main Menu The programs Main Menu is shown below in Fig 1 1 All the individual financial programs can be run from this single well organized and easy to use menu Productivity Programs Selection Guide Distributions IRA Calculator Future Amount G5 Loan Payments G7 Variable Loan Compare w Points Finance Things to Do Other Programs Info on Pelton Exit Program Helper F1 Mort Calc F2 Dos Shell F3 Calendar F4 Calculator ADPOHWOANAUKRWNHE Figure 1 1 To run a program you simply move the light bar up and down via the arrow cursor keys until your choice is reverse highlighted then press lt Enter gt Or touch a key from 1 to 9 T O P or E Pressing lt Esc gt or e will bring you back
125. your report 4 lines only y n NOTE these questions are fairly self explanatory 5 14 Entering the Optional Job Number You may enter a job number or hit lt Enter gt Below the user put in job number 909 Type E to exit Job Number Would you like to give this report a job number e to exit or press lt Enter gt for no job number gt 909 5 15 Entering the Optional Client s Name and Address This part is also very similar to the company s name and address entry see section 5 6 above Next you may enter your name and address or your friend s or client s The computer pulled the name and address shown below from the disk You are asked if you wish to keep it on put in a new name and address The name and address are stored to help you save time and energy when processing multiple schedules for the same party Client Enter client name address etc press lt Enter gt for no name etc Pelton Computer Consultants 21 Hodgkins Drive Ipswich MA 01938 If you want the same client type k or type n for a new client K KEEP or N NEW ONE K N Pelton Computer Consultants 21 Hodgkins Drive Ipswich MA 01938 5 16 Schedule Summary Below is shown the Schedule Summary screen which appears when you have completed entering your data This shows you some interesting info Plus you may change certain items by typing in the item number

Pelton`s Financial Software complete manual

Contents

Download Pdf Manuals

Related Search

Related Contents