Question

Time Value of Money Keenan has won the lottery for $10,000,000. He is offered a cash...

Time Value of Money

  1. Keenan has won the lottery for $10,000,000. He is offered a cash payment now of $7,500,000, or 10 annual payments of $1,000,000.
  • _____________ What is the interest rate that makes these two amounts equal?

  • _____________ If you can invest at 8% how much would you have after 10 years if you invested the $7,500,000?

  1. You want a new car that costs $32,000. Figure out the following:
  • ______________ What would the monthly payment be if you borrowed $32,000 from a credit union at 4% for 5 years?

  • ______________ What would be the total of monthly payments (the amount you would actually pay for the car)?

  • ______________ How much interest would you pay if you did this?

  • ______________ How much would you have to save each month if you decided to save for 5 years and pay cash for the car, and you could earn 6% on your savings?

  • ______________ What would be the total of monthly savings (the amount you would actually pay for the car if you saved)?

  1. You have a trust that mature to $75,000 that you will receive when you are 40 years old. You are 23 years old now. If the trust is growing at 4% per year what is the value of the trust now? ____________
  1. You want to purchase a house that costs $150,000. You have $30,000. Because you have good credit score you have been offered a loan of 15 years at 3% or 30 years at 3.75%.

  • ______________ How much is your loan?

  • ______________ What is your monthly principal and interest payment for the 15 year loan?

  • ______________ What is your monthly principal and interest payment for the 30 year loan?

  • _____________ What is the total of the payments (the amount you actually pay for the house) with the 15 year loan?

  • _____________ What is the total of the payments (the amount you actually pay for the house) with the 30 year loan?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

(1) Lump sum Offering = $ 7500000, Annual Payments = $ 1000000 and Tenure = 10 years

Let the interest rate that makes the two options equal be r%

Therefore, 7500000 = 1000000 x (1/r) x [1-{1/(1+r)^(10)}]

Using EXCEL's Goal Seek Function/hit and trial method/ a financial calculator to solve the above equation, we get:

r = 0.056 or 5.6 %

Initial Investment = $ 7500000, Interest Rate = 8 % and Tenure = 10 Years

Final Value = 7500000 x (1.08)^(10) = $ 16191937.48

NOTE: Please raise separate queries for solutions to the remaining unrelated questions, as one query is restricted to the solution of only one complete question with up to four sub-parts.

Add a comment
Know the answer?
Add Answer to:
Time Value of Money Keenan has won the lottery for $10,000,000. He is offered a cash...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2. You want a new car that costs $32,000. Figure out the following: ______________ What would...

    2. You want a new car that costs $32,000. Figure out the following: ______________ What would the monthly payment be if you borrowed $32,000 from a credit union at 4% for 5 years? ______________ What would be the total of monthly payments (the amount you would actually pay for the car)? ______________ How much interest would you pay if you did this? ______________ How much would you have to save each month if you decided to save for 5 years...

  • Time Value of Money The following situations test your comprehension of time value of money concepts....

    Time Value of Money The following situations test your comprehension of time value of money concepts. You will need your financial calculator. For each problem write the variable from the problem next to the variable in your calculator menu. Put a question mark next to the variable we are solving for, and put the answer to that variable on the “Answer” line. Remember that there has to be a negative number in your calculations for the formulas to work. If...

  • Question 4: Application of Time Value of Money to Mortgages (30 marks) Shanna wants to buy...

    Question 4: Application of Time Value of Money to Mortgages (30 marks) Shanna wants to buy a house costing $325,000 and has obtained a loan from TD Bank. A minimum down payment of 15% would be required and the bank will provide the difference. Her grandparent have told her that they will cover her down payment. a. TD Bank has quoted her mortgage interest rate is 4.5%; this rate would be compounded semi- annually, while her payments would be made...

  • Solve the cash flow equivalence below for the unknown value of Q assuming an 7% annual...

    Solve the cash flow equivalence below for the unknown value of Q assuming an 7% annual interest rate. 1. 800 4i Q 70 o0 i23 2 2, You borrowed $6,000.00 for 5 years at 7% annual interest rate. The banker said that to repay the total loan amount you have to pay $1,463 at the end of each year. a) Draw a time line depicting this cash low b) Build a table to determine how much of the annual payment...

  • You want to buy a car that will cost $33,100. You have $2,750 cash as a...

    You want to buy a car that will cost $33,100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years Compute the amount of the monthly loan payment that you will need to make. Rate Nper PMT PV FV туре Prepare a loan amortization schedule using the format presented below. Use the amortization schedule to answer...

  • You want to buy a car that will cost $33, 100. You have $2,750 cash as...

    You want to buy a car that will cost $33, 100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years. Compute the amount of the monthly loan payment that you will need to make. Rate 6.75% Nper PMT PV FV Type Prepare a loan amortization schedule using the format presented below. Use the amortization schedule...

  • 5. Calculating Take-home Pay, and Length of Savings: Because it is such a large amount, most...

    5. Calculating Take-home Pay, and Length of Savings: Because it is such a large amount, most people, when deciding to buy a home, need to plan ahead and start saving for the down payment. Using the average starting salary in the career you chose after graduation as a guideline (from #2), calculate your monthly take-home pay; this is your net monthly pay after you have an average of 30% taken out for income taxes. Monthly take-home (net) pay after 30%...

  • TIME VALUE OF MONEY 32. Future Value of si John and Mary Rich invested $15,000 in...

    TIME VALUE OF MONEY 32. Future Value of si John and Mary Rich invested $15,000 in a savings account paying 5.25% interest at the time their son, Mike, was born. The money is to be used by Mike for his college education. On his 18 birthday, Mike withdraws the money from his savings account. How much did Mike withdraw from his account? A. $42,755.32 B. $30,345.27 C. $35,233.89 D $37,678.11 33. Future Value of Annuity of Si John and Char...

  • look down needs answer the last question 3 and 4 please You will be provided a...

    look down needs answer the last question 3 and 4 please You will be provided a car price of either: $12k, $16k, $20k, $24k, $28k, $32k, $36k, $40k, $44k, or $48k 1. Suppose you have $4000 saved up for a down payment, and you plan to finance the rest of the balance due. You are offered a 60 month loan at 4.5% APR. Calculate your monthly payment for the loan. What is the total cost of the car and loan?...

  • Aya and Harumi would like to buy a house..

    Aya and Harumi would like to buy a house and their dream house costs $500,000.  They have $50,000 saved up for a down payment but would still need to take out a mortgage loan for the remaining $450,000 and they’re not sure whether they could afford the monthly loan payments.  The bank has offered them an interest rate of 4.25%, compounded monthly. How much would they have to be able to afford to pay each month in order to pay off...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT