Question

In: Finance

At the end of each year for the first 5 years, Cecil and Norma DeMille plan...

At the end of each year for the first 5 years, Cecil and Norma DeMille plan to contribute $1,000 to their daughter Sally's college fund. For the next 5 years they will contribute $2,000 at the end of each year, and then increase that amount to $3,000 until she turns 18 and is ready for college. What amount will they have accumulated for Sally's college fund if the account pays 6.35% annually?

Please be very thorough with work and provide the specific formula used.

Solutions

Expert Solution

Accumulated value Accumulated value left in account(no further contribution) for remaining years to maturity (till18 years) Future value at end of year 18
For first 5 years

FVA6.35%,5 *Amount

5.67662*1000

5676.62

18-5=13 years

FVF6.35%,13*Accumulated value

2.22632*5676.62

12637.97

For next 5 years

FVA 6.35%,5*Amount

5.67662*2000

11353.24

18-5-5=8 years

FVF6.35%,8*Accumulated value

1.63644*11353.24

18578.90

For next 8 years   [18-5-5]

FVA6.35%,8*Amount

10.02267*3000

30068.01

0 30068.01
Total value 61284.88

Total value accumulated : 61284.88

**Find future value factor using the formula : 1/(1+i)^n or using the financial calculator

**find future value annuity factor using the formula :[(1+i)^1+(1+i)^2+(1+i)^3+...(1+i)^n-1] or using financial calculator or from future value annuity table]

For first 5years annuity factor = [1+(1+i)^1+(1+i)^2+....(1+i)^4]

for 8 years annuity factor = [1+(1+i)^1+(1+i)^2+....+(1+i)^7]


Related Solutions

If​ $1000 is deposited at the end of each year for 5 years into an ordinary...
If​ $1000 is deposited at the end of each year for 5 years into an ordinary annuity earning 7.59​% compounded​ annually, construct a balance sheet showing the interest earned during each year and the balance at the end of each year. Complete the balance sheet. Period Amount Interest Balance 1 ​$1000.00 ​ ​ 2 ​$1000.00 ​ ​ 3 ​$1000.00 ​ ​ 4 ​$1000.00 ​ ​ 5 ​$1000.00 ​ ​ ​(Round to the nearest cent as​ needed.)
if you deposit 1200 at the end of each year of the first 8 years and...
if you deposit 1200 at the end of each year of the first 8 years and 1800 at the end of each year for the second 8 years. find the fund value at the end of 16 year, if the fund earn. it's 8%
At the end of each year for 5 years, $500 is deposited into a credit union...
At the end of each year for 5 years, $500 is deposited into a credit union account. The credit union pays 5% interest compounded annually. At the end of 5 years, how much will be in the account?
An investment will pay $150 at the end of each of the next 3 years, $200 at the end of year 4, $350 at the end of year 5, and $550 at the end of year 6.
An investment will pay $150 at the end of each of the next 3 years, $200 at the end of year 4, $350 at the end of year 5, and $550 at the end of year 6. If other investments of equal risk earn 9% annually, what is the present value? Its future value? Do not round intermediate calculations. round your answers to the nearest cent.
It is the end of 2020. You plan to complete a Ph.D. in 5 years. Your...
It is the end of 2020. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2021 2022 2023 2024 2025 Cash flow 1,200 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 8%. Questions: 1. Create an Excel spreadsheet showing the years...
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years....
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2020 2021 2022 2023 2024 Cash flow 1,000 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 6%. Attempt 1/5 for 10 pts. Part 1 Create...
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years....
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2020 2021 2022 2023 2024 Cash flow 1,000 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 6%. Attempt 1/5 for 10 pts. Part 1 Create...
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years....
Intro It is the end of 2019. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2020 2021 2022 2023 2024 Cash flow 1,000 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 10%. Attempt 1/5 for 10 pts. Part 1 Create...
At the end of each of the next 8 years, you plan to put $25,000 in...
At the end of each of the next 8 years, you plan to put $25,000 in the bank. If the annual interest rate is 3%, what is the present value of this planned savings stream? What will the bank balance be at the end of the 8 year period? [Hint: once you know the present value of the savings stream, it's easy to work out the future value]
You plan on saving $12,300 at the end of each of the next 20 years and...
You plan on saving $12,300 at the end of each of the next 20 years and investing your savings at an annual interest rate of 8%. At the end of year 20 you plan on retiring. You plan on leaving your savings in investments yielding an annual rate of 8% and withdrawing from savings a constant amount for the next 30 years commencing at the end of your first year of retirement. How large a withdrawal can you afford to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT