On Aug 21, 11:22 am, I wrote:
But that does not make it right(!). Because (my US) banks calculate
interest on the balance after closing, I believe the following are
more correct.

Monthly compounding (result: $189,918.31):
=fv(12%/12, 12*5, -100, -100000, 1)

Ignore that. For a number of reasons, my comment above is not
relevant. Too complicated to explain.