PMT with balloon payment at the end of term

I want to confirm that I have calculated this correctly.
Rate: 5%
Term: 5 years
Principal: 1 000 000
Balloon Payment at end of term: 400 000
I have attached a sample file with my calculation.
Thanks in advance

Am I on the right track with the PMT formula or should I be using another financial formula when there is a balloon payment at the end of the term?

I don't think my formula is correct as the 400, 000 balloon payment is made at the end of the term. Any suggesstions will be much appreciated.

I think I have figured it out. I have attached an amended sample file.

This helped a lot, thank you for the effort...