Hi, I am struggling to figure out how to calculate the lump sum i would need to invest now that would cover my child's education. I would most likely put the lump sum in a balanced fund or equivalent and ideally not pay in every month i.e. the lump sum now would be sufficient to grow with interest to cover everything.

I'm getting stumped by having to factor in that money would have to be withdrawn each year at varying amounts as the fees increase for kindergarten to (hopefully) university...

Any suggestions of templates or examples out there??
Thanks