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
