Question

Henry Hitchcock is 37 years old today and he wishes to accumulate $543,000 by his 58th...

Henry Hitchcock is 37 years old today and he wishes to accumulate $543,000 by his 58th birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal deposits on his 37th through his 57th birthdays. What annual deposit must Henry make if the fund will earn 8% interest compounded annually?  

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Rate Interest rate compounded annually 8%
Nper Number of deposits 21 (58-37)
Fv Future value required at 58th birthday $543,000
Type Deposits at beginning of years 1
PMT Annual deposit required from 37 to 57 birthday $9,971.21 (Using PMT function of excel with Rate=8%,Nper=37,Fv=-543000)
t N=21-t D FV=D*(1.08^N)
Birthday Year Number of Years to future Deposit Future Value of Deposits
37 0 21 $9,971.21 $50,193.44
38 1 20 $9,971.21 $46,475.40
39 2 19 $9,971.21 $43,032.78
40 3 18 $9,971.21 $39,845.17
41 4 17 $9,971.21 $36,893.67
42 5 16 $9,971.21 $34,160.81
43 6 15 $9,971.21 $31,630.38
44 7 14 $9,971.21 $29,287.39
45 8 13 $9,971.21 $27,117.95
46 9 12 $9,971.21 $25,109.21
47 10 11 $9,971.21 $23,249.27
48 11 10 $9,971.21 $21,527.10
49 12 9 $9,971.21 $19,932.50
50 13 8 $9,971.21 $18,456.02
51 14 7 $9,971.21 $17,088.91
52 15 6 $9,971.21 $15,823.06
53 16 5 $9,971.21 $14,650.99
54 17 4 $9,971.21 $13,565.73
55 18 3 $9,971.21 $12,560.86
56 19 2 $9,971.21 $11,630.42
57 20 1 $9,971.21 $10,768.91
SUM $543,000.00

Rate Nper FV Interest rate compounded annually 8% Number of deposits 21 (58-37) Future value required at 58th birthday $543,0
Add a comment
Know the answer?
Add Answer to:
Henry Hitchcock is 37 years old today and he wishes to accumulate $543,000 by his 58th...
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
  • Leon Hitchcock is 36 years old today and he wishes to accumulate $538,000 by his 59th...

    Leon Hitchcock is 36 years old today and he wishes to accumulate $538,000 by his 59th birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal deposits on his 36th through his 58th birthdays. What annual deposit must Leon make if the fund will earn 8% interest compounded annually?

  • Your answer is incorrect. Try again. Robert Hitchcock is 40 years old today and he wishes...

    Your answer is incorrect. Try again. Robert Hitchcock is 40 years old today and he wishes to accumulate $500,000 by his 65th birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal deposits on his 40th through his 64th birthdays, what annual deposit must Robert make if the fund will earn 8% interest compounded annually? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0...

  • Problem 6-2 Using the appropriate interest table, provide the solution to each of the following four...

    Problem 6-2 Using the appropriate interest table, provide the solution to each of the following four questions by computing the unknowns. Click here to view factor tables x Your answer is incorrect. Try again. What is the amount of the payments that John Winslow must make at the end of each of 8 years to accumulate a fund of $96,300 by the end of the 8th year, if the fund earns 8% interest, compounded annually? (Round factor values to 5...

  • A: What is the amount of the payments that Henry Winslow must make at the end...

    A: What is the amount of the payments that Henry Winslow must make at the end of each of 8 years to accumulate a fund of $86,200 by the end of the 8th year, if the fund earns 8% interest, compounded annually? B: Morgan Hitchcock is 39 years old today and he wishes to accumulate $513,000 by his 63rd birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal...

  • A: What is the amount of the payments that Henry Winslow must make at the end...

    A: What is the amount of the payments that Henry Winslow must make at the end of each of 8 years to accumulate a fund of $86,200 by the end of the 8th year, if the fund earns 8% interest, compounded annually? B: Morgan Hitchcock is 39 years old today and he wishes to accumulate $513,000 by his 63rd birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal...

  • Andrea is 40 years old today and she wishes to accumulate $2,000,000 by her sixty fifth...

    Andrea is 40 years old today and she wishes to accumulate $2,000,000 by her sixty fifth birthday so she can retire to a beach in Florida. She wishes to accumulate this amount by making equal deposits on her fortieth through her sixty fourth birthdays. Compute the annual deposit Andrea must make if the fund will earn 6% interest compounded annually.

  • Maria is 40 years old today and she wishes to accumulate $1,840,000 by her sixty-fifth birthday...

    Maria is 40 years old today and she wishes to accumulate $1,840,000 by her sixty-fifth birthday so she can retire to a beach in Florida. She wishes to accumulate this amount by making equal deposits on her fortieth through her sixty-fourth birthdays. Compute the annual deposit Maria must make if the fund will earn 4% interest compounded annually. Annual deposit $_______________

  • Andrea is 40 years old today and she wishes to accumulate $2,000,000 by her 65th birthday...

    Andrea is 40 years old today and she wishes to accumulate $2,000,000 by her 65th birthday so she can retire to a beach in Florida. She wishes to accumulate this amount by making equal deposits on her fortieth through her sixty fourth birthdays. Compute the annual deposit Andrea must make if the fund will earn 6% interest compounded annually. (Round factor values to 5 decimal places and final answer to 0 decimal places). Annual deposit: $

  • What is the future value of $8,650 at the end of 7 periods at 8% compounded...

    What is the future value of $8,650 at the end of 7 periods at 8% compounded interest? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) The future value $ Click here to view factor tables What is the present value of $8,650 due 8 periods hence, discounted at 6%? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) The present value...

  • Hermes Conrad is celebrating his birthday and wants to start saving for his anticipated retirement. He...

    Hermes Conrad is celebrating his birthday and wants to start saving for his anticipated retirement. He has the following years to retirement and retirement spending goals: Years until retirement = 30; Amount to withdraw each year = $90,000; Years to withdraw in retirement = 20; Investment rate = 8%. Because Hermes is planning ahead, the first withdrawal will not take place until one year after he retires. He wants to make equal annual deposits into his account for his retirement...

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