The DB function calculates fixed declining balance depreciation for an asset given the cost, it's salvage value, estimated economic life, the accounting period for which depreciation is being calculated, and, optionally, the number of month in first year. (If you don't include the optional month argument, Excel sets this value to 12.) The DB function uses the following syntax:
DB (cost, salvage, life, period, month)
Suppose, for example, that you must calculate the fixed declining balance depreciation for equipment that costs ,000, lasts five years, will have a salvage value of ,000 at the end of the fifth year, and that was placed into service in the third month of the first year. To calculate the depreciation for the first year, you use the following formula:
=DB(50000,10000,5,1,3)
The function returns the value 3437.5. To calculate the depreciation for the second year, you use the formula
=DB(50000,10000,5,2,3)
The function returns the value 12804.69
The distinguishing feature of fixed-declining balance depreciation is that it calculates depreciation
at a fixed rate based on the estimated cost, salvage value, and economic life of the asset. Excel calculates this rate using the following formula:
Fixed rate=1-((salvage/cost)^(1/life))
and then rounds this value to the nearest three decimal places. To calculate the depreciation for a period, Excel multiplies the rate by the sum of the original cost less the accumulated depreciation to date.
NOTE: The accumulated depreciation equals the original cost minus the previous periods' depreciation.
Excel uses variations of the standard fixed-declining balance formula for the first and last periods. For the first period, Excel calculates the depreciation by using the following formula:
First-period depreciation=cost * rate * month / 12
For the last period, Excel calculates the depreciation using the following formula (which essentially just depreciates the asset down to its salvage value):
Last-period depreciation=((cost. accumulated depreciation)*rate*(12-month))/12
- April 2011
- March 2011
- February 2011
- June 2008
- December 2007
- July 2007
- June 2007
- May 2007
- April 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
Does this sound good or bad?
Anisha Padilla
Mobile Phone:
E-mail: jade...@yahoo.com
“ I am a sincere, loyal and dedicated individual who has a great deal of ambition”
A person with high energy excellent personality interact and relates to public well. Enjoys hands on training very self motivated individual. I am seeking a position where I can develop and excel while giving my best to an employer.
Excellent communication, organization and multi-tasking skills. Work well both independently and as a group. Proficient in Windows 98/XP, Microsoft Office Suite (Word, Excel, Access), Adobe Photoshop.
WORK EXPERIENCE
Winder
5 2005 – 7 2007
Johnson Filtration | Amarillo, Potter, TX
Manufacturing – Other
Winder for small company.
Ran a “10″ machine of 1000 filters a day
mostly labor work , cleaned and maintained premises of my work area each and everyday.
Receptionist
10 2007 – 05-2009
Garcia Concrete | Amarillo, Potter, TX
Residential & Commercial/Office
Sales, outgoing, incoming calls, data entry, money intake
sales, customer services and business operations
selling concrete owned and operated by the same individuals. Consistently met or
exceeded sales goals.
[Translate]
One little thing:
Under WORK EXPERIENCE.
It says sales,outgoing,incoming calls,
put outgoing/incoming calls.
sounds a little better
[Translate]
What kind of computer would best fit our needs?!
?
What is the best computer for Graphic Design, Photography Editing, Games, and Digital Scrapbooking? I guess you can say we need a lot of memory. We want to get dual screens, and get one of those splitter things, lol i dont know what the right name is. I know it would be best to get a custom built one, but i am stupid when it comes to building a computer. lol.
Im on a local website that builds computers and i am needing to put in a bunch of things that i would need, but like i said..its all basically in a different language.
Select Processor Type
ProcessorIntelAMD ProcessorTypeIntel Celeron Dual Core E1200 1.6GHz 512KB CacheIntel Core Duo E5200 2.5GHz 2MB CacheIntel Core 2 Duo E7300 2.53GHz 3MB CacheIntel Core 2 Duo E8400 3GHz 6MB Cache Core 2 Quad Q9300 2.5GHz 6MB Cache 1333MHz FSBCore 2 Quad Q9400 2.66GHz 6MB Cache 1333MHz FSBCore 2 Quad Extreme QX9650 3GHz 12MB Cache 1333MHz FSBCore 2 Quad Extreme QX9770 3.2GHz 12MB Cache 1600MHz FSB Core i7 920 2.66GHz 8MB CacheCore i7 940 2.93GHz 8MB CacheCore i7 965 3.2GHz 8MB Cache
Select Video Card
Gaming Machine Recommended is NVIDIA 9600GSO and Higher
Gaming Machine Recommended is ATI HD4550 and Higher
Video/Graphics CardIntegratedPCI-Express Video/Graphics Model
Select Your Memory (Ram)
Windows XP Recommended is 1-2GB
Windows Vista Recommended is 2-4GB
*Windows XP and Vista 32-Bit are limited to 3GB of ram
2GB
4GB
6GB *Must use Vista 64-Bit to utilize 4GB and higher
Other: (input amount)
Select Your Hard Drive
160GB
320GB
500GB
750GB
1TB
1.5TB
*Select a Secondary Hard Drive (*Optional)
320GB
500GB
750GB
1 Terabyte
1.5 Terabyte
Select Your Optical Drive
Blu Ray Reader
DVD-RW (DVD Burner)
*Select A Secondary Optical Drive (*Optional)
Blu Ray Burner
DVD-RW (DVD Burner)
Select Your Monitor
*Certain Models Also Available in Standard Format
19″ Widescreen LCD
22″ Widescreen LCD
24″ Widescreen LCD
26″ Widescreen LCD
Select Your Keyboard and Mouse
None
Standard
Wireless
Laser Wireless
Select Your Speaker System
None
2 Piece
2.1 Piece with Subwoofer
5.1 Surround Sound
THX Certified 5.1 Surround Sound
Select Your Operating System
Windows XP Home Edition
Windows XP Pro Edition
Windows XP Media Center Edition
Windows Vista Home Basic
Windows Vista Home Premium
Windows Vista Business
Windows Vista Ultimate Edition
Select Your Office Version (*optional)
Microsoft Office 2007 Home and Student
Word, Excel, PowerPoint, OneNote
Microsoft Office 2007 Basic
Word, Excel, Outlook
Microsoft Office 2007 Small Business
Word, Excel, PowerPoint, Outlook w/ Business Contact Manager, Accounting Express, Publisher
Microsoft Office 2007 Professional
Word, Excel, PowerPoint, Outlook w/ Business Contact Manager, Accounting Express, Access, Publisher
Corel WordPerfect X3 Edition
[Translate]
Velocity Micro – $629 ; add $165 for video card.
> 500GB HDD
>Lifebook 500GB
>Vista Home Basic
>5.1 Surround sound
>Photo Album
>Paint Shop Pro
>Student and Teacher Edition (Office)
>(2X) Drives
>Logictech G-11 Keyboard (USB)
>Intel mobo
>E8400 Intel
>22″ Monitors
>infrared mouse (USB)
[Translate]
mail problem?
We have Microsoft Exchange Server Small Business 2003.
Our mail server is mail.claremontind.com .
When I configure our user account in Outlook Express 6.0 that’s working good. But when I configure same account in Microsoft outlook 2000/2003 . we get this type of message. But Internal ( in our office LAN) mail working . Problem with external mail
( not coming or not going out side from our office)
Your message did not reach some or all of the intended recipients
Subject : test dec 28 2007
Sent : 12/28/2007 10.57 am
The following recipients(s) could not be reached:
arun...@yahoo.com on 12/28/2007 10.57 AM
There was a SMTP communication problem with the recipient’s email server. Please contact your system administrator.
Help me.
Thank’s
Arunava Mandal
arun...@yahoo.com / arun...@rediffmail.com
[Translate]
you can not access the same mail in two e-mail client simultaneously
- even yahoo does not allow you to work with two account name on the same pc, the site will ask you to sign out and only use one
- try to access your mail with only one client
[Translate]
Recent grad looking for an accounting job, HELP, ADVICE, COVER LETTER?
Si I graduated college this May and haven’t had any luck finding a job. I know its my fault, I don’t have any previews accounting experience and most companies look for at least 1 yr. Only good about me is that i graduated college with honors and that is not helping a bit.
So now I’m thinking of sending a letter to every small accounting form around my area, which are several, and include my resume. Please let me know what you guys think?
Cover letter:
55 Franklin ave
Clifton, NJ 07011
(973) 580-6620
NjDa...@aol.com
August 4, 2009
Employer contact information
Name
Title
Company
Address
City, State, Zip Code
I am recent college graduate from the University of Rutgers Business School who is interested in interviewing for a job position in your accounting firm. If you are looking for someone who is hard working, smart and dedicated I am your man. Please allow me to put into practice all the knowledge that I have received at Rutgers. Let me become a member of your team and allow me to show you what a great asset I can be to your firm.
As a recent graduate at Rutgers University with significant experience in the business field I am sure I can bring the energy and commitment to excellence to thrive in your firm. Rutgers has given me knowledge in accounting necessary to excel in your firm. Also, my job has given me a greater understanding of the business world.
I am fluent in Spanish and English and this could help your firm communicate better with those Spanish owned companies. I am also very computer wise; I am very proficient in Microsoft word, excel, access. I have some knowledge of QuickBooks; it’s a very simple program, which I am sure I can learn very fast.
Since I have little accounting experience I would be willing to settle for a smaller salary than others. I have attached my resume to this letter; please contact me as soon as possible regarding a position in your firm.
Respectfully yours,
Daniel Zerpa
My resume:
Objective:
To secure a full-time entry level position in the accounting field where skills acquired from undergraduate study can be used.
Education:
Rutgers Business School Newark, NJ
Bachelors in Accounting
Cumulative GPA: 3.7 / 4.0
Honors / Achievement:
Graduated Rutgers Business School with High Honors (Spring 2009)
Participated in Price Waterhouse Cooper case competition (Fall) 2007
Participated in Deloitte case competition (Spring) 2007
Work Experience:
Domino’s Pizza Caldwell, NJ 2004 – Present
Shift Manager
ϖAssist with marketing strategy
ϖImprove efficiency by cutting cost
ϖAdvice through forecasting based on previews years
ϖEnsure that all team members conform to franchise service and product guarantees
ϖHelp train new team members
ϖResolve customer inquires, questions and problems that they may have incurred
Skills:
Microsoft Office (Word, Excel, Power Point, Access)
Bilingual: Fluent in English / Spanish
Basic knowledge of Portuguese
[Translate]
1 All cover letters should follow the cover letter format, that is, you must format the heading elements correctly. When sending your resume via email, the line spacing and address conventions may no longer apply, although, they do in paper cover letters.
2 The First Paragraph. This part should immediately tell your recipient how you learned about the job opening, your intent, the position you are applying, or if you are inquiring about future employment possibilities.
3 Second Paragraph. An effective cover letter would have the second paragraph explain and highlight your experience relevant to the job you are applying for. This part calls to action your background elements, particularly your education, experience, and leadership which are relevant to the position you are applying. Be sure to cite examples and strong evidences.
4 Reflect your attitude, such as your personality, motivation, enthusiasm, and communication skills.
5 Provide any information that the job advertisement specifically requested which is not covered in your resume, including your availability date, or reference to an attached writing sample.
6 Make the first sentence of the second paragraph hard-hitting – make it a quick introduction of your accomplishments directed at the qualifications and skills the job/industry requires.
7 Make your cover letter (and yourself, that is) more enticing to your prospective employers, by presenting facts that would interest them in hiring, or at least, interviewing you, such as your ability to increase profits, save money, conserve time, to immediately discharge or assume responsibility, and rapidly produce results when hired.
8 Be proactive by indicating that you will do a follow-up. This will show your deep interest to your job application, by saying something like, “I will contact you in the next two week to see if you require any additional information regarding my qualifications.”
9 Make the last paragraph count. In the final sentences, use call-to-action and always request for an interview. Also thank the reader for reading your cover letter and looking into your resume
When writing a resume always consider that the piece of paper you’ll be writing will generally represent who you are, what you can offer and why they should hire you. To put it simply, it is a marketing brochure showcasing “you”, your specifications and your capabilities and what you offer their company if you get hired.
[Translate]
Discuss the markets that these vendors are targeting.?
Big-name business applications vendors—Microsoft, Oracle, Lawson and (on the
business intelligence front) Cognos each made a splash with new software
announcements at the National Retail Federation’s Big Show event in New York on
Jan. 16.
The bevy of new offerings could help businesses in the retail sector move forward
with electronic initiatives.
Microsoft, for example, announced the 2.0 version of its Dynamics POS (Point of
Sale) suite of software aimed at making it easier for retailers to extend their
storefront online with such functionality as online invoicing and the ability to link to
PayPal and eBay marketplace selling.
POS 2.0 also offers roles-based design and integrates with Microsoft Office
Accounting Professional 2007 software.
For smaller retailers—and in conjunction with First Data and HP—Microsoft also
announced an out-of-the-box POS and payment suite that is designed to replace a
cash register and dial-up connection to the Internet with a PC-based POS sys
[Translate]
Various markets from SMB to large enterprises.
[Translate]
How much does it cost to run a Microsoft Exchange Server?
If you purchase Microsoft Small Business Server 2003 (which is a fixed price), it seems to come with Exchange Server 2007 and possibly 5 accounts for free. So, if you operate the server in-house, is there a monthly fee (other than registering a domain) associated with exchange? Do you have to purchase and pay monthly for client exchange licenses (CAL)? Thanks!
[Translate]
Ive installed a few sbs2003 servers.
if you are just going to use the 5 cals, you shoud only have to buy yearly cals. You will also need a seperate office license for all systems that are going to connect to the exchange server.
the cool this bout sbs 2003 is that it comes with rww and owa. if you configure owa, then your 5 people can remote into your exchange server to check their email. its pretty cool and easy to setup. i believe you just need to forward port 443 to the ip address of the server.
ohh yeah, you will need to get a static ip address from your Isp, and a cheap router/firewall to do the port forwarding.
other then that you should be good to go. i would suggest you also purchase some sort of spam protection for your exchange server, because if not, you are going to get hit hard by spam. Symantec spam works great, but if you dont want to pay for it, you can also contact any email hosting company in your town and see if you can use them as a gateway.
hope that helps
[Translate]