Purchase Solution

Future value of single sum annuity using excel

Not what you're looking for?

Ask Custom Question

1.) You put $5,000 in an investment account today which will earn 6% over the next 11 years, what is the future value?

2.) You put $2,000 in an investment account today which will earn 8% over the next 14 years, what is the future value?

3.) You deposit $5,000 into a retirement account at the end of the next 15 years earning 8% interest, what is the future value of your retirement after 15 years?

4.) What is the value of a perpetuity with an annual payment of $50 and a discount rate of 4%?

5.) You deposit $10,000 into a retirement account at the end of the next 10 years earning 9% interest, what is the future value of your retirement after 10 years?

Purchase this Solution

Solution Summary

Your tutorial is in Excel and gives you the ingredients (p = , i = , pv/pmt = ) to use excel or a financial calculator to get desired amounts.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

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.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.