Spreadsheet Homework 2

Create a spreadsheet that calculates simple and compound interest
at 6% on a deposit of $1000, for 40 years.

Your spreadsheet should look something like this.  

Firstname Lastname (MUST BE TYPED!)
Spreadsheet Homework #2: Simple and Compound Interest


	Simple Interest:						|Compound Interest:

Years 	Rate		Main	Int.	Interest	Simple		|Compound	Interest
since	This		Balance Earned	Balance		Total		|Balance	Earned
start  	Year			ThisYr	at start	Balance		|		This Year
					of year				|
0	6%		$1000	$60	 $0		$1000		|$1000.00	$60.00
1	6%		$1000	$60	 $60		$1060		|$1060.00	$63.60
2	6%		$1000	$60	 $120		$1120		|$1123.60	$??.??
etc--you must fill in these rows.
40	6%		$1000	$60	 $???		$????		|$????.??	$???.??

The question marks are numbers that you will have to determine.
You should not do the calculations by hand or copy from anywhere--
instead, type formulas in to the spreadsheet.  No numbers (like 0 or 60 or 120) should
appear in your formulas on or below year #1.

Your spreadsheet should be tested as follows:
* changing the 6% at the top of its column to another value, and making sure all the calculations work automatically.
* Changing the initial deposit of $1000 to another value, and making sure all the calculations work automatically.


You should also make a graph that has:
x=years since start
and two y curves,
y=Simple total balance
and
y=Compound balance.

Your axes should be labeled appropriately.