Someone Check My Excel Sheet?

hl0m4n · 01-01-2009, 05:15 PM

im trying to make a spread sheet for interest rates and savings. did i make this correct?

the spread sheet uses $200 month with 3.75%. enter $200 in jan invest column and see the calculations.

after january is the forumla accurate at (200+B4)+(B4*0.0375)?

the 200 is $200 monthly deposit followed by the addition of previous month added by the previous month's deposit's interest rate.

hl0m4n · 01-01-2009, 05:42 PM

what is the difference between rate and apr which am i supposed to use for example http://www.gmacbank.com/todays-rates/mmrates.html

e92phreak · 01-01-2009, 05:44 PM

Isn't your rate 3.75% annually and not monthly? Otherwise, I want my savings in that bank of yours.

01-01-2009, 05:42 PM	#2
hl0m4n Major General 2345 Rep 5,627 Posts Drives: BMW Join Date: Nov 2006 Location: NY iTrader: (58)	what is the difference between rate and apr which am i supposed to use for example http://www.gmacbank.com/todays-rates/mmrates.html __________________ Cars: 07 335i ► 08 328i ► 11 328xi ► 13 M3 ► 17 M4 ► 14 M6
	Appreciate 0 Quote

01-01-2009, 05:44 PM	#3
e92phreak General 393 Rep 21,745 Posts Drives: E92 335i TiAg/E46 323i TiAg Join Date: Mar 2007 Location: CA iTrader: (1) Garage List 2007 E92 335i [9.50] 2000 E46 323i [0.00]	Isn't your rate 3.75% annually and not monthly? Otherwise, I want my savings in that bank of yours. __________________ 07 E92 335i \| TiAg \| Step \| Padl \| Cmft \| Alum Trm \| PDC \| Nav \| Assist \| Sat \| Lthr \| Prem \| Sprt \| Rear Splr \| RDSport Quads \| iPod \| V1 \| LT Refl \| VS Clear Bra \| OEM Lip \| KWV2 \| Mtec Sides \| BBS LM-R 00 E46 323i \| TiAg \| 5sp \| Sport \| Roof \| RDSport Cams \| RDSport tune \| RDSport Shift \| Volk LE37 \| M3 spoiler \| PSS9 \| SuperSprint \| Brembo
	Appreciate 0 Quote