Home › Forums › Financial Markets/Economics › Rent or Buy? Here is a tool for you › Simpler formulas for C9 and
Simpler formulas for C9 and E9 are =ppmt(c6/12, 1, 360, $b3) and the tweak (or copy/paste) for E9. =ipmt should be used row 8.