Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you make it in Excel spreadsheet please A couple will retire in 50 years; they plan to spend about $38,000 a year (in current
Could you make it in Excel spreadsheet please A couple will retire in 50 years; they plan to spend about $38,000 a year (in current dollars) in retirement, which should last about 25 years. They believe that they can earn a real interest rate of 9% on retirement savings. a. If they make annual payments into a savings plan, how much will they need to save each year? Assume the first payment comes in 1 year. Note: Do not round intermediate calculations. Round your answer to 2 decimal places. b. How would the answer to part (a) change if the couple also realize that in 20 years they will need to spend $68,000 on their child's college education? Note: Do not round intermediate calculations. Round your answer to 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started