Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel function to calculate macrs

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-06-2009
Member
 
Join Date: Nov 2008
Posts: 1,185
Excel function to calculate macrs
  

I am using Excel to maintain accounts for my company. I want to calculate the MACRS depreciation expense for 2008. My problem is that I don't know how to calculate in Excel. Is there any inbuilt function for calculating MACRS? Or some similar combination of functions which will give me the result?

Reply With Quote
  #2  
Old 08-06-2009
Member
 
Join Date: Sep 2005
Posts: 1,306
Re: Excel function to calculate macrs

Although Excel do not have a function like MACRS(cost, class life, year), but they do have a function that when can be used to calculate the MACRS depreciation amounts. It is called variable declining balance (VDB) function.

Syntax
Code:
=VDB (cost, salvage, life, start_period, end_period, factor, no_switch)
where,

Cost is the initial cost of the asset.

Salvage is the value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

Life is the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Start_period is the starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

End_period is the ending period for which you want to calculate the depreciation. End_period must use the same units as life.

Factor is the rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see DDB.

No_switch is a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.
Reply With Quote
  #3  
Old 08-06-2009
Member
 
Join Date: Jan 2008
Posts: 1,512
Re: Excel function to calculate macrs

You can even calculate MACRS using small java code:

Code:
import com.imsl.finance.*;
import java.text.NumberFormat;

public class vdbEx1 {
    public static void main(String args[]) {
        double cost = 30000;
        double salvage = 7000;
        int life = 12;
        int start = 5;
        int end = 7;
        double factor = 3.;
        boolean no_sl = false;
        
        double vdb = Finance.vdb(cost, salvage, life, start, end,
        factor, no_sl);
        System.out.println ("The depreciation allowance between the " +
        "5th and 7th year is " + NumberFormat.getCurrencyInstance().format(vdb));
    }
}
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel function to calculate macrs"
Thread Thread Starter Forum Replies Last Post
How to calculate together a set of Data in Excel !Jumala! MS Office Support 5 25-02-2012 10:05 AM
How to calculate integrals with Excel Ojsuta MS Office Support 2 24-02-2012 06:14 PM
Calculate IRR in Excel superdave1984 Windows Software 3 01-12-2009 11:46 AM
How to calculate GPA in Excel worksheet Lambard Windows Software 3 06-06-2009 09:29 PM
How to calculate two dates in Excel Ektaa Windows Software 5 03-03-2009 04:50 PM


All times are GMT +5.5. The time now is 07:32 AM.