Example 8 - Using cash surplus from an
investment property to help repay a home loan
This example shows how to direct a surplus cash flow from an investment
into repayments for a home loan. We will start with an existing home loan which
still has a significant term remaining and an investment property that is (or
almost) cash flow positive and examine what impact it will have on the home loan
if we link the two loans. We will explore various finance options in relation to
the investment loan to see how soon we can repay the home loan and, optionally,
the investment loan.
Property and loan details:
Home: The principle place of residence is currently valued at 600k but
has an existing mortgage of $441k at 5% P&I and regular monthly payments of
2,578/month.
Investment property: The investment property is an established property
(45 years since construction) in a country town in Queensland. The property will cost
just $365k and is expected to rent for $430/week (2% vacancy rate).
While the yield is relatively high (6%), the growth prospects are limited (2%).
The purchase costs (13,277) include stamp duty (11,200), transfer fees (827) and conveyancing costs (1,250).
Rental expenses are estimated at 5,488 per year
As the building is already 45 years of age, there is no building depreciation
to claim and (as of 1 July 2017)
nor are there any depreciation claims for fittings.
Investment loan:
After a 10% cash deposit ($36.5k), an interest-only loan was arranged at 5.0% to
cover all remaining costs, including purchase and loan costs.
The total loan costs amount to $2,181.
The total loan required is $343,958.
Investor details:
The investor’s current annual taxable income is $95,000 per year, his
spouse’s is $55,000. They estimate that their annual living expenses are
about 45,000 per year, excluding the home repayments. They intend buying the
investment property in joint names.
What If?
If we assume that growth in value of the investment property of 2% and
that of principle place of residence at 4% and an inflation rate of 2%, what is
the remaining term of the home loan if…
- They continue their normal home loan regular payments
- They purchase the investment property and use any available cash from it as well
- They capitalise the interest and rental expenses on the investment property.
What are the steps?
- Create a new file and enter the investment parameters (specified
above). Under the Investor tab in the Data Entry Check List, enter the investor
details, home loan details and living expenses as specified above. Click on the
Spreadsheet button to reveal the Investment Analysis spreadsheet.
image
Note that the cash flow is slightly negative in the first two years but becomes cash flow positive after that,
though not significantly
- Switch to the Home Loan spreadsheet (View menu/Home Loan Analysis)
- Note that this spreadsheet automatically reveals the answer to the first question that we have listed. It will take
another 25 years of repayments (30,937/yr) before the home loan will be repaid
- Now switch to the Linked Loan spreadsheet (View menu/Link Loans).
Initially this spreadsheet will show the key rows from each of the previous two spreadsheet
(Investment property in yellow and the Home in blue) with the loans remaining independent entities
(Note the term "Independent loans" in the top left corner of the spreadsheet). The last row for the
Investment property (Inv. term & surplus) shows "?????" in the Input column because the investment loan is
interest only and is never repaid. The rest of the row is the "surplus" cash flow (initially negative).
The term remaining for the home loan is still 25.0 years. Choose to link the loan by either
clicking the “Independent loans” title in the top-left corner of the spreadsheet or on the toolbar
icon or the item in the Settings menu. The surplus cash flow from the investment property is now added
to the home loan payments. The Independent loans title will switch to
Linked loans and the Term remaining
for the Home loan will drop to 22.6 years
- Now we will look at the options available if we are to link the loans (Settings menu/Link Options).
For simplicity, let's look at just using surplus cash flow from the Investment property to repay
the home loan and once it is repaid, use the surplus and other monies to then pay down the investment
loan, but limit the net cost to that of the regular home loan payments.
- The Linked Loan spreadsheet should now look like this below with loan terms remaining of 22.6 yrs
(Home loan) and 30.8 yrs (Investment loan).
- Now choose the Link Options item under the Settings menu and by choosing to capitalise the
interest and rental expenses on to the investment loan, we can generate an even greater cash surplus
to accelerate the home loan repayment. In this example, we will assume that the interest on the
capitalised portion of the investment loan is tax deductible (though this should be checked for
individual situations) which means that we are effectively replacing non-deductible debt with deductible
debt. While in this dialog, we will also choose to repay the investment loan once the home loan is
repaid, but again limit the repayments to that which they have been making as regular
home loan repayments
Note that a “(c)” now appears in the Interest and Rental expenses row titles, indicating that these
are capitalised in the investment loan. The net result is that the home loan will be repaid in 9.8 yrs
and the investment loan will have been repaid in 28.3 yrs.
- Now generate the Linked Loan Analysis report (Report menu) and compare
the original arrangement of repaying the debt on the home loan with the proposed
arrangement as described above. Apart from the additional 36.5k cash deposit,
the net cost per year (i.e. proposed repayments) are the same, but the result is
very different. At the end of 25 years, both show the same equity in the home,
but in the proposed arrangement, there is an additional $449,583 in equity
generated in an investment property (see Page 4 of the report).