Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions