software

Hi I'm trying to figure out how to use the FV function to come up with
a future value in Excel.

The data from excel is listed like this:
---------------------------------------------------------------------------------------------------------------------------
Investment Plan Analysis

Monthly DepositInterest RateYearsFuture Value
900 5.00% 15
---------------------------------------------------------------------------------------------------------------------------
900 is in cell B6, 5.00% is in cell B7, 15 is in B8, the cell that is
supposed to have the FV function in it is in cell B9 directly below
where it says quot;Future Valuequot;. What value do I put in first, second,
third, etc. using the function boxes...to come up with the Future
Value?

Thanks very much in advanced for any responses.

MCTry

=FV(B7/12,B8*12,-B6)

--
Regards,

Peo Sjoblom

(No private emails please)gt; wrote in message oups.com...
gt; Hi I'm trying to figure out how to use the FV function to come up with
gt; a future value in Excel.
gt;
gt; The data from excel is listed like this:
gt; ---------------------------------------------------------------------------------------------------------------------------
gt; Investment Plan Analysis
gt;
gt; Monthly Deposit Interest Rate Years Future Value
gt; 900 5.00% 15
gt; ---------------------------------------------------------------------------------------------------------------------------
gt; 900 is in cell B6, 5.00% is in cell B7, 15 is in B8, the cell that is
gt; supposed to have the FV function in it is in cell B9 directly below
gt; where it says quot;Future Valuequot;. What value do I put in first, second,
gt; third, etc. using the function boxes...to come up with the Future
gt; Value?
gt;
gt; Thanks very much in advanced for any responses.
gt;
gt; MC
gt;thank you