
Andy C. answered 11/26/17
Tutor
4.9
(27)
Math/Physics Tutor
It cannot depreciate and increase in value at the same time.
The value either goes up or down.
It depreciates 5% each year.
100% - 5% = 95% = 0.95
The formula is 30000*(0.95)^t where t is the number of years.
I did it in MS Excel for you. Here's the table:
Year value at Beginning of Year Value at End of Year
1 30000 28500
2 28500 27075
3 27075 25721.25
4 25721.25 24435.1875
5 24435.1875 23213.42813
6 23213.42813 22052.75672
7 22052.75672 20950.11888
8 20950.11888 19902.61294
9 19902.61294 18907.48229
10 18907.48229 17962.10818
11 17962.10818 17064.00277
12 17064.00277 16210.80263
13 16210.80263 15400.2625
14 15400.2625 14630.24937
15 14630.24937 13898.7369
16 13898.7369 13203.80006
17 13203.80006 12543.61006
18 12543.61006 11916.42955
1 30000 28500
2 28500 27075
3 27075 25721.25
4 25721.25 24435.1875
5 24435.1875 23213.42813
6 23213.42813 22052.75672
7 22052.75672 20950.11888
8 20950.11888 19902.61294
9 19902.61294 18907.48229
10 18907.48229 17962.10818
11 17962.10818 17064.00277
12 17064.00277 16210.80263
13 16210.80263 15400.2625
14 15400.2625 14630.24937
15 14630.24937 13898.7369
16 13898.7369 13203.80006
17 13203.80006 12543.61006
18 12543.61006 11916.42955
19 11916.42955 11320.60808
20 11320.60808 10754.57767
20 11320.60808 10754.57767