Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started