1. You have just turned 22, and you intend to start saving for your retirement. You...

70.2K

Verified Solution

Question

Finance

1. You have just turned 22, and you intend to start saving foryour retirement. You plan to retire in 43 years when you turn 65.During your retirement, you would like to have an annual incomeof$120,000 per year for 26years (until age 91).
a)Calculate how much you need to have in your account before thefirst withdrawal at age 66.
b)Calculate how much you would have to save annually between nowand age 65 in order to finance your retirement income and to fillthat account.
Make the following assumptions:
Assume that the relevant compounded interest rate is 4 percentper year.
You make the first deposit today and the last deposition the dayyou turn 65 (44 deposits in total).
You make the first withdrawal when you turn 66and the lastwithdrawal when you turn 91(26 withdrawals).
(PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)

Answer & Explanation Solved by verified expert

3.5 Ratings (263 Votes)

A Amount required before the first withdrawalUsing financial calculatorInput N 26IY 4PMT See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

1. You have just turned 22, and you intend to start saving foryour retirement. You plan to retire in 43 years when you turn 65.During your retirement, you would like to have an annual incomeof$120,000 per year for 26years (until age 91).a)Calculate how much you need to have in your account before thefirst withdrawal at age 66.b)Calculate how much you would have to save annually between nowand age 65 in order to finance your retirement income and to fillthat account.Make the following assumptions:Assume that the relevant compounded interest rate is 4 percentper year.You make the first deposit today and the last deposition the dayyou turn 65 (44 deposits in total).You make the first withdrawal when you turn 66and the lastwithdrawal when you turn 91(26 withdrawals).(PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)