Computing the Present VAlue of an Annuity
Not what you're looking for?
Which of the following 10 year annuities has the greatest present value? Assume all the annuities have the same interest rate.
An annuity that pays $1,000 at the end of each year?
An annuity that pays $500 at the beginning of every six months?
An annuity that pays $1,000 at the beginning of each year?
An annuity that pays $500 at the end of every six months?
Purchase this Solution
Solution Summary
This solution illustrates how to compute the present values of ordinary annuities and annuities due (in arrears) using the Excel Time Value of Money function.
Solution Preview
Please see the attached Excel 97-2003 spreadsheet.
Which of the following 10 year annuities has the greatest present value? Assume all the annuities have the same interest rate.
Intuitively, we would say that the annuity that pays $1,000 at the beginning of each year would have the greatest present value. To test this, we will discount all of the annuities at a 5 percent per year interest rate.
An annuity that pays $1,000 at the end of each year?
PV $7,721.73 This is the present value of the annuity
FV $- This is the amount remaining after all ...
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Operations Management
This quiz tests a student's knowledge about Operations Management