Ultima IV: Quest of the Avatar/Magic

Reagents

 * ash
 * garlic
 * ginseng
 * silk
 * pearl
 * manroot (mandrake root)
 * fungus

Classes and MP
Remember that in the NES version "Int" and "Dex" labels are swapped.

The Shepherd has no Magic Points, but she is the only character who can use the Sheep Flute, an item that casts the Sleep spell on all opponents.

I got 99 magic points in the NES version once I achieved Avatar status as a bard. Not sure if this would hold true as a Fighter/Shepherd or on any of the other versions.

Spell list
The GP cost of reagents does not consider Fungus and Manroot, that can be obtained for free.

Spell Types:
 * Field: spells that can be used outside battle;
 * Support: battle spells that target the allies;
 * Debuff: battle spells that target the enemies but deal no damage;
 * Attack: battle spells that damage the enemies.

Prompt specifies whether a spell is available since the beginning of the game ("yes") or if it has to be learned ("no"). Spells can be learned by going to "Spells Unlimited" in Moonglow, and telling the shop owner the proper ingredients.