Question

In: Finance

Calculate the following time value of money problems: If you want to accumulate $500,000 in 20...

Calculate the following time value of money problems:

  1. If you want to accumulate $500,000 in 20 years, how much do you need to deposit today that pays an interest rate of 15%?
  2. What is the future value if you plan to invest $200,000 for 5 years and the interest rate is 5%?
  3. What is the interest rate for an initial investment of $100,000 to grow to $300,000 in 10 years?
  4. If your company purchases an annuity that will pay $50,000/year for 10 years at a 11% discount rate, what is the value of the annuity on the purchase date if the first annuity payment is made on the date of purchase?
  5. What is the rate of return required to accumulate $400,000 if you invest $10,000 per year for 20 years. Assume all payments are made at the end of the period.

Solutions

Expert Solution

1. Information provided:

Future value= $500,000

Time= 20 years

Interest rate= 15%

The question is concerning finding the present value of an annuity due. Annuity due refers to annuity that occurs at the beginning of a period.

This can also be solved using a financial calculator by inputting the below into the calculator:

The financial calculator is set in the end mode. Annuity due is calculated by setting the calculator to the beginning mode (BGN). To do this, press 2nd BGN 2nd SET on the Texas BA II Plus calculator.

Enter the below in a financial calculator in BGN mode:

FV= 500,000

N= 20

I/Y= 15

Press the CPT key and PV to compute the present value.

The value obtained is 30,550.14.

Therefore, $30,550.14 must be deposited today.

2. Information provided:

Yearly investment= $200,000

Time= 5 years

Interest rate= 5%

The future value is calculated by entering the below in a financial calculator:

PMT= 200,000

N= 5

I/Y= 5

Press the CPT key and FV to compute the future value.

The value obtained is 1,105,126.25.

Therefore, the future value is $1,105,126.25.

3. Information provided:

Present value= $100,000

Future value= $300,000

Time= 10 years

The interest rate is calculated by entering the below in a financial calculator:

PV= -100,000

FV= 300,000

N= 10

Press the CPT key and I/Y to compute the interest rate.

The value obtained is 11.61.

Therefore, the interest rate is 11.61%.

4. Information provided:

Annuity= $50,000

Time= 10 years

Interest rate= 11%

The question is concerning finding the present value of an annuity due. Annuity due refers to annuity that occurs at the beginning of a period.

This can also be solved using a financial calculator by inputting the below into the calculator:

The financial calculator is set in the end mode. Annuity due is calculated by setting the calculator to the beginning mode (BGN). To do this, press 2nd BGN 2nd SET on the Texas BA II Plus calculator.

Enter the below in a financial calculator in BGN mode:

PMT= 50,000

N= 10

I/Y= 11

Press the CPT key and PV to compute the present value.

The value obtained is 326,852.38.

Therefore, the value of the annuity on the purchase date is $326,852.38.

5. Information provided:

Future value= $400,000

Annuity= $10,000

Time= 20 years

The rate of return is calculated by entering the below in a financial calculator:

FV= 400,000

PMT= 10,000

N= 20

Press the CPT key and I/Y to compute the rate of return.

The value obtained is 6.77.

Therefore, the rate of return is 6.77%.

In case of any query, kindly comment on the solution.


Related Solutions

What is time value of money? Whu problems may arise if time value of money is...
What is time value of money? Whu problems may arise if time value of money is not taken into consideration while making transactions? Explain theoretically how can these problems be dealt with?
Time Value of Money You have the chance to buy the neighbors farm for $500,000. You...
Time Value of Money You have the chance to buy the neighbors farm for $500,000. You have a $100,000 down payment with the rest ($400,000) financed in one of the following ways. Equal annual payments with an interest rate of 7% for 20 years. Equal annual payments with an interest rate of 10% for 15 years. Equal quarterly payments with an interest rate of 8% for 15 years. Your neighbor will carry the contract. 1) Calculate each of the loans...
Advanced Time Value of Money Problems Your child was just born and you are planning for...
Advanced Time Value of Money Problems Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Financial Economics you decide to send your child to Hofstra University as well. You anticipate the annual tuition to be $60,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday every year starting today, the day of your child’s birth. No deposits will be made after...
Time value of money: 1 point You want to have an amount of $30,000 in five...
Time value of money: 1 point You want to have an amount of $30,000 in five years. Calculate the amount you need to save each year in the next five years so you can achieve this goal. Assume that the interest rate is 6%, that interest is compounded annually, and that you put money into your saving account at the beginning of each year.   Bond valuation: 2 points XYZ Corporation has an outstanding 20-year bond with a $10,000 face value...
To calculate the time value of money, we need to consider all of the following except...
To calculate the time value of money, we need to consider all of the following except the... -Length of time the money is on deposit. -Type of investment. -Principal. -Amount of the savings. Annual interest rate.
Use the Excel time value of money functions to complete the following problems. Highlight your answers....
Use the Excel time value of money functions to complete the following problems. Highlight your answers. Upload your solution on blackboard. 1) Manny’s grandparents gave him $1,800 for his birthday. He opened a savings account that pays 4% annually. How much money will he have in 7 years if he does not make any withdrawals? N= I= PV= PMT= FV= 2) Your parents will retire in 25 years. They currently have $100,000 in savings. They think they will need $1,000,000...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
Managerial Finance Learning Objective: Calculate the time value of money Activity: Using the time value of...
Managerial Finance Learning Objective: Calculate the time value of money Activity: Using the time value of money (TVM) principles develop a retirement calculator using the following steps. Submit an Excel file showing your calculations and answers to the questions below. Step 1: Calculate the future value of the money you will need. How old are you now? 22 At what age do you want to retire? 60 Assume you will live until the age of 90. In today's dollars, how...
Part One 1. [Time Value of Money] David, aged 30, wishes to accumulate a college fund...
Part One 1. [Time Value of Money] David, aged 30, wishes to accumulate a college fund for his newborn baby (age 0). Assuming that his baby will need 20,000 each year for four years starting the beginning of his age 18 for college, how much money he needs to put aside right now? If David does not have that amount of money right now, but he can save certain amount of money at the end of each year, how much...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT