• 2 Posts
  • 11 Comments
Joined 2 years ago
cake
Cake day: August 6th, 2023

help-circle
  • I think it’s beyond a software fix at this point. I haven’t had a flicker of life from the drive after switching power/sata cables, a usb drive enclosure and a hdd docking station (i’ve confirmed the external devices work with a different drive). I’m all for booting to linux, but the bios doesn’t report that anything is connected when going through the sata ports.












  • You are correct, the interest rate should be (1 + r / n)^n(t) - 1, where r = interest, n = number of periods, t = terms. This is handled by the PMT function in sheets and only requires the rate to be entered as r/n or 5.84/12. I did an earlier version of the chart without the cmhc interest included and it was producing spot on values that matched agaisnt other available mortgage calculators. My issue comes when adding in there cmhc amount. At this point the chart works as a quick reference, which is what I was looking for, but it would be good to get it right.