Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could you please assist with this question? Question In this problem you will be calculating compound interest on 4 different deposit amounts. For each deposit

Could you please assist with this question?

Question

In this problem you will be calculating compound interest on 4 different deposit amounts. For each deposit amount, you will calculate the value of the deposit using 2 different interest rates compounded for the same number of years. I recommend you place this data into a Microsoft Excel workbook to make the calculations easier.

Notice the difference a small change in interest rate yields on the ending value of the deposit. Calculate the difference in the value of the deposit (take 1 value less the other), but enter the difference in absolute terms (i.e. all values are positive). For example if the difference is -$100, the absolute difference is $100 (which is the magnitude of change, direction is not important).

AFTER you have completed ALL your calculations, including FV & differences in value of deposit, round your answers to the nearest whole dollar and include dollar signs and commas to separate thousands. Do NOT round PRIOR to completing ALL your calculations, this may throw off 2 answers if you do. Do not place spaces before after $ signs and commas. Remember, all difference values must be in absolute terms.

Amount Deposited

Interest Rate (annual)

Period (years)

Value of Deposit After Period (years)

$550,000

5.0%

3

$550,000

2.0%

3

Difference in Interest Rate

3.0%

Difference in Value of Deposit

$750,000

7.5%

3

$750,000

6.0%

3

Difference in Interest Rate

1.5%

Difference in Value of Deposit

$3,200,000

2.5%

5

$3,200,000

2.0%

5

Difference in Interest Rate

0.5%

Difference in Value of Deposit

$15,800,500

6.0%

10

$15,800,500

4.0%

10

Difference in Interest Rate

2.0%

Difference in Value of Deposit

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

Chains Of Finance How Investment Management Is Shaped

Authors: Diane-Laure Arjalies, Philip Grant, Iain Hardie, Donald MacKenzie, Ekaterina Svetlova

1st Edition

0198802943, 978-0198802945

More Books

Students also viewed these Finance questions