Retirement by investing with each monthly paycheck

Assignment Help Financial Management

Reference no: EM131990576

Retirement Problem: Excel Functions For this retirement problem you should use the Excel Template I have provided. We will then use this same template to do further calculations as we discuss the functionality of Excel. Make sure to do all your calculations in the cells (rather than typing in answers). PLEASE SOLVE BY HAND AND SHOW FUNCTIONS/EQUATIONS USING A CALCULATOR

You just got your first job and plan to start saving for retirement by investing with each monthly paycheck.

You plan to retire in 45 years.

In 50 years, you want to give your daughter a gift of $1,000,000.

You will receive an inheritance from a rich great-uncle of $250,000 in 20 years.

You think you will want $150,000 every year when you retire, starting the day you retire. You plan to need 30 payments, so the last one will be paid at the end of the 29th year (beginning of the 30th year). You do not want to leave any money in your account at the end.

You expect to earn 8% APR during your investing years and 5% APR during your retirement years.

How much do you need to save each month to meet your retirement goal?

Reference no: EM131990576

Questions Cloud

How has the effect of Brexit effected the US economy : Question: How has the effect of Brexit effected the US economy as well as the UK

Cause the investors required rate of return : Two factors that cause the investors required rate of return to differ from the company’s cost of capital are

Develop one question for the interview introductory stage : Develop one question for the interview introductory stage. Explain why you chose this question. Develop eight competency-based questions for the core stage.

Determine from the officer the departments official policy : Does the officer feel that he or she should be allowed to accept small gratuities such as free or discounted meals or coffee?

Retirement by investing with each monthly paycheck : You just got your first job and plan to start saving for retirement by investing with each monthly paycheck.

Discuss plans for a new program : Write a report on a special probation/parole client and programs that have been established to address this problem client.

What is competency-based interviewing : What is competency-based interviewing? How is it different from typical interviewing? Provide two examples of competency-based questions that might be used.

How are information systems transforming business : How are information systems transforming business, and why are they so essential for running and managing a business today?

How does this affect the hr managers hiring decisions : Valid applications arrive every week or so, and the applicants all seem to bring different levels of expertise.

User Account

All Pages