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: 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 one you used.Thank you.

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

since deposits are made at the beginning of every moth we use the formula

future value of annuity due = futurevalue of annuity x (1 + r)

future value of annuity = PMT[ (1 + r)^n - 1 / r ]

where PMT = monthly payments

r = rate of interest (per period)

n = number of periods

future value = 13000

so , 13,000 = 500[(1 + r)^24 - 1 / r ] x (1 + r)

[(1 + r)^24 - 1 / r ] x (1 + r) = 13000 / 500

  [(1 + r)^24 - 1 / r ] x (1 + r) = 26

  using future value of annuity due table( or using scientific calculator) we can see that value 26 occurs at r =0.635%

nominal  Yeraly rate = 0.635 x 12 = 7.62%

(in calculator inputs will be ( n = 24 , PV=0 ,PMT=500,FV=13000 , i/n = ? )

  

  

  

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: 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...

  • 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...

  • 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,...

  • 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 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....

  • Aisha is a pension fund manager. According to her estimates, retirees will be paid benefits worth...

    Aisha is a pension fund manager. According to her estimates, retirees will be paid benefits worth $800,000 annually 12 years from now. Given a discount rate of 6 percent, what is the present value of the payments today if these annuity payments start at the beginning of the year rather than at the end of each of the next twelve years? An example in the book: PEARSON 4.4 Annuity Due and Perpetuity (continued) Example 4: Annuity Due versus Ordinary Annuity...

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