tag:infinitekind.tenderapp.com,2009-01-14:/discussions/suggestions/14301-canadian-mortgage-calculationInfinite Kind: Discussion 2022-09-06T00:50:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-12T03:13:56Z2022-01-12T03:14:17ZCanadian Mortgage Calculation<div><p>update please?</p></div>jpx_6tag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-16T20:35:37Z2022-01-16T20:35:37ZCanadian Mortgage Calculation<div><p>Hello,</p>
<p>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.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-22T18:45:45Z2022-01-22T18:45:53ZCanadian Mortgage Calculation<div><p>This is a VERY old request... See this topic, specifically my post (#3, section (A).)</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/general-questions/624-canadian-mortgage-capitalization-setup">https://infinitekind.tenderapp.com/discussions/general-questions/62...</a></p>
<p>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.</p></div>GoneCampingtag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-22T19:52:13Z2022-01-22T19:52:13ZCanadian Mortgage Calculation<div><p>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.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-22T19:54:51Z2022-01-22T19:54:55ZCanadian Mortgage Calculation<div><p>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.)</p>
<p><a href="https://www.yorku.ca/amarshal/mortgage.htm">https://www.yorku.ca/amarshal/mortgage.htm</a></p>
<p>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?</p></div>GoneCampingtag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-01-22T20:49:06Z2022-01-22T20:49:08ZCanadian Mortgage Calculation<div><p>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!</p>
<p>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.</p></div>GoneCampingtag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-04-16T17:58:51Z2022-04-16T17:58:52ZCanadian Mortgage Calculation<div><p>Hi Ethan,</p>
<p>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.</p>
<p>Regards,</p></div>GoneCampingtag:infinitekind.tenderapp.com,2009-01-14:Comment/495802022022-06-07T00:43:07Z2022-06-07T00:43:08ZCanadian Mortgage Calculation<div><p>So, another major Moneydance update rolled out recently, and we still don't have this...</p>
<p>13 years, yes, YEARS, have gone by since I've talked about this way back then... and over the years, several have been asking for this.</p></div>GoneCamping