Explain how compound interest and growth rates differ across

Assignment Help Financial Management

Reference no: EM131573253

1. Mr. Richards is trying to update his client presentations. He would like you to perform some future value calculations showing how great his returns are and how compounding works. He would like to show how $100,000 invested for 10, 20 and 30 years grows with his superior record of 8% annual returns. Just to underscore this he would also like the same compounding information with the historical annual market returns of 4%.

Excel: Use the standard TVM setup to determine the FV value given the PV of $100,000, rate of .04 and .08 and NPR of 10, 20, 30. Set this up and then copy and change values as described for each of the additional five scenarios. Create a summary table showing the years and rates and the compound interest earned. Also, create a summary table showing the year and rates and calculate the overall growth of each FV net of the PV. Use both of these tables in the write up. Written: Briefly describe the analysis that you have performed and explain the effect of compound interest. Describe what the growth rate of the money over, 10, 20 and 30 year spans. What is the difference in growth between the 4% and 8% rates? What do these rates say about the level of overall returns required to grow money and create wealth?

2. Mr. Richards needs more analysis to update his client presentations. He would like additional future value calculations. Using the same framework as in the last mini-project, calculate the future value of bank CDs that would pay 1% and 2% annual interest.

Excel: Copy the framework from the last mini-project and change the rates. Combine the summary tables from these analyses with the prior analysis to show the compound interest earned and overall growth rates for 10, 20, 30 years and annual returns of 1, 2, 4 and 8%.

Written: Briefly describe the analysis that you have performed and explain the effect of compound interest. Explain how the compound interest and growth rates differ across the different returns. Provide 3 summary points that could be used in a presentation about these returns.

Reference no: EM131573253

Questions Cloud

Estimate of firm common stock value : Before hiring investment banker to assist in making public? offering, managers at Nabor have decided to make their own estimate of firm's common stock value.

Discuss the monty hall problem : If you pick the right door, you win the prize. You pick door A. The game show host then opens one of the other doors and reveals that there is no prize.

Compute the annual depreciation expense : Using straight-line depreciation, compute the annual depreciation expense for 20X5 and 20X6

Which of first four stages of organizational growth presents : Write a one to two page paper in which you discuss which of the first four stages of organizational growth presents the greatest single challenge and why.

Explain how compound interest and growth rates differ across : Explain how the compound interest and growth rates differ across the different returns.

What is her medical expense deduction : Olive's daughter Polly suffers from rare illness. During 2017, Olive drove Polly to see specialist in another state 15 times. What is medical expense deduction

How many positive three-digit integers are multiples of six : What is the probability that a randomly chosen positive three-digit integer is a multiple of 6?

What does the presence or absence of anti-bullying policies : What does the presence or absence of anti-bullying policies suggest to you about the corporate culture and values of an organization

Describe the business and its likely main competitors : Describe the business and its likely main competitors. How would you structure your advertising and customer service to differentiate your product/service?

User Account

All Pages