Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show excel formula Compound Interest You want to know how long it will take you to double your money when it is invested at

Please show excel formula

image text in transcribed

Compound Interest You want to know how long it will take you to double your money when it is invested at different interest rates. The amount of time it takes to double in value depends on the interest rate. To estimate the number of periods to double your investment use the "Rule of 72 " To calculate the "Rule of 72 " divide 0.72 by the interest rate. (Don't forget to include the decimal point) That tells you approximately how many periods it will take to double your money if interest is compounded "Compounded" means interest is paid on both the principal and any interest earned up to that point. It is larger every time. "Simple" interest is when the interest is paid only on the principal. It is a fixed amount. Let's test this theory for different interest rates Enter formulas in cells C19 C20 and C21 Copy the formulas into the range D19:K21 Rule of 72 calculation =0.72/ by the interest rate. This can be written as =072/0.03, for example. Rule of 72 calculation =.0;72/ by the interest rate. This can also be expressed in integers, =72/3 for example. Is the rule of 72 a reliable way to estimate doubling time? What is the trend in the "Amount of Savings" as interest rates increase

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Futures And Options Market

Authors: John C. Hull

6th Edition

0132242265, 9780132242264

More Books

Students also viewed these Finance questions

Question

=+. Alliteration The Magic of Macy's tagline.

Answered: 1 week ago

Question

=+iv. Simple promise No ordinary airline (Virgin Atlantic Airway).

Answered: 1 week ago