ECXEL QQUESTION

[lolzzz_321]

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)

??????????????????????

[Muxy]

something like that yup

[elipsesjeff]

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.

[Lukie]

something looks funny in your tightle

[lolzzz_321]

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]

Hangin out with PO$$E$$ED too much.

=VLOOKUP(C14, Lukie:Boost, 2, true)

#N/A

[Lukie]

Hangin out with PO$$E$$ED too much.

=VLOOKUP(C14, Lukie:Boost, 2, true)

#N/A

what are you trying to say trip