Expected annual return on your savings before you retire

Assignment Help Financial Management

Reference no: EM131908164

You save $600 every quarter (4 months) and plan to retire in 30 years. You are planning to spend 20 years in retirement.

You currently have an expected return on your savings before retirement of 10% (EAR) and and an expected return on savings during retirement of 15% (APR)

You also hope to be able to spend $5,000 each quarter (4 months) during retirement.

Questions (Using Excel).

1. What is the expected annual return on your savings before you retire (Converted to APR)

2. What is the amount you will have saved in your account at retirement based on the $600 you save ever quarter? (Using Excel FV)

3. What is the amount that you will be able to spend each period once you are retired?

4. How much more (or less) would you need to earn if you chose to retire FIVE years earlier than anticipated? (In APR)

5. Convert that APR to an EAR

6. Since you want to have $5,000 available to spend every quarter once you are retired, how much money will you need to have in your account? (USING PV FUNCTION in Excel)

7. What is the amount you need to save each period before you retire to meet that $5,000 a quarter goal? (USING PMT FUNCTION in Excel)

Reference no: EM131908164

Questions Cloud

What is the project net present value : If the discount rate of 14.6 percent, what is the project's net present value?

What is the value of this firm if you ignore taxes : What is the value of this firm if you ignore taxes?

Explain the rationale for your decision : You are the manager of a factory of the Make-It Company. You have 5,000 parts that must be shipped by Friday at 5:00 p.m.

What will the total finance charge be : How much will your monthly payment be? What will the total finance charge be?

Expected annual return on your savings before you retire : What is the expected annual return on your savings before you retire (Converted to APR)

What is basic earning power ratio : Its total assets at the end of the year was $15,000,000. What is its Basic Earning Power ratio?"

What does business intelligence really mean to a business : In your opinion, what does business intelligence really mean to a business? How do you believe does a database and data warehouse support business intelligence?

Describe the role of the the anterior pituitary hormones : BIO/405 Version 3 - Label the parts of the organ or structure, and describe the structure and its function - Reproductive System Worksheet

Proposal to replace the machine : 1. Should they accept or reject the proposal to replace the machine?

User Account

All Pages