Education

Cash Flow Study For Maui Rental Property

In an article dated June 19, 2019, The Wall Street Journal reported that according to data released by CoreLogic, Inc., the share of homes purchased by investors in the United States reached 11.3%, the highest on record.

Here on Maui, the share of homes purchased by investors is closer to 30-35% according to local Realtor opinion. Personally, from my last 32 sales, 12 were Investor Purchases, making up 37.5%

If you are looking to invest in Maui real estate as investment rental property, it is important to understand cash flow and pertinent planning strategies.

The Following Example Will Cover These Important Topics Relevant to Investor Purchases:

Measuring Housing Inventory

  • In Terms of Months of Inventory

Measuring Profit

  • Income/Cash Flow Method
    • Solving for Capitalization Rate (CAP Rate)
    • Solving for Property Value
    • Solving for Monthly Rent
    • Solving for Net Operating Income (NOI)
    • Use of a Spreadsheet
  • Appreciation in Value Method
    • Internal Rate of Return (IRR)

Leverage

  • In Terms of Purchasing
  • In Terms of Mortgage Rate

Housing Inventory

(In Terms of Months of Inventory)

To determine housing inventory in terms of “Months of Inventory”, take the total number of homes listed for sale during the last month and divide that number by the total number of homes sold in that month. This determines the number of months of inventory remaining.

Housing Inventory Example 

If there were 400 homes listed for sale in June, and 100 of these listings sold in June, then 400 divided by 100 equals 4 months of inventory.

  • 6 months of inventory equals a Balanced Market.
  • More than 6 months of inventory equals a Buyer’s Market.

Less than 6 months of inventory equals a Seller’s Market.

Measuring Profit

Two methods to profit with real estate:

  • Income / Cash Flow
  • Appreciation in Value

Income / Cash Flow

Let’s assume that you are considering the purchase of a home on Maui and it is your intention to rent this unit on a Long-Term Basis (6 month minimum lease term).

Applicable Terms:

  • Gross Annual Rental Income
  • Annual Expenses
  • Net Operating Income (NOI)
  • Annual Mortgage Payments
  • Capitalization Rate (CAP Rate)
  • Property Value (Purchase Price)

Gross Annual Rental Income minus Annual Expenses equals Net Operating Income (NOI)

$40,200 = Gross Annual Rental Income
– $7,262.64 = Annual Expenses
$32,937.36 = Net Operating Income (NOI)

Net Operating Income (NOI) minus Annual Mortgage Payments equals Positive Cash Flow

$32,937.36 = NOI
-$24,911.88 = Annual Mortgage Payments
$8,025.48 = Annual Positive Cash Flow

Solving for Capitalization (CAP) Rate 

Assume a List Price of $567,500.

Net Operating Income (NOI) divided by Property Value (Purchase Price) = CAP Rate

NOI divided by Purchase Price = CAP Rate
$32,937.36 ÷ $567,500 = 5.804 % (Cap Rate)

Solving for Property Value 

One of your goals with this potential purchase is a 6% CAP Rate; normal for this neighborhood. 

NOI divided by CAP Rate = Purchase Price (In Order to Achieve CAP Rate Goal)
$32,937.36 (NOI) ÷ 6% (Target CAP Rate) = $548,956 (Purchase Price to Achieve 6% Cap Rate)

Solving for Monthly Rent

One of your goals is to determine the amount of rent necessary to achieve $32,937.36/ month NOI.

Annual NOI Divided by 12 = Monthly NOI
$32,937.36 ÷ 12 = $2,744.78 (Monthly NOI)

Annual Expenses Divided by 12 = Monthly Expenses
$7,262.64 ÷ 12 = $605.22 Monthly Expenses

Monthly NOI plus Monthly Expenses = Gross Monthly Rent
$2,744.78 + $605.22 = $3,350 (Gross Monthly Rent for $32,937.36 Annual NOI and 6% CAP Rate)

Solving for NOI

Method to determine NOI.

Property Value X 6% CAP Rate = NOI
$548,956 X 6% CAP Rate = $32,937.36

Spreadsheet

A spreadsheet can be helpful computing the feasibility of a particular property. Here is an example:

Appreciation In Value

Internal Rate of Return (IRR)

Using an Internal Rate of Return Calculator, The Rate of Return over time may be calculated.

Internal Rate of Return

Breakdown over Time

Leverage

Leveraging is a powerful tool.  Here is an example of leverage in terms of purchasing. 

In this example, we have a purchase price of $548,956. There is a down-payment of $137,239.  We’ve borrowed $412,717 in the form of a mortgage at 4.5% over 30 years. So, in essence, we have the opportunity to leverage a significant Internal Rate of Return with 75% of the purchase being with someone else’s money!

Yearly Rate of Return (if sold at year end)

But Wait! There’s More!

There Is Also The Potential To Leverage The Cost Of The Mortgage Interest! 

In our example we are looking at a Rate of Appreciation of 4%, a CAP Rate of 6%, and Mortgage Interest Rate of 4%.

  • CAP Rate Plus Appreciation Rate Lower Than Mortgage Rate = Negative Leverage
  • CAP Rate Plus Appreciation Rate Higher Than Mortgage Rate = Positive Leverage

6% CAP Rate Plus 4% Appreciation Rate = 10% Total

10% Total Minus 4% Mortgage Rate = 6% Positive Leverage

In conclusion, always remember to consult with your CPA and financial advisor!

These figures are assumed to be correct, but Buyers and Sellers are encouraged to Perform their Own Due Diligence. Information is Not Guaranteed to be Correct.

For more information regarding Real Estate on Maui, please feel free to contact me!

Comments (2) Show CommentsHide Comments (Remember)

Cool. Add your comment...

Your email address will not be published. Required fields are marked *

Leave your opinion here. Please be nice. Your Email address will be kept private, this form is secure and we never spam you.

Jim Burden

January 18, 2020

Rick, that was a very good presentation. I own lots of commercial rentals and property in Calif. and passed your short study on to my three children. Two of them live in Haiku, 11 Kane rd. It has 4 possible rentals on about 3 acres. We are going to sell it soon and buy some investment property. Please give me a call, best regards Jim Burden

Oriana Vick

August 3, 2022

Dear Rick,
I am in the midst of an acrimonious divorce. When it ends (he managed to get the jurisdiction to France even though we’re both US born/bred) I will only have 1/2 of our real estate value to reinvest and live on. I have NO OTHER INCOME or job. I will plan to do a 1031 exchange from Del Mar, CA (around $1.2 million is all).
However, I am nervous about the massive income tax on rental income in Hawaii? 40%? Really truly?
At least I will not have mortgage interest. However, the huge income tax is making me consider states with no income tax like Washington/Nevada etc.
Please tell me what you think?

More Articles from Hawaii Life