What is the value of retirement plan

Assignment Help Finance Basics
Reference no: EM132134794

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

Reference no: EM132134794

Questions Cloud

Calculate return of equity as a percentage : Calculate Return of Equity as a percentage Calculate the Debt Ratio as a percentage Calculate Operating Return on Assets as a percentage
Use shared memory for command execution : Show me a working implementation, in C source code, of a Linux shell that will use shared memory for command execution using pipes that read data.
What is the present value of investment : What is the present value of this investment if 11.1 percent per year is the appropriate discount rate?
How many files are related to hard disk devices : Delete all partitions on the disk, and recreate a primary partition and an extended partition with 2 logical partitions.
What is the value of retirement plan : 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
Calculate the npv of alternative : You have inherited an apple orchard and want to sell it in the next four years. An expert in apple orchard valuation has estimated the after-tax cash flow
Different steps in the project development : Complete the design for the critical, core, risky, difficult (CCRD) use case; create a comprehensive test plan and build a prototype for the CCRD use case
Create a word doc comparing your predicted average : Create a Word doc comparing your predicted average search lengths with your empirically derived values.
What is the ytm of the bond : The bond sells for $961.87 and matures in 21 years. The par value is $1,000. What is the YTM of the bond?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the present value of security

The security's annual return is 7%. What is the present value of this security? Round your answer to the nearest cent.

  Without assuming anything about the distribution

Without assuming anything about the distribution of the number of hours community college students study per week, at most what percentage of the students study less than 3.7 hours or more than 19.7 hours per week?

  You investes 8000 in two funds paying 2 and 5 annual

you investes 8000 in two funds paying 2 and 5 annual interest. at the end of the year the interest from the 5

  Reduction in profits margin

Grocery stores who are decreasing their prices and taking a reduction in their profits margin, for items that are already heavily decreased.

  Compute the economic order quantity compute the ordering

corsair inc. uses 40000 plastic housing units each year in its production of paper shredders. the cost of placing an

  What is the bank cost of preferred stock

Sixth Fourth Bank has an issue of preferred stock with a $7.00 stated dividend that just sold for $75 per share.

  If current interest rates are 10 what should be the price

a 1000 bond has a 7.5 coupon and matures after 10 years. if current interest rates are 10 what should be the price of

  What is an appropriate cost of capital for given division

Miller Sisters has an overall beta of 1.27 and a cost of equity of 13.4 percent for the firm overall. The firm is all-equity financed.

  Probability that an order change to one for application

What is the probability that an order change to one for application A can be ?lled from a batch ready to be shipped for application B?

  Determine the annual dividend for each year

If the firm's dividend policy was based on a fixed dollar payout policy of 50 cents per share plus an extra dividend equal to 75 percent of earnings per share.

  What is the role of information overload and automation

What is the role of Information Overload and automation in marketing strategy? Why? What role do work and leisure play in creating and executing marketing

  A firm has sales of 500 total assets of 300 and a

a firm has sales of 500 total assets of 300 and a debtequity ratio of 2.00. if its return on equity is 15 percent what

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd