Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The rule of 72. 6. Show in Excel that if $20,000 is invested at 6% compounded annually, then it will double in about 12

image

The rule of 72. 6. Show in Excel that if $20,000 is invested at 6% compounded annually, then it will double in about 12 years. (Note: 12=72/6) year F 1 23456780 9 Calculate the future value as the function of the years and see in which year the investment is doubled. Evaluate the future value in Excel using the cells of the year column. Keep the interest rate constant. 7. Show in Excel that if $20,000 is invested for 4 years, then it will approximately double at 18% compounded annually (Note 18=72/4) interest rate F 1 234567800-2 10 11 12 Calculate the future value as the function of the interest rates and see at which rate the investment is doubled. Evaluate the future value in Excel using the cells of the interest rate column. Keep the year in the formula constant.

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

Finite Mathematics and Its Applications

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

12th edition

978-0134768588, 9780134437767, 134768582, 134437764, 978-0134768632

More Books

Students also viewed these Mathematics questions

Question

31. Why are database reorganizations necessary?

Answered: 1 week ago

Question

If we had an inverted pyramid, what would we have to change? P987

Answered: 1 week ago

Question

Do we value our line staff? How? P987

Answered: 1 week ago

Question

Should we have two-way evaluations? Why or why not? P987

Answered: 1 week ago