this post was submitted on 02 Sep 2023
9 points (100.0% liked)

Personal Finance Canada

1196 readers
1 users here now

Come and discuss anything related to personal finance, directly or indirectly, with other Canadians!

founded 1 year ago
MODERATORS
 

I'm trying to put together a google sheets reference chart for mortgage payments but I'm having a hard time figuring out the cmhc portion.

The basics of the chart is having a row for the price (200k-900k, incrementing 25k per row), down payment amount by %(set as a global in a field above), the cmhc insurance amount (price amount - down payment * CNBC rate based on down payment %; is this right?), monthly payment amount (using the PMT function on sheets, this is close but not matching to other calculators). My input for the PMT is the interest %/12, the lifetime (300 monthly period, 25 years), the total amount of the mortgage (price - down payment + CNBC insurance). This is mostly working but is still off by 10s-100s on the monthly payment. Is there something like graduated % in calculating the cmhc amount that I'm missing?

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 1 year ago

This at least confirms I'm understanding how cmhc is included. I'll have to double check everything.