"AST1CAL3 EQUATION VARIABLE |N15 1N|","10-01-1993","09:14:58" "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" "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." 12 .3506031008305671,0,"" 35.06,0,"" 12468.42,0,"" 8096.95,0,"" 5258.14,0,"" 12468.42,0,"" 6731.58,0,"" 6731.58,0,"" 1440,0,"" 19200,0,"" 6,0,"" 1,0,"" 1 0 0