home *** CD-ROM | disk | FTP | other *** search
/ Current Shareware 1994 January / SHAR194.ISO / spreadsh / fin311.zip / FINC11P4.EQU < prev    next >
Text File  |  1993-02-27  |  2KB  |  22 lines

  1. "AST1CAL3 EQUATION VARIABLE |N 7 0N|","02-27-1993","22:03:53"
  2. "VALUDEBT=PURPRICE-DWNPYMNT FREQCONV=12/PAYMNINT NPERIODS=FREQCONV*NUMYEARS RATE%PER=ANNRATE%/FREQCONV PERPAYMN=RND(VALUDEBT/(1-(1+RATE%PER/100)^-NPERIODS)/100*RATE%PER) EFFRATE%=RND(100*((1+RATE%PER/100)^FREQCONV-1)) SELLEREQ=RND(PERPAYMN*(1-(1+RATE%PER/100)^-(NPERIODS-PERIOD#))*100/RATE%PER) BUYEREQ=PURPRICE-SELLEREQ"
  3. "AMORTIZATION, SELLER'S EQUITY, BUYER'S EQUITY.                 An INTEREST BEARING DEBT is said to be AMORTIZED when all liabilities which     include the principal and interest are discharged by a sequence of usually equalpayments.  The BUYER'S EQUITY in the property, at any time, is that part of     property which he has paid. The SELLER'S EQUITY is that part of the price of theproperty that remains to be paid.                                               ANNRATE% is the annual interest rate. NUMYEARS is the term in years. PAYMNINT isthe payment interval in months. PERPAYMN is the periodic payment. VALUDEBT is   the debt's value. PURPRICE is the purchase price and DWNPYMNT is the down       payment.  SELLEREQ is the seller's equity at the end of PERIOD#. BUYEREQ is the buyer's equity at the end of PERIOD#.                                                                                                                           *** Answers to problems ***                                                     (a) Set ANNRATE%=14.75, DWNPYMNT=10,000, NUMYEARS=30, PAYMNINT=1 (monthly=1),   PERIOD#=50, PURPRICE=128,000. The buyer's equity is BUYEREQ=26,674.08.          Type any key to exit.                                                                          ||(a) Mr. Nurlmann buys a house for $128,000.  He puts $25,600   (20%) down and borrows the balance at 14.75% compounded monthly.  He makes      equal payments at the end of each month for the next 30 years.  What is his     equity just after making the 50th payment?                                                     Type , to see answers.  Type (F2) to return to helpfile.         ''(c) Copyright PCSCC, Inc., 1993"
  4. 14
  5. 0,0,""
  6. 0,0,""
  7. 0,0,""
  8. 0,0,""
  9. 0,0,""
  10. 0,0,""
  11. 0,0,""
  12. 0,0,""
  13. 0,0,""
  14. 0,0,""
  15. 0,0,""
  16. 0,0,""
  17. 0,0,""
  18. 0,0,""
  19. 1
  20. 0
  21. 0
  22.