For the below time value of money problems, complete using formulas in Excel on each separate tab. Mention any assumptions and support each decision made.

Question One:
You deposited $15,000 today and the interest rate is 8% annually. How much will you have in nine years?

Question Two:
Tiff will receive a graduation gift of $10,000 from her parents in three years. If the discount rate is 7%, what would this present worth today?

Question Three:
What's the present value of a twenty year ordinary annuity of $30,000 using a discount rate of 6%?

Question Four:
You deposited $5,000 in an account paying 8% interest a year. How long will it take to double the amount?

Question Five:
The Johnsons have $60,000 to use as a down payment on a home, and they want to borrow $240,000. The mortgage interest rate is 5%. If they make equal monthly payments for thirty years, how much they be paying each month?

Question Six:
Tim pays $250 a month into his 401K retirement plan. After thirty years, he will have $500,000. What average annual rate of interest will he earned?

Question Seven:
In 2001 Charlotte's firm had sales of $525,000. By 2012, sales went up to $1,200,000. What's the average annual rate of increase?

Question Eight:
Alan had saved up $500,000 so far. How much more must he save per year over the next ten years in order to have a total of $2 million? Alan earns 5% interest, compounded each year.

Solution Summary

The instructional comments explain how each variable was extracted from the problem, what function in excel is needed and when to use a negative amount in the formula.

... amount invested today c. The smaller the present value of a future sum of money d. All ... The principle behind time value of money is based on the fact that: A ...

... c. Show that the loan balance after 1 year is equal to the year-end payment of $301.92 times the 3-year ... Solutions to Chapter 4 The Time Value of Money. ...

... assists the decision maker by evaluating the present value of the future expected cash flows using a discount rate to remove the time value of money for future...

... how much will be the total amount of money if you ... We have to find the future value of the savings which is in ... The time period is 514 months (65-22 years = 516 ...

... a. What is the present value of your firm's cash flows for Years 1 through 5? b. How would your answer to (a) change if you ...Time Value Money 1. Future Values. ...

... interest formula to get the future value The future value is 3.59 X ... The solution explains various multiple choice questions relating to time value of money. ...

... d. Option B has a lower future value at year 5 than option A given a zero rate of return. ... Option A is ruled out as Time value of money is not considered. ...

... the "compound amount") after the specified time has gone ... compounded semiannually, which means two times per year ... Plugging all of these values into the equation ...

... he make in order to retire at the same time as Dylan? ... 1 - (1 + ) T where, T = the number of times interest is ... the project because it DOES NOT ADD value for the ...

Financial concepts - Time Value of Money. ... c, we are basically interested in finding present value of a future payment to ... LG 2: Time Value: PV = FVn × (PVIFi%,n ...