That one I didn't know. Compare with 'The Fantastical Prodigal/ Multum in Parvo' song of c 1715. There's a traditional version of it in Roy Palmer's 'Everymans' Book of British Ballads'. In the earlier one we find out his evil deeds, too.