home *** CD-ROM | disk | FTP | other *** search
/ Simtel MSDOS 1992 September / Simtel20_Sept92.cdr / msdos / lotus123 / 123train.arc / APARTREC.AST next >
Text File  |  1987-04-04  |  2KB  |  57 lines
  1. .po8
  2. .op
  3.                 Apartment Accounting Spreadsheet
  4.  
  5.      Yo⌡ havσ useΣ thσ rea∞ estatσ investmen⌠ mode∞ t∩ evaluatσ ì
  6. severa∞ apartmen⌠ building≤ anΣ havσ purchaseΣ aε eight-uni⌠ ì
  7. buildinτ calleΣ thσ Lexingtoε Apartments.
  8.  
  9.      You≥ assignmen⌠ i≤ t∩ se⌠ u≡ ß spreadshee⌠ t∩ d∩ thσ annua∞ ì
  10. accountinτ fo≥ you≥ building«  Thσ spreadshee⌠ wil∞ bσ useΣ t∩ ì
  11. preparσ incomσ taxes¼ s∩ i⌠ shoulΣ sho≈ thσ year'≤ rentA╠ income¼ ì
  12. regula≥ monthl∙ expenses¼ anΣ specia∞ expense≤ likσ repair≤ o≥ ì
  13. ta° payments«  
  14.  
  15.      Thσ areß witΦ monthl∙ ren⌠ payment≤ fo≥ eacΦ apartmen⌠ show≤ ì
  16. thσ apartmen⌠ number¼ tennan⌠ name¼ anΣ thσ amoun⌠ recieveΣ fo≥ ì
  17. eacΦ oµ thσ 1▓ months«  (Therσ arσ ┤ one-bedreooφ apartment≤ ì
  18. rentinτ fo≥ $45░ anΣ ┤ two-bedrooφ apartment≤ rentinτ fo≥ $60░ ì
  19. pe≥ month).
  20.  
  21.      The regular monthly expenses along estimated amounts are:
  22.  
  23.                Water                    200.00
  24. áááááááááááááááGa≤                      230.00
  25. áááááááááááááááElectricit∙               80.00
  26. áááááááááááááááGarbagσ Collectioε        40.00
  27. áááááááááááááááExterminato≥              30.00
  28. áááááááááááááááPoo∞ Servicσ              50.00
  29. áááááááááááááááGardene≥                  40.00
  30. áááááááááááááááMortgagσ Paymen⌠       2,500.00
  31. ááááá 
  32.      Specia∞ expense≤ d∩ no⌠ occu≥ ever∙ month«  The∙ arσ thing≤ ì
  33. likσ ta° payments¼ repairs¼ painting¼ etc«  Fo≥ specia∞ expenses¼ ì
  34. yo⌡ woulΣ wan⌠ t∩ recorΣ thσ date¼ checδ number¼ amount¼ anΣ aε ì
  35. explanatioε oµ thσ reasoε fo≥ thσ expense« 
  36.  
  37.      Don'⌠ forge⌠ tha⌠ thσ spreadshee⌠ wil∞ bσ useΣ fo≥ ta° ì
  38. purposes, so the incomes and expenses should be totaled.
  39.  
  40.      Plaε eacΦ oµ thσ threσ area≤ beforσ yo⌡ begiε workinτ oε thσ ì
  41. computer«  Remembe≥ tha⌠ yo⌡ wil∞ no⌠ bσ usinτ thσ spreadsheet¼ ì
  42. you≥ buildinτ manage≥ will«  Therefore¼ yo⌡ mus⌠ pa∙ carefu∞ ì
  43. attentioε t∩ thσ appearancσ oµ thσ spreadsheet¼ addinτ heading≤ ì
  44. anΣ explanation≤ s∩ i⌠ wil∞ bσ eas∙ fo≥ thσ manage≥ t∩ use«  Yo⌡ ì
  45. shoulΣ als∩ protec⌠ an∙ cell≤ thσ manage≥ woulΣ no⌠ bσ expecteΣ ì
  46. t∩ change.
  47.  
  48.      Turn in the following when you are finished:
  49.  
  50.           1. Overvie≈ documentatioε oµ thσ spreadsheet¼ showinτ ì
  51. áááááááááááááho≈ i⌠ i≤ layeΣ out.
  52.  
  53.           2. A printout of the spreadsheet.
  54.  
  55.           3« ┴ disδ witΦ thσ mode∞ oε i⌠ (bσ surσ you≥ namσ i≤ ì
  56.              written on the disk label).
  57.