Compare simple and compound interest (compounded annually) on a principal of $20,000 at an an-nual rate of 5%. Find the number of years it takes for the the difference of the total to reach more than $1000.

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter4: Time Value Of Money
Section4.17: Amortized Loans
Problem 1ST
icon
Related questions
Question

Compare simple and compound interest (compounded annually) on a principal of $20,000 at an an-nual rate of 5%. Find the number of years it takes for the the difference of the total to reach more than $1000. (I need this in an ecel spreadsheet) 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Present Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage