This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview:  20 year 4% annuity paid $50,000 end of each year, $100,000 remaining 10 year annuity of quarterly $20,000 payments at 3%, nothing remaining 5. Build the Future Value Calculator Shown Below Returns the present value of an investment, the value now of a series of future pay Maintain general appearance and formatting Name the four input cells "fvRate", "fvNumPmts", "PeriodicPmt", "LumpSumPm Name the Present Value output cell "PresentValue" FUTURE VALUE CALCULATOR RATE NUMBER OF PMTS AMT OF EACH PMT LUMP SUM PMT FUTURE VALUE = 6. Find the future value for the following (all pmts made at beginning of period); Invest $100,000 today, compounded annually at 6% for 20 years Invest $1000 monthly for 35 years at 8% Invest one lump sum of $5,000, then 1000% monthly for 35 years at 8%. yments mtRemaining) Answer yments t") Answer...
View
Full Document
 Spring '10
 Matta
 4%, 3%, $1000, 4 year, $500

Click to edit the document details