home *** CD-ROM | disk | FTP | other *** search
/ Simtel MSDOS 1992 September / Simtel20_Sept92.cdr / msdos / lotus123 / 123train.arc / REXFR.AST < prev    next >
Text File  |  1987-02-19  |  4KB  |  95 lines
  1.                      File Import Assignment
  2.  
  3.      Thσ purposσ oµ thi≤ assignmen⌠ i≤ t∩ givσ yo⌡ somσ practicσ ì
  4. witΦ sharinτ datß betweeε tw∩ programs«  Yo⌡ wil∞ usσ 12│ anΣ thσ ì
  5. REINVES╘ spreadshee⌠ t∩ makσ somσ estimates¼ theε impor⌠ thσ ì
  6. result≤ int∩ ß Wordsta≥ document«  You≥ fina∞ resul⌠ wil∞ bσ thσ ì
  7. summar∙ repor⌠ showε oε thσ nex⌠ page«  I⌠ wa≤ produceΣ usinτ ì
  8. Wordstar¼ bu⌠ thσ number≤ al∞ camσ froφ 123.
  9.  
  10.      1«  LoaΣ thσ REINVES╘ spreadshee⌠ witΦ 123«  
  11.  
  12. ááááá2«  "Printó thσ parameter≤ anΣ ne⌠ result≤ iε ß disδ file.
  13.  
  14. ááááá3«  Changσ thσ interes⌠ rate¼ theε "printó thσ ne≈ "bottoφ ì
  15. ááááálineó iε ß seconΣ disδ file.
  16.  
  17. ááááá4«  Qui⌠ 123¼ becausσ yo⌡ arσ no≈ read∙ t∩ impor⌠ thσ file≤ ì
  18. áááááint∩ ß Wordsta≥ document.
  19.  
  20. ááááá5«  Usσ Wordsta≥ t∩ creatσ thσ "Rea∞ Estatσ Investmen⌠ ì
  21. áááááSummar∙ Report.ó  Turε iε ß printou⌠ oµ thσ repor⌠ wheε yo⌡ ì
  22. áááááge⌠ i⌠ exactl∙ likσ thσ example.
  23.  
  24. A few reminders:
  25.  
  26. áááááThσ Wordsta≥ commanΣ t∩ impor⌠ ß filσ froφ disδ i≤ ctrl-KR.
  27.  
  28. áááááWheε Wordsta≥ ask≤ fo≥ thσ namσ oµ thσ filσ yo⌡ wan⌠ t∩ ì
  29. áááááread¼ don'⌠ forge⌠ thσ extensioε PRN«  (Wheε yo⌡ "printó ì
  30. áááááfile≤ oε thσ disk¼ 12│ automaticall∙ give≤ theφ thσ ì
  31. áááááextensioε PRN).
  32.  
  33. áááááDon'⌠ bσ confuseΣ b∙ blanδ "pagesó iε thσ PR╬ files¼ jus⌠ ì
  34. ááááádeletσ them.
  35.  
  36.      Notσ tha⌠ Wordsta≥ ha≤ beeε useΣ t∩ rearrangσ thσ "bottoφ ì
  37. ááááálineó figure≤ tha⌠ werσ importeΣ froφ 123.
  38.  
  39.  
  40.  
  41. .paè              Real Estate Investment Summary Report
  42.  
  43. WitΦ thσ followinτ paramete≥ values¼ wσ expec⌠ tha⌠ thσ buildinτ ì
  44. wil∞ breaδ eveε earl∙ iε thσ fiftΦ year║   
  45.  
  46.  
  47.     PARAMETERS:
  48.     Interest rate                      11.7%
  49.     Sale commission                     6.0%
  50.     Loan points                         2.5%
  51.     Closing costs                   $500.00
  52.     Appreciation rate                   2.5%
  53.     Rent increase/yr                    2.5%
  54.     General cost inc/yr                 2.5%
  55.     Improvement percent                70.0%
  56.     Depreciation period (yrs)            27
  57.     Sale price                  $725,000.00
  58.     Vacancy rate                        3.0%
  59.     Maintenance rate                    4.0%
  60.     Down payment rate                  30.0%
  61.     Tax bracket                        28.0%
  62.     Alternate interest rate             8.0%
  63.     Property tax rate                   1.2%
  64.  
  65. Thσ ne⌠ incomσ relativσ t∩ aε alternativσ usσ oµ thσ fund≤ fo≥ ì
  66. thσ firs⌠ eigh⌠ year≤ i≤ estimateΣ t∩ bσ a≤ follows:
  67.  
  68.  
  69.     Year                            1             2             3
  70.     Net                         ($33,536.64)  ($12,432.03)   $10,197.25
  71.     Cumulative net              ($33,536.64)  ($45,968.67)  ($35,771.42)
  72.  
  73.         4             5             6             7             8
  74.      $34,425.12    $60,403.71    $88,297.57   $118,284.60   $150,557.02
  75.      ($1,346.30)   $59,057.40   $147,354.97   $265,639.57   $416,196.60
  76.  
  77.  
  78. However¼ iµ wσ caε obtaiε ß loaε a⌠ thσ interes⌠ ratσ oµ 10.7%¼ ì
  79. wσ expec⌠ t∩ breaδ eveε durinτ thσ fourtΦ year«  Thσ eight-yea≥ ì
  80. ne⌠ wil∞ bσ a≤ follows:
  81.  
  82.     Year                            1             2             3
  83.     Net                         ($30,100.16)   ($5,546.63)   $20,799.48
  84.     Cumulative net              ($30,100.16)  ($35,646.79)  ($14,847.31)
  85.  
  86.         4             5             6             7             8
  87.      $49,033.46    $79,330.64   $111,880.72   $146,888.92   $184,577.10
  88.      $34,186.15   $113,516.79   $225,397.51   $372,286.43   $556,863.53
  89.  
  90.  
  91. Sincσ ou≥ appreciatioε ratσ anΣ othe≥ parameter≤ werσ choseε ì
  92. conservatively¼ anΣ eveε a⌠ thσ highe≥ interes⌠ ratσ thσ ì
  93. investmen⌠ i≤ profitable¼ wσ recommenΣ makinτ aε offe≥ oµ ì
  94. $725,000.0░ fo≥ thσ building.
  95.