Calculating Depreciation For Your Investments

By: Stephen Nelson
Submitted: 2007-01-17 16:17:16
Print this article | Tell a friend | For publisher | Social Bookmarking
Rating:
 

Investing in real estate? Thinking about buying new equipment for your business? The depreciation you take on your tax return can turn into a significant tax benefit. But you need to make some complex calculations. Fortunately, Microsoft Excel can help.

Excel’s VDB function calculates declining balance depreciation for an asset given the cost, its salvage value, estimated economic life, the starting accounting period and the ending accounting period for which depreciation is being calculated, the factor at which the balance declines, and, optionally, a switch-to-straight-line switch which is set to either TRUE or FALSE. If you set this switch to TRUE, Excel doesn’t switch to straight-line at the point when straight-line depreciation exceeds declining balance depreciation. If you set this value to FALSE, Excel does switch to straight-line. If you don’t set the optional switch-to-straight-line switch to TRUE, Excel sets this value to FALSE.

Note: By default, US tax laws do convert to straightline depreciation at the point that straightline depreciation exceeds declining balance deprecation. But back to the mechanics of the VBD function...

The VDB function uses the following syntax:

VBD(cost,salvage,life,start-period,end-period,factor,switch)

Suppose, for example, that you must calculate 150% declining balance depreciation for equipment that costs $50,000, lasts five years, and will have a salvage value of $10,000 at the end of the fifth year. To calculate the depreciation for the first year, you use the following formula:

=VBD(50000,10000,5,0,1,150%)

The function returns the value 15000.00. Notice that to calculate depreciation for the first year, you set the start period to 0 and the end period to 1. To calculate the depreciation for the second year, you use the formula

=VBD(50000,10000,5,1,2,150%)

The function returns the value 10500.00. Notice that to calculate the depreciation for the second year, you set the start period to 1 and the end period to 2. In both of the two preceding examples, Excel will automatically switch to straight-line depreciation at the point when straight-line depreciation for a period exceeds declining balance depreciation. To instruct Excel not to make this switch, you would use the following formula to calculate depreciation for the first year:

-VBD(50000,10000,5,0,1,150%,TRUE)

The word TRUE, which Excel interprets as 1, tells Excel not to switch to straight-line. To instruct Excel not to make this switch in the second year, you would use the following formula to calculate depreciation:

=VBD(50000,10000,5,1,2,150%,TRUE)

CPA Stephen L. Nelson is the author of QuickBooks for Dummies and Do-It-Yourself LLC Incorporation and LLC Formation Kits for all fifty states. Formerly an adjunct tax professor at Golden Gate University. You can reach him at http://www.llcsexplained.com

Article source: Expert Articles

Most Recent Articles in Taxes category

  • Use the Appraisal District's Information to Reduce Your Property Taxes - By: Patrick C O Connor
    Homeowners are amazed to learn they can obtain a copy of the appraisal district's evidence at a nominal cost. This is referred to as a House Bill 201 package, and is the only information many homeowners use to successfully reduce their property taxes.
  • Tax Return Outsourcing - Cost and Time Effective Services - By: Michelle Barkley
    Tax return outsourcing has simplified the cumbersome task of maintaining tax returns files and data in an efficient manner.
  • Optimise Savings with an Offshore Account - By: Isla Campbell
    Offshore accounts, based in the Channel Islands, the Isle of Man and Ireland, offer many benefits to those wishing to set up a savings account. But what are the advantages of cash conservation offshore.
  • Texas Business Personal Property Rendition and Taxation - By: Patrick C O Connor
    The Texas Property Tax Code for many years had required owners of business personal property (BPP) to annually render those assets used in a business. Rendering is summarizing to the central appraisal district the ownership and value of the assets. Historically, however, over half of all owners of business personal property have not rendered.
  • How to sustain current economic slump? - By: Mark Waltzer
    Small businesses need professional accountants but their services are too expensive so it's better to hire an outsourcing vendor providing cost-effective accounting services and allow them to take your business to next level.
  • Texas Property Tax Appeals - By: Patrick C O Connor
    Texas Property Tax Appeals Steps to Protesting and Reducing Your Property Value Annually
  • Taxes - By: Patrick C O Connor
    Taxes are a levy imposed upon people or legal entities by a governmental entity. There are many forms of taxes including income taxes, property taxes, capital gains taxes, consumption taxes, excise taxes, retirement taxes, sales taxes, tariffs, toll taxes and transfer taxes. This article focuses on reducing income taxes for real estate owners.
  • Gift Tax Valuations - By: Patrick C O Connor
    Gift tax valuations are prepared for many reasons. Gift tax includes market value of gifts to charity, market value of conservation easements and gifts in excess of annual limit. Well-reasoned planning of gifts can minimize gift taxes, income taxes, and estate taxes.
  • Please keep your hands out of my pockets Uncle Sam!: Business tax savings you should know about. - By: Amar Brown
    Many people are unaware that a business including a home based business can mean thousands of dollars in tax advantages per year. Thousands that you can put back into you pocket. Here are a few tips on keeping Uncle Sam Out of your pockets and keeping more of your hard earned money in.
  • Cost segregation - correctly depreciation real estate 10 - By: Patrick O'Connor
    Depreciation is an important non-cash tax deduction. By increasing tax deductions, commercial property owners affect federal income tax reduction. The increase in tax write-offs generates such a large tax cut that some wonder if it is a tax shelter or tax evasion scheme. It is not. Cost segregation is an IRS-guided process used to increase tax deductions during the tax preparation process. The IRS has provided a detailed explanation of the items that qualify for short-life depreciation and acceptable methodologies for performing a cost segregation study. Cost segregation studies performed by appraisers in compliance with the IRS's Audit Techniques Guide are unlikely to be challenged in an audit. Commercial real estate owners seeking tax advice and tax relief can benefit from reviewing the tax relief available from cost segregation.