Time value of money calculator

Assignment Help Business Management

Reference no: EM133067543

Question 1. Using the TVM (Time Value of Money Calculator) determine how much you need to save monthly to reach $1,000,000 in savings over a 20 year time period, over 30 years and over 40 years at a 5% annual return. You simply need to plug in the numbers into the boxes. You are solving for PMT, so once you input the given values, hit the PMT to determine the monthly payment amount. Be sure to set the compounding box to monthly and in the number of payments to the total number of months (20x12; 30x12; and 40x12). You should see a significant difference in the amount you need to save each month depending on how long you invest. You will calculate 3 amounts.

Question 2. Now calculate the lump sum you would need today under the 3 scenarios. In other words, calculate for PV using the 5% return over 20, 30 and 40 years. You will include a payment since the only payment is the lump sum you need today to reach the $1,000,000 in 20, 30, and 40 years. In this case, be sure to set the compounding periods to annual. You are calculating 3 amounts.

Reference no: EM133067543

Questions Cloud

Discuss what happens to inter-team communications : Discuss what happens to inter-team communications when the size of the group increases. What can management due about this?

Define term strategy : Define the term "strategy". List at least 6 basic questions that should be asked when developing the key components of an organizational strategic plan.

Company resubmit or cure the alleged defects in bid : Based on your research, has the company ever failed to be awarded a contract? If so, did the company resubmit or cure the alleged defects in the bid?

Should Advaark stick to its core business or diversify : Should Advaark stick to its core business or diversify? Apply and explain your reasoning with the Strategic Sourcing framework.

Time value of money calculator : Determine how much you need to save monthly to reach $1,000,000 in savings over a 20 year time period,

Traits-Skills or Behaviors : Discussion-Leadership-What's most important for a leader to possess? Traits, Skills or Behaviors?

Developments marketing information : Discuss some of the developments which make the need for marketing information greater now than at any time in the past.

Team experience and waste : What have been the typical problems you have encountered and how did you address those problems?

Challenging work environment and slow economy : What are the most significant challenges facing managers of service organizations in today's challenging work environment and slow economy?

User Account

All Pages