I'm sure someone else can post it more elegantly, but here's a quick solution:

select cast(round(123.45 * 1.07,2) as money)

I based it off of slange-862761's suggestion of using cast in an earlier post.

I don't know if this helps at all, but it might point you in the right direction.

--

Kevin C.