How to write double-declining balance (DDB) formula on Excel?
 

Hello:)
Please help me!

I do not know how to write DDB formula on Excel.
This is for my project.

The problem is this:

"The first method is the DDB (double-declining balance) financial formula. Place this formula in cells B6 through B8, filling in the appropriate cell references (NOT the actual values, but the address of the cells containing those values), for the cost, salvage, and life values. For the period value, use 1, 2, and 3 respectively. Then, in cells C6 through C8, calculate the current value by subtracting the year's depreciation from the previous year's initial value. Use cell references rather than plugging in actual values."

I typed on Excel like this:

A1: Initial cost B1: $2,000.00
A2: Salvage value B2: $300.00
A3: Useful life B3: 3 (years)

A5: End of year B5: Double-declining value
C5: Value of computer D5: Straight-line depreciation
E5: Value of computer F5: Sum of years depreciation
G5: Value of computer

Please help me how to write DDB formula in cell B6(for initial cost), cell B7(for salvage value), and cell B8(for Useful life).

Also, please help me how to write the current value formula.

Thank you:D

While I`m sure this is a good question, please check the rules before posting.

4.5 General Discussion is for threads that don't fit into any of the other categories. HOWEVER that does not mean that any topic is appropriate for General Discussion. Along with following the above rules, General Discussion threads should be
1) Relevant and inclusive to a majority of JF users
and/or
2) Timely and current (i.e. related to upcoming holidays, news or events).
and/or
3) Japan/Asia related.