Question

# You plan on buying yourself a retirement cabin in the Rocky Mountains 40 years from now....

You plan on buying yourself a retirement cabin in the Rocky Mountains 40 years from now. At an interest rate of 5 percent per year, how much must you invest each year (equal annual amounts beginning next year) to have \$150,000 in your cabin fund in 40 years?

please solve using excel

#### Homework Answers

Answer #1

Future Value to accumulate in 40 years = \$150,000

Calculating the Equal Annual Payments at the end of each year using Excel "PMT" function:-

So, equal annual payments is \$1241.72

If you need any clarification, you can ask in comments.

If you like my answer, then please up-vote as it will be motivating

Know the answer?
Your Answer:

#### Post as a guest

Your Name:

What's your source?

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Not the answer you're looking for?
Ask your own homework help question
ADVERTISEMENT
##### Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

ADVERTISEMENT