Pmt and nper functions in excel

Assignment Help Finance Basics
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.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Compute of invoice price of a bond

Compute of invoice price of a bond If the last interest payment was made 2 months ago and the coupon rate is 6%

  Computation of cost of equity with use of capm

Computation of cost of equity with use of CAPM and Assuming the CAPM or one-factor model holds

  Show comparisons of per capital gross domestic product

Multiple choice questions on CVP analysis, Profitability ratios, Variance analysis and Comparisons of per capital gross domestic product (GDP)between countries:

  Computation of value of share

Computation of value of share and What is the value of a share of Gamma Corporation common stock to an investor who requires a 20% return on an investment

  Explain capital budgeting decision for purchase of computers

Explain Capital Budgeting decision for purchase of computers based on present value of costs

  Calculation of cost of capital using wacc formula

Calculation of Cost of Capital using WACC formula where the company raises $20,000,000 is in the US equity market

  Determining the portfolio-s expected returns

Portfolio is invested 37.7% in Stock A, 26.6% in Stock B, and remainder in Stock C. Expected returns are 19%, 26.1%, and 11.8% respectively. Determine the portfolio's expected returns?

  Computation of breakeven sales and contribution margin

Computation of Breakeven sales and Contribution margin at breakeven and what would be the break even in this case

  Risk tolerance as well as your need to diversify

Risk tolerance as well as your need to diversify the portfolio and the Effects of Portfolio Risk for Average Stocks will impact your future investment decisions

  Explain portfolio management

Explain Portfolio management - Forex Using the currency exposures and exchange rates given above

  Determining random sample from normal population

Random sample is attained from normal population with the mean of µ = 80 and standard deviation of σ = 8. Which of the following outcomes is more probable? Describe your answer.

  Calculation of net present value of convertible bond

Calculation of Net present value of convertible bond and what is the Aramis Inc.'s net present value of its interest savings

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd