(Answered) Assume that you contribute 300 per month to a retirement

Finance

Assume that you contribute $300 per month to a retirement plan for 25 years. Then you are able to increase the contribution to $500 per month for 20 years. Given a 9 percent interest rate, what is the value of your retirement plan after 45 years?

How can I reach the answer using excel? Below is what I'm tracking but I think I'm off because I was not able to show the value increase of the intial $300 for 25 years. How do I add in the interest increase of the 300 per month for 25 years during the additional 20 years I've contributed 500?

PMT=300, i=9/12=.75, NPER=300 $619,106.43

PMT=500, i=9/12=.75, NPER=240 $333,943.43

$953,049.86

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M93122259
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Moody farms just paid a dividend of 265 on its stock the

Moody Farms just paid a dividend of $2.65 on its stock. The growth rate in dividends is expected to be a constant 3.8 percent per year indefinitely. Investors require a return of 15 percent for the first three years, a r ...

If you deposit 970 every year for the next 6 years with

If you deposit $970 every year for the next 6 years, with first deposit to be made today and all deposits to be made at the beginning of every year, in an account that pays 8.01% APR with annual compounding, how much is ...

A new piece of equipment is purchased for 15000 the

A new piece of equipment is purchased for $15,000. The expected lifetime of the asset is five years. Which depreciation method depreciates exactly 3,000 each year? It would be Straight-line, Modified Accelerated Cost Rec ...

What are the ways that it can help comply with legal

What are the ways that IT can help comply with legal requirements and social responsibilities surrounding the sales of alcohol?

Question - what is weighted average cost of capital how is

Question - What is weighted average cost of capital, how is it used, and when is it not appropriate to use? A substantial initial response consisting of a minimum of 100 words, using proper grammar, spelling, and punctua ...

We are evaluating a project that costsnbsp691200 has an

We are evaluating a project that costs $691,200, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 85,000 units per y ...

1 your firm expects to incur a 500k loss in year 1 and make

1. Your firm expects to incur a ($500K) loss in year 1 and make $100K of net income in year 2 and $300K of net income in year 3. The retention ratio is projected to be 100%. The beginning equity balance on the balance sh ...

Your firm spends 5200 every month on printing and mailing

Your firm spends $ 5,200 every month on printing and mailing? costs, sending statements to customers. If the interest rate is 0.52% per? month, what is the present value of eliminating this cost by sending the statements ...

Question - discuss common stock valuation and the required

Question - Discuss common stock valuation and the required assumption(s) for zero growth. Relate this discussion to a real-world problem.

What is the fundamental difference between the factors that

What is the fundamental difference between the factors that make up the Task Environment (sometimes called the Micro-Marketing Environment) and the Broad Environment (sometimes called the Macro-Marketing Environment). Hi ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert