PV and FV Calculator
You were asked to invest $60,000 into a business and it was guaranteed to you that you'll be paid $600/month for 15yrs with an annual interest rate of 6%/yr. Is this a good investment?
Potential Investment: Health Food Store
Investment Amount $60,000.00
Annual Interest Rate 6%
Term (Years) 15
Present Value ??????
Is this a good investment? ?????
Using a PV calculator I found the PV=$71,102.11 which means it's a good investment. Am I correct?
Potential Investment: Savings Plan
Annual Interest Rate 1.25%
Term (Years) 3
Monthly Deposit 1000
Future Value ?????
Interest Earned ?????
Using FV calculator I got FV=$36,664.06, Interest Earned=$664.06
Am I right?
Thanks in advance.
Re: PV and FV Calculator
Look at the IRR and XIRR functions.
This is a simple linear approach: See attachement
Last edited by rwgrietveld; 01-24-2010 at 04:18 AM.
Looking for great solutions but hate waiting
Seach this Forum through Google
(e.g. +multiple +IF site:excelforum.com/excel-general/ )
(e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1