How to Build a Savings Interest Calculator in Excel

Open a new spreadsheet in Excel.
Label row 1 as follows: A1 is 'Date,' B1 is 'Balance,' C1 is 'Additional deposits' and D1 is 'Interest.' Format columns B, C and D as currency by selecting the columns and clicking on the dollar sign button in the 'Home' tab. (Users of Excel 2003, click the dollar symbol on the Formatting toolbar.)
Call your bank or look at your account online to find out when the bank adds interest payments to your account.
Fill in column A with interest payment dates, starting with the most recent date your account received an interest payment. If your bank adds interest payments monthly, use monthly dates (October 1, November 1, etc.); if it pays annually, add dates by year. For example, if your last interest payment was October 1, 2009, the next date will be October 1, 2010.
Type the current balance of your savings account into cell B2.
Fill in column C with additional deposits. If you deposit $500 into the account in the interval between interest payments, enter '500' in cells C2, C3, and down as far as you'd like. If you deposit irregularly, leave those cells blank but enter figures each time you make a deposit. You can combine these approaches, entering a minimum figure and adding to it if you make more deposits.
Enter the following calculation in cell D2, without the quotation marks: '=B2+C2+x
(B2+C2)' where x is the interest rate. The interest rate type--daily, monthly, annually or other--must match the intervals between the dates in column A (step 4). Remember to multiply the interest rate expressed as a percentage by .01. So a 1.5 percent interest rate calculated once a year gives you a multiplier of 0.015. In this case your formula would be '=B2+C2+.015
(B2+C2)'. If the same interest rate was applied monthly instead of annually, your formula would be '=B2+C2+(0.015/12)*(B2+C2)'.
Copy cell D2 and paste in cells D3, D4 and on down as far as you'd like.
Navigate to cell B3 and type (without the quotation marks) '=D2'. This will cause Excel to display the formula result--your account balance after the interest payment--in cell B3.
Copy cell B3 and paste in cells B4, B5 and on down as far as you'd like.
Save the spreadsheet and close it.
VPS Hosting

How to Earn Amazon Gift Cards Using Swag Bucks

Sign up at Swagbucks.com by entering your name, a valid email address and a user name and password you would like to use to log into the site. The email address should be one you check regularly so you receive notifications if you win extra prizes.
Check your email address to get the verification link. Click on this to activate your account.
Search the Web using the search engine on Swagbucks.com. You can also download and install the toolbar for your browser to make it easier to search on a regular basis. Some of your searches will earn Swag Bucks, which are the currency on the site.
Perform other activities on the site that earn Swag Bucks. Possibilities include completing surveys, playing games, completing special offers, voting in the poll every day and watching videos. You can also sometimes find Swag Codes on the blog, facebook and twitter pages, which you enter on the Swagbucks.com homepage to win more Swag Bucks. You can complete as few or as many activities as you would like, but the more you complete, the faster you will earn Swag Bucks.
Wait until you have at least 450 Swag Bucks in your account, which is the price of the Amazon.com gift card at the time of publication.
Navigate to the Swag Store by going to the 'Redeem' tab at the top of the home page or in the toolbar.
Click on the 'Gift & Rewards Cards' button in the Swag Store menu. Scroll until you find the $5 Amazon.com gift card. If you're in the U.S., be careful to not choose the Amazon.ca gift card, which is for Canadians, or the Amazon.co.uk gift card for people in the United Kingdom.
Follow the prompts to redeem your Swag Bucks for the Amazon.com gift card. You will need to click the verification link in your email to confirm that you are the account owner. After you click the verification link, your gift card will take about 10 to 14 business days to be processed.
Go to the 'My Gift Cards' section of your account after 14 business days have passed. You will also receive an email notification when the gift card is processed, which might be sooner than 14 business days. Enter your password as prompted to view your gift cards.
Enter the gift card code on Amazon.com while making a purchase or while logged into your account to have the credit available next time you make a purchase.
VPS Hosting