Question

using =FV(5%,15,,75000) in excel, but it keeps showing up as a negative amount. what do i need to change to make it positive. A=$75000 B=YRS 15 C=5% PER YR
thanks in advance

Answer 1

=FV( interest_rate, number_payments, payment)
Could you show exactly what the formula is (copy and paste it right to this board), and what you are getting as a result?

Answer 2

Investment Years Per Year Return
$75,000.00 15 5.0% ($155,919.61)

Answer 3

FV(5%,15,,75000)

Answer 4

Well I tested out those figures with an online compound interest calculator and it matches to the penny. But as you say, it comes out negative correct?
I'm wondering if inputting the per cent sign (%) might have something to do with it. Computers don't like to deal with per cent signs, dollar signs and the like. So try inputting without the per cent sign.

Answer 5

ok will try that
just wondered if i was going mad or something :)