It's very easy to test - create a project with one sprite, run it in Debug Mode, note the memory and cpu usage.
Then create an event: "repeat 200 times -> create sprite at random x,y"
Run again in Debug Mode.
You'll see that memory and cpu usage values are exactly the same!
Of course if these sprites are moving, fading, resizing, colliding etc., then the large number of sprite instances with have effect on the CPU usage.