you plan to save $500 monthly for 2 years earning 5%interest. how much will you end...

you plan to save $500 monthly for 2 years earning 5%interest. how much will you end up with?

Solutions

Expert Solution

Monthly Saving = $500

Let us assume that saving is made at the start of each month

Annual Interest Rate = 5%

Monthly Interest Rate = Annual Interest Rate/12 = 5%/12 = 0.4167%

Investment Period = 2 years = 24 months

The future value of savings after 2 years can be calculated using the FV formula in spreadsheet

FV(rate, number of periods, payment amount, present value, when-due)

Where, rate = monthly interest rate = 0.4167%

number of periods = 24

payment amount = Monthly saving = $500

present value = present value of investments = 0

when-due = when is the saving made each month = beginning = 1

The future value of savings after 2 years = FV(0.4167%, 24, 500, 0, 1) = $12,645.48

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

1. You deposit $4000 in an account earning 5% interest compounded monthly. How much will you...

1. You deposit $4000 in an account earning 5% interest compounded monthly. How much will you have in the account in 5 years? 2. Find the time required for an investment of 5000 dollars to grow to 6500 dollars at an interest rate of 7.5 percent per year, compounded quarterly. Round your answer to two decimal places Your answer is t=____ years. 3. You deposit $2000 in an account earning 5% interest compounded monthly. How much will you have in...

you deposit 400$ each month into an account earning 2% interest compounded monthly. a) how much...

you deposit 400$ each month into an account earning 2% interest compounded monthly. a) how much will you have in the account in 35 years? b) how much money will you put into the account? c) how much total interest will you earn?

How much will $500 be worth thirty years from now earning a 1% interest with quarterly...

How much will $500 be worth thirty years from now earning a 1% interest with quarterly compounding? (Points : 7) $671.00 $667.73 $17,392.45 $674.68 $1,650.19 $505.00 $69,870.71 $115,019.34 none of the above Question 7.7. Your first home costs one hundred and seventy thousand dollars. You put down 10% and finance the rest with a loan from the local branch of the Farm Service Agency. Suppose the FSA charges you two points. What do the points cost you in dollars? (Points...

Consider a deposit of $10,000 made for 5 years earning 5.00% interest. How much interest was...

Consider a deposit of $10,000 made for 5 years earning 5.00% interest. How much interest was earned due to compounding? In other words, what was the difference between compounded interest and simple interest. Answer to nearest dollar.

1. You deposit $2000 in an account earning 8% interest compounded monthly. How much will you...

1. You deposit $2000 in an account earning 8% interest compounded monthly. How much will you have in the account in 15 years? 2. Find the time required for an investment of 5000 dollars to grow to 9000 dollars at an interest rate of 7.5 percent per year, compounded quarterly. Round your answer to two decimal places ___t years. 3. You deposit $3000 in an account earning 5% interest compounded monthly. How much will you have in the account in...

If you invest $1,000 today into a deposit account earning 5.75% interest compounded monthly, how much...

If you invest $1,000 today into a deposit account earning 5.75% interest compounded monthly, how much would your investment be worth in 10 years?

If you invest $5,000 today into a deposit account earning 6.25% interest compounded monthly, how much...

If you invest $5,000 today into a deposit account earning 6.25% interest compounded monthly, how much would your investment be worth in 5 years?

You are trying to decide how much to save for retirement. Assume you plan to save...

You are trying to decide how much to save for retirement. Assume you plan to save $8,000 per year with the first investment made one year from now. You think you can earn 5.5% per year on your investments and you plan to retire in 32 years, immediately after making your last $8,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $8,000 per year, you wanted to...

You are trying to decide how much to save for retirement. Assume you plan to save...

You are trying to decide how much to save for retirement. Assume you plan to save $ 6,500 per year with the first investment made one year from now. You think you can earn 5.0% per year on your investments and you plan to retire in 36 years, immediately after making your last $ 6,500 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $ 6,500 per year,...

You are trying to decide how much to save for retirement. Assume you plan to save...

You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 10.0% per year on your investments and you plan to retire in 43 years, immediately after making your last $5,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $5,000 per year, you wanted to...

Subjects