Future & Present Value Example in Excel
Not what you're looking for?
? Calculate the future value of the following:
?
o $5,000 compounded annually at 6% for 5 years
o $5,000 compounded semiannually at 6% for 5 years
o $5,000 compounded quarterly at 6% for 5 years
o $5,000 compounded annually at 6% for 6 years
?
? Answer the following: What conclusions can be drawn about the frequency of compounding interest? What conclusions can be drawn about the length of time an amount is compounding?
?
? Calculate the present value of the following:
?
o $7,000 in 5 years at an annual discount rate of 6%
o $7,000 in 5 years at a semiannual discount rate of 6%
o $7,000 in 5 years at a quarterly discount rate of 6%
o $7,000 in 6 years at an annual discount rate of 6%
? Answer the following: What conclusions can be drawn about the frequency of the discounting interval? What conclusions can be drawn about the length of time until the receipt of that value?
? Answer the following: Assume you have a choice between two annuity contracts. Contract A pays $5,000 per year for 5 years starting one year from today. Contract B pays $5,000 per year for 5 years starting today. The discount rate for each is 6%. Which annuity contract would you choose for your retirement? Why?
Purchase this Solution
Solution Summary
The solution computes Future & Present Value in a given scenario in Excel.
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Operations Management
This quiz tests a student's knowledge about Operations Management
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking