Fixed asset Depreciation Formula

[Dapao]

Hi,

May anyone be able to help with the below table formula? Thanks in advance.

				1/1/2020	31/12/2020	31/8/2021
Date purchase	Useful life (Yr)	Mth	Cost Amount	Depreciation b/f	Depreciation	Depreciation
2/7/2020	5	60	15,000	???	???	???
4/5/2012	5	60	33,000

 

[daregu]

there is a depreciation formula, it does require a salvage value. If you hit =db in a cell you'll see it.

 

[Dave Patton]

What rules apply for the calculation?
What type of depreciation is applicable?
What results do you expect?
Check Excel's help for formulas SLN SYD DB DDB VDB.
You can also use arithmetic functions.

 

[Dapao]

What rules apply for the calculation?
What type of depreciation is applicable?
What results do you expect?
Check Excel's help for formulas SLN SYD DB DDB VDB.
You can also use arithmetic functions.

straight-line method, salvage value =0

 

[Dave Patton]

What rules apply for the calculation?
What type of depreciation is applicable?
What results do you expect?
Check Excel's help for formulas SLN SYD DB DDB VDB. SLN
You can also use arithmetic functions.

T202110a.xlsm
	A	B	C	D	E
1
2	Date purchase	Useful life (Yr)	Mth	Cost Amount	Monthly Deprec
3	1-Jul-20	5	60	15,000	$250.00
4	4-May-12	5	60	33,000	$550.00
1e

Cell Formulas
Range	Formula
E3:E4	E3	=SLN(D3,0,C3)

T202110a.xlsm
	A	B	C	D	E
2	Date purchase	Useful life (Yr)	Mth	Cost Amount	Monthly Deprec
3	1-Jul-20	5	60	15,000	$250.00
4	4-May-12	5	60	33,000	$550.00
5
1e

Cell Formulas
Range	Formula
E3:E4	E3	=D3/C3