MrDavidThorn
asked on
Calaculate Future value of Investement using Excel
Hi Experts
I have a invesment with an interest rate of 6% and am paying $50 each month for 36 months, I am trying to calculate the future value of the investment with Excel, When I use the FV formula I get a silly value returned which means Im doing something wrong
FutureInvestment.xls FutureInvestment.xls
I have a invesment with an interest rate of 6% and am paying $50 each month for 36 months, I am trying to calculate the future value of the investment with Excel, When I use the FV formula I get a silly value returned which means Im doing something wrong
FutureInvestment.xls FutureInvestment.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a read of the office doc explination here http://office.microsoft.com/en-us/excel-help/excel-functions-for-personal-financial-decisions-the-pv-fv-pmt-ppmt-and-ipmt-functions-HA001111745.aspx
Comes with example spread sheets
Comes with example spread sheets
mising = mixing
Apologies!
Alan.