Question

In: Finance

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 payment and the total payment amounts
7% for 20 years
10% for 15 years
8% for 15 years
2) Which is the best for you? (cheapest total payments for you)
3) Best for the neighbor? (gets him the most money)

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -


Related Solutions

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: 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%? What is the future value if you plan to invest $200,000 for 5 years and the interest rate is 5%? What is the interest rate for an initial investment of $100,000 to grow to $300,000 in 10 years? If your company purchases an annuity that will pay $50,000/year...
You have a chance to buy a BB-rated Grandview, Inc. bond that has a face value...
You have a chance to buy a BB-rated Grandview, Inc. bond that has a face value of $1,000. The bond has a 7% coupon rate of interest and matures in six years. Interest is paid semi-annually. BB-rated bonds of similar maturity pay an interest rate of 8%. How much should you be willing to pay for the Grandview bond?
You have a chance to buy a BB-rated Grandview, Inc. bond that has a face value...
You have a chance to buy a BB-rated Grandview, Inc. bond that has a face value of $1,000. The bond has a 7% coupon rate of interest and matures in six years. Interest is paid semi-annually. BB-rated bonds of similar maturity pay an interest rate of 8%. How much should you be willing to pay for the Grandview bond?
You have the opportunity of purchasing a farm for $500,000. The owner will allow a $100,000...
You have the opportunity of purchasing a farm for $500,000. The owner will allow a $100,000 down payment with the remainder financed in one of the following ways. 1. Equal annual payments with an interest rate of 7% for 20 years. 2. Equal annual payments with an interest rate of 10% for 15 years. 3. Equal quarterly payments with interest rate of 8% for 15 years. 4. Equal principal payments each year with interest rate of 8% for 10 years....
The concept of Time Value Money is very important in investing. When you have money in...
The concept of Time Value Money is very important in investing. When you have money in your "hand" in todays world, it is worth more than it could be in the future. When you are investing, you have no idea what the future will hold or how much your dollar will be worth. Since money earns interest, it is worth more the earlier that you invest it and can get a return on your investment. In the Prudential commercials, they...
Time Value of Money COLLAPSE You have just won the $1,000,000 in the lottery. You have...
Time Value of Money COLLAPSE You have just won the $1,000,000 in the lottery. You have the option of taking a lump sum payout or equal annualized payments over 20 years. Ignoring any tax consequences; how much should you expect from the annualized payments. What target interest rate would make the annualized payments more valuable than the lump sum. In your response, you may want to consider such issues as inflation, investing lump sum in stock market (What have been...
You have a chance to buy an annuity that pays $24,000 at the beginning of each...
You have a chance to buy an annuity that pays $24,000 at the beginning of each year for 5 years. You could earn 4.5% on your money in other investments with equal risk. What is the most you should pay for the annuity?
If the time value of the money is .10 how much do you have to save...
If the time value of the money is .10 how much do you have to save per year for 20 years to have $50,000 per year for perpetuity? Assume that the first deposit is immediate and that the first payment will be at the beginning of the 21st year. Suppose that you decide to hold the bonds in the previous question for a year, and then sell them. The next year, the interest rate on comparable bonds increases to 9.5%....
"Time Value of Money " The time value of money is a critical concept to understand...
"Time Value of Money " The time value of money is a critical concept to understand in accounting, especially when dealing with loans, investment analysis, and capital budgeting decisions. The time value of money concept can be used to decide which projects to start and what investments to make. You can also utilize the time value of money concept in your personal life. Provide two (2) decisions you may need to make that could involve the time value of money....
"Time Value of Money " The time value of money is a critical concept to understand...
"Time Value of Money " The time value of money is a critical concept to understand in accounting, especially when dealing with loans, investment analysis, and capital budgeting decisions. The time value of money concept can be used to decide which projects to start and what investments to make. You can also utilize the time value of money concept in your personal life. Provide two (2) decisions you may need to make that could involve the time value of money....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT