Example:Spreadsheet Strategies-Annuity PV The present value and future value formulas in a spreadsheet include a place for annuity payments Click on the Excel icon to see an example 15
15 Example: Spreadsheet Strategies – Annuity PV n The present value and future value formulas in a spreadsheet include a place for annuity payments n Click on the Excel icon to see an example
Quick Quiz:Part 2 You know the payment amount for a loan and you want to know how much was borrowed.Do you compute a present value or a future value? You want to receive $5,000 per month in retirement.If you can earn .75%per month and you expect to need the income for 25 years,how much do you need to have in your account at retirement? 16
16 Quick Quiz: Part 2 n You know the payment amount for a loan and you want to know how much was borrowed. Do you compute a present value or a future value? n You want to receive $5,000 per month in retirement. If you can earn .75% per month and you expect to need the income for 25 years, how much do you need to have in your account at retirement?