Evaluating Currently Owned Property Performance Question

[Brian S.]

This is my first post here after reading for some time. I a have a few somewhat specific questions regarding analyzing the performance of currently owned properties that range from 90+ unit complexes to 5-6 unit mfd's I'm hoping someone can assist me with:

1. If I wanted to calculate a hybrid what-if internal rate of return for a currently owned property that has a balloon mortgage maturing in the next 4-5 years would it be appropriate to set up a model to do the following:

- Utilize actual/realized cash flows from the time of purchase to present. Should these prior cash flows be left as-is or discounted to the acquisition year? I'm thinking left as-is as they've already been realized.

- Factor in actual gains/losses on re-investments of past positive cash flows while projecting/discounting the future cash flows of those already held reinvestments (let's assume they're reinvested in fixed % cd's or savings accounts for simplicity).

- Projects future cash flows for the remaining term based on historical data/performance expectations, discounting these projected cash flows to the present day rather than the acquisition year (or am I wrong? If these were discounted to the acquisition year I assume the past cash flows would need to be as well). Future excess cash flows would be reinvested in the same reinvestment assets as previously, then discounted to the present day.

- Project various terminal year cash flows based on various potential sales prices to set up a "if the property sells for ___, then we'll return ___ " type of situation / table.

Would this be appropriate / logical?

[Bryan Hancock]

Welcome to BP Brian.

Originally posted by Brian S.:

1. If I wanted to calculate a hybrid what-if internal rate of return for a currently owned property that has a balloon mortgage maturing in the next 4-5 years would it be appropriate to set up a model to do the following:

An IRR calculation is going to reinvest the interim cash flows at the project's yield. If you want to select non-project reinvestments for the realized cash flows use the MIRR function in Excel.

Originally posted by Brian S.:

- Utilize actual/realized cash flows from the time of purchase to present. Should these prior cash flows be left as-is or discounted to the acquisition year? I'm thinking left as-is as they've already been realized.

What are you trying to value? If you are trying to value the project overall you would want to include the realized cash flows.

Originally posted by Brian S.:

- Factor in actual gains/losses on re-investments of past positive cash flows while projecting/discounting the future cash flows of those already held reinvestments (let's assume they're reinvested in fixed % cd's or savings accounts for simplicity).

This is very easy to do with the MIRR function in Excel. In the resources section of this site Phil C. has modified a model I used to use for multi-familiy product that bakes in stuff like this so you don't have to use your own model.

Originally posted by Brian S.:

- Projects future cash flows for the remaining term based on historical data/performance expectations, discounting these projected cash flows to the present day rather than the acquisition year (or am I wrong? If these were discounted to the acquisition year I assume the past cash flows would need to be as well). Future excess cash flows would be reinvested in the same reinvestment assets as previously, then discounted to the present day.

Again...it depends on what you are trying to value. If you are valuing the whole project you need to include the past cash flows.

Originally posted by Brian S.:

- Project various terminal year cash flows based on various potential sales prices to set up a "if the property sells for ___, then we'll return ___ " type of situation / table.

This type of what-if scenario makes a lot of sense. The terminal cash flow will make less impact on your overall project-level returns if it is distant. For shorter projects it drives the variance in returns greatly. The rent and vacancy (sales) assumptions drive your returns big-time too. You may want to consider doing a what-if analysis that varies all three of these data points. I think v7 of the model Phil wrote does this in the spot referenced above.

Originally posted by Brian S.:

Would this be appropriate / logical?

You just need to know what assumptions you are making. If you are trying to value the project overall I would include all of the data for the project. If you are trying to blend one project with the next I would use the same discount rates and weight the projects by their overall value to come up with an overall return for the rental portfolio.