Pmt and nper functions in excel

Reference no: EM1327690

At each question the solution cell must contain the Excel formula (Function) that produced the answer. - Replace the existing numerical contents.- Also add a brief explanation of how the answer was derived and the significance of the question in understanding the Time Value of Money.

1. Alan had saved up $500,000. How much more must he save each year over the next 20 years in order to have a
total of $1 million? Alan earns 5% interest, compounded annually.

Hint: Use the Excel PMT function.

2. You deposit $5,000 in an account that pays 8% interest per annum. How long will it take to double your money?

Hint: Use the Excel NPER function.

Use the Rule of 72.

Reference no: EM1327690

Questions Cloud

How could pdp augment memory in evaluating : How could PDP augment memory in evaluating the potential risk in this and other potentially threatening situations.

Technology for strategic business processes : Technology for Strategic Business Processes - Is business process integration feasible and, if so, what lessons can be learned from the case study that would be applicable to any organization planning a strategy of business process integration?

Explain marketing development planning : Explain Marketing Development Planning and Develop marketing objective from the results of this analysis and in line with your corporate goals

N stands for per capita disposable income : P stands for price Pr stands for price of related good also N stands for per capita disposable income.

Pmt and nper functions in excel : At each question the solution cell must contain the Excel formula (Function) that produced the answer. Replace the existing numerical contents. Also add a brief explanation of how the answer was derived and the significance of the question in unde..

Describe the hyper-social organization : Four Pillars Of A Hyper-Social Organization - Explain the hyper-social organization. Explain the four pillars of a hyper-social organization.

Determine the best crop to plant : A farmer in Holland must decide which crop to plant next season: Wheat, corn, or Barley. The return on each will be determined by weather conditions.

Shift in leadership theory from competition to collaboration : Discuss the concept of a paradigm in relation to leadership. Also discusses a shift in leadership theory from competition to collaboration.

Mcdonnell douglas corp. v/s green test-outcome : I have read this case and I am not getting the test. Please help - Was the McDonnel Douglas test appropriate, are there any changes to the test. Will Green be able to prove McDonnell Dougla's reason was pretexual.

User Account

All Pages