Please, answer for following questions: You’ve spent $10,000 searching for an investment property. Now, you’re considering...

Please, answer for following questions:

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 $12,000 per year in rent and pay $8,000 per year in HOA, taxes, and other expenses. Assume you’ll be able to sell the house in ten years for $400,000. Calculate in Excel the NPV (assume a reasonable discount rate) and IRR of this investment.
Now, assume that you must spend $100,000 in year 10 to raise the house on stilts due to sea-level rise from a warming planet. What are the NPV and IRR in this scenario?
Is the cottage still a good investment? Why?
Please Use Excel and shows all formulas.

Thank you so much!

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

You’ve decided you need a pet while you’re in Davis, and are considering a boa constrictor...

You’ve decided you need a pet while you’re in Davis, and are considering a boa constrictor and a caiman. The boa would cost you $200 to purchase and $50 per year for food, while the caiman would cost $100 to purchase and $100 per year for food. They both give you the same satisfaction as a pet, and you will give away your pet to a good home after the end of next year. You decide to purchase the boa....

Answer the following questions. Polk Products is considering an investment project with the following cash flows:...

Answer the following questions. Polk Products is considering an investment project with the following cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cashflow -100 90 -25 -40 30 80 The company’s cost of capital is 10%, and it can get an unlimited amount of capital at that cost. What is the modified internal rate of return (MIRR) for the Project? Select one: a. 15.77% b. 10.80% c. 10.18% d. 6.03% e. 8.54%

By searching the Internet, answer these two questions About Exxon Mobile Petroleum : An overview of...

By searching the Internet, answer these two questions About Exxon Mobile Petroleum : An overview of the company's quality policies, plans and supply chain policies.>? What procedures the company follows to ensure efficient operations.>?

Using Java implement a searching algorithm to solve the following problem (please specify the searching algorithm...

Using Java implement a searching algorithm to solve the following problem (please specify the searching algorithm being used) Requirements Choose one problem with an algorithm and implement it. You should show and explain the result whatever you got. I recommend using N-Queen problem (at least N=8 or more) or any simple perfect games. For example, - N-Queen problem with hill climbing - N-Queen problem with simulated annealing - N-Queen problem with genetic algorithm - Tic-Tac-Toe with Minimax

Timothy is considering an investment of $10,000. This investment is supposedly going to provide him with...

Timothy is considering an investment of $10,000. This investment is supposedly going to provide him with cash inflows of $2,500 in the first year and $6,000 a year for the following 2 years. At a discount rate of zero percent this investment has a net present value (NPV) of _____, but at the relevant discount rate of 18 percent the project's NPV is: a. $4,500; $62.03. b. -$1,500; $62.03. c. $4,500; $79.54. d. -$1,500; $79.54. e. $6,000; $98.48.

4.11.2 - Mixed Streams with an Initial CashFlowYou receive $10,000 now for an investment...

4.11.2 - Mixed Streams with an Initial Cash FlowYou receive $10,000 now for an investment that will give you cash flows of $1000 in one year, $2000 in two years, $3000 in three years, and $4000 in four years. If the discount rate is 5% then what is the PV of this investment? (Enter the answer in dollar format without $ sign or thousands comma -> 3519.23 and not $3,519.23 or 3,519.23)4.11.3 - Mixed Streams with Repeating Cash FlowsYou receive...

Use the following information to answer questions 9-15. The length of time spent in the examination...

Use the following information to answer questions 9-15. The length of time spent in the examination room is recorded for each patient seen by each physician at an orthopedic clinic. Does the data provide a significance difference in mean times? Physician 1 Physician 2 Physician 3 Physician 4 34 33 17 28 25 35 30 33 27 31 30 31 31 31 26 27 26 42 32 32 34 33 28 33 21 26 40 29 X.1=198 X. 2=205...

HI please answer these questions with clean handwriting. 1)What property of the spherical curve allows the...

HI please answer these questions with clean handwriting. 1)What property of the spherical curve allows the vertex of positive and negative mirrors to be determined in the same way? 2)What is an easy way to align the spherical mirror so that its center of curvature is on the optical axis (i.e., the centerline of the pinhole autocollimator beam)? Why is this a critical alignment? In [ ]: 3)What happens in the autocollimation measurement if the mirror's spherical center...

The following corporation has a moderate current asset investment policy, but it is now considering a...

The following corporation has a moderate current asset investment policy, but it is now considering a change, perhaps to a restricted or maybe to a relaxed policy. The firm’s annual sales are $400,000; its fixed assets are $100,000; its target capital structure calls for 50% debt and 50% equity; its EBIT is $39,000; the interest rate on its debt is 10%; and its tax rate is 40%. With a restricted policy, current assets will be 15% of sales, while under...

Not handwriting answer, please In a word document, please answer the following questions: Course Introduction of...

Not handwriting answer, please In a word document, please answer the following questions: Course Introduction of Biostatistics Define the following terms: correlation coefficient scatter plot bivariate relationship Provide an example where the outlier is more important to the research than the other observations? Identify when to use Spearman’s rho.

Subjects