Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are interested in buying a house to rent out for income. Purchase price for the house is $ 1 9 9 , 0 0

You are interested in buying a house to rent out for income. Purchase price for the house is $199,000 and the market value at the end of 27 years of use will be $300,000(assume that you will be able to sell the house for this amount on December 31st of Year 27).
The monthly rent you receive on the house will be $1,700. Assume that you will be able to rent the house out every month after purchase. Expenses you will incur include annual taxes (1% of purchase price of house), home insurance of $800, miscellaneous expenses that average $1080 yearly, and depreciation expense.
The depreciable life of the house is 27 years and it will be fully depreciated when you sell. Your required rate of return (discount rate) for a real estate investment is 8% and your tax rate is 30%.Create a cash flow table that shows your annual cash flows; then use NPV and IRR to evaluate if this house is a good investment. Explain why you would or would not invest.
Thank you! Please show work and formulas on an excel spreadsheet if possible!
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of Stock Trends

Authors: Robert D. Edwards, John Magee, W.H.C. Bassetti

9th Edition

0814408648, 978-0814408643

More Books

Students also viewed these Finance questions

Question

How does selection differ from recruitment ?

Answered: 1 week ago

Question

A study based on

Answered: 1 week ago