Question

In: Accounting

Compare the accumulated value of an IRA account into which $500 is invested at the end...

Compare the accumulated value of an IRA account into which $500 is invested at the end of each month; the account earns 2.5% annual interest. Make sure you compare how much was invested and how much interest was earned.

a.       You start at age 25 and retire at 60.

b.       You start at age 30 and retire at 60.

c.        You start at age 35 and retire at 60.

d.       You start at age 40 and retire at 60.

The questions should be answered with a table created in excel. Make sure the column headings are clearly labeled and use appropriate units.

Solutions

Expert Solution

We can calculate the future value of annuity i.e. value of investment using following formula,
FV of annuity = P * {[(1+r)^n - 1]/r}
FV of annuity = Future value of annuity
P = Monthly payment
r = rate of interest per month
n = number of months
Answer a
FV of annuity = Future value of annuity =?
P = Monthly payment = $500
r = rate of interest per month = 2.5%/12 = 0.002083
n = number of months = 35 years * 12 = 420
FV of annuity = 500 * {[(1+0.002983)^420 - 1]/0.002083}
FV of annuity = 500 * 670.4126
FV of annuity = 335206.28
Value of investment at the end of 60th year = $3,35,206.28
Answer b
FV of annuity = Future value of annuity =?
P = Monthly payment = $500
r = rate of interest per month = 2.5%/12 = 0.002083
n = number of months = 30 years * 12 = 360
FV of annuity = 500 * {[(1+0.002983)^360 - 1]/0.002083}
FV of annuity = 500 * 535.3675
FV of annuity = 267683.77
Value of investment at the end of 60th year = $2,67,683.77
Answer c
FV of annuity = Future value of annuity =?
P = Monthly payment = $500
r = rate of interest per month = 2.5%/12 = 0.002083
n = number of months = 25 years * 12 = 300
FV of annuity = 500 * {[(1+0.002983)^300 - 1]/0.002083}
FV of annuity = 500 * 416.1752
FV of annuity = 208087.62
Value of investment at the end of 60th year = $2,08,087.62
Answer d
FV of annuity = Future value of annuity =?
P = Monthly payment = $500
r = rate of interest per month = 2.5%/12 = 0.002083
n = number of months = 20 years * 12 = 240
FV of annuity = 500 * {[(1+0.002983)^240 - 1]/0.002083}
FV of annuity = 500 * 310.9747
FV of annuity = 155487.35
Value of investment at the end of 60th year = $1,55,487.35
Option Invested amount Value of investment at the end of 60 th year Interest Earned
A B C C-B
a $210,000.00 $335,206.28 $125,206.28
b $180,000.00 $267,683.77 $87,683.77
c $150,000.00 $208,087.62 $58,087.62
d $120,000.00 $155,487.35 $35,487.35

Related Solutions

Compare the accumulated values at the end of 10 years if P100 is invested at the...
Compare the accumulated values at the end of 10 years if P100 is invested at the rate of 12% per year compounded annually, semi-annually, quarterly, monthly, daily, and continuously.
If you deposit $2,000 at the end of each year into an IRA account that is...
If you deposit $2,000 at the end of each year into an IRA account that is expected to earn 8% per year simple interest, how much will be in the account in 30 years? (Answer to the nearest dollar)
What is the accumulated (future) sum of monthly contributions of $500 invested at an average return...
What is the accumulated (future) sum of monthly contributions of $500 invested at an average return of 5% p.a. over 30 years? What if the average return increases to 8% from the 16th year?
Payments of $1000 are invested into an account at the end of each year for 8...
Payments of $1000 are invested into an account at the end of each year for 8 years, earning 8% effective per annum. Interests can only be reinvested at 6% for the first 6 years and 7% thereafter. Find the accumulated value of the investment after 10 years. (Answer: $12092.96)
Find the accumulated value of $18,000 invested for 8 years: (A) at a nominal annual rate...
Find the accumulated value of $18,000 invested for 8 years: (A) at a nominal annual rate of interest of 4.5% convertible quarterly. (B) at 4% per year compounded weekly. (C) at a discount rate of 2.8% per year compounded monthly.
Find the accumulated value of $4,715 invested for 13 years if the annual effective rate of...
Find the accumulated value of $4,715 invested for 13 years if the annual effective rate of discount is 5% for the first 7 years and a nominal rate of discount of 3.8% per year compounded bi-monthly (i.e., every two months) is used thereafter
a. What is the future value in five years of $1,000 invested in an account with...
a. What is the future value in five years of $1,000 invested in an account with an APR of 10 percent, compounded annually? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the future value in five years of $1,000 invested in an account with an APR of 10 percent, compounded semiannually? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the...
What is the future value in seven years of $1,100 invested in an account with an...
What is the future value in seven years of $1,100 invested in an account with an APR of 8 percent, compounded annually? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)         Future value $    b. What is the future value in seven years of $1,100 invested in an account with an APR of 8 percent, compounded semiannually? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)   Future...
Suppose you deposit $500 in an account at the end of this year, $400 at the...
Suppose you deposit $500 in an account at the end of this year, $400 at the end of next yer, and $300 at the end of the following year. The interest rate is 7.5%. How much will be in the account immediately after the third deposit is made? How much will be in the account at the end of three years if the deposits are made at the beginning of each year? Please show work and proper equation to use.
find the accumulated value of $100 at the end of two years if thenominal annual...
find the accumulated value of $100 at the end of two years if the nominal annual rate of discount is 7% once every four years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT