Question

Your company is looking to invest in some adjacent land to your current facility. You have...

Your company is looking to invest in some adjacent land to your current facility. You have two options, you can purchase the land outright now for $834,962. Or, you could put pay the balance off in 5 equal annual payments of $200,193. The payment schedule can be seen in the table below. What is the rate of return on buying outright?

Year Single Payment Annual Payments
0 -$821,362 -$200,193
1 0 -$200,193
2 0 -$200,193
3 0 -$200,193
4 0 -$200,193
A.

Purchase the land now because you have a 10% rate of return.

B.

Purchase the land in installments because it will have a higher yield

C.

Don't purchase the land at all, there is no benefit to your organization.

D.

Purchase the land in installments because, even though you're paying more in the long term, you have a higher yield of 14.5%.

Homework Answers

Answer #1

Ans:

To solve this we will calculate IRR:

If we Buy Land now:

Initial Output : 821,362

This will save installment of $200,193 for 5 installemnts starting Now.

So Internal Rate of Return on installment saving :

Year Description Amount
0 Initial Cost ($821,362 - $200,193) $       -6,21,169
1 Installment saving $        2,00,193
2 Installment saving $        2,00,193
3 Installment saving $        2,00,193
4 Installment saving $        2,00,193
IRR [=IRR(C2:C6)] 11%

Therefore correct answer is Option A. because you have rate of return of more than 10%.

For any query please ask in comment box, we are happy to help you. Also please don't forget to provide your valuable feedback. Thanks!

Know the answer?
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
Similar Questions
You have just won the Georgia Lottery with a jackpot of $26,000,000. Your winnings will be...
You have just won the Georgia Lottery with a jackpot of $26,000,000. Your winnings will be paid to you in 26 equal annual installments with the first payment made immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 8% with monthly compounding of interest. What is the present value of the stream of payments you will receive?
You have just won the Mega Millions Lottery with a jackpot of $54,000,000. Your winnings will...
You have just won the Mega Millions Lottery with a jackpot of $54,000,000. Your winnings will be paid to you in 26 equal annual installments with the first payment made immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 12% with monthly compounding of interest. What is the present value of the stream of payments you will receive?
Suppose land is currently selling for $2,500 an acre and that you expect land prices to...
Suppose land is currently selling for $2,500 an acre and that you expect land prices to go up at an annual rate of 6 percent over the next 10 years. a. Ignoring the annual net cash flow generated by this land for the moment, can you justify purchasing this land at this price if your required rate of return is 8 percent and capital gains are taxed at a 20 percent rate? Assume you plan to sell this land 10...
You are looking to buy a small condo where the combination of monthly mortgage payments and...
You are looking to buy a small condo where the combination of monthly mortgage payments and annual property tax bill is much higher than what you were paying previously for renting a similar property. A friend recommends you purchase on the grounds that you can deduct the interest and property tax from your tax payments which will result lower overall payments buying vs renting. Why might that not be the case?
You are looking to buy a small condo where the combination of monthly mortgage payments and...
You are looking to buy a small condo where the combination of monthly mortgage payments and annual property tax bill is much higher than what you were paying previously for renting a similar property. A friend recommends you purchase on the grounds that you can deduct the interest and property tax from your tax payments which will result lower overall payments buying vs renting. Why might that not be the case?
Buying a car from a classmate. One of your classmate is selling you a car with...
Buying a car from a classmate. One of your classmate is selling you a car with a purchase price of $16000 and provides financing at annual percentage rate of 4%. Because you are currently making tuition payments, your friend does not require the first monthly payment until 6 months from today. However, after the first payment you are required to make 12 more payments of that same amount. If you put down payment for $ 5000 today, what is your...
You have just won the Georgia Lottery with a jackpot of $53,000,000. Your winnings will be...
You have just won the Georgia Lottery with a jackpot of $53,000,000. Your winnings will be paid to you in 26 equal annual installments with the first payment made immediately. If you feel the appropriate annual discount rate is 14%, what is the present value of the stream of payments you will receive?
You want to have enough money in the bank to pay for your daughter’s education when...
You want to have enough money in the bank to pay for your daughter’s education when the time comes. You expect to make 4 annual payments for college, with the first payment in 10 years. The first payment will be for $50,000 and each subsequent payment will be 5% higher than the previous payment. If you expect to earn 5% a year on your deposits, how much do you need in the bank now to ensure you will have the...
Can you Solve it in Excel Please Today is your 25th birthday.  You have decided that it...
Can you Solve it in Excel Please Today is your 25th birthday.  You have decided that it is necessary to plan your own retirement since you are not confident that government benefits will be available when you retire.  You will make annual payments into an account earning 5% APY starting on your next birthday (26th) a year from now.  Your last payment will occur on your 70th birthday.  You have decided that you need to plan for payments of $500,000 per year and that...
15 years from now, your 2-year old son will be attending Harvard. You have determined he...
15 years from now, your 2-year old son will be attending Harvard. You have determined he will need $70,000 per year for tuition and living expenses. In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 5% interest. You have found an investment opportunity that will yield an annual return of 7% on your monthly payments. How much...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT