Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Financial Function Formulas

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,425
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default



    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,425
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default



    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?

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!)
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •