Question: Compare simple and compound interest (compounded annually) on a principal of $20,000 at an annual rate of 5%. Find the number of years it takes

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

Step by Step Solution

★★★★★

3.40 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Computation of simple interest is below Year Principal amount interest rate interest 1 20000 5 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A bond that pays 10% interest compounded annually on a $1,000 face value will mature in 20 years. The interest rate is now 12%. What should the bond's market price be?

The simple interest I on a principal of P dollars

The data below show the number of years it took for selected technological innovations to spread to 25% of the U.S. population. The data are also in file XR17062. For y = years to spread and x =...

Could someone help me with putting this in Excel? 1. Compare simple and compound interest (compounded annually) on a principal of $95,500 at an annual rate of 4.25%, for a 10-year period. Fill in the...

compare simple and compound interest

HellonDr.Ramsey Can you assist me with my discussion please, Min 150 words due Friday. Basic Time Value of Money It is a common fact that many lottery winners are ?broke? sooner than later. If you...

For item number 22-23, refer to the problem: Mrs. Versoza wants to compare simple and compound interests on a Php 350,000 investment for 3- and 3- months years. 22. Find the interest if funds earn...

Simple and Compound Interest You invest $1,000 for five years at 5% simple interest at Bank 1. You invest $1,000 for five years at Bank 2 where interest at 5% is compounded annually. Compute the...

Simple and Compound Interest You invest $1,000 for fi ve years at 5% simple interest at Bank 1. You invest $1,000 for fi ve years at Bank 2 where interest at 5% is compounded annually. Compute the...

Entries for Installment Note Transactions On January 1, Year 1, Bryson Company obtained a $58,000, four-year, 10% installment note from Campbell Bank. The note requires annual payments of $18,297,...

INDIVIDUAL TAX RETURN PROBLEM 2Required: Use the following information to complete Johnelle and Latoya Henry's 2016federal income tax return. If information is missing, use reasonable assumptions to...

Veach Division has total assets ( net of accumulated depreciation ) of $ 4 6 2 , 0 0 0 at the beginning of year 1 . One of the assets is a machine that has a net book value of $ 4 8 , 7 2 0 ....

You need to implement the following for the users in the marketing department: Open a customer relationship management (CRM) popup when the users receive a Teams call. Ensure that SIP devices can be...

Southern Amusements Corporation had the following stockholders' equity on November 30: On December 30, Southern purchased 200 shares of treasury stock at $15 per share. Southern Amusements...

What is meant by "satisfying the customer" as a manager in a healthcare industry

The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31. a. On July 31, the company's Cash account has a $25,157...

Horse serum containing specific antibody to snake venom has been a successful approach to treating snakebite in humans. How do you think this anti-venom could be generated? What are some advantages...

What factors must be considered when deciding whether to refinance a loan after interest rates have declined?

What is the break-even mortgage interest rate (BEIR) in the context of financial leverage? Would you ever expect an investor to pay a break-even interest rate when financing a property? Why or why...

What are loan closing costs? How can they be categorized? Which of the categories influence borrowing costs and why?

=+70. A continuous signal is sent over a communication channel. The number of errors per second, x, at the receiving end of the channel has a normal distribution with a mean and standard deviation of...

=+a. Verify that Pd(c ) 5 .5.

=+71. Use spreadsheet (e.g., Excel) or other software to approximate the sampling distribution of the sample mean.