|
lolzzz_321
|
04-04-2006, 04:09 PM
Post subject: ECXEL QQUESTION
|
#1 (permalink)
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
So I'm doing this exel thing and it give me:
Panama City
$2,468.52 COST
4.05% APR
$75.00 MONTHLY PAYMENT
24 MONTHS (PERIODS)
? AMOUNT SAVED
So my formula for amount saved would be =FV(4.05%/12, 24, -75)
??????????????????????
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
Muxy
|
|
4-of-a-Kind
Join Date: Apr 2005
Location: Canadian LOLUH'S AND AMERICAN LOLUHS
Posts: 1,529
|
|
something like that yup
|
|
|
|
elipsesjeff
|
|
Moderator
Join Date: Jul 2004
Location: Northern Virginia
Posts: 4,900
|
|
I think you have to convert your APR into EIR then do the calculation. Also, you find out how much you save by subracting the value you get by doing the calculation from the original cost.
|
Check out my videos at Grinderschool.com
More Full Ring NLHE Cash videos than ANY other poker training site. Training starts at $10/month.
|
|
Lukie
|
|
4-of-a-Kind
Join Date: Jul 2005
Location: back with a vengeance
Posts: 3,307
|
|
something looks funny in your tightle
|
|
|
|
lolzzz_321
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
Nah, she said that was it. The amount saved is how much we have saved of the $2k, like the cost is our goal. We are depositing $75 each month and getting that annual interest rate, so we gotta divide it by 12. Thx Jeff.
|
|
|
|
lolzzz_321
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
Hangin out with PO$$E$$ED too much.
=VLOOKUP(C14, Lukie:Boost, 2, true)
#N/A
|
|
|
|
Lukie
|
|
4-of-a-Kind
Join Date: Jul 2005
Location: back with a vengeance
Posts: 3,307
|
|
Quote:
|
Originally Posted by Triptan3s
Hangin out with PO$$E$$ED too much.
=VLOOKUP(C14, Lukie:Boost, 2, true)
#N/A
|
what are you trying to say trip
|
|
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
