Magnetism in layered oxides: Results from spin density functional calculations