. You are considering purchasing land for investment. The current landowner is w
ID: 2452518 • Letter: #
Question
.
You are considering purchasing land for investment. The current landowner is willing sell you the land in exchange for a $70,000 note payable over 12 years. The landowner would require a payment of $9,289 at the end of each year for 12 years. Calculate the annual interest rate on this loan. (hint: this is an internal rate of return problem)
Interest rate:___________________
You are considering purchasing 100 shares of stock in Big Money Company. You expect the stock to pay annual dividends of $970 at the end of each year, and to be worth $85,000 at the end of ten years, when you plan to sell the stock. The investment costs $43,000 and you need an annual return of 7.3%. What is the net present value of this investment? Note: This is a standard net present value problem.
Cash Flow Worksheet
Present Value
Net Present Value
Based on your calculations, will the total return on the investment be at least 7.3%?
Circle one: Yes No
Cash Flow Worksheet
Present Value
Net Present Value
Explanation / Answer
1)
Interest rate = rate(nper,pmt,pv,fv)
Interest rate = rate(12,9289,-70000,0)
Interest rate = 8%
2)
Based on your calculations, will the total return on the investment be at least 7.3%?
Yes
Cash Flow Worksheet Present Value PV of Annual Dividend (970*6.92721) 6,719.39 PV of Face Value (85000* 0.49431) 42,016.35 Total Present value of cash Inflow 48,735.74 Investment cost -43000 Net Present Value 5,735.74Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.