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?
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 | |||||||||
|
Henry Hitchcock is 37 years old today and he wishes to accumulate $543,000 by his 58th...
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 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 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 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 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 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 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 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 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 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...