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 Plan a Production (6 Steps)

Schedule one or more readings of your script with your team. During the first reading or two, have team members identify what they do and don't like about the script. Have them identify the logistical issues associated with producing it. Ensure that the script falls in line with the preferences of your audience.
Review each scene in the script carefully. Identify the cast, props, crew, equipment and other resources needed to produce each individual scene. Make a spreadsheet identifying each person or item required by scene numbers. Also include a column for the cost of each person or item.
Assign roles to your team members. For school and community theater productions, be sensitive not only to what people would like to do, but also to how much time they have to work. For film productions and paid theatrical productions, work with professionals who have worked in other successful productions. They will have a solid understanding of their respective roles in the production process.
Assess the costs of your production. Move through the spreadsheet you created to identify a cost for each item in the production, including labor and overhead. You may want to ask your team to help you assess costs. Compare the overall projected cost of the production against how much you can afford to pay. Use this information to project how much you want it to earn in ticket sales.
Create a schedule that accurately reflects how long it will take to produce your project. Make sure it encompasses time for cast and technical rehearsals, constructing props and sets, acquiring equipment for use during the production, and clean-up after the production ends. Review the schedule with team members to ensure that it reflects their best estimates. Add extra time to ensure that you can handle unforeseen events.
Combine the script, schedule, cost estimate and team assignments into a written production plan. Use this document to help raise money to produce your project. Follow your production plan when the time comes to create your production.
VPS Hosting