Need Written Down Value Method Depreciation Excel Formula

[spycein]

Hi Everyone,

I want a single formula where i can calculate Accumulated depreciation on Written Down Value Method.

For example, let us assume I purchased a Machinery for Rs.100/-, the depreciation rate is 20%, and i need to calculate accumulated depreciation for 5 year.

Then the calculation would be

Year Depreciation Value Accumulated Depreciation Net Value

1st year Rs.20/- (Depreciation @20% on Rs.100/-) Rs.20/- Rs.80/-
2nd year Rs.16/- (Depreciation @20% on Rs.80/-) Rs.36/- Rs.64/-
3rd year Rs.12.80/- (Depreciation @20% on Rs.64/-) Rs.48.80/- Rs.51.20/-
4th Year Rs.10.24/- (Depreciation @20% on Rs.51.20/-) Rs.59.04/- Rs.40.96/-
5th Year Rs.8.19/- (Depreciation @20% on Rs.40.96/-) Rs.67.23/- Rs.32.76/-

if i put 100 in cell "A1", 20% in Cell "B1" and 1 in "C1", then cell no. "D1" should return the value as Rs.20/-
if i put 100 in cell "A1", 20% in Cell "B1" and 2 in "C1", then cell no. "D1" should return the value as Rs.36/-
if i put 100 in cell "A1", 20% in Cell "B1" and 3 in "C1", then cell no. "D1" should return the value as Rs.48.80/-
if i put 100 in cell "A1", 20% in Cell "B1" and 4 in "C1", then cell no. "D1" should return the value as Rs.59.04/-
if i put 100 in cell "A1", 20% in Cell "B1" and 5 in "C1", then cell no. "D1" should return the value as Rs.67.23/-
Hope i made you understand with explanation.. waiting for your solutions.

Thank you in advance

 

[gaz_chops]

Sorry I misread the post.

 

[spycein]

I want a single formula where i can calculate Accumulated depreciation on Written Down Value Method.

For example, let us assume I purchased a Machinery for Rs.100/-, the depreciation rate is 20%, and i need to calculate accumulated depreciation for 5 year.

Then the calculation would be

Year Depreciation Value Accumulated Depreciation Net Value

1st year Rs.20/- (Depreciation @20% on Rs.100/-) Rs.20/- Rs.80/-
2nd year Rs.16/- (Depreciation @20% on Rs.80/-) Rs.36/- Rs.64/-
3rd year Rs.12.80/- (Depreciation @20% on Rs.64/-) Rs.48.80/- Rs.51.20/-
4th Year Rs.10.24/- (Depreciation @20% on Rs.51.20/-) Rs.59.04/- Rs.40.96/-
5th Year Rs.8.19/- (Depreciation @20% on Rs.40.96/-) Rs.67.23/- Rs.32.76/-

if i put 100 in cell "A1", 20% in Cell "B1" and 1 in "C1", then cell no. "D1" should return the value as Rs.20/-
if i put 100 in cell "A1", 20% in Cell "B1" and 2 in "C1", then cell no. "D1" should return the value as Rs.36/-
if i put 100 in cell "A1", 20% in Cell "B1" and 3 in "C1", then cell no. "D1" should return the value as Rs.48.80/-
if i put 100 in cell "A1", 20% in Cell "B1" and 4 in "C1", then cell no. "D1" should return the value as Rs.59.04/-
if i put 100 in cell "A1", 20% in Cell "B1" and 5 in "C1", then cell no. "D1" should return the value as Rs.67.23/-
Hope i made you understand with explanation.. waiting for your solutions.

Thank you in advance

 

[Dave Patton]

Initial Rate Term Value
100 0.2 5 $32.77


=-FV(-B2,C2,0,A2)

 

[Joe4]

Take a look at these links here:
Depreciation in Excel - Easy Excel Tutorial
Fixed Declining Balance Depreciation Calculator

 

[spycein]

Thank you so much Dave Patton.. it works.. however this formula returns the net value after deducting the depreciation value.

Could you please help me with another formula which will return the accumulated depreciation value.

For example, if i put 5 in the term cell the accumulated depreciation figure should return the value as 67.23.
Thanks

 

[gaz_chops]

Try
=A1-(-FV(-B1,C1,0,A1))

 

[spycein]

Thank you so much gaz_chops... bang on.. this is it.. which i wanted.. works like a charm.. thank you so much