Question

You agree to deposit $500 at the beginning of each month into a bank account for the next 24 months. At the end of the 24th month, you will have $13,000 in your account. If the bank compounds interest monthly, what annual interest rate will you have earned?

Note: Only use the formula listed and show the steps of how you reached the answer, I don't need to know just the answer, I'm trying to learn. Thank you. Don't use excel.

01POPO TABLE 5-7 Summary of Time Value of Money Equations Calculation Equation Future value of a single payment FV, = PV(1 +

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

Given

Monthly deposit D=500

Number of payment N=24

Amoutn recived after 24th month A=13000

Since amount is deposited at beginning of month so it is annuity due problem

Let r be the monthly interest rate

A=D*(1+r)*((1+r)^N-1)/r

13000=500*(1+r)*((1+r)^24-1)/r

Solving for r we get r =0.69%

So annual interest rate =12*r=12*0.69%=8.26%

Add a comment
Know the answer?
Add Answer to:
You agree to deposit $500 at the beginning of each month into a bank account for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You agree to deposit $500 at the beginning of each month into a bank account for...

    You agree to deposit $500 at the beginning of each month into a bank account for the next 24 months. At the end of the 24th month, you will have $13,000 in your account. If the bank compounds interest monthly, what annual interest rate will you have earned? Note: Please post the formula used to solve the question and list the steps taken to reach the answer, please don't use excel. I provided a list of formulas, please state the...

  • Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...

    Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...

  • You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...

    You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000 per year for 30 years? To help you in your decision, estimate the present value of the second option assuming constant annual interest rates of 6%, 8%, and 10%. Expound on your decision within a text box. (You may use the built-in PV function within Excel) Loans: where: and, interest due at the end of each month A = payment P = principal (amount...

  • I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...

    I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...

  • Q1 - Describe N,I/Y,PV,PMT, and FV. Q2 – Why is there one negative sign among the...

    Q1 - Describe N,I/Y,PV,PMT, and FV. Q2 – Why is there one negative sign among the last three listed in Q1? Q3 – What is the difference between compounding and discounting? Q4 – What is an annuity? What are the different types of annuities? When are payments made? Q5 – What is a perpetuity? What is the relationship between PV and Interest? Q6 – Does FV get larger or smaller based off monthly compounding compared to quarterly compounding? Q7 –...

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • You are the beneficiary of a trust that pays you $25,000 per year for the next...

    You are the beneficiary of a trust that pays you $25,000 per year for the next 15 years and assumes a 7.5% required rate of return. Use this information to answer the following questions using Excel formulas in the space provided. pmt $25,000 Present Value for Ordinary Annuity per 15 Present Value for Annuity Due rate 7.50% Future Value for Ordinary Annuity fv $652,959 Future Value for Annuity Due If the interest rate is quoted and compounds monthly, what are...

  • Orla 7.2 S-P+I armla 7.34S-P(I +) restated as FV-PV( 1 + ir Fermula S2 Farmals 10.1--1 Formula 11...

    orla 7.2 S-P+I armla 7.34S-P(I +) restated as FV-PV( 1 + ir Fermula S2 Farmals 10.1--1 Formula 11. FV er year 1+i-1 Formula 12.1P-1 Finding the fatare vaie et an ordisary general annuity using the eflective rate of inter est per paryment peried where p ( +i-1 PVr = PMT[I-(1+p)""I Finding the present value of an ordinary general annuity uning the eflective rate ot interest per paymeet period Farmata 12.3 Formula 124 SIZE OF THE NTH PAYMENT Finding the sire...

  • You have applied for a job with a local bank. As part of its evaluation process,...

    You have applied for a job with a local bank. As part of its evaluation process, you must take an examination of the time value of money following questions. Please show your work. (Identify N. IV, PV, PMT, and PV) icon the 1. What's the future value of $100 after 3 years if it earns M. annual compounding? 2. What's the present value of $100 to be received in 3 years of the interest rate is 8. annual compounding 3....

  • part 1 given info present value = periodic interest rate = number of compounding periods =...

    part 1 given info present value = periodic interest rate = number of compounding periods = 190.00 0.080 6.00 What is the future value (single payment)? part 2 future value periodic interest rate = number of compounding periods = 301.51 0.080 6.00 what is the present value (single payment)? part 3 periodic payment periodic interest rate = number of compounding periods = 340.00 0.02 8.00 What is the future value of this annuity? part 4 present value (amount borrowed) =...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT