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.

... 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. ...

Time value of money. Please assist with the following homework: 1.Calculate the future value of the following a, $500 invested for 5 yrs at a 5 % interest ...

... Annuity due Value: $33,593.83 Explanation: Let x = payment Future value = $150,000 Period = 5 years ... The concepts related to the time value of money are all ...

... 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. ...

... FV=P(1+i) 60,000.00 where,. FV Future value P Present value i Interest rate/rate of return. ... b) Present value represents the time value of money concept it ...

... the value of the dollar at any given time is a ... the need for decision-making since using money in one ... is the procedure for estimating the present value of costs ...

... P/E (price to earnings) ratio is an expression of the number of times the earnings ... Stock valuation takes into consideration the time value of money concept. ...

...Future value 387,120 Present value 32,805 Interest rate 14% Duration 18.84 8. How can we apply the concept of time value of money in evaluating a mortgage? ...

... 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 ...