property calculator

[Kevin12223]

How do I analyze and property for adding a second suite in basement and living in the top half.

 

[Thomas Beyer]

You master the art of a simple spreadsheet, a basic tool for every real estate investor.

 

[Matt Crowley]

Look at the income invested and the rate of return it is expected to earn vs. putting it in the market at a similar investment risk.

So if you put $20,000 cash into development of your basement suite and you get $1000 rent less $500 marginal expenses then you have $500 NOI per month. Now look at what the holding period is for your home. Assume 5 years for this example. If the basement suite increases your home value by $10,000 when you sell in year 5, then the cash flows look like this:

CF time 0 = -20,000
CF time 1 = 6,000
CF time 2 = 6,000
CF time 3 = 6,000
CF time 4 = 6,000
CF time 5 = 6,000 + 10,000 = 16,000

Take those cash flows and plug them into a simple NPV worksheet: http://www.free-online-calculator-use.com/npv-calculator.html

For this example at a 12% discount rate, the NPV is $7,300. This means that on top of the initial $20,000 investment you would be willing to pay an additional $7,300 to purchase this investment, assuming that 12% is a sufficient return for this level of risk.

 

[TAMI]

find the cost of adding the basement suite , then add it to the prosoma of cash flow and NOI

 

[Tina Myrvang]

How do I analyze and property for adding a second suite in basement and living in the top half.

Hi Kevin,
I will go over that when we do your Tutorial.
Talk to you soon.