For the time value of money i want you to explore the rate, Ask an Expert

Finance

For the Time value of money, I want you to explore the "=RATE(...)" function in Excel. It calculates the required interest rate your investment has to generate to match your annual contributions to the desired future value. For this exercise you will need to come up with three values (required inputs for RATE function): 1) Number of years until retirement (NPER); 2) How much you are willing to contribute every year (PMT), and the desired amount of money you wish to have at retirement ($1 to $3 million is common). Set your PV (present value) to zero. Is this a realistic rate of return? Which investment product would offer this rate of return?

Number of years until retirement=29

Yearly contribution $5,000

$2 Million at the time of retirement.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92866991

Have any Question?Write your Review or question?

Related Questions in Financial Management

Question 1 discuss how your organizations overall business

Question : 1) Discuss how your organization's overall business strategy and human resources planning affect one another. 2) Discuss an example of a company engaging in poor ethics and/or social responsibility. What were ...

Read through the below post and provide any on of the

Read through the below post and provide any on of the following: APA format 250 Words. . Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having ...

Portfolio projectexotic food inc capital budgeting casecase

Portfolio Project: Exotic Food Inc., Capital Budgeting Case CASE SUMMARY Exotic Food Inc., a food processing company located in Herndon, VA, is considering adding a new division to produce fresh ginger juice. Following t ...

Exerciseas the executive of a bank or thrift institution

Exercise As the executive of a bank or thrift institution you are faced with an intense seasonal demand for loans. Assuming that your loanable funds are inadequate to take care of the demand, how might your Reserve Bank ...

Compare and contrast the various forms of business

Compare and contrast the various forms of business organizations. Decide which structure is best suited for your class project (Massage Day Spa (Partnership)) and indicate why. From the e-Activity, infer what the trends ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

Assignmentaccording to recent reports produced by the

Assignment According to recent reports produced by the Council of Saudi Chambers, healthcare turnover is on the rise within the Kingdom of Saudi Arabia. Nurses and physicians are leaving the Kingdom to Western countries ...

Question - your chief financial officer cfo was unable to

Question - Your chief financial officer (CFO) was unable to attend the recent monthly chamber of commerce meeting. You learned from some other local CFOs that changing exchange rates had dramatically affected their firms ...

Questions 1 discuss a time that you worked with a group in

Questions : 1. Discuss a time that you worked with a group in your current or a past job to solve a problem. Reflecting back, was your group successful? If not, what could have been done differently? Refer to this week's ...

This week will develop the theory and application of

This week will develop the theory and application of capital budget analysis. The theory was robust, the calculations mathematically and logically defined, and many of the real-world problems, likely to be encountered, w ...

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 Financial Management Expert