Question

You plan to retire at age 40 after a highly successful but short career. You would like to accumulate enough money by age 40 to withdraw $241,000 per year for 40 years. You plan to pay into your account 15 equal installments beginning when you are 25 and ending when you are 39. Your account bears interest of 14 percent per year. Use Appendix A for your reference. (Use appropriate factor(s) from the tables provided.) Required: 1. How much do you need to accumulate in your account by the time you retire? (Round your final answer to the nearest dollar amount.) 2. How much do you need to pay into your account in each of the 15 equal installments? (Round your final answer to 2 decimal places.) 1. Amount to be accumulated in your account 2. Annual installment

Answer 1

Please find below table useful to compute desired results: -

А 1 No. of Years 40 2 Accumulated money 241000 3 Installments 15 4 Interest Rate =14/100 5 Amount to be accumulated in your account =PV(B4,B1,-B2) 6 Annual installment =PMT(B4,B3,0,B5)

End results would be as follows: -

А 1 No. of Years 40 2 Accumulated money 241,000 3 Installments 4 Interest Rate 14% 5 Amount to be accumulated in your account | 1,712,314.87 6 Annual installment (39,056.13)