Question: how do i do this in excel? Assume that you can invest $10,000 today at a 7% annual rate of return. What will the deposit

how do i do this in excel?

Assume that you can invest $10,000 today at a 7% annual rate of return. What
will the deposit be worth in 15 years?
Deposit $10,000
Annual rate of return 7%
Years 15
Future value <== Use FV to calculate the future value
What if you add $2,000 a year to the investment, what will be the future value?
Future value <== Use FV to calculate the future value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

TOPIC 2 FINANCIAL MATHEMATICS Question 1.1 Your parents put some money in the bank 20 years ago for you to go to university. The interest rate was 5% p.a. compounded quarterly. Today, they have you...

Q:

Question 1.2 a) How much will you have in the bank if you invest $40 000 today at an interest rate of 7% p.a. compounded fortnightly in 8 years from today? b) What is the effective annual interest...

Q:

Can I please get help. Thanks! 1. Fusion Inc. would like to purchase a new machine for $85,000. The machine is expected to generate a cost savings of $23,000 per year for five years. The company's...

Q:

FIN222 Week 7_T CH8: RQ5 P5,9,10(a),20,23,24,26,27 (9 Questions, 15 parts) RQ5. Under what conditions will the IRR rule and the NPV rule give the same accept/reject decision? P5. You have been...

Q:

Solve the following questions by using Excel formula. Show me your data 1- If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years? 2-...

Q:

Use time value of money techniques to answer the following questions. Be sure to show the appropriate information used for your calculations. Round all answers to the nearest whole dollar. You want...

Q:

Urgent thanks Question 6 (1 point) How much is a $10000 investment in a savings account worth after 8 years if the bank pays an annual interest rate of 1%? Your Answer: Answer Question 7 (1 point)...

Q:

Question 6 (1 point) How much is a $10000 investment in a savings account worth after 8 years if the bank pays an annual interest rate of 1%? Your Answer: Answer Question 7 (1 point) How much do you...

Q:

1. Find the future value of investing $1,000 today for 10 years under the following conditions: a. 6% compounded annually b. 6% compounded semiannually c. 6% compounded quarterly d. 6% compounded...

Q:

3. You will be able to invest this stream of cash flows for 4 years, with the iast cash flow occurring at the end of 4 years from now. What is the future value of these cash flows under the following...

Q:

1. When the Virginia Coffee Service sold its assets to the Macke Company, what rights did it assign? 2. What duties were delegated? Singley, Judge The appellees and defendants below, Pizza of...

Q:

The following data represent the divorce rate (per 1000 population) for most states in the United States in the year 2006. (a) Construct a stem-and-leaf plot and (b) Describe the shape of the...

Q:

Behavior analysts make _ _ _ _ based on the needs of the client and / or relevant stakeholders and include multiple providers when possible. They also disclose any relationships with the providers...

Q:

The project _ _ _ _ _ answers the questions of what, when, how much, and at times where.

Q:

6. Describe how our cognitions about ourselves and our behavior affect our communication with others

Q:

4. Describe cultural differences that influence perception

Q:

5. Identify how our selfconcept who we think we areinfluences communication