Purchase Solution

How Long to Double Your Money?

Not what you're looking for?

Ask Custom Question

You deposit $1,000 in an account that pays 8% interest, compounded annually. How long will it take to double your money?

Now I already know the answer is 9 years by using the rule of 72 however I am trying to find a formula in excel that proves this answer to be correct and I am coming up with nothing. I need help with the formula in excel for this.

Thanks!

Purchase this Solution

Solution Summary

This solution discusses how to use Excel to find out how long it would take to double one's investment.

Solution Preview

I would suggest using the NPER Function in Excel for this. The format is:

=NPER(RATE, PMT, PV, FV, [TYPE]), where

NPER = Number of compounding ...

Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

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.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.