Planned

:speech_balloon:

Housing - Allow modeling of mortgage series

As it is now, you can add a single mortgage item, which is great for the simple and typical US case where you get a 15 or 30-year fixed rate mortgage.

Use case 1: In a lot of countries, they don’t get to have long-term fixed rate mortgages, or they are so expensive that no one uses them. e.g. in Canada you’re more likely to find something like a 25-year mortgage, where the rate is fixed at 1, 3, or 5 year intervals.

Use case 2: A common US scenario is to refinance in order to cash-out, or reduce the rate. There are various costs associated with these refis, some of which could added to the cost basis for tax purposes.

55 votes

Tagged as Suggestion

Suggested 25 April 2022 by user Shawn S

Moved into Planned 24 May

  • Sign in to comment and vote. Sign in by email
  • 25 April 2022 Shawn S suggested this task

  • 25 April 2022 Kyle Nolan approved this task

  • avatar

    Similarly, some mortgages have various terms.

    Example, interest-only mortgages, where the mortgage is calculated over 30y, but pay only interest over 10y and then have a balloon payment after the 10y. Common in construction loans.

    25 April 2022
  • avatar

    This would be so useful in Australia were interest rates for home loans are like Canada (mentioned above).

    29 April 2022
  • avatar

    From discussion on Discord:

    Having multiple loans that make up a mortgage would be a requirement. For example, if I buy a house using multiple loans (80% mortgage, 20% secured loan, etc).

    29 April 2022
  • avatar

    Antoine’s comment would be useful. I’ve resorted to creating multiple debts to reflect multiple mortgage tracks/loans, each with different terms, time periods, amounts, payments etc.

    30 May 2022
  • avatar

    I would also like to be able to run Monte Carlo simulations on different historical mortgage rates, to model a future purchase or refi. Should that be a different suggestion?

    26 October 2022
  • 22 December 2022
  • avatar

    This would be great or even just an option to refinance at x date and so forth

    13 July 2023
  • avatar

    In the UK, and here is the scenario I have right now:

    • We bought our current house and sold our previous last year. At the time of purchase, we were on a 2 year fixed rate mortgage, with a significant penalty to repay early (before the 2 years was up).
    • We were able to roll this mortgage over to the new property, to avoid the penalty. So at the time of purchase, about 60% of the purchase mortgage was on this previous fixed rate which had about 6 months left on it, and the rest we fixed at a different rate for 5 years from the date of purchase
    • When the 2 year fixed portion expired, we refinanced that onto a new 5 year fixed rate, which is a different rate than the other 5 year portion. So now we have two staggered fixed rates, one finishing about 6 months before the other in 2027
    • Next year we plan to do some additional borrowing to cover the cost of some house work. This will likely be at a 2 year fixed rate
    • In the next few years we’ll keep an eye on rates here (not looking good!) and either refinance everything onto a single rate in 2027, or keep staggering things to optimize the rates we’re on

    This type of arrangement is not uncommon here in the UK, but is currently difficult to model in the tool!

    13 July 2023
  • avatar

    Adding a +1 request for this one. Trying to model interest only repayments for investment property purposes in Australia

    20 July 2023
  • avatar

    +1 to this

    25 July 2023
  • avatar

    Even the most basic implementation of this would help, where you could specify for example a specific interest rate applying from year 0-X and X-Y.

    Also helpful would be an “interest tax deductible” option, which would add any interest payable to your tax credits.

    16 August 2023
  • avatar

    In Canada, fixed-rate mortgages (the majority of people have these I think, for a set term, usually 1-5 years) are compounded on a “semi-annual basis” - twice per year - this Option would be a nice and very easy addition to the compounding drop down, “Semi-Annual (Canadian Fixed Mortgages)”. Variable mortgages are less common here in Canada but they are compounded monthly. :)

    23 October 2023
  • avatar

    Quick workaround to compounding differences for semi-annual for Canadian fixed is to calc and just adjust the interest rate to the equivalent monthly compounding rate. Close enough.

    23 October 2023
  • avatar

    Another vote for the refi use case.

    02 February
  • avatar

    This would be great. Being able to model (1) a refinance and/or (2) an Adjustable Rate Mortgage.

    24 April
  • avatar

    It would also be useful to add a “HELOC” Home Equity Line of Credit to a Home with an existing primary mortgage.

    03 May
  • 24 May Kyle Nolan moved this task into Planned