Components in Calculating the Time Value of Money
Not what you're looking for?
All answers should be in a single Excel file.
Show the step by step calculations how it was done and explained thoroughly by using excel:
1 If you deposit $15,000 today and earn 8% annual interest, how much will you have in 9 years?
Answer: $29,985.07
2 Tiffany will receive a graduation gift of $10,000 from her parents in 3 years. If the discount rate
is 7%, what is this gift worth today?
Answer: $8,162.98
3 What is the present value of a 20-year ordinary annuity of $30,000 using a 6% discount rate?
Answer: $344,097.64
4 You deposit $5,000 in an account that pays 8% interest per annum. How long will it take to double your money?
Answer: 9 years
5 The Johnsons have $60,000 to use as a down-payment on a house, and they want to borrow $240,000
from the bank. The current mortgage interest rate is 5%. If they make equal monthly payments for 30 years,
how much will the monthly payment be?
Answer: $1,288.37
6 Tim paid $250 per month into his 401K retirement plan. After 30 years, he had accumulated $500,000. What
average annual rate of interest had he earned over the 30 years?
Answer: 9.42%
7 Charlotte's firm had sales of $525,000 in the year 2001. By 2012, sales had increased to $1,200,000. What was
the average annual rate of increase?
Answer: 7.80%
Purchase this Solution
Solution Summary
The solution explains how to use Excel to calculate each component involved in the time value of money, for example, discount rate, period, present value, future value, etc.
7 questions; attached as Excel.
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
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.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.