Financial Function Formulas

Tim25

New Member
Joined
Mar 17, 2002
Messages
2
For an accounting class, I need to calculate several depreciation schedules. Using the financial function feature I can make them all work except the DDB oprion. I haven't been able to have the computer's calculated total depreciation equal the cost of the asset, nor does it zero out in the final year. I enter the data correctly because the first year's depreciation is correct, It equals twice the straight line depreciation. What am I doing wrong?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
An example of your information,
the formula that you used,
and expected results would be useful.

yr 1 =DDB(2400,300,10,1,2)
yr 2 =DDB(2400,300,10,2,2)

consider using a column and adj row() as necessary =DDB(2400,300,10,ROW(),2)
Copy down to show 10 cells
 
Upvote 0
Thanks. Formula for year one was DDB(50000,0,15,1,2). I made the first three numbers absolutes with the $ sign. I then copied the formula to the cells for years 2-15. Year 2 formula became (50000,0,15,2,2). However, I'm now thinking that the 15 can't be absolute becasue unlike other methods, the depreciation schedule "starts over" in each year. So would I be unable to simply copy the cell formula to other cells in this case?
 
Upvote 0
You may learn more by trying the formula and
seeing if it increments.

Look at the formulas after you copy them down.

If you want, manually edit the formulas.


You could also look at the sample formula that I provided. Why do you think I used row() to derive the number?
 
Upvote 0
On 2002-03-18 21:42, Tim25 wrote:
For an accounting class, I need to calculate several depreciation schedules. Using the financial function feature I can make them all work except the DDB oprion. I haven't been able to have the computer's calculated total depreciation equal the cost of the asset, nor does it zero out in the final year. I enter the data correctly because the first year's depreciation is correct, It equals twice the straight line depreciation. What am I doing wrong?

I think that DDB is useless. It doesn't give
you the ability to switch to straight-line
depreciation (like real life depreciation
schedules do). Use the VDB function instead.
(And even that function won't help you for
short tax years!)
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top