home *** CD-ROM | disk | FTP | other *** search
/ PC World Komputer 1997 February / PCWK0297.iso / technika / formcalc / science / scif3p3.equ < prev    next >
Text File  |  1993-10-01  |  2KB  |  20 lines

  1. "AST1CAL3 EQUATION VARIABLE |N15 1N|","10-01-1993","09:14:58"
  2. "RATEDEPR=1-EXP(1/NYEARS*LOG(SCRPVAL/ORIGCOST)) DEPR%=RND(100*RATEDEPR) BKVAL#1=RND(ORIGCOST*(1-RATEDEPR)) BKVAL#2=RND(ORIGCOST*(1-RATEDEPR)^2) BKVAL#3=RND(ORIGCOST*(1-RATEDEPR)^3) BKVAL#N=RND(ORIGCOST*(1-RATEDEPR)^N) DPRCHARG=RND(ORIGCOST*(1-RATEDEPR)^(N-1))-BKVAL#N DPRFUND=ORIGCOST-BKVAL#N"
  3. "FINANCE: DEPRECIATION, CONSTANT PERCENTAGE (RATE) METHOD.      Determine the annual depreciation charge by assuming depreciation charge is madeat year end and is a fixed percentage or rate RATEDEPR of the book value at the beginning ofthe year.                                                                                                                                           Ans(a) Set N=1, NYEARS=6, ORIGCOST=19,200, SCRPVAL=1440. Depreciation rate      is 0.351.                                                                                                                                                       Ans(b) Setup as in (a) above. Set N=1, then 3 then 6. Results are:                   Year End    Book Val.     Depr. Chrg.     Depr. Fund                               0         19,200                                                                1         12,468        6,732            6,732                                  3          5,258        2,839           13,942                                  6          1,440          777           17,760                                                                                                          Type any key to exit.       (c) Copyright PCSCC, Inc., 1993                                                                                                                    ||(a) A car costing $19,200 has a useful life of 6 years and has a scrap value of $1,440.  Find the annual rate of depreciation.                                  (b) Construct a depreciation schedule: book value at year end, depreciation charge and amount in depr. fund for years 1, 3 and 6.                 Type comma key to see answers.  Type (F2) to return to application file."
  4. 12
  5. .3506031008305671,0,""
  6. 35.06,0,""
  7. 12468.42,0,""
  8. 8096.95,0,""
  9. 5258.14,0,""
  10. 12468.42,0,""
  11. 6731.58,0,""
  12. 6731.58,0,""
  13. 1440,0,""
  14. 19200,0,""
  15. 6,0,""
  16. 1,0,""
  17. 1
  18. 0
  19. 0
  20.