You’ve spent $10,000 searching for an investment property. Now, you’re considering investing in a cottage near Brighton Beach. You can buy the house for $300,000 with cash, earn $20,000 per year in rent and pay $7,000 per year in HOA, taxes, and other expenses. Assume you’ll be able to sell the house in ten years for $400,000 (the "salvage value"). Your second-best investment alternative would earn a return of 6.50%. Calculate in Excel the NPV and IRR of this investment.

You’ve spent $10,000 searching for an investment property. Now, you’re considering investing in a cottage near Brighton Beach. You can buy the house for $300,000 with cash, earn $20,000 per year in rent and pay $7,000 per year in HOA, taxes, and other expenses. Assume you’ll be able to sell the house in ten years for $400,000 (the "salvage value"). Your second-best investment alternative would earn a return of 6.50%. Calculate in Excel the NPV and IRR of this investment.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter2: The Domestic And International Financial Marketplace

Section: Chapter Questions

Problem 8P

See similar textbooks

Similar questions

You are considering investing in a rental property. Market rent for similar properties is 1, 500 a month (18,000 a year). Maintenance costs, property tax and insurance add up to 4, 000 a year. You expect rent and cost to increase at 5% a year. You plan to hold the property for 10 years and expect to sell it at the end of 10 years for $250,000. How much should you pay for it now if you're asking for a return of 15% ?Question 13 options: $152, 134.01 $132, 058.94 $169, 321.37 $145, 426.88
You have an opportunity to purchase a piece of vacant land for $30,000 cash. If you plan to hold it for 15 years and then sell it at a profit. During this period, you would have to pay annual property taxes of $600 and have no income from the property. Assuming that you would want a 10% rate of return from the investment, a) Draw a cashflow diagram. b) What net price would you have to sell it in the next 15 years?
You can buy property today for $3.9 million and sell it in 5 years for $4.9 million. (you have no rental income on the property). 1. If the interest rate is 8% what is the present value of the sales price? 2. Is the property investment attractive to you? 3. What is the present value of the future cash flows if you are could earn $290000 per year rent on the property? The rent is paid at the end of each year. 4. Is the property investment attractive to you now?
You can buy a piece of land today that you expect will be worth $500,000 in 9 years. Assuming you could invest your money at 13%, what is the most you would be willing to pay for the property? a) $195,500 b) $183,000 c) $166,500 d) $176,600
You are considering buying a condo as an investment property. The condo will generate $20,000 a year for 10 years in rent, after which you expect to sell the property for $275,000. What is the maximum you should pay for the property if your cost of money is 7%?
Mr. chan wants to purchase a house after a couple of years. his target house value is P4,975,193. He decides to invest in a product where he can deposit yearly P592796 starting at the beginning of each year until year 13. he wants to know what is the present value of the annuity investment that he is doing. this would enable him to know what the true cost of the property in today's term is. you are required to do the calculation of the present value of the annuity due that mr. chan is planning to make. assume that the rate earned on investment will be 9.87%. Write your answer in two decimal places
Manny Kurr is considering the purchase of a beauty salon. The initial costof this purchase is $16,000. The after-tax cash flows from this investmentshould be $4,000 per year for the next 5 years. His opportunity cost of capitalis 10 percent. Calculate the following:a. Payback—Should Manny buy the beauty salon based on payback if hisrequired payback is less than 3 years?b. The present value of the benefits (PVB),c. The present value of the costs (PVC),d. The net present value (NPV )—Should Manny buy the beauty salon basedon NPV rules?e. Profitability index (PI )—what does the profitability index mean in terms ofbuying the beauty salon?f. Internal rate of return (IRR), (Hint: Use interpolation)—should Manny buythe beauty salon based on IRR rules?g. Accounting rate of return (ARR)—Should Manny buy the beauty salonbased on the ARR?
What should you do if you own a piece of land that you bought 5 years ago for $50,000. The tax rate is 30% and you can assume you have sufficient other income to take advantage of all tax effects. Your after-tax discount rate is 7%.a. You can sell the land today for $200,000. b. You believe the land will be worth $275,000 in five years because you expect a new shopping center to be built next to your land, so You can wait and sell the land at that time (in 5 years).
You recently inherited $10,000 that you are planning to use for a down-payment on a house in 3 years. You considering using those funds in the meantime to purchase new solar panels for your current home, with the hope that you can earn the $10,000 back by the time 3 years comes around for use as the down-payment on the new house. The manufacturer promises the panels will save $4000 per year in gas and electric costs. If you can expect i = 12%, should this equipment be purchased (ie. will you have received your money back in 3 years)?
(Related to The Business of Life: Saving for Your First House) (Future value) You are hoping to buy a house the future and recently received an inheritance of $18,000. You intend to use your inheritance as a down payment o your house. a. If you put your inheritance in an account that earns 8 percent interest compounded annually, how many years will be before your inheritance grows to $34,000? b. If you let your money grow for 10.25 years at 8 percent, how much will you have? c. How long will it take your money to grow to $34,000 if you move it into an account that pays 4 percent compounded annually? How long will it take your money to grow to $34,000 if you move it into an account that pays 13 percent? d. What does all this tell you about the relationship among interest rates, time, and future sums? it be before your inheritance grows to $34,000? 8.26 years (Round to one decimal place.) b. If you let your money grow for 10.25 years at 8 percent, how much will you have? (Round to the…
You have just won a lottery prize of $1,000,000 collectable in 10 yearly installments of $100,000 starting today. The total present worth of the prize is $665,270. Suppose that you have a large mortgage you want to pay off now. You propose an alternative but equivalent payment scheme. You would like $420,000 today and the balance of the prize in four years when you intend to purchase a large piece of waterfront property. How much will the payment be in four years? Assume that annual interest is 10 percent, compounded monthly. The payment in four years will be $. (Round the final answer to the nearest dollar as needed. Round all intermediate values to six decimal places as needed.)
Exhibit 1-A Future value (compounded sum) of $1 after a given number of time periods Period 1% 1.010 1.020 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 1.020 1.040 1.040 1.082 1.125 1.170 1.217 1.050 1.103 1.158 1.216 1.276 1.340 1.407 1.030 1.061 1.060 1.124 1.070 1.145 1.225 1.311 1.403 1.110 1.232 1.368 1 1.080 1.090 1.100 1.166 1.260 1.360 1.469 1.188 1.210 3 1.030 1.061 1.093 1.191 1.295 1.331 1.041 1.126 1.159 1.194 4 1.082 1.262 1.412 1.464 1.518 5 1.104 1.126 1.338 1.611 1.772 1.685 1.870 1.051 1.539 1.062 1.072 6. 1.265 1.419 1.501 1.587 1.677 1.316 1.949 2.144 1.149 1.230 1.504 1.606 1.714 1.828 1.993 2.076 2.305 1.594 1.689 8 1.083 1.172 1.267 1.369 1.477 1.718 1.851 1.305 1.344 1.384 2.358 1.423 1.480 1.094 1.195 1.551 1.838 1.999 2.172 2.558 2.839 3.152 10 1.105 1.219 1.629 1.791 1.967 2.159 2.367 2.594 1.710 2.105 2.252 2.410 11 1.116 1.243 1.539 1.898 2.332 2.580 2.853 12 1.127 1.268 1.426 1.601 1.796 2.012 2.518 2.813 3.138 3.498 1.138 1.149 2.720 3.452 3.797 4.177 4.595 5.054 5.560…