I’m investing 6% of my monthly salary into a savings account with a monthly interest rate...

I’m investing 6% of my monthly salary into a savings account with a monthly interest rate of 0.67%, the interest compounds monthly. How much will the savings account be worth after 10 years if I make an annual salary of $62,000 dollars and expect an annual salary increase of 1.5%?

Solutions

Expert Solution

Monthly interest rate = 0.67%

Number of times compounding in a year = 12 (monthly basis)

Monthly compounded Annual interest rate = (1+ monthly interest rate)^(number of time compounding in a year) -1

= (1+0.67%)^12 -1

= 1.08343 -1

Effective annual interest rate = 8.343%

Current salary = $62,000 (1.5% increment every year)

Savings every year = 6% of the salary in that year

Total savings at the end of 10th year = $62,899

Spreadsheet calculation:

Years	Annual salary (1.5% increase pa)	Savings (6% of salary)	Annual effective interest rate	Cumulative saving amount at the of year
1	62,000	3,720	8.343%	4,030
2	62,930	3,776	8.343%	8,457
3	63,874	3,832	8.343%	13,315
4	64,832	3,890	8.343%	18,641
5	65,805	3,948	8.343%	24,473
6	66,792	4,007	8.343%	30,857
7	67,793	4,068	8.343%	37,838
8	68,810	4,129	8.343%	45,468
9	69,843	4,191	8.343%	53,802
10	70,890	4,253	8.343%	62,899

Excel formulas:

jeff jeffy answered 6 months ago

Next > < Previous

Related Solutions

6.Suppose that you had savings deposited in an account at an interest rate of 5 percent...

6.Suppose that you had savings deposited in an account at an interest rate of 5 percent and your father told you that he earned 10 percent interest 20 years ago. Which of you was getting the better return? How would your answer change if you were told that the inflation rate in the United States was 12 percent 20 years ago and is 3 percent now? 7.Suppose you have $1,000, which you can put in two different types of accounts...

You have invested money in a savings account that pays a fixed monthly interest on the...

You have invested money in a savings account that pays a fixed monthly interest on the account balance. The following table shows the account balance over the first 5 months. Time in months Savings balance 0 $1500.00 1 $1521.00 2 $1542.29 3 $1563.88 4 $1585.77 5 $1607.97 (a) How much money was originally invested? $ (b) Show that the data are exponential. (Round your answer to three decimal places.) Each successive ratio of new/old is , which shows that the data...

1. If your bank quoted a 6% interest rate on your account, which is compounded monthly,...

1. If your bank quoted a 6% interest rate on your account, which is compounded monthly, which of the following implications is correct? a. The semi-annual interest on your account is 3% b. The monthly interest on your account is 0.5% c. Your effective annual interest rate on this account is 6% d. Your effective annual interest rate on this account is below 6% 2. The interest amount of an interest-only loan is ______. a. repaid in full at the...

An amount of $10,000 is deposited into a savings account that pays interest at a rate...

An amount of $10,000 is deposited into a savings account that pays interest at a rate of 7%. If 10 equal annual withdrawals are made from the account starting one year after the money was deposited, how much can be withdrawn so that in the fifth year one would be able to withdraw an additional $1,000 and the account would be depleted after 10 years? Explain verbally in detail and sketch a timeline to illustrate.

A payment of $110 was made at the end of each month for 4 years into a savings account. The interest rate on the account is 5.4% compounded monthly. What’s the interested earned on the account?

Kori is making monthly contributions of of $260 to her savings account which pays interest at...

Kori is making monthly contributions of of $260 to her savings account which pays interest at the APR of 6.9%, compounded monthly. Right after Kori makes her 35th contribution, the bank changes the APR to 7.2% and Kori makes 57 more $260 contributions. What is Kori's balance right after her last contribution?

Question