Brendan, with all due respect, I don't see why I am wrong. I just did it a different way, and it gets exactly the same result.
Yes, I agree that you need to calculate the repayment (and break it down into Principal and Interest each time) which is what you did.
I just interpreted the results...