In: Finance
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) |
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -