Canadian Mortgage Calculation

jpx_6's Avatar

jpx_6

04 Jan, 2022 10:11 AM

Hi,
@ Moneydance team: do you have any future plans to include Canadian mortgage calculations?

  1. 1 Posted by jpx_6 on 12 Jan, 2022 03:13 AM

    jpx_6's Avatar

    update please?

  2. Support Staff 2 Posted by Ethan on 16 Jan, 2022 08:35 PM

    Ethan's Avatar

    Hello,

    Can you clarify in a bit more detail what would need to be added to the mortgage calculation function to make it more relevant to Canadians? I've done some online searching, but it's not quite clear to me what's different with mortgages in Canada versus the United States.

    Ethan
    Infinite Kind Support

  3. 3 Posted by GoneCamping on 22 Jan, 2022 06:45 PM

    GoneCamping's Avatar

    This is a VERY old request... See this topic, specifically my post (#3, section (A).)

    https://infinitekind.tenderapp.com/discussions/general-questions/624-canadian-mortgage-capitalization-setup

    Basically, mortgages up here are calculated (for weekly payments) on the basis of 7/365th of the interest rate as opposed to 1/52nd of the rate. This difference is significant when talking mortages, which are larger loans, typically. I have to manually update all transactions in MoneyDance on a monthly basis when I get my bank statement of account.

  4. Support Staff 4 Posted by Ethan on 22 Jan, 2022 07:52 PM

    Ethan's Avatar

    Ah, thanks for the clarification. You're right that this is a very old request based on that thread. I'll create a suggestion ticket for our developers to consider for adding these option in a future release.

    Ethan
    Infinite Kind Support

  5. 5 Posted by GoneCamping on 22 Jan, 2022 07:54 PM

    GoneCamping's Avatar

    I'm not familiar with how US mortages are setup, but here's a primer on Canadian ones. I think the difference between my Excel file (which is identical to my bank's statement) and the "incorrect" (for us Canadians) MoneyDance loan data is related to 2 things: the compounding (2 times a year, by law, in Canada) and the precision of what constitutes a "week" of interest (i.e. the aforementioned difference between 1/52 and 7/365.)

    https://www.yorku.ca/amarshal/mortgage.htm

    I'd like to provide an Excel test for you to see and compare, but I'm having trouble re-creating the payment schedule MoneyDance is proposing... What formula are you using, assuming I select the "52 payments a year" option?

  6. 6 Posted by GoneCamping on 22 Jan, 2022 08:49 PM

    GoneCamping's Avatar

    OK, I think I figured that US mortgages are compounded monthly (vs. semi-annually for Canadian ones.) To see the difference this makes, I've created an Excel sheet. Assumptions: $100,000 initial amount, 5% interest rate (annual), $300.00 weekly payment schedule. As you can see, after 401 weeks (a bit less than 8 years), the 2 Canadian mortgages are "paid off", with slightly different "balloons" (small ones!) The only difference between the 2 Canadian ones are the 7/365 vs, 1/52 week. The US mortgage, on the other hand, is also paid up in 401 weeks, but with a larger balloon, almost the equivalent of an extra payment!

    This is just an example illustrating the differences between the monthly and semi-annual compounding, and shows how us Canadians using mortgages need to always manually update transactions in Moneydance.

  7. 7 Posted by GoneCamping on 16 Apr, 2022 05:58 PM

    GoneCamping's Avatar

    Hi Ethan,

    Any news on when this could be implemented? We Canadians have been waiting for quite a while on this... and it shouldn't be that difficult to implement.

    Regards,

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac