home *** CD-ROM | disk | FTP | other *** search
/ DP Tool Club 17 / CD_ASCQ_17_101194.iso / vrac / fin312.zip / FINCREF2.EQU < prev    next >
Text File  |  1993-10-02  |  2KB  |  23 lines

  1. "AST1CAL3 EQUATION VARIABLE","10-02-1993","10:18:15"
  2. "MONPAYM1=RND(ORIGLOAN/(1-(1+INTRAT%1/1200)^-(12*TERMYRS1))/1200*INTRAT%1) OUTSTPR1=RND(MONPAYM1*(1-(1+INTRAT%1/1200)^-(12*TERMYRS1-12*CURRYR1+1))*1200/INTRAT%1) FINANCE2=OUTSTPR1*(1+POINTS2/100)+FEES2 MONPAYM2=RND(FINANCE2/(1-(1+INTRAT%2/1200)^-(12*TERMYRS2))/1200*INTRAT%2) MONSAV$=MONPAYM1-MONPAYM2 YRSNEED=TERMYRS1-CURRYR1 INTRSAV$=MONSAV$*12*YRSNEED"
  3. "AMORTIZATION, SAVINGS ON REFINANCING A HOME MORTGAGE.          A debt such as a home mortgage (original value of loan is ORIGLOAN and original interest rate is INTRAT%1) is to be refinanced at year CURRYR1 of the original  term TERMYRS1. The amount to be refinanced includes the current outstanding     principal OUTSTPR1, loan origination fees called POINTS2 and all other fees suchas credit checks, surveys, attorney's costs and so on are included in FEES2. Thenew interest rate is INTRAT%2 and the new loan term, in years, is TERMYRS2.     MONPAYM1 and MONPAYM2 are the old and new monthly payments. The monthly         savings is MONSAV$ and the interest savings is INTRSAV$ if the new mortgage is  held for YRSNEED years.                                                         *** Answers to Problem ***                                                      (a) Variables are set to proper values at entry.  Their monthly savings is      546.66.                                                                         (b) Their nominal interest savings for the balance of the original loan (24.5   years) is $160,718.                                                                                Type any key to exit.                                                                                        (c) PCSCC, Inc., 1993                          ||Mary and Bill Smith are refinancing their home mortgage        ($102,400 at 14.75% nominal for 30 years) after 5 1/2 (5.5) years with a new 30 year mortgage at 7.5% nominal plus 2 points and $1200 of closing costs. What is their monthly savings? (b) What is there  nominal (before taxes, etc.) interest savings if they hold their new mortgage for 24.5 years.?                             Type comma key to see answers.  Type (F2) to return to application file."
  4. 15
  5. 1274.34,0,""
  6. 100853.46,0,""
  7. 104070.5292,0,""
  8. 727.68,0,""
  9. 546.66,0,""
  10. 24.5,0,""
  11. 160718.04,0,""
  12. 14.75,0,""
  13. 30,0,""
  14. 102400,0,""
  15. 5.5,0,""
  16. 2,0,""
  17. 1200,0,""
  18. 7.5,0,""
  19. 30,0,""
  20. 1
  21. 0
  22. 0
  23.