Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

m #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest

image text in transcribed
image text in transcribed
m #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest each month. Every 3 months (i.e. every quarter) the interest rate will increase The initial deposit will be $183. At the beginning of each month thereafter, another deposit will be made increasing by size $30. The continuously compounded interest rate will be 7.04% per annum for the first quarter, but will then increase by 0.2% at the beginning of each subsequent quarter. Note that the rate is the same constant value for each of the 3 months in a given quarter. Create a spreadsheet with headings as shown: A B D E F G Increase in deposit 1 2 3 4 Timestep Initial rate Rate increase initial Deposit 0.083333 your value> 5 Total 6 7 8 Time o *B7+$B$3 Rate -C3 Deposit E3 Prev Total with interest 0 =D7+E7 Each row of the table will represent a different month, with the first row being time zero. Programming note: You will be reusing this spreadsheet and using Goal Seek in the next question. So you should use best practices by having all parameters in individual cells at the top of your spreadsheet. Then inside the table, all the formulas should contain cell references only, no constant numerical values, as illustrated above. Suggestion: For ease in entering the formula for an increasing rate, the first three time steps have the identical rate, and then the rate in any later month equals the rate 3 months ago plus the increase, At the end of 5 years, after your 61st deposit, how much money do you have? slem #5: 79436.12 Answer correct to 2 decimals Just Save Submit Problem #5 for Grading Attempt Attempt #5 Problem #5 Your Answer: Your Mark: Attempt 75215.58 0/1X Attempt 2 79329.09 Attempt 79436.12 0/1X 0/1X lem #6: Return to the spreadsheet from the previous problem. Keep the initial deposit and all the interest rates the same. Use Excel's "Goal Seek" to determine the amount by which the deposit should increase each month in order to reach a final value of $137520.55 after the 61st deposit. What should be the monthly increase in the size of the deposit? (Note: "Goal Seek" is usually located under "What-If Analysis" under the "Data" tab.) Problem #6: Answer correct to 2 decimals m #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest each month. Every 3 months (i.e. every quarter) the interest rate will increase The initial deposit will be $183. At the beginning of each month thereafter, another deposit will be made increasing by size $30. The continuously compounded interest rate will be 7.04% per annum for the first quarter, but will then increase by 0.2% at the beginning of each subsequent quarter. Note that the rate is the same constant value for each of the 3 months in a given quarter. Create a spreadsheet with headings as shown: A B D E F G Increase in deposit 1 2 3 4 Timestep Initial rate Rate increase initial Deposit 0.083333 your value> 5 Total 6 7 8 Time o *B7+$B$3 Rate -C3 Deposit E3 Prev Total with interest 0 =D7+E7 Each row of the table will represent a different month, with the first row being time zero. Programming note: You will be reusing this spreadsheet and using Goal Seek in the next question. So you should use best practices by having all parameters in individual cells at the top of your spreadsheet. Then inside the table, all the formulas should contain cell references only, no constant numerical values, as illustrated above. Suggestion: For ease in entering the formula for an increasing rate, the first three time steps have the identical rate, and then the rate in any later month equals the rate 3 months ago plus the increase, At the end of 5 years, after your 61st deposit, how much money do you have? slem #5: 79436.12 Answer correct to 2 decimals Just Save Submit Problem #5 for Grading Attempt Attempt #5 Problem #5 Your Answer: Your Mark: Attempt 75215.58 0/1X Attempt 2 79329.09 Attempt 79436.12 0/1X 0/1X lem #6: Return to the spreadsheet from the previous problem. Keep the initial deposit and all the interest rates the same. Use Excel's "Goal Seek" to determine the amount by which the deposit should increase each month in order to reach a final value of $137520.55 after the 61st deposit. What should be the monthly increase in the size of the deposit? (Note: "Goal Seek" is usually located under "What-If Analysis" under the "Data" tab.) Problem #6: Answer correct to 2 decimals

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

The Financial Crisis Implications For Research And Teaching

Authors: Ted Azarmi, Wolfgang Amann

1st Edition

3319205870, 978-3319205878

More Books

Students also viewed these Finance questions

Question

Are my points each supported by at least two subpoints?

Answered: 1 week ago