# Fin515 week 2 problems – done in excel :)

Hey đź™‚

For such questions contact me! If you need only part of these, also do message me!

Week 2 Problem Set

Answer the following questions and solve the following problems in the space provided. When you are done, save the file in the format flastname_Week_2_Problem_Set.docx, where flastname is your first initial and you last name, and submit it to the appropriate dropbox.

Chapter 4 (pages 132â€“136):

3. Calculate the future value of \$2000 in

a.Â five years at an interest rate of 5% per year;

b.Â ten years at an interest rate of 5% per year; and

c.Â five years at an interest rate of 10% per year.

d.Â Why is the amount of interest earned in part (a) less than half the amount of interest earned in part (b)?

Â

4. What is the present value of \$10,000 received

a. twelve years from today when the interest rate is 4% per year;

b.Â twenty years from today when the interest rate is 8% per year; and

c.Â six years from today when the interest rate is 2% per year?

Â

5. Your brother has offered to give you either \$5,000 today or \$10,000 in 10 years. If the interest rate is 7% per year, which option is preferable?

Â

6. Consider the following alternatives.

i.Â \$100 received in 1 year

ii.Â \$200 received in 5 years

iii.Â \$300 received in 10 years

Â

a.Â Rank the alternatives from most valuable to least valuable if the interest rate is 10% per year.

b.Â What is your ranking if the interest rate is only 5% per year?

c.Â What is your ranking if the interest rate is 20% per year?

Â

Â

8. Your daughter is currently 8 years old. You anticipate that she will be going to college in 10 years. You would like to have \$100,000 in a savings account to fund her education at that time. If the account promises to pay a fixed interest rate of 3% per year, how much money do you need to put into the account today to ensure that you will have \$100,000 in 10 years?

Â

9. You are thinking of retiring. Your retirement plan will pay you either \$250,000 immediately on retirement or \$350,000 5 years after the date of your retirement. Which alternative should you choose if the interest rate is

a.Â 0% per year;

b.Â 8% per year; and

c.Â 20% per year?

Â

14. You have been offered a unique investment opportunity. If you invest \$10,000 today, you will receive \$500 1 year from now, \$1,500 2 years from now, and \$10,000 10 years from now.

a.Â What is the NPV of the opportunity if the interest rate is 6% per year? Should you take the opportunity?

b.Â What is the NPV of the opportunity if the interest rate is 2% per year? Should you take it now?

Â

36. You are thinking of purchasing a house. The house costs \$350,000. You have \$50,000 in cash that you can use as a down payment on the house, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires annual payments and has an interest rate of 7% per year. What will your annual payment be if you sign up for this mortgage?

Â

37. You would like to buy the house and take the mortgage described in Problem 36. You can afford to pay only \$23,500 per year. The bank agrees to allow you to pay this amount each year, yet still borrow \$300,000. At the end of the mortgage (in 30 years), you must make aÂ balloonÂ payment; that is, you must repay the remaining balance on the mortgage. How much will this balloon payment be?

Â

38. You have just made an offer on a new home and are seeking a mortgage. You need to borrow \$600,000.

a.Â The bank offers a 30-year mortgage with fixed monthly payments and an interest rate of 0.5% per month. What is the amount of your monthly payment if you take this loan?

b.Â Alternatively, you can get a 15-year mortgage with fixed monthly payments and an interest rate of 0.4% per month. How much would your monthly payments be if you take this loan instead?

Â

*A.1. This problem is from the Appendix to Chapter 4.

Your grandmother bought an annuity from Rock Solid Life Insurance Company for \$200,000 when she retired. In exchange for the \$200,000, Rock Solid will pay her \$25,000 per year until she dies. The interest rate is 5%. How long must she live after the day she retired to come out ahead (that is, to get more inÂ valueÂ than what she paid in)?

Â

Top of Form

Â

Â